• 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

A couple of questions...

Which column were you mapping across?
What file were you using as your structure file? (or what game system was used to create the blank realm?)

I tried just doing 1 column which was the name column. The structure file is one I have used in the past. I sent it to you previously when I was having another issue so I know it works though I am going to create a new structure file just to test. Also this is 5th edition.

EDIT: Created a new structure file and still get the same error. https://drive.google.com/open?id=1-v6B7_nDYjjcGElhFHmhoJtcIg6rHyR3
 
Last edited:
Version 1.43 has just been released

The fixes the problem with the mysterious "overlay" element that can appear in structure files (but not in mine, for some reason).

The previous fix got broken when the structure and contents elements were separated out into separate objects.

joe2chillo, this should fix your latest problem.
 
I tried just doing 1 column which was the name column. The structure file is one I have used in the past. I sent it to you previously when I was having another issue so I know it works though I am going to create a new structure file just to test. Also this is 5th edition.

EDIT: Created a new structure file and still get the same error. https://drive.google.com/open?id=1-v6B7_nDYjjcGElhFHmhoJtcIg6rHyR3

Awesome! Glad I am not crazy. I had an overlay problem in the past but it was a different error and I was able to manually get rid of the overlay tags to fix it until you released the patch. This one had me stumped. Thanks for the quick fix!
 
After a bunch of testing I have resolved the issue. I am still new to the HTML tags within the tool and RW so it took some trail and error. The ability score section was working and the traits were not. The only difference is that the ability scores fall within the <table> tags.

I tested out putting the trait section into a table and it worked. So I assumed I needed some other tags to encapsulate the traits as I don't want them in a table. I used <html></html> and it worked. So it seems that if you want to format data with the html tags outside of a table you must use the html tags first. Lesson learned. Thanks!
 
After a bunch of testing I have resolved the issue. I am still new to the HTML tags within the tool and RW so it took some trail and error. The ability score section was working and the traits were not. The only difference is that the ability scores fall within the <table> tags.

I tested out putting the trait section into a table and it worked. So I assumed I needed some other tags to encapsulate the traits as I don't want them in a table. I used <html></html> and it worked. So it seems that if you want to format data with the html tags outside of a table you must use the html tags first. Lesson learned. Thanks!

That's good news. I'm not sure on the exact restrictions on the HTML side of things. It probably requires some sort of marker at the beginning and end, such as <p>...</p>. I don't think it has to be <html>
 
That's good news. I'm not sure on the exact restrictions on the HTML side of things. It probably requires some sort of marker at the beginning and end, such as <p>...</p>. I don't think it has to be <html>

Not sure. I am still having problems in some cells trying to figure out the syntax and the restrictions around it. Making progress though.
 
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


I think this is the problem I am running into now. I am trying to format a cell with italics and I have line breaks in the cell for formatting purposes. I am getting the came C++ error. Not sure if there is any way around this.
 
I think this is the problem I am running into now. I am trying to format a cell with italics and I have line breaks in the cell for formatting purposes. I am getting the came C++ error. Not sure if there is any way around this.

I think the issue is probably when the tool is converting your single cell into several paragraphs.

The tool takes a blank line as a paragraph break. Each paragraph is wrapped in some special RW html, so all html tokens have to be completely enclosed within each paragraph.

This means that all html elements must be closed before/at the end of each paragraph.
 
I think the issue is probably when the tool is converting your single cell into several paragraphs.

The tool takes a blank line as a paragraph break. Each paragraph is wrapped in some special RW html, so all html tokens have to be completely enclosed within each paragraph.

This means that all html elements must be closed before/at the end of each paragraph.

I tried that as well but still get the error. I have the first line with the ending tags, then the line break which is just open quotes, line break, line break, close quotes, then on the new line I open the tags again and continue.
 
Hi Joe,

In the example you sent me, you have a cell with the formula:
=CONCATENATE("<b><i>",X2,"</b>. ","<i>",Y2,"</i>. ",Z2)

However, this results in the b and i not nested properly. Since there is an opening b then i, but you only close the b after the X2.

In html, the elements need to be nested properly:
good = <b><i>Hello</i></b>
bad = <b><i>Hello</b></i>

In your other example, are you putting in " around the new lines just to get them into excel? The " aren't needed for the tool (they are required in CSV file format, but not in excel cells).

Is there a version of the excel concatenate function which will copy the cell format as well as the cell text when merging cells and free text together?

Google suggests that the following will add line breaks as part of concatenating multiple fields:
=A2 & " " & B2 & CHAR(10) & C2 & CHAR(10) & D2 & ", " & E2 & " " & F2
 
Last edited:
Hi Joe,

In the example you sent me, you have a cell with the formula:
=CONCATENATE("<b><i>",X2,"</b>. ","<i>",Y2,"</i>. ",Z2)

However, this results in the b and i not nested properly. Since there is an opening b then i, but you only close the b after the X2.

In html, the elements need to be nested properly:
good = <b><i>Hello</i></b>
bad = <b><i>Hello</b></i>

In your other example, are you putting in " around the new lines just to get them into excel? The " aren't needed for the tool (they are required in CSV file format, but not in excel cells).

