Lone Wolf Development Forums  

Go Back   Lone Wolf Development Forums > Realm Works Forums > Realm Works Discussion

Notices

Reply
 
Thread Tools Display Modes
kbs666
Senior Member
 
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690

Old August 29th, 2017, 09:15 AM
What part isn't working in the import?

my Realm Works videos
https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw
kbs666 is offline   #91 Reply With Quote
nightpanda2810
Senior Member
 
Join Date: Jun 2016
Posts: 204

Old August 29th, 2017, 09:19 AM
It imports successfully, but it looks like this. Ignore some of the names, experimenting with it right now.

Edit: All the "weapons" on the left are a result of the import. I'm hoping to have a list on the right hand side like my previous image.

nightpanda2810 is offline   #92 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old August 29th, 2017, 03:14 PM
Ah, I see what you are trying to do.

The tool isn't designed to put a complete CSV file into a single topic. It is designed to create a separate topic for each row in the CSV file.

It would require a quite different structure to the program to be able to create a single topic with a separate snippet for each row in the 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
Farling is offline   #93 Reply With Quote
nightpanda2810
Senior Member
 
Join Date: Jun 2016
Posts: 204

Old August 30th, 2017, 05:51 AM
Quote:
Originally Posted by Farling View Post
Ah, I see what you are trying to do.

The tool isn't designed to put a complete CSV file into a single topic. It is designed to create a separate topic for each row in the CSV file.

It would require a quite different structure to the program to be able to create a single topic with a separate snippet for each row in the CSV file.
Ah, damn! Oh well, back to manually creating these lol. Thanks!
nightpanda2810 is offline   #94 Reply With Quote
kbs666
Senior Member
 
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690

Old August 30th, 2017, 12:44 PM
But there's no reason with a little spreadsheet magic you couldn't get what you want.

you tried to put one file into each topic which doesn't work. What does work is putting a single row into a single topic. So figure out the structure these topics need, including these loot tables, and make them one row of the CSV.

my Realm Works videos
https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw
kbs666 is offline   #95 Reply With Quote
nightpanda2810
Senior Member
 
Join Date: Jun 2016
Posts: 204

Old August 31st, 2017, 03:50 AM
Quote:
Originally Posted by kbs666 View Post
But there's no reason with a little spreadsheet magic you couldn't get what you want.

you tried to put one file into each topic which doesn't work. What does work is putting a single row into a single topic. So figure out the structure these topics need, including these loot tables, and make them one row of the CSV.
Interesting, I'll give this a shot. Thanks!
nightpanda2810 is offline   #96 Reply With Quote
K126
Junior Member
 
Join Date: Sep 2017
Posts: 6

Old September 19th, 2017, 04:11 AM
Might be a dumb question but how do I import text strings containing commas without having the commas being interpreted as delimiters?
K126 is offline   #97 Reply With Quote
Valyar
Senior Member
 
Join Date: Jul 2017
Posts: 347

Old September 24th, 2017, 08:13 AM
Quote:
Originally Posted by K126 View Post
Might be a dumb question but how do I import text strings containing commas without having the commas being interpreted as delimiters?
Enclose the whole string with “ “. It is valid, but must be for every item. I have Whole paragraphs imported from Dark Heresy core rule book this way. For example:

Name,Titles
“Name”,”Title01, Title 02”

Best way to ensure all is in proper format is to fill the table in Excel and export in CSV.

The past is a rudder to guide us, not an anchor to hold us back.
Valyar is offline   #98 Reply With Quote
kbs666
Senior Member
 
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690

Old September 24th, 2017, 08:53 AM
Quote:
Originally Posted by Valyar View Post
Best way to ensure all is in proper format is to fill the table in Excel and export in CSV.
This is really the easiest way for most things. Building CSV files by hands is very tedious.

my Realm Works videos
https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw
kbs666 is offline   #99 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old September 24th, 2017, 01:16 PM
Quote:
Originally Posted by Valyar View Post
It is valid, but must be for every item.
In a CSV, the "...." is only required around the items which have embedded commas. For simple columns it shouldn't be required.

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
Farling is offline   #100 Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 03:22 AM.


Powered by vBulletin® - Copyright ©2000 - 2024, vBulletin Solutions, Inc.
wolflair.com copyright ©1998-2016 Lone Wolf Development, Inc. View our Privacy Policy here.