• Please note: In an effort to ensure that all of our users feel welcome on our forums, we’ve updated our forum rules. You can review the updated rules here: http://forums.wolflair.com/showthread.php?t=5528.

    If a fellow Community member is not following the forum rules, please report the post by clicking the Report button (the red yield sign on the left) located on every post. This will notify the moderators directly. If you have any questions about these new rules, please contact support@wolflair.com.

    - The Lone Wolf Development Team

RealmWorks CSV Import Tool

So, is there a particular reason why your tool doesn't allow us to create a category in the same category as the parent? I mean, I see that in the release notes for 1.20 that you state it. I'm just trying to figure out if it's just something you haven't implemented yet, or if it's a RW limitation. The same with letting us choose Settlements (a subset of Locations).

Love the tool, just trying to figure out if I'm just missing something to use it better. Just experimenting before I try to start going whole hog.

Thanks!
 
Last edited:
So, is there a particular reason why your tool doesn't allow us to create a category in the same category as the parent? I mean, I see that in the release notes for 1.20 that you state it. I'm just trying to figure out if it's just something you haven't implemented yet, or if it's a RW limitation. The same with letting us choose Settlements (a subset of Locations).

It is a restriction of my tool.

It is to do with the way that the mappings are currently stored inside the tool.
 
It is a restriction of my tool.

It is to do with the way that the mappings are currently stored inside the tool.

Bummer. Is this something you think might be possible to change in the future? If not, I can see work arounds that aren't that much of a pain, but for convenience it would be awesome. :)
 
Running into an issue where the import is creating a bunch of empty entries named "no-name"

https://www.dropbox.com/s/qube307g9rig7zh/no-names.PNG?dl=0

I've included a picture link so you can see the results, and a copy of the realm structure and the base CSV file.

I created a copy of the Settlement topic for my structure. I've been creating a parent, and putting the Region Name in that field, then the rest of them into the (more or less) appropriate sections of the category.

Ty for any assistance. I can manually delete those entries (though there's a 50-50 shot of doing so crashing Realm Works) but if I can find out why it's doing it, maybe we can prevent it. :)
 

Attachments

Last edited:
"no-name" is the place-holder put into the topic's title if the cell in the CSV file is blank.

In your CSV file the second line has an entry in only the first column "Region Name" called "Dessarin Valley".
All subsequent lines have a blank first column, and then the rest of the line is filled in.

If you want all entries to be in Dessarin Valley, then you need to include that text in the first column of every row, and probably delete row 2 of your CSV.
 
Last edited:
Bummer. Is this something you think might be possible to change in the future? If not, I can see work arounds that aren't that much of a pain, but for convenience it would be awesome. :)

Parents

It looks like a few hours of restructuring how the data is stored means that it will now be possible to use the same Category for multiple levels of parents; and even the same category as the main data (if you are really inclined to arrange your data that way).

I have to do some more testing to ensure that it is stable before releasing it, and I've run out of time this evening.

Multiple Topic types (categories) in the same file

It also opens up the way to having a single CSV file able to create topics in different categories, most likely based on choosing a column in the CSV file to determine which category should be used for the topics of those rows.

This won't be available immediately, but could be done in the future.
 
Last edited:
V1.29 has just been released

This release removes the restriction that all parents must be different categories.

This should help remove the inconveience expressed by Vanye111.

Note that there was a large amount of restructuring which happened in the code, so please test and let me know if there are any issues with CSV files which used to work.
 
V1.29 has just been released

This release removes the restriction that all parents must be different categories.

This should help remove the inconveience expressed by Vanye111.

Note that there was a large amount of restructuring which happened in the code, so please test and let me know if there are any issues with CSV files which used to work.

Dude, you are amazing.
 
V1.30 has just been released

This release allows you to configure several different categories in order to import more than just one type of data in a single RWexport file.

There is a new "key" icon next to the topic title which can be used to choose which rows of the CSV table will be used with that particular category definition.

The parentage of each category can also be defined separately.
 
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 ";".

Workarounds:
- Switch regional settings temporarilty to english
- Use an editor to change the delimiter

It would be a quality of life setting if the user would be able to choose delimiter and maybe the escape character (quotation marks)


Example file containing 3 columns:
column1,column1,column1;column 2;"Column 3;"
value1,value1;value 2;"v;alue3"
 
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).
 
Last edited:
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.
 
Last edited:
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.
 
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
 
Last edited:
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!
 
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.
 
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 :D
 
Back
Top