Lone Wolf Development Forums  

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

Notices

Reply
 
Thread Tools Display Modes
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old March 21st, 2019, 02:51 PM
Quote:
Originally Posted by Acenoid View Post
Hi Farling!

Is it possible somehow to get the rw importer to update my topics in rw? At the moment it will always create a duplicate topic tree correct? (its no problem - just wanted to know if iam missing something)
Hi,
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
Farling is offline   #501 Reply With Quote
Janrith
Member
 
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57

Old March 21st, 2019, 04:34 PM
Quote:
Originally Posted by Farling View Post
Darn, more testing required.

Are the issues you reported related to what the tool is like after loading a project, or even immediately after launching the tool?
After loading a project. Starting the process has no issues.

Quote:
Also, was the "RWTopic>>" message from loading a saved project from an earlier version of the tool? Earlier saves aren't compatible with the format used by 2.4.1
Tested loading both a 2.3.0.0 and a 2.4.1.0 project file. Same result opening both.

Thanks.

-=Janrith
Janrith is offline   #502 Reply With Quote
Janrith
Member
 
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57

Old March 21st, 2019, 04:49 PM
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
Janrith is offline   #503 Reply With Quote
Janrith
Member
 
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57

Old March 21st, 2019, 04:52 PM
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
Janrith is offline   #504 Reply With Quote
Janrith
Member
 
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57

Old March 21st, 2019, 07:28 PM
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
Janrith is offline   #505 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old March 21st, 2019, 11:49 PM
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
Farling is offline   #506 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old March 22nd, 2019, 03:36 AM
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
Farling is offline   #507 Reply With Quote
Ash Nazg
Junior Member
 
Join Date: Apr 2018
Posts: 15

Old March 22nd, 2019, 06:42 AM
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
Ash Nazg is offline   #508 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old March 22nd, 2019, 09:30 AM
Quote:
Originally Posted by Janrith View Post
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
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
Farling is offline   #509 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old March 22nd, 2019, 11:34 AM
Quote:
Originally Posted by Taronthir View Post
I haven't discovered yet how to make multi-domain tag entries in the csv/xls so they'll be interpreted properly.
"Tags (Multi-Domain)" snippets are not supported yet.

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
Farling is offline   #510 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 06: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.