RealmWorks CSV Import Tool

[Farling]

Originally Posted by JustinThomason

I have all the pertinent files - my realm structure file, the original CSV, and the export file created by the tool. I can forward any or all of this to you if it would help your diagnosis.

Hi JT,

All three files would be useful, so I can see what might be going wrong.

[Merion]

Originally Posted by Merion

BTW, can someone with mod rights please make this topic sticky!?

Thanks, btw, to whoever stickied this!

[Rone]

You are most welcome!

[JustinThomason]

Originally Posted by Farling

All three files would be useful, so I can see what might be going wrong.

Zipped them for easier transfer.

The main import topic type was set to "Dungeon Room" and the parent type was set to "Dungeon Level." Otherwise everything should be pretty self-explanatory from the column names.

Let me know if you have any questions

[daplunk]

There's an issue with adding multiple names. Joe and I have both experienced crashes with it.

[Farling]

Originally Posted by JustinThomason

I've got everything mapped out in the CSV, and in fact, I've imported essentially the same data in a prior version of the program. That version of the tool didn't allow setting the linking priority on the main titles of topics, so I was getting a lot of false positives for generic location names like "Entryway".

Hi JT,

I've had a look in your RWEXPORT file and I can see some topics appearing more than once. With recent changes to support relationships, each row of the CSV is now allocated a unique topic number (either the row number, or the row number -1, I don't remember). This means that if the row is selected more than once to appear in the file, then the final file won't import.

I was aware that this limitation might not be ideal, and could cause problems; but I also thought that nobody would probably want the same CSV row appearing more than once in the final realm.

In your source CSV table, there are some duplicate entries, which you probably don't want in your final realm anyway :-)

(topics 22-100 are in both)
Level 0B: The Cloister of the Frog-God
Level 0B: The Cloister of the Frog-God: The Cloister
...
Level 0B: The Cloister of the Frog-God: Within the Vaults

(topics 365-389 are in both)
Level 4B: The Gut
Level 4B: The Gut: A. Zombie Stables
...
Level 4B: The Gut: F. The Gates of Gloom

(topics 645-690 are in both)
Level 9D: The Bloodways
Level 9D: The Bloodways (Supplemental Areas)

[Farling]

Originally Posted by daplunk

There's an issue with adding multiple names. Joe and I have both experienced crashes with it.

Is this a crash of the tool, or a crash of Realm Works during import?

Can you give any examples of what might crash?

[Farling]

Version 1.48 is available

This version doesn't add new functionality, it merely performs some additional checking during generation. An error window will be displayed showing any topics which would appear more than once in the generated RWEXPORT file, and tell you that the Realm Works will reject the import.

This should help JustinThomason avoid creating duplicate topics in his realm.

[JustinThomason]

Farling,

I don't quite understand what is wrong with my CSV. Is it because there are room names that are the same (like "Rat Tunnels" or "Entrance"?). If that's the case, that's an annoyance of this module and, frankly, lots of other modules as well - I might be able to deal with it, but it would be a pain. However, When I tried to import, I got references that topics were said to be used more than once, but I could only find a single instance of the name in the CSV.

Is it because the parent names repeat? If that's the case, how can you have multiple topics import under the same parent?

Sorry I'm being a little dense about this - I just don't quite grok the minutiae.

Failing that, would it be possible to get the last version before Relationships were added? I'm not sure if it would warrant a feature request to have Relationships be optional, but If I can get this skeleton entered it will make entering the 550+ pages SOOOOO much easier.

Once again, thanks so much for your help and the time you've given to the community.

[daplunk]

Originally Posted by Farling

Is this a crash of the tool, or a crash of Realm Works during import?

Can you give any examples of what might crash?

A crash during import. I would need to replicate the issue. But in our experience adding multiple names to snippets is a sure fire way to get the import to crash and in all cases we have been able to get around the crash by removing multiple names from the equation and nothing else.