• 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

Version 1.39 transfers formatting

If your XLSX file has basic text formatting, then this will be imported into Realm Works.

This includes, bold, underline, italic, and strike-through.
 
Version 1.40 fixes XLSX import

This version just fixes the XLSX import where cells might contain "<" or a cell might be entirely HTML.
 
Farling said:
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.)
Click to expand...

You are the MAN!!! (and I mean that in an entirely gender neutral sort of way ;))
 
You know, I wish I'd had this before I put an 800 page book into RW. Right now, starting over with a new realm, it's definitely saved my bacon over and over again.
 
So what next...

1) Ability to add tags to topics and/or snippets? (using a CSV column to define the class and name of the tag, e.g. "Adventure Area:Fortress"

2) Ability to add connections by having a CSV column containing the name of the connected topic: with the tool being used to specify the type (and direction) of each connection.

3) Do all the quests in WoW before the new expansion launches in 2-3 weeks time?
 
My vote is for #1. My next job is to import all my magic spells and they'll each have tags associated with the spell, so that would be awesome!
 
gloranphile said:
My vote is for #1. My next job is to import all my magic spells and they'll each have tags associated with the spell, so that would be awesome!
Click to expand...

Each of the domain items (like spell level, school, etc.) which have values selected from domains are already creating the relevant tag if you drag the CSV column onto the grey box that represents the drop-down menu that you would see inside RW :-)
 
Encountered an error with the new version (probably wasn't even possible before, my knowledge of CSV syntax is nonexistant).

I noticed that text I had in italics in my excel document imported italicized.

However, success was inconsistent. Took a while to figure out what did and did not work.

If the cell didn't contain any line breaks, bold or italics imported fine.

Cell WITH line breaks, ends in an error message. I've seen a few of these errors with different line numbers.

Code: 
The following errors were encountered during import:

C++ Exception: Not in a span at line 1621 in file utility.cpp

I realize this may not be something that's even possible, but wanted to report the potential bug and find out if it's usable :)

AZOWHbo.png
 
Version 1.40.1 is now available

This bug-fix releases prevents a crash of RW when trying to import data from an XLSX file which has multiple paragraphs of text in a single cell.

Thanks to nightpanda2810 for finding this bug.
 
Farling said:
Version 1.40.1 is now available

This bug-fix releases prevents a crash of RW when trying to import data from an XLSX file which has multiple paragraphs of text in a single cell.

Thanks to nightpanda2810 for finding this bug.
Click to expand...

Awesome, thanks! I'll try it out later today :)
 
Hey Farling,

I'm trying to add tags to the imports. I have a custom Tag called Folk Magic Traits. One of the tags is called "Duration: Special". When I drag it over to the Structure side of the tool, it only fills in the annotation, not the tag. Here's a screenshot of my tool with the csv and the stucture in place:

https://imgur.com/a/NgTrUjX
 
gloranphile said:
Hey Farling,

I'm trying to add tags to the imports. I have a custom Tag called Folk Magic Traits. One of the tags is called "Duration: Special". When I drag it over to the Structure side of the tool, it only fills in the annotation, not the tag. Here's a screenshot of my tool with the csv and the stucture in place:

https://imgur.com/a/NgTrUjX
Click to expand...

The automatic tagging only works where your structure already specifies a specific tag in the definition of the snippet (not just filling in the annotation).

In the category definition within Realm Works, the behaviour needs to be set to "tag" or "hybrid tags or text" and in the "Tag Configuration" you need to specify the "default domain selection".

With this configuration for a snippet, then the importer will display a grey combo box (drop down menu) into which you can drag a CSV column. The till will search the values in the domain you set in "default domain selection" to find a matching tag (if any).
 
Last edited:
You must log in or register to reply here.
Back
Top