Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
I thought it was universal, since CSV means "comma separated values", not "semi-colon separated values" :-) Further reading shows that it is MICROSOFT who are breaking the CSV standard (using some silly "list separator" regional setting). 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; July 12th, 2018 at 03:30 PM. |
|
#291 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Version 1.31 is out
The default separator for CSV files is now going to use your language's "list separator". For English speaking countries this is most likely still the "," character. For some European, and possibly other, languages, Microsoft (in its "infinite wisdom" [i.e. usual practise of breaking published standards]) uses ";" as the list separator instead. Microsoft apparently didn't realise they could break the standard further by adding a non-standard escape character, so there's no support for that in the tool The list separator can be changed manually through the Windows Settings panel (if you dig deep enough). Primarily this just means less quote marks around field values. P.S. I hope I didn't break anybody's existing CSV files with this change/improvement. Please let me know if I did. 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; July 12th, 2018 at 04:04 PM. |
#292 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Version 1.32 is out
This is just a minor update to allow the CSV field separator to be specified from the main menu. You can choose from comma, semi-colon, or whatever Windows has configured as the list separator. 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 |
#293 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
Great!
Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers) -> Browser Client: https://kiwiirc.com/client/irc.rizon.net |
#294 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Version 1.33 has just been released
1. It is now possible to mark a section as starting in the "collapsed" state. 2. You can specify a particular CSV column to be used as the name of a section within a topic. 2.1 Select "..." and set a column for the "First Section" box (leave the other two section boxes blank). 3. You can specify a range of CSV columns to be used to create multiple sections within a section. 3.1. Select "..." and set a column for the First, Second, and optionally the Third section box. 3.1.1. The First section defines the CSV column containing the title of the first section. 3.1.2. The Second section defines the CSV column containing the title of the second section. 3.1.3. The Final section (defaults to last column) defines the CSV column containing the title of the last section. 3.2. The snippets within the section should be set to use CSV columns between First and Second column. 3.3 For the second and subsequent sections, the same "offset" will be used for reading the text from the correct column of the CSV table. Note that the first time that the CSV cell for the "section header" is empty, then the creation of those sections stops immediately (it doesn't continue up to the "final section" column). Multiple Column Example CSV columns: room1, description1, occupants1, room2, description2, occupants2, room3, description3, occupants3, room4, desc4, occ4, room5, desc5, occ5 Configure the relevant section in the tool as: First Section = room1 Second section = room2 Last section = room5 (or leave empty) In the snippets inside the section, use description1 and occupants1 (the tool works out the offset from column 'room1' to column 'description1' and applies that offset when populating for 'room2', 'room3' ,etc.) When the RWexport file is generated, the first section will use description1 and occupants1, the second section will use description2 and occupants2, and so on, up to the last section that will use desc5 and occ5 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; July 15th, 2018 at 05:58 AM. |
#295 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294
|
Round of applause.
Realm Works - Community Links Realm Work and Hero Lab Videos Ream Works Facebook User Group CC3+ Facebook User Group D&D 5e Community Pack - Contributor General Hero Lab Support & Community Resources D&D 5e Community Pack - Install Instructions / D&D 5e Community Pack - Log Fault / D&D 5e Community Pack - Editor Knowledge Base Obsidian Obsidian TTRPG Tutorials |
#296 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
The changes I'd made in v1.29 to support using the same category for multiple levels of parent made this improvement almost trivial
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 |
#297 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
I have a question with this version (not downloaded yet but it sounds very useful). You write sections, but is this also possible with snippets within a section?
For example.... Section 1 -> Snippet 1 (flavour 1) -> Snippet 2 (flavour 2) -> Snippet 3 (flavour 1) CSV file holds then for each snippet a column i guess. But I didnt see a way to select multiple csv columns for the same snippet / define multiple flavours for it depending on the column. So I guess this is unsupported? Thanks! Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers) -> Browser Client: https://kiwiirc.com/client/irc.rizon.net |
#298 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
No, this only works for sections. You can put multiple paragraphs of text into a single CSV cell, so there's no real reason to split them up into separate snippets. 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 |
|
#299 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
I want to have parts in different flavours but I just realized - I could just edit the categories and add the maximum number of snippets possible to achieve the same result, since I can switch of the auto-add. I think. Need to check it asap
Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers) -> Browser Client: https://kiwiirc.com/client/irc.rizon.net |
#300 |
|
|