[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