sabinrf24
06-22-2015, 01:57 PM
I am probably very late to the party here, but I wanted to share this as it's been a great help to me with keeping track of what I have on what character / bank etc.
TL;DR - run a command on each character to create a text file inventory export for each of them, then run this script to put it all in an excel spreadsheet for you. Example output:
https://bytebucket.org/sabinrf24/everquest/raw/591489e5e1e7baab8935e8da477522999689169c/eq/inventory_output_example.png
You can right click -> save as this link, then run it with python (you will need to install python before you can run this script). You may need to right click -> open with, then find python.exe wherever you install it.
When you run the script it will tell you what command to run on your characters. It will then prompt for your EverQuest directory location (this is where the files are placed) and then you are asked for where to output the final consolidated inventory file. Optionally, you can also pass these two paths as arguments if you don't want to deal with dialog boxes.
The command that outputs this information is valuable with or without this script, so its worth mentioning here:
/outputfile inventory Charactername_inventory.txt
The bold part is an arbitrary file name - I use this syntax because inside the file there is no indication of what character you ran the command on. This also prevents your files from having the same name and overwriting each other.
As for the fields in the file:
Character - pulled from the filename if the syntax is right (example above)
Location - from data in the file
Item - from data in the file
LastSeenTime - from the timestamp on the file
CountInStack - from the data in the file
parseinventory.py (https://bitbucket.org/sabinrf24/everquest/raw/591489e5e1e7baab8935e8da477522999689169c/eq/parseinventory.py)
Python Interpreter Download (https://www.python.org/downloads/release/python-2710/)
P.S. There is another variation (/outputfile spellbook Charactername_spellbook.txt) that will output your spellbook contents as well.
TL;DR - run a command on each character to create a text file inventory export for each of them, then run this script to put it all in an excel spreadsheet for you. Example output:
https://bytebucket.org/sabinrf24/everquest/raw/591489e5e1e7baab8935e8da477522999689169c/eq/inventory_output_example.png
You can right click -> save as this link, then run it with python (you will need to install python before you can run this script). You may need to right click -> open with, then find python.exe wherever you install it.
When you run the script it will tell you what command to run on your characters. It will then prompt for your EverQuest directory location (this is where the files are placed) and then you are asked for where to output the final consolidated inventory file. Optionally, you can also pass these two paths as arguments if you don't want to deal with dialog boxes.
The command that outputs this information is valuable with or without this script, so its worth mentioning here:
/outputfile inventory Charactername_inventory.txt
The bold part is an arbitrary file name - I use this syntax because inside the file there is no indication of what character you ran the command on. This also prevents your files from having the same name and overwriting each other.
As for the fields in the file:
Character - pulled from the filename if the syntax is right (example above)
Location - from data in the file
Item - from data in the file
LastSeenTime - from the timestamp on the file
CountInStack - from the data in the file
parseinventory.py (https://bitbucket.org/sabinrf24/everquest/raw/591489e5e1e7baab8935e8da477522999689169c/eq/parseinventory.py)
Python Interpreter Download (https://www.python.org/downloads/release/python-2710/)
P.S. There is another variation (/outputfile spellbook Charactername_spellbook.txt) that will output your spellbook contents as well.