Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
Unfortunately, the tool isn't able to update existing topics. Realm Works creates a unique id for each topic, and the tool would have to read a full realm export instead of only a structure file in order to get the ids (and then it would have to do some checking to see if you wanted to update an existing topic or create a new topic for each row in the CSV/XLSX). 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 |
|
#501 |
Member
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57
|
Quote:
Quote:
Thanks. -=Janrith |
||
#502 |
Member
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57
|
Three quick 2.4.1.0 tests: Each is a new 2.4.1.0 project file.
1. XLSX Name column mapped to Article Name of Spell (AD&D) Article type. Load: OK Mapping: OK 2. XLSX Name column mapped to Article Name of Spell (AD&D) Article type. Class mapped to Parent General Abilities Article Name. Load: OK Mapping: Missing parent 3. XLSX Name column mapped to Article Name of Spell (AD&D) Article type. Class mapped to Parent General Abilities Article Name, "AD&D" literal text added to Parent Name Suffix. Load: OK Mapping: Missing parent I'm going to go through one at a time with my column mappings and see what triggers the RWTopic>> failed to find RWContentsItem for ":" error. I'll let you know what I find out. Thanks. -=Janrith |
#503 |
Member
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57
|
Feature request:
"New Project" option on the File Menu... Would like to clean the slate w/o needing to exit and reload the tool. Thank. -=Janrith |
#504 |
Member
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57
|
OK,
After a bunch of tests, it appears the importer doesn't like having column N populated. When Casting Time (column N) is not mapped in the project file, but Saving Throw, Material Components, Notes, Author, Filtered Name are (columns O, P, R, S and T are mapped), the project load succeeds without incident. For some reason, when column N is mapped to a structure field in the project file, loading the project prevents any column past N from mapping successfully. (*EDIT: It appears the Article Name is unaffected, as that is currently being populated by column T (Filtered Name); but the problem does affect subsequent sections.) NOTE: Creating the definition and then generating an rwexport file in the same session works fine. It seems to only be a problem with loading the project file. DETAILS: XLSX Column Definitions: A: Class B: Source Book C: Edition D: Frequency E: Level F: Name G: Reversed Spell H: Reversible I: School of Magic J: Range K: Duration L: Area of Effect M: Components N: Casting Time O: Saving Throw P: Material Component Q: Description R: Notes S: Author (formula) T: Filtered Name (formula) Here are the last few results: Test results: 20: Type: XLSX Structure: v.03 Target Article: Spell (AD&D) Columns Mapped: Filtered Name;School of Magic;Level;Range;Material Component;Duration;Components;Area of Effect;Saving Throw;Source Book;Edition;Author;Notes;Reversed Spell Load: OK Mapping: OK So far so good... Here comes the first failure: 21: Type: XLSX Structure: v.03 Target Article: Spell (AD&D) Columns Mapped: Filtered Name;School of Magic;Level;Range;Material Component;Duration;Components;Area of Effect;Saving Throw;Source Book;Edition;Author;Notes;Reversed Spell;Casting Time Load: RWTopic>> failed to find RWContentsItem for ":" Mapping: No fields mapped past Casting Time (column N in the spreadsheet). Is it the name of the column in the spreadsheet? 22: Type: XLSX Structure: v.03 Target Article: Spell (AD&D) Columns Mapped: Filtered Name;School of Magic;Level;Range;Material Component;Duration;Components;Area of Effect;Saving Throw;Source Book;Edition;Author;Notes;Reversed Spell;renamed Casting Time to CT in XLSX. Load: RWTopic>> failed to find RWContentsItem for ":" Mapping: No fields mapped past Casting Time (column N in the spreadsheet). Nope. Is it a problem with the field definition in the structure file? 23: Type: XLSX Structure: v.03 Target Article: Spell (AD&D) Columns Mapped: Filtered Name;School of Magic;Level;Range;Material Component;Duration;Components;Area of Effect;Saving Throw;Source Book;Edition;Author;Notes;Reversed Spell;mapped Range to Casting Time target as well. Load: OK Mapping: OK Nope. Is it positional in the spreadsheet? 24: Type: XLSX Structure: v.03 Target Article: Spell (AD&D) Columns Mapped: Filtered Name;School of Magic;Level;Range;Material Component;Duration;Components;Area of Effect;Saving Throw;Source Book;Edition;Author;Notes;Reversed Spell, Casting Time moved from column N to column J in XLSX. Load: RWTopic>> failed to find RWContentsItem for ":" Mapping: No fields mapped past Components (new column N in the spreadsheet). Yep. No idea why though. I hope this helps. -=Janrith Last edited by Janrith; March 21st, 2019 at 07:37 PM. Reason: Adding the distinction between Article name and subsequent sections |
#505 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Thanks for all the detail Janrith!
I'll have a look to see why column N (number 14) is causing a problem. (Initial thought, column N could be number 13 if you start counting at 0, and 13 is the ASCII for code for carriage return [end of line].) 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 |
#506 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Version 2.4.2 is available
This fixes more bugs. It is now possible to load a project in which you've used column 14 in your data table. The parentage that you've set up for topics should also be saved and restored. Many thanks to Janrith for his diligent hard work in finding the column 14 issue. No previous saved projects will load successfully in this version. 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 |
#507 |
Junior Member
Join Date: Apr 2018
Posts: 15
|
Just a quick note to say, brilliant QA and debugging work to both Janrith and Farling. Very impressive!
And specifically @Farling: thanks for this amazing tool (which I'm surprised LWD did not built into RW), and for your continued support and tinkering that makes it consistently and (frequently!) better. *doffs cap* ~Ash |
#508 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Actually you only need to load a structure file (you could pick the same file). This will remove all the columns that you've configured.
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 |
#509 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
If you want multiple tags on a more normal "Tags" snippet, then you can do this by separating the tab labels with a comma in your source data cell. 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 |
|
#510 |
|
|