RealmWorks CSV Import Tool

[Farling]

Originally Posted by Acenoid

Hello there!

Unfortunately my last post got lost (so much text was written)

So now I'll keep it shorter:
- German regional settings cause the tool not to recognize the delimiter between the fields. US setting is "," german setting is ";".

It is on my to-do list to choose an alternative separator.

I thought it was universal, since CSV means "comma separated values", not "semi-colon separated values" :-)

Further reading shows that it is MICROSOFT who are breaking the CSV standard (using some silly "list separator" regional setting).

[Farling]

Version 1.31 is out

The default separator for CSV files is now going to use your language's "list separator".

For English speaking countries this is most likely still the "," character.

For some European, and possibly other, languages, Microsoft (in its "infinite wisdom" [i.e. usual practise of breaking published standards]) uses ";" as the list separator instead.

Microsoft apparently didn't realise they could break the standard further by adding a non-standard escape character, so there's no support for that in the tool

The list separator can be changed manually through the Windows Settings panel (if you dig deep enough).

Primarily this just means less quote marks around field values.

P.S. I hope I didn't break anybody's existing CSV files with this change/improvement. Please let me know if I did.

[Farling]

Version 1.32 is out

This is just a minor update to allow the CSV field separator to be specified from the main menu.

You can choose from comma, semi-colon, or whatever Windows has configured as the list separator.

[Acenoid]

Great!

[Farling]

Version 1.33 has just been released

1. It is now possible to mark a section as starting in the "collapsed" state.

2. You can specify a particular CSV column to be used as the name of a section within a topic.
2.1 Select "..." and set a column for the "First Section" box (leave the other two section boxes blank).

3. You can specify a range of CSV columns to be used to create multiple sections within a section.
3.1. Select "..." and set a column for the First, Second, and optionally the Third section box.
3.1.1. The First section defines the CSV column containing the title of the first section.
3.1.2. The Second section defines the CSV column containing the title of the second section.
3.1.3. The Final section (defaults to last column) defines the CSV column containing the title of the last section.
3.2. The snippets within the section should be set to use CSV columns between First and Second column.
3.3 For the second and subsequent sections, the same "offset" will be used for reading the text from the correct column of the CSV table.

Note that the first time that the CSV cell for the "section header" is empty, then the creation of those sections stops immediately (it doesn't continue up to the "final section" column).


Multiple Column Example

CSV columns: room1, description1, occupants1, room2, description2, occupants2, room3, description3, occupants3, room4, desc4, occ4, room5, desc5, occ5

Configure the relevant section in the tool as:
First Section = room1
Second section = room2
Last section = room5 (or leave empty)

In the snippets inside the section, use description1 and occupants1 (the tool works out the offset from column 'room1' to column 'description1' and applies that offset when populating for 'room2', 'room3' ,etc.)

When the RWexport file is generated, the first section will use description1 and occupants1, the second section will use description2 and occupants2, and so on, up to the last section that will use desc5 and occ5

[daplunk]

Round of applause.

[Farling]

Originally Posted by daplunk

Round of applause.

The changes I'd made in v1.29 to support using the same category for multiple levels of parent made this improvement almost trivial

[Acenoid]

Originally Posted by Farling

Version 1.33 has just been released

I have a question with this version (not downloaded yet but it sounds very useful). You write sections, but is this also possible with snippets within a section?

For example....

Section 1
-> Snippet 1 (flavour 1)
-> Snippet 2 (flavour 2)
-> Snippet 3 (flavour 1)

CSV file holds then for each snippet a column i guess.
But I didnt see a way to select multiple csv columns for the same snippet / define multiple flavours for it depending on the column. So I guess this is unsupported?

Thanks!

[Farling]

Originally Posted by Acenoid

I have a question with this version (not downloaded yet but it sounds very useful). You write sections, but is this also possible with snippets within a section?

For example....

Section 1
-> Snippet 1 (flavour 1)
-> Snippet 2 (flavour 2)
-> Snippet 3 (flavour 1)

CSV file holds then for each snippet a column i guess.
But I didnt see a way to select multiple csv columns for the same snippet / define multiple flavours for it depending on the column. So I guess this is unsupported?

Thanks!

Hi there,

No, this only works for sections.

You can put multiple paragraphs of text into a single CSV cell, so there's no real reason to split them up into separate snippets.

[Acenoid]

I want to have parts in different flavours but I just realized - I could just edit the categories and add the maximum number of snippets possible to achieve the same result, since I can switch of the auto-add. I think. Need to check it asap