Export char items to a spreadsheet.

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.

ibb.co/6ZbMfk7



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

ibb.co/PxSCB7c



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/4PwSbW



Step 10. Notice your browser downloaded the CSV file.

ibb.co/0hbDqTB



How to use the spreadsheet:

Step 11. Download LibreOffice. its free, very fast and better at finding items than expensive Microsoft Excel. www.libreoffice.org/download/download-libreoffice/?type=win-x86&version=7.3.6&lang=en-US

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 autofilter you can reset it by going to the menu and turn it off and on again


---------------------------------------------------------------------------------------------------------------------------

I recoded a video how to use Libreoffice (like Excel but free) you can download it here www.libreoffice.org/download/download/
I think its same as openoffice so you can also try that.

You go to save your char in game and can alt tab between game and the spreadsheet. So handy to find items for other players or your self.

This video shows you how to manage the items to search, filter, sort and look for items with certain properties:

youtu.be/dMIjSw5f__I

I select the top row, and then from data menu select Auto Filter.

If you selected top row then all the cols get the autofilter. Not just one col. (select the top row first is imporatant if you want it on all cols)

Now the top row has these drop downs to auto filter with arrows.

Then you can use the filter box to search on the item descriptions as a quick over view filter. Like i am looking for uni saves.

Or to go to each col and use the filter there on its property value or sort them. eg i want str items between 4-6 str.

I use the basestat col to filter on only the item type i am lookin for. eg rings and belts.

So now I can see all items that have str > 4 and have some uni save.

If i wanted i could then go to uni save col, and use filter there to pick the range of uni save i wanted. 

And go back to the description and remove uni save from there and put in another text filter.

So thats how you can search for items with what ever property you need.