Member
Join Date: Nov 2016
Posts: 40
|
So if that changes, all will be good?
|
#121 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Yes, although you could try v1.8 that I've just uploaded which means you won't have to change your Realm Works structure :-)
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 |
#122 |
Junior Member
Join Date: Oct 2017
Posts: 15
|
I've been playing around with this tool, which is way freaking cool BTW, and have been having some small issues. Here is what is happening.
I have a slew of data in Excel for Traveller systems. It includes everything from specifications of the system to long descriptions of the history, patrons, adventure seeds, etc. The items that seem to be causing issues are: 1. Many system names (and in several description fields) there is text with ' in them. This is usually in a system name such as "A'eouya", but is also in text such as "The captain's chair". After reading through this topic I tried to put double quotes around the system name, which allowed a small sample import to run, but the system name showed up in RW as "A’eouya". It also put the "’" in any spot a single quote was in the text. Is there a way to avoid getting the ’ characters and get the ' instead? And do I need to go put " around every system name that has an ' in it? 2. Many descriptions are multiple paragraphs with line feeds in them. This caused the import to get misaligned and put things in the wrong fields, resulting in it attempting to populate the public_name field with an entry that was a few paragraphs long. I have tried to fix this by editing the CSV file in Notepad++ and it seems to help, but then the text shows up in RW as one big block of text which can be difficult to read. How can I keep the paragraphs for the import? 3. If I have a text string in the CSV that represents a URL, what type of snippet should I import it into so that it shows up as an active link in the topic view? I tried text, but it just shows up as plain text until I edit something in the topic and save it, at which point it is recognized as a URL. 4. How can I import a simple picture from a URL? I know if I go in and select load from file and put a URL in, it will import the image. Can I do that with an import as well? Thanks!!!! |
#123 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
I will have to look to see why the single quote character is being imported as three separate characters. It might be encoding problems. Could you have a look at the CSV table which is displayed in the bottom half of the window to see if that table still shows the single quote or is showing those three characters? This will help me know if it is the CSV reader or the XML writer which is causing the issue. Do single quotes appear fine in other parts of text? Quote:
Quote:
Quote:
--- So, new feature requests appear to be: 1 - handle single quote properly 2 - detect paragraphs when importing large amounts of text. 3 - detect URLs when importing text. 4 - provide some mechanism to import images. 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; October 18th, 2017 at 12:10 AM. |
||||
#124 |
Senior Member
Join Date: Jan 2013
Location: Rochester, MN
Posts: 1,518
|
Problem 1 is Smart Quotes being misinterpreted; somewhere along the line they're getting converted to UTF-8 and then reinterpreted as "not Unicode".
Last edited by Parody; October 18th, 2017 at 05:57 AM. |
#125 |
Junior Member
Join Date: Oct 2017
Posts: 15
|
Quote:
Quote:
Quote:
Quote:
Quote:
Thanks! |
|||||
#126 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
Wow goog luck have t check out the new versio nwhen it comes as well Quite an undertaking but this could ease up the import in RW I suppose... quite a bit
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 |
#127 |
Senior Member
Join Date: Mar 2013
Location: Denver, CO
Posts: 437
|
So can I export what I need for my game and import using this tool?
Trying to do this with the built-in import/export breaks RW, and the devs haven't fixed it for me yet.... D100 for life! |
#128 |
Junior Member
Join Date: Oct 2017
Posts: 15
|
Farling
I just went through and edited my CSV to remove the line feeds and it imported fine. The singe quotes all imported properly, no editing required from me on that part. So the single quotes issue doesn't seem to be an issue. Not sure what was going on yesterday with it. The paragraph thing is still an issue. In the CSV file it makes each paragraph a new line, which is screwing up the import. I don't know if there is a way around that. I changed the Picture snippets back to text and it imported the URLs. I just need to edit a page for them to become active, which while a bit of a pain, isn't all that bad. However, if there was a way top import the file path directly that would be awesome. Thanks! |
#129 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
Another file with an image in a CSV file would be useful for testing. 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 |
|
#130 |
|
|