I am looking for an addon that will save a list of the names of all the items in my bags and bank. I use Bagnon for inventory management which appears to store the Blizzard item numbers in the saved variables files. While I can use the item number I would prefer the items names. What I want to be able to do is to sift through all the items I have squirreled away to find items from old quests, holiday events, etc. that I no longer need and can get rid of and what I might want to hang on to for a while yet.

I use an addon called Possessions to monitor what is on all of my toons. I then use the following Lua script to turn the Possessions SavedVariables file into a comma-separated-value file that I read into a small database program.

local server, realm

-- print "Hello, world"

-- source table is included beforehand with -l



for server, realm in pairs(PossessionsData) do

	if server ~= "config" then

		-- print (server);

		local characterName, character

		for characterName, character in pairs(realm) do

			-- print (server, characterName);

			local items = character["items"]

			local bag, bagItem

			for bag, bagSlots in pairs(items) do

				-- print (server, characterName, bag);

				local slot, slotValue

				for slot, slotValue in pairs(bagSlots) do

					print(server, characterName, bag, slotValue[1], slotValue[3])

				end

			end

		end

	end

end

Thank you for the information. Both Possessions and the lua script you provided work nearly perfectly for what I wanted. One quick question though, what lua interpreter are you using? I have tried WoWLua, which works perfectly in game but the point is to get this information of offline use. If could figure out how to capture the WoWLua output chanel to the clipboard or log file it would be perfect.

http://wow.allakhazam.com/Wowreader.html

Edit: It doesn't say this on that page, so I'll say it.

You have to sign up, it's free, and put your account info into WoWReader. Then after you upload the data, go to http://wow.allakhazam.com/poster.html and click "WoW Characters". Each character, when clicked, will show you all the data you sent including bags and bank (if you visited the bank while the addon was running).

Edit2: To upload:
Play the game wile the addon is running, then exit, then run the WoWReader app, then click upload.
-- or --
Run the WoWReader app, click the WoW icon, then play the game, then exit, then WoWReader will automatically upload the data.

Okay, I have tries the Allahkhazam's WoWReader approach as well. I do like how the data is web based with the mouseover tooltips, but I can't seem to get it to pick up on the bank inventory and a couple of my bags have display problems. If I can figure out how to get the bank inventory to be included online and the bag display issues I'd be set. The lua script approach was much more along the line of what I was looking for but this would work, assuming I can get all the kinks worked out.

---

Q u o t e:
Thank you for the information. Both Possessions and the lua script you provided work nearly perfectly for what I wanted. One quick question though, what lua interpreter are you using? I have tried WoWLua, which works perfectly in game but the point is to get this information of offline use. If could figure out how to capture the WoWLua output chanel to the clipboard or log file it would be perfect.

---

I downloaded the Lua 5.1 (?) interpreter, compiled for Mac OS X. I believe the Lua version that WoW Lua is compatible with is 5.1. It runs from the command line in the Terminal application. I know that there are interpreters that run from the command line for Windows; I used one for a short while on my work computer.

From the command line, I pass in the path to the SV file, and redirect output to the required CSV file.

lua5.1 Possessions2CSV.lua < /Applications/World\ of\ Warcraft/WTF/accountname/SavedVariables/Possessions.lua > Possessions.csv

I do it that way since I actually have several accounts and run a script to accrue the Possessions.lua file from each account into a single file. The syntax in Windows command line is a bit different, but you can likely translate.

It's actually part of a larger script that I use to feed a database that I use for craft inventory and planning purposes -- I select what recipes I need to craft and then it tells me what mats I need to collect to craft that stuff. It was pretty much essential when my guild was running AQ40, and I was doing the crafting quests for Argent Dawn and Cenarion Circle.

---

Q u o t e:
Okay, I have tries the Allahkhazam's WoWReader approach as well. I do like how the data is web based with the mouseover tooltips, but I can't seem to get it to pick up on the bank inventory and a couple of my bags have display problems. If I can figure out how to get the bank inventory to be included online and the bag display issues I'd be set. The lua script approach was much more along the line of what I was looking for but this would work, assuming I can get all the kinks worked out.

---

There's also RPGOutfitter.

http://www.rpgoutfitter.com/Addons/CharacterProfiler.cfm

I ended up writing my own addon to extract the information I was looking for; the code for the addon is provided before for the curious. I am not particularly happy with how the data being returned by the GetItemInfo() function is being handled as I would have preferred to use a table/array rather than individual variables and placeholders. As a result of this addon I was able to free up about a third of my total bank space by trashing old quest items that I no longer needed.

InventoryList = {}

frame = CreateFrame("Frame", nil, UIParent)

frame:RegisterEvent("BANKFRAME_OPENED")

frame:SetScript("OnEvent", function()

   if event == "BANKFRAME_OPENED" then

      for x = -2, 11, 1 do

         for y = 1, GetContainerNumSlots(x) do

            local itemlink = GetContainerItemLink(x, y)

            if itemlink then

              local a, _, b, c, d, e, f, _, g = GetItemInfo(itemlink)

              iteminfo = a ..",".. b ..",".. c ..",".. d ..",".. e ..",".. f ..",".. g

              table.insert(InventoryList, iteminfo)

            end

         end

      end

      print("Inventory Scan Complete.")

   end

end)