RealmWorks CSV Import Tool

[DickNervous]

I've been distracted from RW for a while and to come back to see this update is awesome! Great work Farling!

[Guyanthalas]

Tool is wonderful, I used it to add a list of spells and it worked perfectly.

I'm looking at adding monsters which has its own layer of problems. I've found some JSON content for monsters here:
https://www.reddit.com/r/dndnext/com...n_json_format/

JSON works great for storing monsters (multiple actions for example), but terrible as a way to import into realm works.

Any solutions around this that anyone can think of?

[Farling]

Originally Posted by Guyanthalas

Tool is wonderful, I used it to add a list of spells and it worked perfectly.

I'm looking at adding monsters which has its own layer of problems. I've found some JSON content for monsters here:
https://www.reddit.com/r/dndnext/com...n_json_format/

JSON works great for storing monsters (multiple actions for example), but terrible as a way to import into realm works.

Any solutions around this that anyone can think of?

Have you tried one of the JSON-to-CSV web converters?

A quick google found https://konklone.io/json/ but it might not like massive files.

[BJ]

Thanks for all your hard work Farling!

[Farling]

Originally Posted by BJ

Thanks for all your hard work Farling!

I consider it easier than coding new game systems in Hero Lab :-)

[ErinRigh]

If you are any good at PF coding in HL pop over to that forum and give me a hand, will ya?

[Farling]

Originally Posted by ErinRigh

If you are any good at PF coding in HL pop over to that forum and give me a hand, will ya?

I hate the language - not enough documentation, and too many undocumented macros.

C++ programming is much easier, it's just a shame that I'm UK based rather than US based.

[cas206]

Obligatory new member, this is an awesome tool comment. Thanks for this.

[Farling]

Originally Posted by cas206

Obligatory new member, this is an awesome tool comment. Thanks for this.

I'm glad you like it :-)

If you find you are doing any "work-arounds", then let me know and I'll see if there's a simple improvement to the tool that can help avoid it.

[cas206]

I have a source of XML with content I wanted to import. I used my very basic introductory level skills in XSLT to make the CSV to import. My biggest snag was some of the text contained the delimiter (comma). So I enclosed every text field with quotes. But then some of the text also included quotes which messed up the import. For example, the Mind Flayer innate spell charm gives example commands enclosed in double quotes and with comma's. Some web searching quickly found a way for me to add some XSLT to change the double quotes to single quotes which fixed the problem.

So I don't require any changes. However, you did ask about work-arounds, soooo.... an option to delimit by tabs...or something else, might have helped with this.