Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
I don't know the specific issue with Excel when creating multi-line entries in the CSV file. The correct format is simply to have the line break appear inside the double-quote marks that surround the value of a field.
A quick test shows the following CSV file was generated for 4 lines in the spreadsheet: what,the vaule,another value line 1,a single line,"a line with a line break" line 2,another single line,yet another singleline line3,,no data in previous column 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; April 3rd, 2018 at 09:56 AM. |
#221 |
Member
Join Date: Mar 2018
Posts: 46
|
Quote:
Spellcasting. He is a 3rd level caster." "Cantrips: spell1, spell2 Need that extra blank line. One last question for you though I don't think its possible. Is there any way to add bold and italics? I know CSV doesn't support it, but is there a tag I can add that the xml would pick up and then it would work? |
|
#222 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
The tool doesn't go down to that level. However, it does allow you to specify the snippet style that is applied to the entire snippet.
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 |
#223 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
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 |
|
#224 |
Member
Join Date: Mar 2018
Posts: 46
|
Quote:
I have both. It has to be something with the structure as I created a VERY minimal CSV file with only 1 row and 4 columns and still got errors. What is the best way to send you these? |
|
#225 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Links to any cloud service, e.g. dropbox, in a private message would be fine.
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 |
#226 |
Member
Join Date: Mar 2018
Posts: 46
|
|
#227 |
Member
Join Date: Mar 2018
Posts: 46
|
For some reason CR is not importing for me. Can you see if you can reproduce this?
|
#228 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
Did you generate the RW structure file directly from Realm Works? It has some rogue "overlay" elements. Was this from a realm that was created a few years ago, or a newish realm? When I used your structure file to create a brand new realm, and then did a structure-only export from that the new realm, the RW structure file did NOT have the "overlay" elements in it. 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; April 4th, 2018 at 08:30 AM. |
|
#229 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
The tag values for the Challenge Rating tag defined in your structure-only export file includes "CR " in front of the numeric value, so this text must also appear at the start of the CR field in your CSV file.
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 |
#230 |
|
|