• 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

Acenoid said:
I want to have parts in different flavours but I just realized - I could just edit the categories and add the maximum number of snippets possible to achieve the same result, since I can switch of the auto-add. I think. Need to check it asap :D
Click to expand...

I think I can get multiple text snippets working quite easily. However they would all have the same snippet style and truth level.
 
Version 1.34 has just been released

This version will enable the main contents of a section to contain multiple snippets.
All the content snippets will have the same revealed state, style and truth.

(Not quite what Acenoid is after, but a step towards it :) )
 
Version 1.35 is out

This fixes a bug that an import would fail if your structure has sections as children of other sections.
 
Hi there,

This looks very interesting. I am not very tech savvy so I am still confused on how this works. Could I use the tool to convert a PDF file (Tome of Horrors) to a Realm Works file? How would I go about that?

Thanks! :)
 
FreakFire74 said:
Hi there,

This looks very interesting. I am not very tech savvy so I am still confused on how this works. Could I use the tool to convert a PDF file (Tome of Horrors) to a Realm Works file? How would I go about that?

Thanks! :)
Click to expand...

To use the tool you need the information in a CSV file format. If you copy all the text out of a PDF and put it into excel; you can then save the excel file in CSV format.

Some people claim that this is MUCH quicker than copy-and-paste from PDF directly into Realm Works, but I haven't used the tool for that sort of work.

Other people might have a better idea if a non-tech-savvy person would be able to cope :)
 
Thank you, Farling.

Has anyone here undertaken something like for instance the Monsters Manual for 5e D&D? Any advice or guidelines?

I take it I would have to convert a PDF to an excel file. I already tried a PDF-Excel convertor but the convertor crashed on me after about 30 mins (the PDF is pretty big). Is it possible to do that automatically or do I need to enter the data into the Excel file manually?
 
Oh yes. I just finished putting all the monsters from TFTYP in. My eyes they bleed.

PDF-Excel is a good start but have you considered JSON-CSV though? JSON is a pretty popular web format which means if there are web services or even phone apps using JSON and supporting this content then it's highly likely that the data will exist in JSON format out there in the vast internet.

JSON > CSV > Realm Works Importer > Realm Works > Win
 
Thanks all!

I don't even know what a JSON is so I will have to do a lot more research.. Wish the content market was out so I could just buy all this stuff in RW, ready to go. I'd pay a lot of money for it to have it accessible in game.. Especially the monsters! (Having them in RW would be nice, but what I really want is for them to be available in Hero Lab)..
 
When attempting to import this file:
https://www.dropbox.com/s/rcq5t8onjz39eqs/Places in Leilon.rwexport?dl=0

Which was generated from this CSV:
https://www.dropbox.com/sh/xk0cmgpl2jy0n4g/AAD71O-FBGBEXzjz7ogNJX60a?dl=0

Using this structure:
https://www.dropbox.com/s/m0s509pg3p1gmcz/Realms Redux (Structure Only).rwstructure?dl=0

I am getting this error:
The following errors were encountered during import:

Containment requires category role match

After I close out that error, RW crashes out.
I'm using version 1.35.0.0. of the import tool.

I'm not sure what is wrong. Sadly, RW isn't telling me which category role requires a match. :/
 
Vanye111 said:
When attempting to import this file:
https://www.dropbox.com/s/rcq5t8onjz39eqs/Places in Leilon.rwexport?dl=0

Which was generated from this CSV:
https://www.dropbox.com/sh/xk0cmgpl2jy0n4g/AAD71O-FBGBEXzjz7ogNJX60a?dl=0

Using this structure:
https://www.dropbox.com/s/m0s509pg3p1gmcz/Realms Redux (Structure Only).rwstructure?dl=0

I am getting this error:
The following errors were encountered during import:

Containment requires category role match

After I close out that error, RW crashes out.
I'm using version 1.35.0.0. of the import tool.

I'm not sure what is wrong. Sadly, RW isn't telling me which category role requires a match. :/
Click to expand...

There is a rogue line near the end of the RWEXPORT file.

You would be able to import the linked file if you remove the fourth-from-last line (line number 2759, the last occurrence of "<tag_assign tag_id="Tag_1"/> )

I will have a look to see why the tool is generating that line.

---

Further study shows that you're creating a "Location" topic; however the tool is also putting in a topic for each of the sub-categories which are children of Location. That is not a good thing.
 
Last edited:
V1.36 is available

This fixes Vanye111's problem with attempting to use the "Location" category for his import.

(It was very similar to the bug fixed by v1.35)
 
V1.37 is out

This version helps you manage your projects.

You can save your current project, which will remember the names of the CSV and RWEXPORT files, as well as all the field mappings that you've set up.

Only categories with a field mapped to the name will be saved - if you map other fields but don't map the name then that category won't be saved.
 
Since I am done with the massive data upload for Only War realm, not sure I want to go back to those days and test, but for the next one I definitely will. Planning to have some madness with CVS related to Rogue Trader...
 
Last edited:
Version 1.38 is available

Are you tired of having to convert your wonderful Excel spreadsheet into a CSV file? Then worry no more because V1.38 allows you to load your XLSX file directly into the tool.

Just use the "Load CSV" button as normal, then change the filetype to Excel Workbook.

Note that XLS files are not supported, only XLSX files.

(This opens up the door for retaining text formatting within cells.)
 
You must log in or register to reply here.
Back
Top