Download
(7 Kb)
Download
Updated: 05/25/20 03:59 AM
Compatibility:
Greymoor (6.0.5)
Harrowstorm (5.3.5)
Dragonhold (5.2.5)
Scalebreaker (5.1.5)
Updated:05/25/20 03:59 AM
Created:08/28/19 10:14 AM
Monthly downloads:35
Total downloads:7,304
Favorites:2
MD5:
Guild Bank Ledger Greymoor Patch  Popular! (More than 5000 hits)
Version: 1.2.0
by: Splat [More]
Updated to work with api version 100031 & ESO 6.0.0 Greymoor for those that are still using this for the spreadsheet output for guild donation management.

Install in place of the original.

Please make backups of your addons & savedvariable files before installing.
## Change log for 1.2.0

Updated to API version 100031
Move Libs to external dependencies
Made small change to date/time string to comply with excel - thanks to Kwoung


## Change log for 1.1.0

Update addon to work with Harrowstorm
Archived Files (2)
File Name
Version
Size
Uploader
Date
1.1.0
52kB
Splat
02/21/20 05:48 AM
1.0
51kB
08/28/19 10:14 AM


Post A Reply Comment Options
Unread 03/13/21, 04:21 AM  
gamingneeds

Forum posts: 0
File comments: 8
Uploads: 0
Hello, any way to make a small in-chat function where I can have it dump the inventory inside the Guild Bank to a csv or anything?

Thanks!
Report comment to moderator  
Reply With Quote
Unread 02/03/21, 04:12 PM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
Changing Guilds not working

Hi

Have historically run GBL exclusively on Guild#1. All fine.

This week, while working with Guild#2, swapped the ON/OFF from Guild#1 to Guild#2. Ran fine, with expected results.

Changed back to Guild#1. Pressed "Save Data Now". UI correctly reports Guild#2 as "skipped".

Quit ESO; converted from .lua to .csv. Again, no errors or issues reported. Upon importing to Excel, found BOTH Guild#1 and Guild#2 transactions. Guild#2 shouldn't be there.

Tried a second time to support the premise that "me not dum" Same result.

Any chance you could take a look, please and thanks!

RESOLUTION: (update Feb 12, 2021)
My bad. Simply backup your current GuildBankLedger files, and re-install per author's guidance. Reinstalling resets the guild selection and subsequently works without issue. Importantly, this issue will NOT materialize during the normal administration of the AddOn ... and only happened as I was flipping between two guilds.
Last edited by Wraith2018 : 02/12/21 at 05:11 PM.
Report comment to moderator  
Reply With Quote
Unread 12/31/20, 01:29 AM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
Bit of a scare

There's a GuildBankLedger 3.0 version- Updated that's been introduced. Version 3.4 Minion 6.2.5.

Just FYI. Perhaps helpful if someone faces the same scary day I just had.

I swear I didn't download it with minion on purpose, but that appears untrue, as it appeared in my minion downloads. I can only claim ... well ... senility I suppose

It's largely undocumented, but from my experiences today, it appears to be an attempt to::
- make it minion-friendly
- make it run faster (using LibHistoire, near as I can tell). My medium-size guild currently takes 5-10 min. This 3.x version is near instantaneous. Removed the "Server Poll Option" slider. Removed the "fetching events xxx" status updates. Remainder looked identical.
- they're (again, near as I can tell) ... using LibHistoire to create an extract that's longer than the 10-ish day extract that this one does. I'm not clear what the goal is. My Excel makes sure only a "raffle week" with specified start & end data/times is used, then transferred to a historical database for reporting & queries. I suppose one could simply repeatedly download a "new" version of the entire historical database each week. The tradeoff would likely be a "slowing down" of extracting each week as the database gets larger and larger. *shrug*. Both workable, I suppose. Happy with what you've provided here, myself!

Warning:
- they used the Date/Time “time_secs” field format from a few months back (the one with the "T" before time), prior to it being made 'Excel-friendly'. [ 2020-12-30T19:46:53 vs 30-12-2020 7:46:53 PM ]
- I accidentally pressed the “Refresh Data Now” button a few times. Each "press" seemed to add another copy of the data to the .lua file (and hence was transferred to the .csv file). Confusingly I ended up with a .csv extract containing a LOT of records: a combination of transactions with 4 ... AND 5 ... copies of each.
- The author also added a new column/field titled "id". Looks to be a system identifier for a generic transaction #. Can't see any way it adds value, myself. (although it was a quick way to identify the silly duplicated records )

I minion-uninstalled it, reinstalled this. Worked exactly as expected /phew.
Left what I hope wasn't a too critical note explaining the facts as I saw them.

<- remains a happy-camper-dude
Report comment to moderator  
Reply With Quote
Unread 11/02/20, 09:08 PM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
Uh huh!

Pretty ginormous patch/update today.

Tested quite extensively. Working perfectly.

Huge props for durability!


Yay
Report comment to moderator  
Reply With Quote
Unread 09/14/20, 11:38 AM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Price lookup change?

Does anyone know how I can change this part of the code to use TTC or LibPrice instead?