Is there a version of the excel concatenate function which will copy the cell format as well as the cell text when merging cells and free text together?

Google suggests that the following will add line breaks as part of concatenating multiple fields:
=A2 & " " & B2 & CHAR(10) & C2 & CHAR(10) & D2 & ", " & E2 & " " & F2

I through that example together quick rather than sending you the longer file I had been working on. My nesting is correct in my other file. I actually changed to the CONCATENATE as a hope it would resolve the issue as I was using & to combine the text earlier. I had not tried char(10) however and will give that a shot. I was also thinking of trying the html break tag to see if that will work. I will keep at it. Thanks.
 
Looks like I got it. the char(10) didn't work right but using the html break tag
Code:
<br>
did. Thank you for the help on this. The tool is wonderful!
 
Looks like I got it. the char(10) didn't work right but using the html break tag
Code:
<br>
did. Thank you for the help on this. The tool is wonderful!

Thanks.
I think embedded HTML inside imported snippets is always going to be a little trial and error, to see what RW will accept and what it doesn't like.
 
Hey Farling - great tool! I'm working on entering Rappan Athuk (a not insubstantial task), and this tool is a near perfect starting point. I entered the sections and individual rooms as parents and children in my CSV columns and it mapped to the import exactly as anticipated.

I do have one feature request though - would it be possible to add the Name Management fields to the main name as well as to the alternate names (Ignore case, linking priority, etc). I have an alternate name for each location using its key (e.g., 1A-1 or whatever) which is how other areas are referenced in the text. As it is, because I can't tell the import structure to ignore the primary name, I'm getting a HUGE number of false positives for location areas named things like "Entrance," and I don't see a way to do a mass alteration in RW.

If I could get the import set up to ignore the main names, I would be golden.

Thanks for your work in bringing this super useful tool to the community.
 
Last edited:
Hey Justin, I believe in the current build of the tool, in the top right corner of the structure pieces there is a button that says Name and if you click it, it should start bringing up your different name options as additional fields below the regular name layout.

I'm not in front of the computer that has this on it, but I believe I have it remembered correctly.

Asandir.
 
Asandir, the "Name+" button does add a True name and allows other alternate names to be added; this is how I can add the individual location key numbers as alternate names that will map to those key numbers when referenced in the text. These alternate name lines have additional controls to set if they are to be shown in the navigation, if the case must match, and sets their linking priority. That all works great.

My problem is I need the program to allow me to set the Primary name as a priority of "Never" for the auto linking, and currently there isn't a way to do this (at least, not that I can find).

The module I'm entering doesn't reliably reference locations by name in the text; just by key number. The problem I ran into very quickly is relatively generic location names (e.g., "Entrance" which is the name of at least 3 or 4 locations) try to link to any text that has these relatively common words in it.

I could fix this very quickly if there were a way to tell the tool to Never link the primary name.

It makes sense that this is the way the tool was designed - I know the initial purpose for the tool was to easily import large batches of more mechanical content (spell lists, feat lists, equipment lists, etc), and generally you'd want these to link to the word in the text. I'm pushing the intended design, but I'm hoping the ability to set linking priorities for alternate names means it is possible to add the functionality of setting the linking priority for the primary name as well. It could also open up case matching for the primary name, which would potentially be useful.

What I would like to do can be done through the Manage Names tool in Realm Works (I double checked to make sure), but having to manually switch each topic when I have over 1000 entries is less than ideal.
 
Asandir, the "Name+" button does add a True name and allows other alternate names to be added; this is how I can add the individual location key numbers as alternate names that will map to those key numbers when referenced in the text. These alternate name lines have additional controls to set if they are to be shown in the navigation, if the case must match, and sets their linking priority. That all works great.

My problem is I need the program to allow me to set the Primary name as a priority of "Never" for the auto linking, and currently there isn't a way to do this (at least, not that I can find).

The module I'm entering doesn't reliably reference locations by name in the text; just by key number. The problem I ran into very quickly is relatively generic location names (e.g., "Entrance" which is the name of at least 3 or 4 locations) try to link to any text that has these relatively common words in it.

I could fix this very quickly if there were a way to tell the tool to Never link the primary name.

It makes sense that this is the way the tool was designed - I know the initial purpose for the tool was to easily import large batches of more mechanical content (spell lists, feat lists, equipment lists, etc), and generally you'd want these to link to the word in the text. I'm pushing the intended design, but I'm hoping the ability to set linking priorities for alternate names means it is possible to add the functionality of setting the linking priority for the primary name as well. It could also open up case matching for the primary name, which would potentially be useful.

What I would like to do can be done through the Manage Names tool in Realm Works (I double checked to make sure), but having to manually switch each topic when I have over 1000 entries is less than ideal.

Ahh. Sorry. Misunderstood what you were after and I don't have the importer in front of me at the moment. I don't think there is a way, but don't know that I have ever looked for what you are asking. Have to wait for Farling to get back to you then since it is his tool.
 
It is something that I was wondering how to present in the interface in a nice way (rather than cluttering up the main topic line with too many buttons.

I will be having a look at it after my holiday, in about a week's time :-)

(Issue was raised on 1/Aug, possibly by me.)
 
Back
Top