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:	130
Total downloads:	7,981
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 2 of 2

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?

03/29/17, 09:29 PM

ziggr

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.

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

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!

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):

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?

05/28/17, 12:41 PM

ziggr

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.

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)?

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.

Page 2 of 2

Report this File