RealmWorks CSV Import Tool

[Farling]

Originally Posted by ErinRigh

Hey mate, I checked the rwexport file and it appears that the tool quit compiling the file at line 1720, IDK why it would do that, but the tool CTD when I try to use it. I press Generate and the dialog box that shows percent complete pops up, shows 0%, and crashes the tool, apparently after making the first 1720 lines of the rwexport. I didn't realize it was crashing, I thought it just shut down after use

If you look at the end of the generated RWEXPORT file, can you identify which line of your CSV crashed the tool?

If so, could you try just that one line and it works, could you PM the file to me so that I can see the exact problem please.

[ErinRigh]

Here mate, I am lost here, but this is what I am working with.

[Farling]

Originally Posted by ErinRigh

Here mate, I am lost here, but this is what I am working with.

Thanks for the file.

I have identified the problem, it is because the "Unit Tonnage" field is configured as a "Numeric" field in your Category definition of "MyIndividual".

I will need to do some testing to find the correct input format for this field.

Meanwhile if you change that field in your structure to be a labelled text snippet the conversion should work properly.

[ErinRigh]

Ok cool thanks

[Farling]

Erin, there are a few odd characters in your CSV file.

The "Trch" seems contain some additional character (binary value 129) which don't map onto a UTF-8 character properly. This might cause your input data not to be imported correctly.

"Ded Trch" or "Akhlakh Trch" - perhaps you are expecting accented characters where "?" appear in "T?r??ch".

[Farling]

Version 1.27 has just been released

This version supports numeric snippets, so that ErinRigh can import his CSV data properly.

[ErinRigh]

Wow, awesome, mate

[Farling]

Version 1.28 is now available

This version adds the ability to set the veracity of each snippet (True, Partially True, Untrue).

This is available from the new "Options" button for each snippet, which also includes the old snippet-style selector.

[ErinRigh]

Originally Posted by Farling

Erin, there are a few odd characters in your CSV file.

The "Trch" seems contain some additional character (binary value 129) which don't map onto a UTF-8 character properly. This might cause your input data not to be imported correctly.

"Ded Trch" or "Akhlakh Trch" - perhaps you are expecting accented characters where "?" appear in "T?r??ch".

Thanks for pointing that out, mate. I didn't even notice and yes there are supposed to be accented characters there, specifically "ü" which is "ү" in cyrillic the word is Türüüch (түрүүч). It means Sergeant in Mongolian.

[Farling]

Originally Posted by ErinRigh

Thanks for pointing that out, mate. I didn't even notice and yes there are supposed to be accented characters there, specifically "ü" which is "ү" in cyrillic the word is Türüüch (түрүүч). It means Sergeant in Mongolian.

Hi, I will update the notes on the front page to clarify that the CSV file should be encoded in UTF-8 format if non-ASCII text is required :-)