• 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

A new release (v1.5) has just been published.

It allows you enter free text into a snippet, which will be the same in every single instance of the topic/article that the tool creates. You can also choose one of the fixed tags if the field takes tags.

You can't mix CSV data and free text in the snippet (yet) though.

There's also a fixed bug where in the right (or wrong!) conditions the structure part of the XML file would put text into a partition element.
 
IF it is a registry key that makes a difference, maybe run a disk checker to see if the registery is getting corrupted?

OK, I've got no bloody idea what's going on :confused:

Attempted to import a module (We Be Goblins which I have successfully imported before), gets partway and springs the category not found error.
Ran a registry check to see if it might be a registry error - no issues
Ran a system file check - no issues
Ran check disk - no issues.
After restart from check disk I attempt to import a couple of different things (the featbook file from ErinRigh and my Feats - Story file I created with the tool) both imported without issue :confused:
Originally I thought the issue may have been arising from adding custom snippets into my feat copy article in my structure file but as you can see from the attached file they imported with no issue.

Anyway, I'll keep my eye on it and if I discover the underlying issue will let you all know if anyone else is having a similar issue.
 

Attachments

  • Snip1.PNG
    Snip1.PNG
    174.5 KB · Views: 14
The good news with release 240 of Realm Works is that you can now provide the structure-only export file from the SAME realm into which you want to import the CSV-data :)
 
How do I have more than one column appear in a field? e.g. with Feats you have Benefit but also Normal and Special. Is it possible to add more than one column to a field? Or is that part of the initial copying of the category? To add any missing fields before exporting the structure? (I think I know the answer to this already now after thinking about it :o)

I think I missed part of this original question.

You can add additional snippets to the category structure within Realm Works before you create the structure-only export. These additional snippets will be available within my tool for you to assign a CSV field to.

e.g. you could create a Labeled_Text snippet and put "Normal" as the label, and then use my tool to populate the message/annotation part of the snippet from a column of the CSV file.
 
I think I missed part of this original question.

You can add additional snippets to the category structure within Realm Works before you create the structure-only export. These additional snippets will be available within my tool for you to assign a CSV field to.

e.g. you could create a Labeled_Text snippet and put "Normal" as the label, and then use my tool to populate the message/annotation part of the snippet from a column of the CSV file.

Yeah, I managed to get that working :) Thanks
 
I've updated the TODO list on the first page of the thread to indicate that a few items should really be handled by updating the category definitions within Realm Works before performing the structure-only export.

Please feel free to argue against any of these items. :)
 
With the release of version 241 of Realm Works, it is no longer a requirement that you must make a copy of a predefined category in order to import into that category.

:) YAY TO LWD !!! :)

(However, note that the greyed-out placeholder text for each field will be more basic for a predefined category compared to a custom category, due to information missing from the structure file: specifically the purpose child elements, and soon-to-be description elements too).
 
Last edited:
I've posted another version v1.6 which only contains a few minor tweaks, such as remembering the last used path in each of the file selection dialogs (each is remembered separately).

For those with Linux or Mac, the source code is available on github and should be compilable using QtCreator on your respective platforms.
 
Has anyone tried this tool and abandoned it?

If so, what were your reasons for abandoning it?

I'm looking to see what to add to this tool to make it helpful for more people.
 
Has anyone tried this tool and abandoned it?

If so, what were your reasons for abandoning it?

I'm looking to see what to add to this tool to make it helpful for more people.

Still using it :)

I'm not sure how you could improve it TBH, it's pretty good as is, my only problem is trying to find decent sources of CSV files to use :D
 
Had no need to import something yet, currently on a "short" break from typing in and out data :D

BUt the quest will continue soon....!

Ill check out your tool! Thanks for reminding.
 
I am looking forward to get some time to play around with this tool and the other tools that were introduced these last months.

I imagine I can use this tool to export my homemade equipment lists from spreadsheets and import it into RW, saving a lot of work. Still wondering if this would be the right approach or if I should just leave it in the spreadsheets as is (filtering and calculations are such helpful features).
 
So I just found this and haven't had much time to view all 8 pages of posts but have a question/suggestion, is there a way to use the structure to generate a blank csv file that can then be filled out and reloaded back into the program to create an upload file. This way people will have all the listings that is shows and will be able to add something that the writer might not know they need.
 
So I just found this and haven't had much time to view all 8 pages of posts but have a question/suggestion, is there a way to use the structure to generate a blank csv file that can then be filled out and reloaded back into the program to create an upload file. This way people will have all the listings that is shows and will be able to add something that the writer might not know they need.

The available fields vary wildly between the different topic categories. The general concept of the tool is that one CSV file contains information about one particular category (such as creatures, or items). There is no limit to how many columns you can have in your CSV file and the user can choose how each column maps onto the fields within the category chosen for that CSV file.
 
The available fields vary wildly between the different topic categories. The general concept of the tool is that one CSV file contains information about one particular category (such as creatures, or items). There is no limit to how many columns you can have in your CSV file and the user can choose how each column maps onto the fields within the category chosen for that CSV file.

Oh I'm not thinking a csv for all field for all items. I'm thinking a blank csv for a category. For example I want to enter gods into me and I have not created anything for it. I load my structure select the category for gods hit a button and it creates a csv file that has all the headers that would be used for gods. then i can fill that out and load it in and then just match the names and import.
 
@ray57913: That would be really useful. If had a blank format for creating the CSV files, it would be so much easier. Several categories are rigidly structured so this could work.

I've been working on importing 300+ gods into HeroLab. I identified the format and have created an Excel sheet that I enter the names, domains, descriptions, etc and then a second sheet that merges all of those fields with the necessary field information.

I haven't carved out the time to do this for RealmWorks but it would be very cool if something like this was available for standardized categories like deities, NPCs, creatures, spells and feats. Copy/paste the info and let your favorite spreadsheet format it using concatenation.
 
Back
Top