Export char items to a spreadsheet.

EDITED FOR QUICK REFERENCE:

This project works well so you can export all your items from multiple chars into a single cvs file that can be opened in a spreadsheet. There you can easily sort and search for items.

Link to the 3t item exporter to csv file:
threetowns-py.web.app/

The guide for non technical people to use the inventory software with step by step pictures anybody can follow.

It shows how to get your char inventory, download libre office and load the file into it.

How to search and find items.



The example shows to look for all rings that have acid and wizard spells and to then quickly compare them to decide which one is best to wear.



If anyone asked me to search across all my chars for rings with acid and wiz spells and i didnt have this software - can you guess what i would tell them?



But now finding your best items to wear is a piece of cake:



How to export your inventory:

Step 1. Press escape and press save char button.

ibb.co/LgRmm98



Step 2. Notice that in your log in green it says Exported.

ibb.co/fvjJDYb



Step 3. Notice in your nwn/localvault dir it downloaded your character inventory bic file. Notice the size of your bic file. Very rarely it produces a small 6kb file that is broken. If so start again the export (look at all 6 inventory pages) and press Save char again. A larger working file will be saved.

ibb.co/cxBNSZ0



How to use 3t Inventory website:

Step 4. Open the 3t inventory page at threetowns-py.web.app/

ibb.co/9rtcDLt



Step 5. Press the button choose files. Goto the localvault folder.

ibb.co/df6Np3r



Step 6. Select the char inv bic file. In this example two files helga and arloquinren selected. You can select multiple char files. So then you can find items from all your characters quickly.

ibb.co/V35RNGB



Step 7. Webpage shows both chars ready to upload. Now select the Open button to filter what items you want to include.




Step 8. Uncheck the crap you dont want like scrolls/potions/arrows. I only want items listed that i can wear.

ibb.co/BsbGKL9



Step 9. Press Blue button at the bottom to export to CSV file. A CSV file is to be opened by libreoffice spread sheet.

ibb.co/BsbGKL9



Step 10. Notice your browser downloaded the CSV file.

ibb.co/0hbDqTB



How to use the spreadsheet:


ibb.co/2gFRsZP

Download and install it.



Step 12. Double click on the downloaded CSV file or open libreoffice and open the file. This dialog appears and choose the semi colon ; as delimiter (NOT COMMA OR TAB)

ibb.co/GJFxH5w



If the spreadsheet looks strange its probably because you didnt select semi colon. Go open the file again.

Now you probably think this is great i can see all the items. But its way better with a feature called Autofilter.



How to use Autofilter: Example find all rings with acid and wiz spells.

Step 13. Click the 1 in blue on the left top row. I put a red circle around it. This selects across the first row.

ibb.co/WgS1141



Step 14. Select the menu data and then submenu Autofilter. I put a red circle around it.

ibb.co/jHhvyZj



Step 15. The autofilter is now on the top row. Notice the small grey arrows on right of the column names.

Select the small grey down arrow next to the colum baseitem so you can filter on wearable items. In this example checkbox shows only rings.

ibb.co/ZSwrXJk



Step 16. Scroll right to see the other colums. Stop on the damage resistance col. Open the gray arrow. In the text box type Acid. Now only acid rings show.

ibb.co/T176SVj



Step 17. Scroll to the left. See the main item description col condensedString. Its the quick way to read and search for items.

ibb.co/kGV3fnC



Step 18. Filter using the condensedString item search box. Type in wiz to only show rings with wiz (and Acid as you did the previous filter already)

ibb.co/rpm2VHx



Step 19. Review the filtered result of ring with acid and wiz properties. Compare the rings found and decide which is best for your wiz to wear.

ibb.co/C8GF4BH



You can use autofilter to search and find items or sort items.

Want to see all your best DR or Str items or both items with DR and Str its super easy.

Want to see your best AC sorted from +10 AC to +9 only its super easy.

With auto filter you can reset it by going to the menu and turn it off and on again.


Enjoy.

------------------------------------------------------------------------------------------------------------
Original first message:

Hi,

Takes too long to find items on chars or even remember what you found. So trying to find a solution. 
A few people in game said they really want to be able to do this.

