GuildBankLedger-discontinued : Discontinued & Outdated : Elder Scrolls Online AddOns

(43 Kb)

Download

Updated: 01/23/17 12:05 AM

Add Favorite

Install Help

Portal

Bugs

Features

Pictures

File Info

Compatibility:	One Tamriel (2.6)
Updated:	01/23/17 12:05 AM
Created:	09/25/16 09:23 PM
Monthly downloads:	30
Total downloads:	7,808
Favorites:	3
MD5:
Categories:	Discontinued & Outdated, Discontinued & Outdated

GuildBankLedger-discontinued Popular! (More than 5000 hits)

Version: 2.6.3

by: ziggr [More]

*** no longer supported ***

Want to know which guild members donated gold to the guild this week?
Who deposited all those crafting materials? Who withdrew them?

This add-on scans guild bank history, then saves all deposits and withdrawals
to a SavedVariables file. It can then convert that SavedVariables file to a
CSV comma-separated-value file suitable for import into a spreadsheet.

If you have

Click "Save Data Now" button. Add-on will fetch Guild Bank history from ESO's server and note all gold deposits.
Log out (or relog). ESO will then save data, writing SavedVariables/GuildBankLedger.lua.
From a terminal window, run
% cd ~/Documents/Elder Scrolls Online/live/AddOns/GuildBankLedger
% lua GuildBankLedger_to_csv.lua
This creates SavedVariables/GuildBankLedger.csv
Import GuildBankLedger.csv into a spreadsheet.

GuildBankLedger_to_csv.lua requires that you have downloaded and installed a standalone Lua interpreter, presumably from lua.org.

Optional: if you have Master Merchant installed, GuildBankLedger will look up average price information and include it in the CSV file.

--Z

2.6.3 2017-01-22

Fix max() vs. math.max() bug introduced in 2.6.2. Thanks for the report, ckhorne!

2.6.2 2017-01-15

New "Server Poll Options" settings to avoid server kick for "excessive messages."

2.6.1 2016-10-05

Increment API version for ESO 2.6 (One Tamriel). No other changes.

2.5.2 2016-09-25

Create new add-on, based on GuildGoldDeposits 2.5.1.

Optional Files (2)

File Name	Version	Size	Author	Date	Type
GuildBankLedger - 3.x - Updated	3.55	8kB	myristican	04/12/21 04:04 PM	Patch
Guild Bank Ledger Greymoor Patch	1.2.0	7kB	Splat	05/25/20 03:59 AM	Patch

Archived Files (3)

File Name	Version	Size	Uploader	Date
GuildBankLedger	2.6.2	43kB	ziggr	01/15/17 05:06 PM
GuildBankLedger	2.6.1	43kB	ziggr	10/05/16 07:55 PM
GuildBankLedger	2.5.2	43kB	ziggr	09/25/16 09:23 PM

Comment Options

Page 1 of 2

09/29/16, 01:15 AM
Eldorhaan Forum posts: 2 File comments: 142 Uploads: 0	This sound awesome, but is there a way to simplify the way to extract the csv file, because i am not expert IT and for me you speak chinese. But I really want this kind of informations

09/30/16, 12:59 AM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Originally Posted by Eldorhaan

This sound awesome, but is there a way to simplify the way to extract the csv file, because i am not expert IT and for me you speak chinese. But I really want this kind of informations

I wish I could make it easier, but I cannot. The separate Lua interpreter and GuildBankLedger_to_csv.lua is the best that I can do.

Add-ons cannot write CSV files from within ESO. Zenimax intentionally limits what Add-ons can do, and prohibits writing files.

01/14/17, 07:15 AM
BMCXP Forum posts: 1 File comments: 44 Uploads: 0	Wish This is an awesome addon, far closer to anything that I have looked at, for what I want. I am looking for an Addon that will create a list of the entire contents of a guild bank. Looking to post the contents on our Guild web site. Yours comes really close to doing this. But limited to 10 days. So how can I do this, maybe force the transactions to refresh for all items. (withdrawal everything, then re-deposit them) then create the ledger file? Going to try this today. (I am the Banks Manager) Maybe you can figure out how to make an inventory list? And button for it.

01/14/17, 08:57 PM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Re: Wish

Originally Posted by BMCXP

This is an awesome addon, far closer to anything that I have looked at, for what I want.

I am looking for an Addon that will create a list of the entire contents of a guild bank.
Looking to post the contents on our Guild web site.

Yours comes really close to doing this. But limited to 10 days.

So how can I do this, maybe force the transactions to refresh for all items. (withdrawal everything, then re-deposit them) then create the ledger file? Going to try this today. (I am the Banks Manager)

Maybe you can figure out how to make an inventory list?
And button for it.

Interesting idea. "Current Bank Inventory" is a different set of APIs and different table schema than "recent bank transactions", but might be possible. Added to the wish list for future versions.

01/15/17, 10:34 AM
BMCXP Forum posts: 1 File comments: 44 Uploads: 0	Re: Re: Wish So how can I do this, maybe force the transactions to refresh for all items. (withdrawal everything, then re-deposit them) then create the ledger file? Going to try this today. (I am the Banks Manager) Tried my idea yesterday, took a bit of doing (limited bag space). But it did work. Next problem was how to import the csv file into (Excel), that program dose not have an import function. What I had to do was open the lua file from (Excel), and indicate what the separators were. I will be using this method once every 1/4 to generate a list for my Guilds web page. Note: the time function was not being transferred correctly. and the Letter t was at the beginning of each separation.

01/15/17, 06:00 PM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Re: Re: Re: Wish

Originally Posted by BMCXP

So how can I do this, maybe force the transactions to refresh for all items. (withdrawal everything, then re-deposit them) then create the ledger file? Going to try this today. (I am the Banks Manager)