Code:
function Event.MMPrice(link)
    if not MasterMerchant then return nil end
    if not link then return nil end
    mm = MasterMerchant:itemStats(link, false)
    if not mm then return nil end
    --d("MM for link: "..tostring(link).." "..tostring(mm.avgPrice))
    return mm.avgPrice
Report comment to moderator  
Reply With Quote
Unread 06/16/20, 04:32 PM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
Soo ... killed my Excel raffle spreadsheet

First, and super important ... I've no objection to updates; and remain thrilled that this add-on is being kept viable. Consider that upper-case, bold and with exclamation points.

Just a caveat that changing the data structure (like the Greymoor update to the date field) ... kills anyone's already-working Excel spreadsheets. (Date is a critical part of any raffle, of course ... used for data validation; start/end times; and filtering).

Please consider this the minor-est of cautions ... not at all a complaint! Just thought it worth pointing out. I needed a re-write anyway!

(That said, I personally wouldn't want the time-frame of the extract to change, for example).

Bottom line though: still happy, and majorly appreciative!

Edit Jun 17: ok; even that was an over-reaction. The change to the date format is logical and works perfectly with Excel.
Last edited by Wraith2018 : 06/17/20 at 12:51 PM.
Report comment to moderator  
Reply With Quote
Unread 05/25/20, 04:26 AM  
Splat
AddOn Author - Click to view AddOns

Forum posts: 7
File comments: 50
Uploads: 7
New release for Greymoor out now (once its verified)

See Change log for update
Report comment to moderator  
Reply With Quote
Unread 05/15/20, 04:53 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Re: Hopefully paying it back a tiny bit.

Originally Posted by Wraith2018
...
CD C:\Users\User\Documents\Elder Scrolls Online\live\AddOns\GuildBankLedger
LUA GuildBankLedger_to_csv.lua
The first of those is simply a "CHANGE DIRECTORY" ("CD") command to point to your newly created Guildbankledger.lua file's sub-directory.
The second runs the previously downloaded LUA.exe file ... and creates the .CSV file that can be read by Excel (which should now be the most recently created file within the "C:\Users\User\Documents\Elder Scrolls Online\live\SavedVariables" subdirectory. Exit the Command Prompt popup.

I hope this helps. Apologies for length.
Awesome guide! I can add a little that helps also...

Line 81 of GuildBankLedger_to_csv.lua, replace the T in the date/time string with a space, then Excel will understand it.
Code:
Before:
return string.format("%04d-%02d-%02dT%02d:%02d:%02d"

After:
return string.format("%04d-%02d-%02d %02d:%02d:%02d"
Use this little nugget to remove the @ sign from the output, which also helps keep Excel from freaking out on the user column:
Code:
powershell -Command "(gc GuildBankLedger.csv) -replace '@', '' | Out-File -encoding ASCII %USERPROFILE%\Desktop\GuildBankLedger_Clean.csv"
Last edited by Kwoung : 05/15/20 at 05:01 PM.
Report comment to moderator  
Reply With Quote
Unread 05/15/20, 01:57 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Feature Request...

Hi, thanks for an excellent addon! I never thought I would become a guild master, but here I am and running raffles. Your addon has made life considerably easier, but I would like to make a request:

- Ability to just export changes since last run, or a specific date/time.

I ask because I would love to just update my on-going spreadsheet(s) with new data, and not have to manually massage them to remove duplicate data. It would also make running the export considerably quicker I suspect, if we are just scanning from newest to last run time. Last run could be tricky though, as I tend to get auto-logged out before the run finishes unless I keep moving my character around, although if it was just doing the recent entries instead of all, that may not be an issue.

Thanks!
~Kwoung
Report comment to moderator  
Reply With Quote
Unread 03/17/20, 10:27 PM  
deadnskinny

Forum posts: 0
File comments: 2
Uploads: 0
Thank you! The length and detail are perfect. I really appreciate the response!

Stay awesome
Report comment to moderator  
Reply With Quote
Unread 03/09/20, 06:12 PM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
Hopefully paying it back a tiny bit.

When the automated Raffle programs died after the Guild History changes last year, I spent a while trying to figure out how to do raffles with Excel. (The excel program is unique to my guild rules and kinda a mess right now, but it works and I have 100% confidence in the results.)

I'm hyper-grateful to Splat for enabling this.

First, my googling for alternatives that perform the function of this add-on failed. To my knowledge, this is the only one. Part "b" to that, I am aware that the program I'd previously been using Raffle Gold ... has been repaired and is apparently working fine. I have not personally verified this. If you're creating an Excel version from scratch, I'd suggest looking at this first. That said, I personally find the value of having all the data at my fingertips to be extraordinarily useful.

Caveat 1: This will NOT be about "how to run the add-on" other than a couple tips that helped me. This will not be "about the Excel bit". This is entirely about the one-time only setup for your computer to use the Guild Bank Ledger add-on. In other words, this is about installing the standalone .LUA interpreter ... the small program that converts files from the ESO "C:\Users\User\Documents\Elder Scrolls Online\live\SavedVariables\GuildBankLedger.lua" into a formatted file that can be read directly by Microsoft Excel (GuildBankLedger.csv).

Caveat 2: I'm no .lua expert. Zero expertise. While pretty good at Excel, I've not done the hard stuff yet (macros to turn a 5,000g deposit into five 1,000g tickets, for example). Still works, just takes me half an hour each week to manually create tickets.

Caveat 3: I'm on PC: Windows 10 Pro 64-bit version. I know absolutely nothing about anything else! I believe my sub-directories are all "generic".

Caveat 4: These steps involve making (relatively minor) changes to your Win 10 config. I highly recommend the safety of creating a "restore point" before proceeding. 20secs can potentially save you ginormous headache if things were to go south.

Q: Where can I get a standalone LUA interpreter?
A: I googled a bunch, and found this site. Under the "History" heading, just download the top (most recent) version.

A1: I downloaded that .zip compressed file, and extracted the four little files within to C:\Program Files\LUA
A2: Within those four files is the executable. Based on a separate googled guide, I re-named the LUA53.exe file to LUA.exe. Left the other three intact, as downloaded. (What follows is "consistent" with the name change to LUA.exe)
A3: Next, we need to let the LUA.exe file run from any sub-directory. Hit your "Start" button; directly type “View advanced system settings” and select it to have the pop-up menu appear.
A4: Using the pop-up, select the "Environmental Variables" button. Left-click on "Path" to select that line, then use the "Edit" button. At the top of the next screen, use the "New" button and then type "C:\Program Files\LUA". Click the "OK" button to establish that new pathway. Done. You can exit out. [Optional: If you like, you can redo A3 & A4 UP TO (but stopping before) the "New" step, to confirm.]
A5: Weekly, when you are about to run the raffle: First, create the weekly data extract "Guildbankledger.LUA" file by using the in-game add-on for your specific guild. (On my slow PC/poor internet provider, I use "2500" in my "Server Poll Options" box). When the almost invisible dark grey "progress" text string directly below your guild's name changes from "fetching events xxx ..." and after a while, reports "Newest: @name-of-latest-entry xx minutes ago", the extract is ready to go. Exit ESO (mandatory; as that triggers the extract creation). Note: the new Guildbankledger.LUA file will over-write the prior week's version. It will include 10 days of "deposit" and "withdrawal" data records, ending the moment you exited ESO.
A6: To run the "LUA.exe" file, use "Start" and type "Command Prompt". For anyone old like me, that opens a li'l DOS-type window. You'll need to enter the following two lines of code, in succession. [I personally just copy-paste from where I saved those two text strings in Excel]. The copy/paste/enter for both takes about 1second that way.
CD C:\Users\User\Documents\Elder Scrolls Online\live\AddOns\GuildBankLedger
LUA GuildBankLedger_to_csv.lua
The first of those is simply a "CHANGE DIRECTORY" ("CD") command to point to your newly created Guildbankledger.lua file's sub-directory.
The second runs the previously downloaded LUA.exe file ... and creates the .CSV file that can be read by Excel (which should now be the most recently created file within the "C:\Users\User\Documents\Elder Scrolls Online\live\SavedVariables" subdirectory. Exit the Command Prompt popup.

I hope this helps. Apologies for length.
Report comment to moderator  
Reply With Quote
Unread 03/05/20, 07:19 PM  
deadnskinny

Forum posts: 0
File comments: 2
Uploads: 0
Another option?

I see that this is not supported anymore but some are able to still use it. What I need to do is pull the guild bank gold donations out into an excel file. I can do csv -> xls easy enough, and this looked like it would do lua -> csv, but I can't get it working.

1) Is there any other addon that will do this? (I can't believe there's no one else that wants this info in a datafile to do the stupid raffles)
2) If not, I can get the first cmd to run, but the second won't. I can't find a "standalone lua interpreter" so any help there would be appreciated by those who can work this.

Thanks!
Report comment to moderator  
Reply With Quote
Unread 03/01/20, 09:35 PM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
You are the bestest Splat EVER!

Can't thank you enough for updating this add-on.
Very much appreciated!

For me, I "think" (#notarocketscientist) I accidentally created an extra nested \live\addons\guildbankledger\guildbankledger\guildbankledger ... kinda thing. Easily rectified by shuffling files back to the first one of those three.

Thanks again Splat!

*Happy Snoopy Dance*
Report comment to moderator  
Reply With Quote
Unread 09/23/19, 05:39 PM  
Wraith2018

Forum posts: 0
File comments: 12
Uploads: 0
Bit (maybe more than a bit) confused

[This replaces my earlier comment.]

This addon works fine; great in fact.

My first attempt failed.

Ran it today after expanding the slider to 2500 ... worked precisely as intended.

Thank you kindly for this. Wonderful piece of work.
Last edited by Wraith2018 : 09/24/19 at 01:57 PM.
Report comment to moderator  
Reply With Quote
Unread 08/30/19, 05:08 PM  
darwyn

Forum posts: 0
File comments: 1
Uploads: 0
THANKS for getting this working again, Splat. (Since it stopped working, I've been blind without a cane.)
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: