• 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

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.

If it is only to get the column titles, this could easily be done by having realmworks open in one window showing a blank version of the appropriate topic/article type and then just typing in appropriate column headers into Excel (or other CSV generating program).
 
@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.

This sounds like a simple import of separate CSV files using csv2rw.

One CSV file for each domain or other mechanic articles, and one CSV for the deities.

You can freely map the named columns from your CSV file(s) into the corresponding fields in the actual topic/article format(s). There's no need to get a CSV list of column titles out of the tool first.
 
This tools is amazing! It is a must-have when you prepare a big mechanics sections or story that can be put in CSV format :) I uploaded Dark Heresy 2nd in Realm Works and this tool saved me so much copy-pasting the equipment and other system-data!

http://forums.wolflair.com/showthread.php?p=253790#post253790


Question: Is there a way during the import to have the topics nested into specific article hierarchy?
 
Question: Is there a way during the import to have the topics nested into specific article hierarchy?

Tick the "Use Parent Topic" button that is underneath the structure panel. This option creates a very basic parent topic for all the other topics being created.

If you want more information in the parent topic, then you can populate the newly created parent topic after import.
 
Just started to use the too. First impression is great. I have yet to import something.

However I noticed that inactive Categories are showing up in the list. Maybe they should be hidden or flagged? I suppose you should not be able to import to inactive categories?
 
Just started to use the too. First impression is great. I have yet to import something.

However I noticed that inactive Categories are showing up in the list. Maybe they should be hidden or flagged? I suppose you should not be able to import to inactive categories?

Ah, I hadn't come across those before. I guess they are part of the exported structure definition and marked as inactive. I will sort that out soon.
 
However I noticed that inactive Categories are showing up in the list. Maybe they should be hidden or flagged? I suppose you should not be able to import to inactive categories?

Hi Acenoid,

Unfortunately, the structure export file doesn't include any flags to indicate which categories are "Inactive" or have the "Shown" flag not ticked.

It will require a change by LWD to the export structure (adding an attribute to the category_global) before I know which categories are to be hidden.
 
I'm trying to create clickable loot tables using links withing RW. I actually already made some manually, but it's SUPER tedious and time-consuming. I've included a screenshot of what I'd like the import to look like when done. I can't figure out how to do so. I've gotten as far as creating the labeled snippets, but can't seem to get them to be customizable for the import. Am I doing this wrong, or is this not possible?

I could edit the labels manually after the rest of the import, but that's not even possible from what I can tell.

Any help would be appreciated!

QslomcS.png
 
It imports successfully, but it looks like this. Ignore some of the names, experimenting with it right now.

Edit: All the "weapons" on the left are a result of the import. I'm hoping to have a list on the right hand side like my previous image.

uwHUYPe.png
 
Ah, I see what you are trying to do.

The tool isn't designed to put a complete CSV file into a single topic. It is designed to create a separate topic for each row in the CSV file.

It would require a quite different structure to the program to be able to create a single topic with a separate snippet for each row in the CSV file.
 
Ah, I see what you are trying to do.

The tool isn't designed to put a complete CSV file into a single topic. It is designed to create a separate topic for each row in the CSV file.

It would require a quite different structure to the program to be able to create a single topic with a separate snippet for each row in the CSV file.

Ah, damn! Oh well, back to manually creating these lol. Thanks!
 
But there's no reason with a little spreadsheet magic you couldn't get what you want.

you tried to put one file into each topic which doesn't work. What does work is putting a single row into a single topic. So figure out the structure these topics need, including these loot tables, and make them one row of the CSV.
 
But there's no reason with a little spreadsheet magic you couldn't get what you want.

you tried to put one file into each topic which doesn't work. What does work is putting a single row into a single topic. So figure out the structure these topics need, including these loot tables, and make them one row of the CSV.

Interesting, I'll give this a shot. Thanks!
 
Might be a dumb question but how do I import text strings containing commas without having the commas being interpreted as delimiters?
 
Might be a dumb question but how do I import text strings containing commas without having the commas being interpreted as delimiters?

Enclose the whole string with “ “. It is valid, but must be for every item. I have Whole paragraphs imported from Dark Heresy core rule book this way. For example:

Name,Titles
“Name”,”Title01, Title 02”

Best way to ensure all is in proper format is to fill the table in Excel and export in CSV.
 
Back
Top