View Single Post
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625

Old March 17th, 2019, 07:06 AM
Quote:
Originally Posted by Acenoid View Post
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 View Post
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

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.
Farling is offline   #479 Reply With Quote