• 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 2.3 is released

This version fixes a problem where the default cell formatting was not being applied when reading an Excel spreadsheet. This would typically be seen by the initial formatting in a cell not being honoured when read in (which can be seen in the table at the bottom of the tool's window).

This should fix daplunk's problem with the columns not starting with BOLD text.
 
I created a file using the tool. So far so good. Now I go to import that to a realm and I get an error every time.

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

Any ideas as to what would cause this? Not sure if it is related to the tool or not. I am importing a file with a bunch of creatures. I used a structure I created and have used several times before. Thanks.
 
joe2chillo said:
I created a file using the tool. So far so good. Now I go to import that to a realm and I get an error every time.

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

Any ideas as to what would cause this? Not sure if it is related to the tool or not. I am importing a file with a bunch of creatures. I used a structure I created and have used several times before. Thanks.
Click to expand...

This usually indicates something wrong in the HTML import file.

Does your source data have HTML inside it? If so, is it all formatted properly?

If you don't have any HTML, then I'll need to see the source file and the generated RWexport file to see what might be causing the problem.
 
Farling said:
This usually indicates something wrong in the HTML import file.

Does your source data have HTML inside it? If so, is it all formatted properly?

If you don't have any HTML, then I'll need to see the source file and the generated RWexport file to see what might be causing the problem.
Click to expand...

Yes. I have HTML and leaving those fields out seems to resolve the issue. Not sure whats wrong as I have done this before but I will mess with the tags.

I have the excel broken up so that for something like an actions, it has the title which is generally bold and italic in one field, and then the description in the next field. I put the bold and italic tags around those cell references.

Code: 
=IF(AK4<>"","<html><b><i>"&AK4&". </i></b>"&AL4&"</html>"&IF(DA4<>"","
"&DA4,"")&IF(DG4<>"","
"&DG4,"")&IF(DH4<>"","
"&DH4,""),"")

So something like this would come out looking like: Multiattck.The creature makes 2 attacks with its claws.

The additional lines are incase the description has more than one paragraph.

So AK4 has "Multiattack" in the cell. AL4 has "The creature makes 2 attacks with its claws." in that cell. In this example the other cells are empty.
 
I can't remember exactly how embedded HTML works with Realm Works, but I don't think you need the "<html></html>" tags around the i and b tags to get it displayed in RW.
 
joe2chillo said:
I tried dropping those tags but still gets the error.
Click to expand...

Can you shrink down your source file to just the line or lines that are causing the problem?

Do the cells that you are joining together (e.g. AK4) have the "<" symbol to be displayed? This will cause problems with the HTML.
 
Farling said:
Can you shrink down your source file to just the line or lines that are causing the problem?

Do the cells that you are joining together (e.g. AK4) have the "<" symbol to be displayed? This will cause problems with the HTML.
Click to expand...

The cells I was combining had no tags but I figured it out. The HTML Tags are required but the </html> tag needs to go at the end. So I just looked to see if there was anything in the initial field again and if there is I put the close html tag, if not its blank. So the above example needs to look like this:

Code: 
=IF(AI2<>"","<html><b><i>"&AI2&". </i></b>"&AJ2&IF(IL2<>"","
-"&IM2&"
-"&IN2&"
-"&IO2,"")&IF(BD2<>"","
"&BD2,"")&IF(LF2<>"","
-"&LG2&"
-"&LH2,"")&IF(IF2<>"","
"&IF2,"")&IF(AI2<>"","</html>",""),"")
 
Farling said:
Ah, good :-)

HTML inside cells is always a challenge.
Click to expand...

Ya. I am still having some issues. I fixed that one column but having issues with other columns. I'll keep messing with it. I just wish I could bold a column and have that formatting stay when I reference the cell.That would make like so much easier.
 
I am still trying to work through some of these HTML issues. I have found some but I am stuck on one right now. The error mentions utility.cpp but thats not a file I can see. Is there a way to debug my issue based on the error message?
 
joe2chillo said:
I am still trying to work through some of these HTML issues. I have found some but I am stuck on one right now. The error mentions utility.cpp but thats not a file I can see. Is there a way to debug my issue based on the error message?
Click to expand...

The only useful(?) error is the one you reported before, "Not in a span at line 1633 in file utility.cpp". This indicates that the HTML inside a snippet is not well formed.

Using the tool to read an excel document will read in the formatting of the cell, so the bold and italic that you see in excel should translate across into your imported realm. This might help you avoid putting explicit HTML into a particular cell. Can you generate your formula using standard excel instructions to switch on bold for the prefix whilst switching it off for the rest of the cell?
 
I am also getting the C++ Exception: Not in a span at line 1633 in file utility.cpp error.

I am fairly confident it is a data issue; I have no HTML in my xlsx file, but I do have a Components field that does have gt characters occasionally (e.g. powdered diamond duct >= 500gpv).

I imported a single row that didn't have any notes (by removing all <topic/> elements from the rwexport file rather than killing my excel file).

I'm trying an import definition that leaves off that column and will report back.
 
Farling said:
I can't remember exactly how embedded HTML works with Realm Works, but I don't think you need the "<html></html>" tags around the i and b tags to get it displayed in RW.
Click to expand...

Just to add a clarification about this. When importing the original data, if the data in a cell start with "<" and ends with ">" then it is assumed to be pre-formatted HTML. The actual tag at the start/end of the cell doesn't have to be "html"; for instance you could use "p".

This check for "<" and ">" is required because otherwise the import will go wrong when importing some non-html that happens to contain the ">" character.
 
Hi there!

After some time Iam experimenting again with your fabulous tool! Going to import now and I think everything works. Unless I put a field of my source XLSX into the "annotation" bit of a picture tag. Then the program floods with "File/URL does not exist:" when clicking on generate file.

Not sure why it does that. The field might be too long for the annotation text? I don't really need it and just messed around, but I wanted to report it :)

Let me know if you require more information. Going to import now w/o that annotation and will see how it goes.
 
Update - Import worked fine.

Two very minor things identified so far:

1st I had one cell formatted like this: 999.999.999,99 -> it is a price column and excel showed the numbers in a convinient way. Very high prices were also imported as ​4.35e+08​ for example.
I suppose the cell formatting is not carried over to RW by the importer , or do I have options?

2nd Some tag fields were left empty (restricted tag domain snippets). The spelling in the XLSX cell was "Transporter, Mittelschwer" and the Structure file named the tag domain "Transporter, mitelschwer". I suppose it's case sensitive, but it would be great if the tool would report inconsistencies, so I know that not all tags were imported to RW.
 
Last edited:
Acenoid said:
1st I had one cell formatted like this: 999.999.999,99 -> it is a price column and excel showed the numbers in a convinient way. Very high prices were also imported as ​4.35e+08​ for example.
I suppose the cell formatting is not carried over to RW by the importer , or do I have options?
Click to expand...

I think the issue is with the format of the numbers. The standard XML format is to have no thousands separators, and to use "." for the decimal point. Unfortunately I haven't found a simple method of converting from the local country syntax into the XML format.

Acenoid said:
2nd Some tag fields were left empty (restricted tag domain snippets). The spelling in the XLSX cell was "Transporter, Mittelschwer" and the Structure file named the tag domain "Transporter, mitelschwer". I suppose it's case sensitive, but it would be great if the tool would report inconsistencies, so I know that not all tags were imported to RW.
Click to expand...

The mismatch was already being reported by the tool, but you would only see the message if you launched the tool from a CMD line. Version 2.4 puts all these messages into a window to make them appear somewhere that most people might notice them.
 
Last edited:
Acenoid said:
Hi there!

After some time Iam experimenting again with your fabulous tool! Going to import now and I think everything works. Unless I put a field of my source XLSX into the "annotation" bit of a picture tag. Then the program floods with "File/URL does not exist:" when clicking on generate file.
Click to expand...

Ok, I've managed to repeat this by having a column assigned to the annotation, but no column assigned to the actual picture itself.
 
Last edited:
You must log in or register to reply here.
Back
Top