RealmWorks CSV Import Tool

[gloranphile]

My vote is for #1. My next job is to import all my magic spells and they'll each have tags associated with the spell, so that would be awesome!

[Farling]

Originally Posted by gloranphile

My vote is for #1. My next job is to import all my magic spells and they'll each have tags associated with the spell, so that would be awesome!

Each of the domain items (like spell level, school, etc.) which have values selected from domains are already creating the relevant tag if you drag the CSV column onto the grey box that represents the drop-down menu that you would see inside RW :-)

[nightpanda2810]

Encountered an error with the new version (probably wasn't even possible before, my knowledge of CSV syntax is nonexistant).

I noticed that text I had in italics in my excel document imported italicized.

However, success was inconsistent. Took a while to figure out what did and did not work.

If the cell didn't contain any line breaks, bold or italics imported fine.

Cell WITH line breaks, ends in an error message. I've seen a few of these errors with different line numbers.

The following errors were encountered during import:

C++ Exception: Not in a span at line 1621 in file utility.cpp

I realize this may not be something that's even possible, but wanted to report the potential bug and find out if it's usable

[gloranphile]

Originally Posted by Farling

Each of the domain items (like spell level, school, etc.) SNIP

This tool just gets better and better! It seems I've only touched the surface... Farling, you are a scholar and a genius!

[Valyar]

Everything ends with utility.cpp exception and terminating error. I love it.

[Farling]

Version 1.40.1 is now available

This bug-fix releases prevents a crash of RW when trying to import data from an XLSX file which has multiple paragraphs of text in a single cell.

Thanks to nightpanda2810 for finding this bug.

[nightpanda2810]

Originally Posted by Farling

Version 1.40.1 is now available

This bug-fix releases prevents a crash of RW when trying to import data from an XLSX file which has multiple paragraphs of text in a single cell.

Thanks to nightpanda2810 for finding this bug.

Awesome, thanks! I'll try it out later today

[gloranphile]

Hey Farling,

I'm trying to add tags to the imports. I have a custom Tag called Folk Magic Traits. One of the tags is called "Duration: Special". When I drag it over to the Structure side of the tool, it only fills in the annotation, not the tag. Here's a screenshot of my tool with the csv and the stucture in place:

https://imgur.com/a/NgTrUjX

[Farling]

Originally Posted by gloranphile

Hey Farling,

I'm trying to add tags to the imports. I have a custom Tag called Folk Magic Traits. One of the tags is called "Duration: Special". When I drag it over to the Structure side of the tool, it only fills in the annotation, not the tag. Here's a screenshot of my tool with the csv and the stucture in place:

https://imgur.com/a/NgTrUjX

The automatic tagging only works where your structure already specifies a specific tag in the definition of the snippet (not just filling in the annotation).

In the category definition within Realm Works, the behaviour needs to be set to "tag" or "hybrid tags or text" and in the "Tag Configuration" you need to specify the "default domain selection".

With this configuration for a snippet, then the importer will display a grey combo box (drop down menu) into which you can drag a CSV column. The till will search the values in the domain you set in "default domain selection" to find a matching tag (if any).

[gloranphile]

Like this? This is the setup I used for the custom Tags/Category:

https://imgur.com/a/bApG4Hx