Quote:
copy-and-paste in a single CSV file when the basic format of the URL is simple (such as the traveller map) is a lot quicker than open web page, copy link, select topic in realm works, press button to paste picture in edit mode, save topic. |
Just used this tool for the first time the other night. Very slick. I was able to load some 5K spells into RW. Took a while to process that many rows of data, but it did. I am going to attempt the Feats list I have next.
|
Quote:
|
Coming out of a set of Access db's I was originally using to do some other things that kind of went on semi-permanent hiatus.
They're a collection of spells, feats, magic items and monsters I'd been collecting from various spreadsheets and form data entry into them. |
If anybody would prefer to run this tool on a MAC of some sort, then I have tried to build the latest version (V1.17) on my old OS X El Capitan (10.11.6) laptop.
The installable file should be available at https://github.com/farling42/csv2rw/...orksImport.dmg |
Hello all,
Version 1.18 has just been released that allows you to input the True Name and/or Other Names for a topic from your CSV files. The really good bit is that you can set up several different "other name" configurations for the various flags on a name, and then assign a different CSV column to each configuration. This means you can set up a CSV column for Revealed other names, and a different CSV column for still-hidden other names. The generated import file will ONLY contain the true/other names for the CSV cells which are not blank (so you won't end up with a blank revealed other name if that CSV column is empty). (The correct install file is around 33MB in size. For a few minutes the wrong installation was on the web site that is only around 20MB in size.) |
Very nice, Farling!
|
Any chance we can drop one of the columns as the parent item?
For example if my CSV is for Weapons and I want the parent to be Exotic, Simple or Martial from the file. Also, Would like to generate a single file for multiple csv files. Spells, Feats, Weapons. Currently I need to generate 3 rwexport files, one for each and then import each one input my realm What is your app written in? I'm a C# developer and would love to contribute to the development. |
Quote:
I will add your ideas to the list, both will require some thinking about to avoid the interface getting too complicated. The application is written in C++ using Qt as the GUI framework; all developed with their Qt Creator IDE. |
Looks very nice. I assume your using the Open Source QT version
|
Quote:
|
Version 1.19 of the tool has just been released.
This release allows you to create more than one parent, based on the unique values found in a single column of the CSV file. Each row of the CSV file will be placed as a child of the parent which has the matching value for the parent's CSV column. Now you can group all your spells according to school, or all your weapons according to type. (Don't worry about the slow turn-around, it only took around 2 hours.) |
Wow, I start to think that this can be used soon to import a lot of text passages.
I didn't download the latest version yet, is it possible to set the "flavor" status? (Its not really that important, Iam just using it frequently) |
Quote:
If so, then you can set this up before exporting the structure file to be used by the tool. If not, then I'll have to add it to the CSV2RW tool. |
I don't think you can set up different flavours in the categories. I am setting it always when I add a snippet to a topic - choosing one of the available flavours.
|
Very cool Farling! This is going to make building the skeleton of a module so much easier.
|
Version 1.20 has just been added.
This version allows you to specify more than one level of parents for your topics. This means you can arrange all your Traveller universe planets under their sub-sector category, and then group all sub-sectors below the appropriate sector category. Or you could arrange your spells by subschool beneath a school topic. Also, icons have been added to the buttons to make it pretty, and to help users understand what each button will do. The generate button is also disabled until both files have been loaded. (There was some work done behind the scenes to move towards making it easier to support multiple CSV files as part of a single export file; but more work is required.) |
A quick turn-around to version 1.21
This version adds the ability to set the Snippet Style on each snippet. Hopefully Acenoid will like it :-) |
Thanks man! Will download asap :)
|
This gets better and better! :D
|
I've been distracted from RW for a while and to come back to see this update is awesome! Great work Farling!
|
Tool is wonderful, I used it to add a list of spells and it worked perfectly.
I'm looking at adding monsters which has its own layer of problems. I've found some JSON content for monsters here: https://www.reddit.com/r/dndnext/com...n_json_format/ JSON works great for storing monsters (multiple actions for example), but terrible as a way to import into realm works. Any solutions around this that anyone can think of? |
Quote:
A quick google found https://konklone.io/json/ but it might not like massive files. |
Thanks for all your hard work Farling!
|
Quote:
|
If you are any good at PF coding in HL pop over to that forum and give me a hand, will ya?
|
Quote:
C++ programming is much easier, it's just a shame that I'm UK based rather than US based. |
Obligatory new member, this is an awesome tool comment. Thanks for this.
|
Quote:
If you find you are doing any "work-arounds", then let me know and I'll see if there's a simple improvement to the tool that can help avoid it. |
I have a source of XML with content I wanted to import. I used my very basic introductory level skills in XSLT to make the CSV to import. My biggest snag was some of the text contained the delimiter (comma). So I enclosed every text field with quotes. But then some of the text also included quotes which messed up the import. For example, the Mind Flayer innate spell charm gives example commands enclosed in double quotes and with comma's. Some web searching quickly found a way for me to add some XSLT to change the double quotes to single quotes which fixed the problem.
So I don't require any changes. However, you did ask about work-arounds, soooo.... an option to delimit by tabs...or something else, might have helped with this. |
Quote:
You can go back to double quote by using two double quotes together within the CSV file. e.g. Special rate "1.79" becomes "Special rate ""1.79""" (nicked from https://gpdb.docs.pivotal.io/43180/a...ted-files.html) |
Quote:
|
1 Attachment(s)
Farling, I noticed that when I import into the realm the new data, each import is displayed as "Test Import".
Is there a way to populate the fields with different information, so the outcome is similar to import from previously exported full/partial realm data? |
Version 1.22 has just been released.
You can now enter the name of the RW Import. The name of the generated file will also default to the entered RW Import name. The installer has been changed to NSIS which is easier to configure than QTIF. Sorry Valyar, I forgot about this particular annoyance. I should have implemented this a lot earlier in the tool's life. |
Quote:
|
Quote:
The end result will look like i have exported my own realm to import into it again or something custom. |
Quote:
|
Fabulous :) Looking forward for my next bulk import when time comes!
Until then I am enjoying your RW Output tool... which lately is used quite a lot for player that are reluctant to buy RW. |
getting this error upon import with the latest version:
The following errors were encountered during import: Encountered validation error for the import XML: The element 'topic' in namespace 'urn:lonewolfdevel.com:realm-works-export' has invalid child element 'overlay' in namespace 'urn:lonewolfdevel.com:realm-works-export'. List of possible elements expected: 'alias, section' in namespace 'urn:lonewolfdevel.com:realm-works-export'. |
Quote:
Could you provide a copy of the generated file for me to look at? If you are familiar with XML, then just the topic containing an "<overlay>" element would be enough. |
All times are GMT -8. The time now is 06:45 PM. |
Powered by vBulletin® - Copyright ©2000 - 2024, vBulletin Solutions, Inc.
wolflair.com copyright ©1998-2016 Lone Wolf Development, Inc. View our Privacy Policy here.