Senior Member
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690
|
Quote:
In a CSV file commas mark the end of a column and the new line symbol marks the end of the row. Therefore to include either one in your data you need to wrap it in quotes. Since quotes themselves are treated as a special symbol if you need to include a quotation mark you need to wrap it in quotes as well. This is why I wrote above that for all but the most trivial CSV files it is far easier to build the file in Excel or some other spreadsheet program and then export it as a CSV rather than trying to build it by hand. my Realm Works videos https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw |
|
#101 |
Junior Member
Join Date: Sep 2017
Posts: 6
|
Thanks a lot! I was aware of the quotes, but I put them around each delimiter and not around the whole text block, which makes it obviously easier. :-)
|
#102 |
Senior Member
Join Date: May 2014
Posts: 203
|
What is CSV?
GM of HARP, Rolemaster, Spacemaster, Dreamchaser, Savage Worlds, and a myriad of other not so well known systems. Software I use for gaming: Realm Works, Inspiration Pad Pro, Ebon, Aeon Timeline, Scrivener, Syrinscape, Hexagon, Fantasia Archive, OneNote, and a spreadsheet program. Mapping programs: CC3+, MapForge, Worldographer, Xara Photo and Graphic Designer 10. Programming experience: Java and Javascript (Maptools and PDF programming). |
#103 |
Senior Member
Join Date: Mar 2014
Posts: 411
|
Comma Separated Values.
It's a type of file format where each column of data is separated from the next by a comma, and each row ending with a newline character. It's a pretty universal way of sending tabular data from one place to another. Almost every data source will have a way to read CSV files. |
#104 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
And now Realm Works does too (indirectly) :-)
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 |
#105 |
Junior Member
Join Date: Mar 2016
Posts: 19
|
I'm importing my first CSV file into this program as I type. Its a list of all the magic spells in 5e. I'm sure I'm going to have to figure some things out with it being overly aggressive on links (curse you 'light' spell!) but I'll figure those out as I go.
This might be outside the scope of what this tool does, but it would be a nice feature to be able to export existing articles, do mass clean ups in excel, then reimport to update in bulk. Thanks for putting time into this, its an excellent tool! Last edited by Guyanthalas; October 6th, 2017 at 02:46 PM. Reason: spelling |
#106 |
Junior Member
Join Date: Mar 2016
Posts: 19
|
Also, got this error importing my CSV file:
Quote:
|
|
#107 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
Perhaps something like Quote:
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 |
||
#108 |
Member
Join Date: Nov 2016
Posts: 40
|
Hi, I've been getting this specific problem, with a few imports. Can someone please help me with this?
Thanks in advance The following errors were encountered during import: Encountered validation error for the import XML: The 'public_name' attribute is invalid - The value '' is invalid according to its datatype 'urn:lonewolfdevel.com:realm-works-export:top_level_name_type' - The actual length is less than the MinLength value. Invalid name specified |
#109 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
I will have a look to see what is going on. 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 |
|
#110 |
|
|