Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
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 |
Member
Join Date: Mar 2018
Posts: 46
|
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.
|
#472 |
Member
Join Date: Mar 2018
Posts: 46
|
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 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
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? 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 |
|
#474 |
Member
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57
|
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. |
#475 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
This check for "<" and ">" is required because otherwise the import will go wrong when importing some non-html that happens to contain the ">" character. 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 |
|
#476 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
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. Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers) -> Browser Client: https://kiwiirc.com/client/irc.rizon.net |
#477 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
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. Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers) -> Browser Client: https://kiwiirc.com/client/irc.rizon.net Last edited by Acenoid; March 16th, 2019 at 03:04 PM. |
#478 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
Quote:
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 Last edited by Farling; March 17th, 2019 at 03:23 PM. |
||
#479 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
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 Last edited by Farling; March 17th, 2019 at 02:30 PM. |
|
#480 |
|
|