Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
So if that changes, all will be good?
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?
I think CSV file formats might allow single quote to be used as an alternative to double quotes to mark the boundaries of a single field.
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?
I think that multi-line fields can be defined in the CSV file by putting double quotes at the start and end of each field. At the moment, the CSV Import tool puts everything into a single paragraph. I suppose the tool could be updated so that a blank line in the middle of some text marks indicates where a paragraph break is required? Would this handle the text in your case?
The conversion from plain text to URL is usually a manual thing that the program does. I could add this into the CSV import tool, possibly as an option in case other users don't want URLs converted (although I guess RW will convert them as soon as the text is edited anyway).
At the moment it isn't possible to import images easily. I don't think there is a way to encode them in CSV format. The RWEXPORT file format allows images to be defined, but the difficulty is creating a simple way for my CSV import tool to detect an image reference inside the CSV file.
---
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
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!
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.
If I am trying to export content that was imported into RW using this tool, would that cause a problem? Would different mechanic structures be a factor? Also the report keeps saying, "Domain has no tags defined" before RW crashes.
Thanks in advance
I'm sure about exporting the data again.
Is the "Domain has no tags defined" error being reported during the export process or the import process?
If it is during the export process then either a domain has no tags in it, or there is something else happening which will require you to raise a support ticket with LWD for them to have a look at your realm.
I re-did the import with the new version and the paragraph fix worked beautifully.
Thanks!!!
That's good to hear
The next task is how to get images into the RW import file.
Would images be inlined inside the CSV file, or would the filename be present as a field in the CSV file?
The path and filename would be a field in the CSV. I don't think there is a way to include an actual image in a CSV file. At least not in a format that would be easy to use.
It would either be a URL that returns and image, or a local file path. I assume it would be much easier to use a full path (C:\username\documents\......) than a relative one, unless you specify where to put the image files.