Tried my idea yesterday, took a bit of doing (limited bag space). But it did work.
Next problem was how to import the csv file into (Excel), that program does not have an import function.
What I had to do was open the Lua file from (Excel), and indicate what the separators were.

I will be using this method once every 1/4 to generate a list for my Guilds web page.

Note: the time function was not being transferred correctly.
and the Letter t was at the beginning of each separation.

Clever idea you had: using withdraw/deposit events to collect inventory. Glad that works!

Unfortunately, the Guild Bank Inventory API only works while you have the Guild Bank open at a banker. So I won't be able to add an inventory option to GuildBankLedger without some additional UI work (have to insert a "Record Inventory" button somewhere in the guild bank screen). Not sure if or when I'll add this. Still thinking about it...

CSV import: I use Google Sheets to import these CSV files, works fine. I'm pretty sure Microsoft Excel can import CSV format text files. But if you've found another way that works for you, great.

Time function: ISO 8601 date format "2016-12-07T00:53:10" : It is truly appalling that here we are in 2017, 29 years after ISO 8601 became the standard for computerized date strings, and yet neither Microsoft Excel nor Google Sheets support this standard. I upped my standards support. They need to up theirs.

"t" before each separation: use "\t" for your separator, not just "\". "\t" is the escape sequence for "tab" which is what that Lua saved variables file uses as a separator.

01/20/17, 05:15 PM
cwkhorne Forum posts: 0 File comments: 5 Uploads: 0	XD soo im a uber noob and just realized before i posted that its not working that savedvariables is in a directory above the addons XD lol....anyways id suggest throwing in a .bat file with your addon, so its a one click addon for people so they dont have to run cmd every time. here is the commands you'd put it in(which you'd have to get them to edit for themselves.) " Code: cd "Z:\Makujo\Documents\Elder Scrolls Online\live\AddOns\GuildBankLedger" lua GuildBankLedger_to_csv.lua %SystemRoot%\explorer.exe "Z:\Makujo\Documents\Elder Scrolls Online\live\SavedVariables" pause they would need to change the first line directory as you have stated previously. first line writes the command to change directory obviously. second is the converter, third opens the saved variables folder, fourth pauses it so that people can see what the cmd did.

01/20/17, 05:18 PM
cwkhorne Forum posts: 0 File comments: 5 Uploads: 0	:( as a side note your the first addon creator i felt like i should create a account on here finally for. so grats i love the addon and the idea behind it. also i just realized that the .csv is empty except for the top line, am i doing something wrong? i click save data now, then i relog, then i convert, then i import to google docs, and empty. also maybe a keybind on the save data now would be nice.

01/21/17, 02:34 PM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Re: :(

Originally Posted by cwkhorne

id suggest throwing in a .bat file with your addon

Nice script. Thanks.

I've yet to find a way to hand out .BAT files to folks that doesn't cost more configuration than it saves. One person won't have lua.exe in their path. Another will have a different path to their SavedVariables directory. A third will be running on Mac instead of Windows. I don't want to spend my days helping people configure their machines. That is not the core problem I'm trying to solve here.

Originally Posted by cwkhorne

the .csv is empty except for the top line

Hrm. Sounds like nothing exported. Next time that happens, drop your SavedVariables\GuildBankLedger.lua file onto your favorite text editor (or Notepad) and make sure there are rows upon rows of data with item names and links and prices and such. If not, then the add-on never saved any data, or it did but ESO never had a chance to write the SavedVariables file.

Originally Posted by cwkhorne

also maybe a keybind on the save data now would be nice.

Interesting. I'll keep that in mind for a possible future addition. I use the existing Settings/Add-On UI for feedback and will not duplicate that work in a second set of UI windows, so any keybind would run without feedback except for the final dump to chat.

01/21/17, 06:13 PM

cwkhorne

Forum posts: 0

File comments: 5

Uploads: 0

Re: Re: :(

[quote=ziggr]

sent a pm about colaborating if you'd like to if not i understand seeing as how im a nobody and dont even have my own addon for eso as of yet...im a lazy eso addon user what can i say lol.

01/21/17, 08:28 PM
cwkhorne Forum posts: 0 File comments: 5 Uploads: 0	ehh not working for adding the img in, so here is the link http://imgur.com/a/EVzWf getting this error now. Last edited by cwkhorne : 01/21/17 at 08:30 PM.

01/23/17, 12:06 AM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Originally Posted by cwkhorne

(bug report)

Ooops. Bug. Introduced in 2.6.2, just fixed right now in 2.6.3.

Thank you so much for reporting this!

01/29/17, 03:07 PM
Mulcibur Forum posts: 0 File comments: 38 Uploads: 0	Got the file - now what I managed to get to the point where I have the file but can't seem to find this lua interpreter you speak of to actually get it into a readable excel format. That batch code shared earlier worked great. Can anyone help with the last part of this process

02/10/17, 12:31 PM
BMCXP Forum posts: 1 File comments: 44 Uploads: 0	I its me again, I'm still using your add-on to get the data I use. I was just wondering if there is a way to capture just 1 days worth of data? 10 days of transactions is just to much for me to filter through. Maybe a slider to restrict the no# of days to capture?

02/11/17, 02:33 PM
BMCXP Forum posts: 1 File comments: 44 Uploads: 0	Lua I finally got the LUA interpreter to work for me, what a difference it makes to the csv file. And the time stamp is working to. This will make a big difference in the way I post my data. Now all I have to do is sort the data for what I want, don't need the withdrawals, or any extra data before I do the bank trick. All I need is the total quantity of each item slot in the bank.

Page 1 of 2

Report this File