On researching online i found nwn 3t github python coding project by our long time player findall/ccc28 (well done i am super impressed). 
github.com/findell666/nwn-3t-items

There is no sample output to see what the program does on the project page as its a super minimal readme.

There is a forum posting here a few years about this program.  I cant find that post after a few mins looking to link to it but its here somewhere.

Over a few hours I finally got it to work and so pasted below the sample output for you to see. I had to debug the program why it was missing items property because the readme does not say to put in an updated player_character.py file that has the items.

Its not yet spreadsheet compatible where it can be imported and sorted on item stats and player names that hold the item. But I think it can be done

For those interested in running it now. The install docs miss out the part to replace the player_character.py file in a related project and it turns out that referenced project has two copies of this file one in a lib dir lower down so took me ages to debug why it didnt work.
So for anyone not familiar with python this would be a ball ache to figure out.

I dont think i can help you install it manually as its a pain and i didnt do that. In the end i run it in a free programming tool called Pycharm.
I can maybe do a youtube short video of the steps to show you how to run it in pycharm as its not many steps there.
But eventually ill see if i can get it packaged as a program thats is easy to install and use for non technical users.

I ran it over one of my 3t character files i exported and saved to my local player vault.

I would like to add some code to convert to a simple csv file that can be loaded into a speadsheet.

So i think filter out the non wearable items like scrolls etc and only export only the wearable items.

I think in a format like how we talk in chat to each other: Name, Baseitem type, cost value, level, and all the possible properties stats like: elemental resist fire, elemental resist cold.

Any suggestions or ideas? I wonder why the project was stopped and didn't do the spreadsheet exportable sortable compatible format. Maybe it has the feature but i didnt read the code to see how to do that.
Maybe its hard to do but i dont think it is.

I dont program python every day so this will take some reading on python syntax for me to get up to speed.

My next project idea after this will be for a program to automatically figure out the best items for your char to wear based on what items you have available for max DR, resists, saves, abilities etc.
If you got any ideas how to do that i am interested to hear.
How do you do this in your head when putting items on your chars?
What are your priorities for getting a good wearable char loadout ? I think it depends on the char type.
Most people i think go for DR then elemental resists then ability points and then saves ?

Maybe this can be an extension of the CBC spreadsheet ?

----------------ITEM FOUND--------------------

NAME : Ring

DESC ID : This ring has been custom crafted and custom made with magical enchantments from a mysterious item maker.

DISPLAY NAME : <cú
ú>Distalzotaper Ring</c>

BASEITEM : 52

TAG : cl_chreering

Property :

PropertyName : 0

Subtype : 0

CostValue : 2

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Enhancement Bonus: Strength +2

Param1Value : 255

Property :

PropertyName : 52

Subtype : 3

CostValue : 5

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Skill Bonus: Discipline +5

Param1Value : 255

Property :

PropertyName : 52

Subtype : 17

CostValue : 6

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Skill Bonus: Spot +6

Param1Value : 255

Property :

PropertyName : 52

Subtype : 20

CostValue : 6

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Skill Bonus: Appraise +6

Param1Value : 255

Property :

PropertyName : 52

Subtype : 12

CostValue : 6

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Skill Bonus: Persuade +6

Param1Value : 255




----------------ITEM FOUND--------------------

NAME : Helmet

DESC ID : This helmet is perfectly charged with magic and enchantments from a mysterious maker and imbuer.

DISPLAY NAME : <cúÈ2>Forferrallumkomin Helmet +5</c>

BASEITEM : 17

TAG : cl_chreehelm

Property :

PropertyName : 1

Subtype : 65535

CostValue : 5

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Armor Bonus: +5

Param1Value : 255

Property :

PropertyName : 41

Subtype : 1

CostValue : 4

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Improved Saving Throws: Fortitude +4

Param1Value : 255

Property :

PropertyName : 40

Subtype : 8

CostValue : 6

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Improved Saving Throws: Fear +6

Param1Value : 255

Property :

PropertyName : 23

Subtype : 10

CostValue : 8

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Damage Resistance: Fire Resist 40 / -

Param1Value : 255

Property :

PropertyName : 23

Subtype : 11

CostValue : 4

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Damage Resistance: Negative Energy Resist 20 / -

