• 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

I successfully created a spreadsheet with drop downs for the default choices. I'm able to make my selections, than save as a .csv file and do the rest of the import.
5e3igHZgYwwffHep9

https://photos.app.goo.gl/5e3igHZgYwwffHep9

I can't figure out the Background date fields though.
In your tool, which fields are you mapped to, the dates or the annotation fields?
My screenshot doesn't show it mapped, but I have mapped it, with what I thought was the correct format for a date and it didn't show up in either.
Jjdcgz5NSyRNsqPQ6

https://photos.app.goo.gl/Jjdcgz5NSyRNsqPQ6
 
Last edited:
Kimco said:
I can't figure out the Background date fields though.
In your tool, which fields are you mapped to, the dates or the annotation fields?
Click to expand...

Hi,

Dates don't import properly yet, so the only option is to copy the data field into the "annotation" part of the snippet.
 
Version 1.26 has just been released.

This version replaces the "Import Name" text box with a button "File Details" which opens up a separate dialog box.

In this new window you can set the "import name" as well as lots of other meta-data for the import file.

(Whilst there is initial support in this version for date fields, the import crashed RW in my tests so don't try using it.)
 
Awesome tool. One question, more related to the RW side of things - when exporting the structure, it just exports the categories, correct, and lets you create things in the categories, but not in groupings under that?

For example, if in my World Almanac/People section I have a list of individual dragons, and I wanted to import more, would I be able to import it into Cast List\Dragon? Or does it just go to People?

Hopefully the image Illustrating my question attaches. lol. Guess not. Here's a link... https://www.dropbox.com/s/slsk4t4hfrejamo/dragons.PNG?dl=0
 
Last edited:
Vanye111 said:
Awesome tool. One question, more related to the RW side of things - when exporting the structure, it just exports the categories, correct, and lets you create things in the categories, but not in groupings under that?

For example, if in my World Almanac/People section I have a list of individual dragons, and I wanted to import more, would I be able to import it into Cast List\Dragon? Or does it just go to People?[/url]
Click to expand...

Unfortunately, due to the limitations of the format of the RWEXPORT file, if you define a parent for the topics with the CSV import tool then the parent topic is created on import, even if a topic already exists with the same name - so you have two topics with the same name in the realm.

I am considering whether it is feasible to read in an entire realm export file instead of only a structure export file; which would allow existing topics to be chosen as parents. (The tool needs to get RW's internal identifier for the topic, so that it can use that specific topic as a parent.)
 
Hey Farling, how ya goin'? I am trying to import a csv created with excel, and I keep running into the same issue. I think I followed all the steps correctly, but the resulting rwexport file crashes RW when I go to import it. It minimizes RW, gets about 35% done really fast and then crashes with the message "There is an unclosed literal string. Line 1720. position 85."

any idea what went wrong?
 
ErinRigh said:
Hey Farling, how ya goin'? I am trying to import a csv created with excel, and I keep running into the same issue. I think I followed all the steps correctly, but the resulting rwexport file crashes RW when I go to import it. It minimizes RW, gets about 35% done really fast and then crashes with the message "There is an unclosed literal string. Line 1720. position 85."

any idea what went wrong?
Click to expand...

At a guess, can you check the file created by the tool in something like notepad++ to see what is at line 1720. It might be an error in the decoding or perhaps a " appears in a string in your data that hasn't been marked properly.
 
Last edited:
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
 
ErinRigh said:
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
Click to expand...

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 said:
Here mate, I am lost here, but this is what I am working with.
Click to expand...

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.
 
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".
 
Version 1.27 has just been released

This version supports numeric snippets, so that ErinRigh can import his CSV data properly.
 
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.
 
Farling said:
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".
Click to expand...

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.
 
ErinRigh said:
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.
Click to expand...

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 :-)
 
You must log in or register to reply here.
Back
Top