Quantcast
Download
(52 Kb)
Download
Updated: 02/21/20 05:48 AM
Compatibility:
Harrowstorm (5.3.4)
Dragonhold (5.2.5)
Scalebreaker (5.1.5)
Updated:02/21/20 05:48 AM
Created:08/28/19 10:14 AM
Monthly downloads:106
Total downloads:873
Favorites:2
MD5:
5.3.4
Guild Bank Ledger Harrowstorm Patch
Version: 1.1.0
by: Splat [More]
Updated to work with api version 100030 & ESO 5.3.0 Harrowstorm 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.
Archived Files (1)
File Name
Version
Size
Uploader
Date
1.0
51kB
08/28/19 10:14 AM


Post A Reply Comment Options
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: 5
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: 5
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: 5
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: