RealmWorks CSV Import Tool - Page 26

daplunk · June 6th, 2018, 02:15 PM

What format is Notepad++ working in? I've had issues before with it being too smart.

daplunk · June 6th, 2018, 02:17 PM

Kept getting requests for a video on how to use this tool so here it is.

https://youtu.be/A1i3FqHfi9E

nightpanda2810 · June 6th, 2018, 02:24 PM

Quote:

Originally Posted by daplunk

What format is Notepad++ working in? I've had issues before with it being too smart.

Ha! I've run into that too. I'm using its default settings.

I just tried with regular Notepad with the same results. I suppose Excel would be the next one to try.

Farling · June 6th, 2018, 03:44 PM

Are you putting the data into a normal text snippet, rather than a field that only allows a single line of text?

Farling · June 6th, 2018, 04:06 PM

Quote:

Originally Posted by daplunk

Kept getting requests for a video on how to use this tool so here it is.

https://youtu.be/A1i3FqHfi9E

That's a great introductory video!

nightpanda2810 · June 6th, 2018, 04:37 PM

Quote:

Originally Posted by Farling

Are you putting the data into a normal text snippet, rather than a field that only allows a single line of text?

Yeah, labeled text and text both do the same, no trouble having multiple lines in both otherwise.

Here's a screenshot of Notepad++, Excel, RW after import, and Import tool pre-import.

Not show in the screenshot is trying to import into a generic text field as well.

I should note I'm running the latest Windows 10.

Farling · June 6th, 2018, 11:20 PM

I'll have to have another look at the CSV import routine.
It was working well a few versions ago, so maybe updating to Qt 5.10 has broken it.

nightpanda2810 · June 7th, 2018, 03:17 AM

Quote:

Originally Posted by Farling

I'll have to have another look at the CSV import routine.
It was working well a few versions ago, so maybe updating to Qt 5.10 has broken it.

Thanks! If there's anything I can do to help test let me know.

Farling · June 7th, 2018, 02:10 PM

The description of V1.9 includes the fact that you need to have a blank line between each of the paragraphs that you want to import for multi-line text. In your case, each line of text is considered a paragraph, so the following should work:

Name,Size,Languages
Bob,Medium,"Aklo

Common

Sylvan"

nightpanda2810 · June 7th, 2018, 03:48 PM

Quote:

Originally Posted by Farling

The description of V1.9 includes the fact that you need to have a blank line between each of the paragraphs that you want to import for multi-line text. In your case, each line of text is considered a paragraph, so the following should work:

Name,Size,Languages
Bob,Medium,"Aklo

Common

Sylvan"

That did it, thank you! Never would have thought of that

Farling Senior Member Join Date: Mar 2013 Location: Greater London, UK Posts: 2,623 June 6th, 2018, 03:44 PM	Are you putting the data into a normal text snippet, rather than a field that only allows a single line of text? 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
#254

Farling Senior Member Join Date: Mar 2013 Location: Greater London, UK Posts: 2,623 June 6th, 2018, 11:20 PM	I'll have to have another look at the CSV import routine. It was working well a few versions ago, so maybe updating to Qt 5.10 has broken 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
#257