RealmWorks CSV Import Tool - Page 48

Farling · March 11th, 2019, 03:24 PM

Ah, good :-)

HTML inside cells is always a challenge.

joe2chillo · March 11th, 2019, 04:00 PM

Quote:

Originally Posted by Farling

Ah, good :-)

HTML inside cells is always a challenge.

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.

joe2chillo · March 11th, 2019, 05:39 PM

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?

Farling · March 11th, 2019, 11:06 PM

Quote:

Originally Posted by joe2chillo

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?

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?

Janrith · March 16th, 2019, 01:25 AM

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 · March 16th, 2019, 03:01 AM

Quote:

Originally Posted by Farling

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.

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.

Acenoid · March 16th, 2019, 02:46 PM

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.

Acenoid · 03:04 PM

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.

Farling · 03:23 PM

Quote:

Originally Posted by Acenoid

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?

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.

Quote:

Originally Posted by Acenoid

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.

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.

Farling · 02:30 PM

Quote:

Originally Posted by Acenoid

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.

Ok, I've managed to repeat this by having a column assigned to the annotation, but no column assigned to the actual picture itself.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Farling Senior Member Join Date: Mar 2013 Location: Greater London, UK Posts: 2,623 March 11th, 2019, 03:24 PM	Ah, good :-) HTML inside cells is always a challenge. Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal
#471

joe2chillo Member Join Date: Mar 2018 Posts: 46 March 11th, 2019, 05:39 PM	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?
#473