Param1Value : 255

Property :

PropertyName : 23

Subtype : 1

CostValue : 2

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Damage Resistance: Piercing Resist 10 / -

Param1Value : 255

Property :

PropertyName : 40

Subtype : 11

CostValue : 8

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Improved Saving Throws: Mind Affecting +8

Param1Value : 255

----------------ITEM FOUND--------------------

NAME : Tower Shield

DESC ID : This tower shield possesses great power and abilities and is infused with powerful magic, one must wonder who is behind this madness of items being made.

DISPLAY NAME : <cú
ú>Ernefithortso Tower Shield</c>

BASEITEM : 57

TAG : cl_chreetshd

Property :

PropertyName : 52

Subtype : 8

CostValue : 5

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Skill Bonus: Move Silently +5

Param1Value : 255

Property :

PropertyName : 23

Subtype : 6

CostValue : 4

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Damage Resistance: Acid Resist 20 / -

Param1Value : 255

Property :

PropertyName : 23

Subtype : 9

CostValue : 5

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Damage Resistance: Electrical Resist 25 / -

Param1Value : 255

Property :

PropertyName : 23

Subtype : 2

CostValue : 4

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Damage Resistance: Slashing Resist 20 / -

Param1Value : 255

Property :

PropertyName : 52

Subtype : 12

CostValue : 5

Param1 : 255

Param1Value : 255

UsesPerDay : 255

Prop string : Skill Bonus: Persuade +5

Param1Value : 255

----------------ITEM FOUND--------------------

NAME : Life's End

DESC ID : This vile weapon was created by the Drow to destroy the tree gates that protected the Elven kingdom.



Though its wilting power is limited, the blade still carries dark enchantments meant to burn and sever the very flesh of the Drow enemy, the Elves.



DISPLAY NAME : None

BASEITEM : 53

TAG : it_10_0096

Property :

PropertyName : 15

Subtype : 309

CostValue : 9

Param1 : 255

Param1Value : 0

UsesPerDay : 2

Prop string : Use: Horrid Wilting (20) 2 Uses/Day

Param1Value :

Property :

PropertyName : 58

Subtype : 1

CostValue : 12

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Attack Bonus vs.: Elf 12

Param1Value :

Property :

PropertyName : 16

Subtype : 11

CostValue : 11

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Damage Bonus: Negative Energy 2d8

Param1Value :

Property :

PropertyName : 23

Subtype : 6

CostValue : 7

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Damage Resistance: Acid Resist 35 / -

Param1Value :

Property :

PropertyName : 6

Subtype : 65535

CostValue : 10

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Enhancement Bonus: +10

Param1Value :

Property :

PropertyName : 43

Subtype : 0

CostValue : 0

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Keen

Param1Value :

Property :

PropertyName : 48

Subtype : 21

CostValue : 6

Param1 : 5

Param1Value : 19

UsesPerDay : 255

Prop string : On Hit: Slay Racial Group DC=26

Param1Value : Magical Beast

Property :

PropertyName : 64

Subtype : 1

CostValue : 0

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Only Useable By: Elf

Param1Value :

Property :

PropertyName : 64

Subtype : 4

CostValue : 0

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Only Useable By: Half-Elf

Param1Value :

----------------ITEM FOUND--------------------

NAME : Rhule Key

DESC ID : Myth says that this is the key for the rumored Vault of Souls that Vonder Muer Rhule has locked away. Adding to it daily and slowly buidling up great power. Another rumor exists that it can lead to a shortcut somewhere in the city of Trighton.

DISPLAY NAME : None

BASEITEM : 65

TAG : cl_soulvaultkey

----------------ITEM FOUND--------------------

NAME : Potion of Greater Spell Mantle

DESC ID : Creates a barrier around the drinker that absorbs all incoming spells. It can absorb up to 1d12+10 levels of spells before collapsing.

DISPLAY NAME : None

BASEITEM : 49

TAG : PotGreatSpellMantle

Property :

PropertyName : 15

Subtype : 130

CostValue : 1

Param1 : 255

Param1Value : 0

UsesPerDay : 255

Prop string : Use: Greater Spell Mantle (17) Single Use

Param1Value :

----------------ITEM FOUND--------------------