• 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

daplunk said:
3. Is it possible to overwrite data when a character or NPC increases in level? Meaning can I just import the same character over and over again or would I need to delete the RW snippets/character entry every time someone goes up a level?
No this will not work as the tool does not save unique UUID's for future use. It creates a new one for each snippet during the import process.
Click to expand...

Hi folks,

Thanks daplunk for providing all those answers.

I would like to clarify on point 3 that the tool isn't able to create unique UUIDs since they are create internally by RW on first import, and unique UUIDs are required in order to overwrite existing topics.

(For people who don't know UUIDs are simply a long string of characters in a particular syntax which provides a unique identifier for each topic, snippet, tag, etc. inside and between realms.)

There is the "potential" for the tool to read in a full realm instead of only a structure-only file, but I suspect that there will be some difficulty in guaranteeing to match up a row in the CSV/XSLX with the correct topic in the realm's export file. (There would also be other issues associated with having to do a full realm import just to pick up the new information.)
 
V2.6.1 is out

This simply fixes a bug where, if a cell isn't HTML, then any occurrences of < or > or & are encoded properly in the RWexport file.
 
Version 2.7 is available

User can now choose which sheet inside an Excel document to be used as the data source. Note that only one sheet from an Excel document can be used in each project (as requested by Janrith in http://forums.wolflair.com/showpost.php?p=276834&postcount=487).

Provide warning about unsaved work when attempting to load a new project, load a new data file, load a new structure file, or choosing a different worksheet in the current excel data set (as reported by Janrith in http://forums.wolflair.com/showpost.php?p=277220&postcount=517).

Ensure that the data mappings are shown when loading a project. (This was just a display bug, the mappings were known behind the scenes.)
 
Last edited:
Hey guys and gals,

I have just finished cleaning up a csv file for import for my ToA game (creatures only), and I am getting a validation error during import:

Encountered validation error for the import XML: The 'format_version' attribute is invalid - The value '4' is invalid according to its datatype 'urn:lonewolfdevel.com:realm-works-export:version_type' - The MaxInclusive constraint failed.

I did a quick search of the forums and didn't find anything pertaining to this. Also, it seems to completely block the import process. I am using v2.7 of the import tool, in case it is related to the tool.

Did any of you ever encounter this? Any fix or workaround?
 
jflevesque said:
Hey guys and gals,

I have just finished cleaning up a csv file for import for my ToA game (creatures only), and I am getting a validation error during import:

Encountered validation error for the import XML: The 'format_version' attribute is invalid - The value '4' is invalid according to its datatype 'urn:lonewolfdevel.com:realm-works-export:version_type' - The MaxInclusive constraint failed.

I did a quick search of the forums and didn't find anything pertaining to this. Also, it seems to completely block the import process. I am using v2.7 of the import tool, in case it is related to the tool.

Did any of you ever encounter this? Any fix or workaround?
Click to expand...

I noticed with the latest version of RW that was released that the version number of the file got increased.

I haven't yet done an analysis to see what might have changed in the format of the structure/data parts of the file.

I will get a look over the coming week and see if I can ensure that imports will start working again.
 
I noticed this too. I went in to my structure file and changed the XML type to 3 and that fixed the problem going forward. If you already have a conversion done, you can go into that file and make the same change and yte import will work just fine.
 
Hi The_Traveller, I just tried your suggestion and that worked! My guess is that LoneWolf forgot to update the validation code in the import function to take into account the new structure version. I haven't tried yet, but my guess is that full realm exports don't work anymore :(
 
jflevesque said:
Hi The_Traveller, I just tried your suggestion and that worked! My guess is that LoneWolf forgot to update the validation code in the import function to take into account the new structure version. I haven't tried yet, but my guess is that full realm exports don't work anymore :(
Click to expand...

No, it is more likely that the Import tool is missing some new data which is required for version 4 of their XML format.
 
So, but if we just update the version umber it still seems to work right? (Ok, who knows what consequences this would have... maybe I should try this on a fresh realm)...

Your import tool is really great, it would be very disappointing if it can no longer be properly used, just because the most recent update of RW (and presumedly the final one for the foreseeable future) was not done tested properly...
 
Version 2.8 is available

This version has a new entry in the Options menu.
When selected, it will force the format_version attribute in the generated XML file to be set to 3.

This is a work-around for what appears to be a bug in Realm Works version 254 whereby it would generate export files with a format_version of 4, but can only read import files with a format_version of 3 or earlier.

The option is NOT selected by default.

Existing saved projects should still load, and when you next save the project the current state of the new menu option will be saved as part of that project.
 
Heya Farling!

The tool's been very helpful in getting export files setup.

I just discovered an issue in v2.8.0.0, but I'm unsure if it's due to saving or opening a project file.

I started setting up imports with multiple names in a series of projects, but when I reload them, the additional names setup in the projects do not appear.

I tried checking one of the project files in a text editor to see if I could do some troubleshooting, but they appear to be saved as UTF-32 BE and I can't find an editor to read that format correctly.

As a result, I can't tell if the additional names are actually in the project file and just being missed when being read in, or if they aren't being saved in the first place.

It should be an easy repro:

Just hit the +Name button and save the project, close the tool, then reload it and open the project file.

The workaround is to just to re-add your additional names before generating the export file, as that definitely still works. In my case, I've got 35 projects, so having the alternate names preserved would save a bit of time.

At any rate, I thought you'd want to know.

Take care and keep up the good work!

Later

-=Janrith
 
Janrith said:
Heya Farling!

The tool's been very helpful in getting export files setup.

I just discovered an issue in v2.8.0.0, but I'm unsure if it's due to saving or opening a project file.

I started setting up imports with multiple names in a series of projects, but when I reload them, the additional names setup in the projects do not appear.

I tried checking one of the project files in a text editor to see if I could do some troubleshooting, but they appear to be saved as UTF-32 BE and I can't find an editor to read that format correctly.

As a result, I can't tell if the additional names are actually in the project file and just being missed when being read in, or if they aren't being saved in the first place.

It should be an easy repro:

Just hit the +Name button and save the project, close the tool, then reload it and open the project file.

The workaround is to just to re-add your additional names before generating the export file, as that definitely still works. In my case, I've got 35 projects, so having the alternate names preserved would save a bit of time.

At any rate, I thought you'd want to know.

Take care and keep up the good work!

Later

-=Janrith
Click to expand...

Thanks for the bug report.
I suspect it is just a case of those alternative names not being saved properly.

I'll have a look after the weekend (since my weeks are no longer occupied with a full-time job).
 
Version 2.9 is now available

The application now saves any name aliases that you've configured as part of a saved project.

The application from now on should also be able to load projects saved with older versions of the tool. (The earliest format now supported is projects saved with 2.7.)

Janrith said:
I started setting up imports with multiple names in a series of projects, but when I reload them, the additional names setup in the projects do not appear.
Click to expand...

Hi Janrith,

I do apologise that I didn't wait until after the weekend before fixing your bug. I hope you won't hold my poor time estimates against me ;-)
 
Dude!

No apologies needed man, you built a cool tool on your own time for the community. I just hope you don't think the bug reports are a dig on the app.

I'll check it out.

-=Janrith
 
Update on v2.9.0.0:

<error message deleted/>

Never mind... error on my side...

testing...

WOOT!

Thanks man!

-=Janrith
 
Last edited:
V2.11 is available

A simple addition to the installer allows the tool to be launched automatically from a .csv2rw project file.

It also adds basic support for JSON and YAML data files. The complex hierarchy is reduced to a simple overall set of column names, using "/" to separate each step of the hierarchy that contains each specific data value.

Please be cautious about using the multiple-snippet capabilities, since it might be that each entry in the source array might have a different number of children, and thus the multiple-snippet capability won't work properly. The work-around would be to set up your structure file to have all possible snippets predefined, and then map each entry individually.

(Note: Eventually I would like the tool to present the proper tree hierarchy that can be defined in JSON and YAML files, to make the multi-section/snippet functionality better.)
 
Last edited:
Brand new user, new to the forums etc. I have recently purchased realmworks. Yeah I know its been shelved, but the information is that they will unchain it if things go south. So, given what it provides, versus the cost, versus the risk etc, this wasnt that big of a decision to make.

With all that said, I was trying to use this tool in a realm I am creating. In that realm I am recreating, or entering, second edition DND game mechanics. In doing so, I have duplicated each category so I can modify it for my needs while inactivating the original categories.

With that said, when I try to follow the steps for your tool and import the final product your tool produces from my spreadsheets (in this case, a weapons list), it creates duplicate categories in realmworks (manage>categories etc). For example, Instead of just one category called "Mundane weapons," I have now have Mundane weapons and "Mundane weapons 01"

This is across the board for all my previously duplicated categories. Is there anyway to stop that?
 
You must log in or register to reply here.
Back
Top