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).

After loading a project. Starting the process has no issues.

Tested loading both a 2.3.0.0 and a 2.4.1.0 project file. Same result opening both.

Thanks.

-=Janrith

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

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

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

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].)

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.

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

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.

"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.