Download
(43 Kb)
Download
Updated: 01/23/17 12:05 AM
Pictures
File Info
Compatibility:
One Tamriel (2.6)
Updated:01/23/17 12:05 AM
Created:09/25/16 09:23 PM
Monthly downloads:28
Total downloads:7,779
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
  1. Click "Save Data Now" button. Add-on will fetch Guild Bank history from ESO's server and note all gold deposits.
  2. Log out (or relog). ESO will then save data, writing SavedVariables/GuildBankLedger.lua.
  3. From a terminal window, run
    % cd ~/Documents/Elder Scrolls Online/live/AddOns/GuildBankLedger
    % lua GuildBankLedger_to_csv.lua
    This creates SavedVariables/GuildBankLedger.csv
  4. 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
3.55
8kB
04/12/21 04:04 PM
Patch
1.2.0
7kB
05/25/20 03:59 AM
Patch


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


Post A Reply Comment Options
Unread 09/10/17, 01:36 PM  
zebrapoe

Forum posts: 0
File comments: 6
Uploads: 0
I really don't have any clue how it works, what to do, wtf is terminal window while I'm using Windows, WTF is Lua.org and what to download there?
I really even don't realize for who this addon has made, I'm GM but not a LUA coder
Last edited by zebrapoe : 09/10/17 at 01:37 PM.
Report comment to moderator  
Reply With Quote
Unread 06/15/17, 10:36 PM  
HelloGoldfish

Forum posts: 0
File comments: 2
Uploads: 0
Slash Command

Is it possible you could add a slash command that will do exactly what clicking the "Save Data Now" button does (using the settings that are currently configured)?
Report comment to moderator  
Reply With Quote
Unread 05/28/17, 12:41 PM  
ziggr
 
ziggr's Avatar
AddOn Author - Click to view AddOns

Forum posts: 27
File comments: 275
Uploads: 10
Re: Milliseconds on timestamps

Originally Posted by HelloGoldfish
is it possible to add milliseconds to the timestamp? Or possibly another value that could uniquely identify rows?
The GetTimeStamp() and GetGuildEventInfo() calls both return integer seconds, not milliseconds. Sorry, no millisecond precision.

--Z
Last edited by ziggr : 05/28/17 at 12:42 PM.
Report comment to moderator  
Reply With Quote
Unread 05/27/17, 11:42 PM  
HelloGoldfish

Forum posts: 0
File comments: 2
Uploads: 0
Milliseconds on timestamps

I am loving this addon so far! But I am concerned with having duplicate entries stored in the archive I am creating. I planned to use the (user,time_secs,item_name) columns to identify unique entries but this presented a problem because I have a user who added two identical motifs to the bank back to back so the time stamp including the seconds is also identical.

I don't really know anything about LUA or the ESO apis but is it possible to add milliseconds to the timestamp? Or possibly another value that could uniquely identify rows?
Report comment to moderator  
Reply With Quote
Unread 05/11/17, 12:45 AM  
Rushinator

Forum posts: 0
File comments: 34
Uploads: 0
Re: Re: Re: Re: Wish

Originally Posted by ziggr
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...
#1 Wished for feature. Would love to be able to press a button or a keybind and have the entire guild inventory saved.

Right now I have to do the withdraw -> deposit trick, which takes awhile.

I use it to display online our guild's entire Motif library for members to peruse so they know exactly what we have as all the motifs are kept in a 2nd guild bank.

Step 1 - Motif Log:


Step 2 - Motif List (formulas use the data from the Motif Log):
Report comment to moderator  
Reply With Quote
Unread 03/31/17, 05:29 PM  
QueenBeaver

Forum posts: 0
File comments: 4
Uploads: 0
Re: Re: Causing Boot from Server

Originally Posted by ziggr
Originally Posted by QueenBeaver
Hey, I love what this add-on does, makes my life as the official guild donation tracker so much easier. Unfortunately I am only having luck getting the scan to work about 1 in 5 times. I get booted from the server frequently while trying to run it for "Excessive Messaging." Any suggestions?
In the GuildBankLedger add-on settings, increase "Server Poll Options / Delay between messages, milliseconds" to a larger number like 2500 or 5000.
Wonderful! Thank you, worked like a charm!
Report comment to moderator  
Reply With Quote
Unread 03/29/17, 09:29 PM  
ziggr
 
ziggr's Avatar
AddOn Author - Click to view AddOns

Forum posts: 27
File comments: 275
Uploads: 10
Re: Causing Boot from Server

Originally Posted by QueenBeaver
Hey, I love what this add-on does, makes my life as the official guild donation tracker so much easier. Unfortunately I am only having luck getting the scan to work about 1 in 5 times. I get booted from the server frequently while trying to run it for "Excessive Messaging." Any suggestions?
In the GuildBankLedger add-on settings, increase "Server Poll Options / Delay between messages, milliseconds" to a larger number like 2500 or 5000.
Report comment to moderator  
Reply With Quote
Unread 03/29/17, 07:46 PM  
QueenBeaver

Forum posts: 0
File comments: 4
Uploads: 0
Causing Boot from Server

Hey, I love what this add-on does, makes my life as the official guild donation tracker so much easier. Unfortunately I am only having luck getting the scan to work about 1 in 5 times. I get booted from the server frequently while trying to run it for "Excessive Messaging." Any suggestions?
Report comment to moderator  
Reply With Quote
Unread 02/11/17, 02:33 PM  
BMCXP
 
BMCXP's Avatar

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.
Report comment to moderator  
Reply With Quote
Unread 02/10/17, 12:31 PM  
BMCXP
 
BMCXP's Avatar

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?
Report comment to moderator  
Reply With Quote
Unread 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
Report comment to moderator  
Reply With Quote
Unread 01/23/17, 12:06 AM  
ziggr
 
ziggr's Avatar
AddOn Author - Click to view AddOns

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!
Report comment to moderator  
Reply With Quote
Unread 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.
Report comment to moderator  
Reply With Quote
Unread 01/21/17, 06:13 PM  
cwkhorne

Forum posts: 0
File comments: 5
Uploads: 0
Re: Re: :(

[quote=ziggr]
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.
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.
Report comment to moderator  
Reply With Quote
Unread 01/21/17, 02:34 PM  
ziggr
 
ziggr's Avatar
AddOn Author - Click to view AddOns

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.
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: