RealmWorks CSV Import Tool

[Farling]

Originally Posted by Arg-ha

<category_global category_id="Category_49" name="Individual" global_uuid="1FB0297B-91C6-5D3A-00D0-6A935D3C6BA9"><overlay original_uuid="14A69BB6-25D0-869A-18F5-6A93BB0E6BA9" signature="90407" />

Ok, I'll need to experiment to see what this "overlay" snippet type is all about. In you category definition for the "Individual" there appears to be an overlay snippet as the very first snippet.

[Happydevil43]

Originally Posted by cas206

@Happydevil43 There is a Add Parent button that lets you put the main articles in a parent container.

Found that, and I am getting closer, but what does adventure area come under, I cannot see it in the list of available options ? unless I can't see it.

but I have got it do most of what I want now, I'll still need to tweak it a bit.

EDIT: I figured out if I duplicate adventure area I can add it in as a parent and it shows up on the second level of the parent (cannot get it to show up as the top level).

worst case scenario is that I get the basic structure created and then go back in to tweak it. Have attached what I have done so far. I am sure there are many improvements to make yet.

Next to figure out is images and herolab files.

[Farling]

At the moment the tool won't allow you to use the same category type for multiple levels of parent or the same as the base topic for importing.

[joe2chillo]

Love the tool

[joe2chillo]

Originally Posted by Farling

At the moment the tool won't allow you to use the same category type for multiple levels of parent or the same as the base topic for importing.

So does this mean I can't import a monster and have multiple action snippets or multiple trait snippets in the appropriate section? I want to have a snippet for each in the section but don't see a way to do it.
??

[daplunk]

Finally tried this for the first time last night. Bloody hell man well done.

[Farling]

Originally Posted by joe2chillo

So does this mean I can't import a monster and have multiple action snippets or multiple trait snippets in the appropriate section? I want to have a snippet for each in the section but don't see a way to do it.
??

Multiple snippets in the same section should be handled by updating the definition of the category to have those extra snippets. The exported "structure file" will then have those extra snippets, and the CSV tool will make those available for you to map to specific CSV fields.

The reference to "Unique" categories refers to what category is chosen for each parent. So if you are importing a file of spells then you would use the "Spell" category for the individual field mapping; you could then use the "topic list" category as a parent, but you could not use a "Spell" category as a parent.

(Apologies if any of the above is not entirely clear, I've had flu for the past few days.)

[joe2chillo]

Originally Posted by Farling

Multiple snippets in the same section should be handled by updating the definition of the category to have those extra snippets. The exported "structure file" will then have those extra snippets, and the CSV tool will make those available for you to map to specific CSV fields.

The reference to "Unique" categories refers to what category is chosen for each parent. So if you are importing a file of spells then you would use the "Spell" category for the individual field mapping; you could then use the "topic list" category as a parent, but you could not use a "Spell" category as a parent.

(Apologies if any of the above is not entirely clear, I've had flu for the past few days.)

Thanks. Got it. Next I need to figure out how to add on HL portfolios and image files. I think I saw that somewhere in the thread so going back to look now.

[joe2chillo]

Every time I try to import the generated file to RW, I get the message:

The following errors were encountered during import:

Encountered validation error for the import XML: The element 'topic' in namespace 'urn:lonewolfdevel.com:realm-works-export' has invalid child element 'overlay' in namespace 'urn:lonewolfdevel.com:realm-works-export'. List of possible elements expected: 'alias, section' in namespace 'urn:lonewolfdevel.com:realm-works-export'.

I even tried just creating a super basic csv with only 4 columns and 1 monster. Any ideas on this?

UPDATE: I figured out the problem though not the cause. I read back through this thread and found someone with the same issue. You had mentioned that it had to do with an empty overlay. I searched the XML for <overlay/> and found several. I simply removed them. Then everything imported just fine.

[joe2chillo]

One last question. I notice that the main post mentions that Mult-line quoted text is supported. What exactly does that mean and how does it work. I am trying to create a cell with spellcasting and then a new line for each level.

EXAMPLE:
Spellcasting. The bad guy is a 5th level spellcaster with these spells:
cantrip (at will): cantrip1, cantrip2, cantrip3
1st level (3 slots): spell1, spell2, spell3
2nd level (2 slots): spell1, spell2
3rd level (1 slot): spell1

I tried just doing a ALT-Enter in excel to create a line return but that doesn't seem to work. Also tried CHAR(10) in the cells for a line return but this did not work either. Is it possible to achieve what I want?