• 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

Sertas said:
Can you use the same structure file to add different excel files. I have three excel files and I'm trying to add them one at a time to my realm but the second file isn't actually importing.
Click to expand...

Do you get any specific error?

Is each import using a different import name? I think there is a button next to the GENERATE button which allows you to define various things (including the name of the import) about the realm that will be added to the import file.
 
Each file has a different import name.

I'm getting the following error:

The following errors were encountered during import:

C++ Exception: Not in a span at line 1621 in file utility.cpp
 
Sertas said:
Each file has a different import name.

I'm getting the following error:

The following errors were encountered during import:

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

Oh, that is a problem in the formatting within the file. Does your source data contain HTML markup? That sometimes causes issues with the correct encoding for putting into the RW import file.
 
I'm not sure if HTML is there. If so I'll not include it and see what happens. Thanks for the quick responses. This tool is AMAZING.
 
Thanks for the direction. I didn't import a column in my excel file and it imported just fine.

Again, love the tool. It's saving me so much time. Now, I just need more data....lol
 
Release 1.45 is out

I've fixed a bug where a parent topic title was being processed as if it was a regular expression rather than a fixed string.

The title can now contain special characters such as parentheses without causing import problems.
 
Release 1.46 is available

(Note: old saved projects will not load into this version.)

(See point 2 in http://forums.wolflair.com/showpost.php?p=268734&postcount=328)
(Zaphod, this is for you from post #61, http://forums.wolflair.com/showpost.php?p=248472&postcount=61)

This version allows you to create relationships in the output file.

You only need to specify the relationship in one direction; Realm Works will automatically create the reverse relationship (if required).

The names of the relationships in the tool are the names supported in the XML file, rather than the names that you might see in Realm Works (there isn't an exact one-to-one map).

The simplest example is using topic names (although you can actually choose any field to search on)...

In your data you need to add one or more additional columns which will contain the name of the topic to which a relationship should be made.

In the tool, you will specify the column containing the name of the related topic, and also the column to be search for that name. (The flexibility in the tool means that you can link two articles not merely based on the actual topic name, but on any unique column.)

(Of course, immediately after writing the above parenthetical clause, I realise that the tool could be extended to automatically link to ALL matching topics instead of only the first match. - see V1.47)

You can set up multiple relationships, each possibly of a different type. If the "link" column in the model is left empty in some rows, then no relationship will be created for the topics created from those rows.


The supported relationships are:

Master_To_Minion / Minion_To_Master (RW calls them "Comprises or Belongs" and "Belongs To or Within"):
(V1.47 removed "Minion_To_Master" since RW ignores it during import.)
= Affiliation / Member
= Depends On / Depended Upon By
= Employer / Employee
= Master / Minion
= Organization / Chapter
= Owner / Subsidiary
= Parent / Child
= Residence / Resident
= Supervisor / Subordinate"

Generic:
= Peer
= Equivalence
= Personal
= General Family

Public_Attitude_Towards / Private_Attitude_Towards:
= Gracious
= Friendly
= Pleased
= Neutral
= Annoyed
= Angry
= Hostile

Arbitrary / Union / Parent_To_Offspring / Offspring_To_Parent
(V1.47 removed "Offspring_To_Parent" since RW ignores it during import.)
= (no qualifiers for these)
 
Last edited:
Release 1.47 is available

This version removes the Minion_To_Master and Offspring_To_Parent options for relationships, since Realm Works ignores them during import. These relationships can be created in the opposite direction using Master_To_Minion and Parent_To_Offspring.

When creating relationships, one relationship will now be created for each match between the KEY field and the SEARCH column. (V1.46 only created a relationship for the first match).

The KEY and SEARCH fields for a relationship now have some placeholder text to give a hint as to their use.

----

An example
You have a table of characters, which includes columns: name, father, mother.

You could set a single relationship for your Character topic category of "Parent_To_Offspring", setting the KEY field to "name" and the SEARCH field to "father".
A second relationship of the same type could also be set up for "name" to "mother".
 
Last edited:
Farling,

I tried the latest version of the CSV importer, and ran into problems importing into Realm Works.

I'm kind of pushing the original intent of the program. I'm working to put all of Rappan Athuk into a realm. My intent is to build a structural skeleton in Excel, then import that using your tool so that when I start entering the actual text of the (ginormous) module place holder topics for all the specific areas already exist and allow easy linking regardless if I've entered the text for a specific location or not.

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".

Anyway, I made a new realm and created a new export file using the new version of the tool. When I attempted to import into the clean realm, it got to 22% and crashed.

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.

Thanks again for your help to the community creating and maintaining this tool - it is SUPER useful!
 
JustinThomason said:
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.
Click to expand...

Hi JT,

All three files would be useful, so I can see what might be going wrong.
 
Farling said:
All three files would be useful, so I can see what might be going wrong.
Click to expand...

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
 

Attachments

JustinThomason said:
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".
Click to expand...

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 :-)

Code: 
(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)
 
Last edited:
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.
 
Last edited:
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.
 
Farling said:
Is this a crash of the tool, or a crash of Realm Works during import?

Can you give any examples of what might crash?
Click to expand...

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.
 
You must log in or register to reply here.
Back
Top