Is there any kind of a topic limit?

[EightBitz]

I'm working on a script that imports spells from the csv file at pathfindercommunity.net. It contains about 2700 spells. The last selectable one is maybe #1348 on the list (which happens to be "Pup Shape"). There are other spells listed beyond that, but I cannot select them.

And when I scroll, once Pup Shape gets to the top of the viewable window, the names stop scrolling. The vertical slide bar continues scrolling, but the spell names do not.

The import process does not report any errors. I have no idea if I'm doing something wrong, if I'm hitting a bug, or if there's an internal limit of some sort.

I'm putting all the spells in a container, if that makes any difference.

[Farling]

This should be registered as a bug, although I've already registered this particular problem.

[ibecker]

I filed a bug (#57622) for that problem 2 years ago. I was told it appeared to be a limitation of the display library, and they'd look into workarounds. That was the least I heard, and the case is still open.

It's a display limitation, so if you can collapse sections higher up, you'll be able to scroll down further in the list.
-Ian

[EightBitz]

Originally Posted by ibecker

I filed a bug (#57622) for that problem 2 years ago. I was told it appeared to be a limitation of the display library, and they'd look into workarounds. That was the least I heard, and the case is still open.

It's a display limitation, so if you can collapse sections higher up, you'll be able to scroll down further in the list.
-Ian

There are no sections higher up. I imported into an empty realm.

[ErinRigh]

Originally Posted by EightBitz

There are no sections higher up. I imported into an empty realm.

Can you divide them into different Sections, Like Alphabetical? IDK how hard that would be?

[EightBitz]

Originally Posted by ErinRigh

Can you divide them into different Sections, Like Alphabetical? IDK how hard that would be?

That would actually be quite easy.

[Acenoid]

Like he wrote in the 1st post: he reads the csv and creates an RW XML for import
probably it is being made especially for this task I wont be of much use, however I agree, it could be great to create all kinds of lists / topics / things via csv and import them.

Let's see what EightBlitz says

[EightBitz]

Originally Posted by Acenoid

Like he wrote in the 1st post: he reads the csv and creates an RW XML for import
probably it is being made especially for this task I wont be of much use, however I agree, it could be great to create all kinds of lists / topics / things via csv and import them.

Let's see what EightBlitz says

I'm doing my best to make the code easily adaptable, but you'll still have to be familiar with PowerShell scripting. That being said, there are a few pending issues.

1. There is currently a bug with RealmWorks where tag values assigned to snippets are instead assigned to topics. I'm told by Farling that this is a known bug which LWD says it's working on.

2. The CSV file I'm working is from pathfindercommunity.net, but I've had to clean it up a bit.

3. There's the issue with the view size limitation. I have yet to modify the code for the suggested workaround.

4. The CSV file has a column for a plain-text description and one for an HTML-formatted description. The formatted description is obviously preferable, but is giving me issues. At least one spell (#134 of ~2700) is giving me an error on import. I say at least one, because it stops there and doesn't go beyond.

5. I've had to modify the tags in the Pathfinder structure to add spell descriptors, schools and subschools. So if I distribute the code, I'd have to distribute it with my Pathfinder structure and my sanitized version of the CSV file, otherwise errors.

Once I get a clean, flawless import, I'll be willing to share. Right now, my copy of RW is supposedly deleting the imported spells so I can have a clean realm to start testing things again.

Except for the import error, all these things have workarounds. For example, I can clone the Spell category, and in the clone, replace the tag snippets with labeled text snippets. Or stick information in the annotation fields instead of assigning tags.

But that one import error, I gotta find out what's going on there, and right now, I'm clueless. I've submitted a support request.

[HippyCraig]

Awesome looking forward to seeing the final result.

[Farling]

Originally Posted by EightBitz

5. I've had to modify the tags in the Pathfinder structure to add spell descriptors, schools and subschools. So if I distribute the code, I'd have to distribute it with my Pathfinder structure and my sanitized version of the CSV file, otherwise errors.

There is no need to modify the tags. All of these are already in the default Pathfinder structure.

I've got all the 4 CSV loading quite happily except for the tags issue. I decided to use the basic text instead of the HTML-ised text. I don't know if the HTML-ised text is from the raw PRD or someone has added from another source.

My solution uses XSLT scripts rather than PowerShell scripts.