-
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
- Thread starter Farling
- Start date
Version 2.4 is available
This version contains two improvements:
1 - you can now specify an annotation for an asset snippet without having to specify the actual file containing the asset (e.g. annotations for pictures and smart images).
2 - all warning and critical messages are now displayed in an error window. One example of this would be when a source data value doesn't match one of the known values for a tag.
This should fix Acenoid's problem reported in post #476 and the second issue reported in post #477.
This version contains two improvements:
1 - you can now specify an annotation for an asset snippet without having to specify the actual file containing the asset (e.g. annotations for pictures and smart images).
2 - all warning and critical messages are now displayed in an error window. One example of this would be when a source data value doesn't match one of the known values for a tag.
This should fix Acenoid's problem reported in post #476 and the second issue reported in post #477.
Imported the data now - I noticed that even after ensuring the XLSX and the RW information is the same the "Transporter, Mittelschwer" entry has not been inserted after all. I manually edited now as it only were 4 entries. However it made me believe that maybe the "," (comma) might have been responsible for the missing entry?
I will try to test it again tonight.
Oh - almost forgot - thanks for the updated version. Will give download it tonight, since i have to import a few more lists and want to test the issue above.
Quick question regarding the images -- Since the error was File / URL not found , does it really mean I could link in my source file any URL? Cool!
I will try to test it again tonight.
Oh - almost forgot - thanks for the updated version. Will give download it tonight, since i have to import a few more lists and want to test the issue above.
Quick question regarding the images -- Since the error was File / URL not found , does it really mean I could link in my source file any URL? Cool!
Last edited:
See release notes...
v1.16
When loading an image (see V1.11) it is now possible to specify a web URL instead of just a local file name. Note that the URL must point directly to the image, not to a web page which contains an image somewhere inside it.
v1.17
When reading images from a web URL, follow web redirects which are issued by the web server.
Confirmed the > is the problem prematurely closing the xml elements inside the rwexport file. Converting these from >= to "at least" allowed for successful imports.
Thanks for this tool! 750 spells imported in 20 minutes.
Hi again Farling,
Two more questions:
1. Have you given any thought to allowing the user to select which worksheet they want to import from inside the workbook? It's be nice to have import data stored in a single workbook, delineated by worksheet. YMMV.
2. Any recommendations on how to include statblock imports inside the spreadsheet? I have an HTML template prepped that works when I manually insert it into a topic, but I'd like to be able to include it in the spreadsheet, use a concatenate() function to insert the appropriate row data into the statblock, and then use the importer to send it to Realm Works.
Aside from the issues having child <html></html> blocks may cause, the concat function is limited to 8192 characters in it's parameter set, so it seems like I may be dead in the water here.
At any rate, thanks again for a great tool!
-=Janrith
Two more questions:
1. Have you given any thought to allowing the user to select which worksheet they want to import from inside the workbook? It's be nice to have import data stored in a single workbook, delineated by worksheet. YMMV.
2. Any recommendations on how to include statblock imports inside the spreadsheet? I have an HTML template prepped that works when I manually insert it into a topic, but I'd like to be able to include it in the spreadsheet, use a concatenate() function to insert the appropriate row data into the statblock, and then use the importer to send it to Realm Works.
Aside from the issues having child <html></html> blocks may cause, the concat function is limited to 8192 characters in it's parameter set, so it seems like I may be dead in the water here.
At any rate, thanks again for a great tool!
-=Janrith
The tool allows you to specify an external file from which to import a stat block. The cell contains the name of the file (or URL) for what will become the stat block. The cell does not contain the actual contents of the stat block.
Perhaps you could write a script (perl, powershell?) which will generate a lot of files from your HTML template; and then reference the filenames of these templates in your XLSX file?
I haven't done much testing with importing stat blocks. I have a comment that it might only work with .rtf file; but I'd be interested to know what success you might have with other file types. (Maybe do Word mail merge to create a lot of .rtf files?)
I've added this to the list of feature requests.
It would be bit of overkill, but I could write an SSIS package to read the excel file and generate the stat blocks. I was hoping for something a little more lightweight though
Maybe I'll whip up a configurable console app or something...
Thanks.
It would be bit of overkill, but I could write an SSIS package to read the excel file and generate the stat blocks. I was hoping for something a little more lightweight though
Maybe I'll whip up a configurable console app or something...
Thanks.
TBH, I think that LWD aren't using Stat Block snippets any more because they aren't as accessible as was first hoped. Instead they put the formatted character stat block into a text snippet.
Has anyone else experienced this issue? My workaround is to just re-create the definition whenever I open the importer, but it would be nice to be able to load a project file.
I did notice there were no obvious memory, resource or handle leaks while it is in this state, although the I/O read count gets astronomical (in the order of 100s of millions), while the I/O bytes read never moves.
Farling, does QT generate PDB symbols? If so and you'd be willing to share, I could run this under NTSD and see if I can tell what it's spinning on; it seems like a resource wait of some kind...
Thanks.
-=Janrith
I will have a look this weekend. I admit I haven't used the save project option recently.
Hi there! Wanted to retry an import - same for me 2.3.0 open project seems to freeze the program - at least for the moment
Was it working in 2.2 ?
Or what was the last version in which it was working
Also, did you save the project in 2.3, or save in an earlier version and try to open in 2.3 ?
Version 2.4.1 is out
This is a bug-fix release which fixes the problem with Save / Load Project.
The saved project information was not sufficient to restore the data properly. In particular, if a section had the same name as a snippet (e.g. "class skills"). I guess that I was lucky in picking the "Class" topic type to do the testing, otherwise it would have taken a lot longer to find the problem.
(My apologies for fixing it earlier than I originally planned.)
This is a bug-fix release which fixes the problem with Save / Load Project.
The saved project information was not sufficient to restore the data properly. In particular, if a section had the same name as a snippet (e.g. "class skills"). I guess that I was lucky in picking the "Class" topic type to do the testing, otherwise it would have taken a lot longer to find the problem.
(My apologies for fixing it earlier than I originally planned.)
Last edited:
Thanks Farling.
I installed 2.4.1 and opened my latest project, but received the following error message:
RWTopic>> failed to find RWContentsItem for ":"
Additional issues:
1. My Notes column is being incorrectly attributed to the Spell's Name; none of the other column mappings are present.
2. The reveal settings for each snippet are lost.
3. The Parent article(s) as created in the project are missing.
Sorry to be the bearer of bad news, but it seems something is still wonky...
-=Janrith
I installed 2.4.1 and opened my latest project, but received the following error message:
RWTopic>> failed to find RWContentsItem for ":"
Additional issues:
1. My Notes column is being incorrectly attributed to the Spell's Name; none of the other column mappings are present.
2. The reveal settings for each snippet are lost.
3. The Parent article(s) as created in the project are missing.
Sorry to be the bearer of bad news, but it seems something is still wonky...
-=Janrith
Darn, more testing required.
Are the issues you reported related to what the tool is like after loading a project, or even immediately after launching the tool?
Also, was the "RWTopic>>" message from loading a saved project from an earlier version of the tool? Earlier saves aren't compatible with the format used by 2.4.1