Download
(8 Kb)
Download
Updated: 04/12/21 04:04 PM
Pictures
File Info
Compatibility:
Flames of Ambition (6.3.5)
Updated:04/12/21 04:04 PM
Created:12/04/20 09:02 AM
Monthly downloads:50
Total downloads:5,971
Favorites:4
MD5:
Categories:Plug-Ins & Patches, ESO Tools & Utilities
GuildBankLedger - 3.x - Updated  Popular! (More than 5000 hits)
Version: 3.55
by: myristican [More]
IMPORTANT PLEASE READ -
This is a rework of the original GuildBankLedger by ziggr - It now no longer uses the old command to collect data and instead fetches it from LibHistoire.

This has unfortunately meant that the status messages now no longer work (I am working on this) I also have rewritten the save function so that it stores all data that LibHistoire has collected.

There is no longer a delay option as this is not needed.
The Export Data button is used in conjuction with the Export Timeframe option to only export in csv friendly format the data that you want. It default is 10 days, can be expanded to 90 currently, let me know if this needs to be longer.
The Refresh now button will force LibHistoire to run through all collected data and then complete the dupe check against your existing saved data. THIS CAN TAKE A LONG TIME and I currently don't have a "complete" message that shows.

It will however enable you to dynamically add guilds to the collection. Note - if you change what is being collected from "on" to "off" the existing data will still exist. If you want to remove the old data I would recommend deleting the saved variables and just starting again.


LibHistoire is a dependency please ensure you have it installed.

IMPORTANT: Saved Variables version has been updated to clear old values. If you don't have LibHistoire running with that data please save a copy of this file or export to csv!!

The default .lua file from this is now very large, proportional to the amount of data you have stored in LibHistoire, so please keep this in mind.

Fully reworked to use LibHistoire, with thanks to Baetram and Sharlikran for solving my stupid lua questions!

Added
  • LibHistoire usage to reduce server load
  • Option to select all data or gold only
  • All Guilds are disabled by default and All Data is selected
  • On first run turn on for guilds you want and select the type of data, you'll then need to /reloadui or log
  • Export Now button - The equivalent of the old Save Now - Utilises a date range at the bottom of the settings window to export only the past x amount of days that you set. (Default is 10days)
  • Save now button repurposed to Refresh - This will force any newly selected guilds to fetch data, as well as refresh all existing data collected

The CSV export requires you to use a windows or linux lua tool.
I used the one from http://luadist.org/ just download the windows one, and inside the /bin folder is a lua.exe, drag your GuildBankLedger_to_csv.lua onto that exe and itll do the rest.
CSV is exported into ../savedvariables/GuildBankLedger.csv


--------------------------------------
Currently Working on:
- Some other way to display/export data - Might be useful to display in game < could tie raffle function into this.
- - Maybe a better way to get data to csv without running another lua script?
- Debug messages for completion of data etc.
- Status to work in the settings window again
3.55
- Changed mm price lookup to use LibPrice

3.54
- Resolved error causing export/addon menu issues

3.53
- Reuploaded due to issue with first upload
- API Version updated

3.52
- Moved MM Price function to export to ensure it is always up to date, rather than historic
-- removed from the listener so this data wont be collected during event retrieval for new events

3.51
- Fixed Gold only export function so that it actually works

3.5
- Added a GBLData Lib for storing the Export data
- GuildBankLedger.lua saved variable now stores the actual event data rather than the CSV friendly format which should make for quicker duplicate checks
- Export function to enable selective data export based on timeframe (default 10days)
- Gold Only export function also moved to this new export part of the lib

3.41
- Small fix to resolve the duplicate check function so that it now actually works

3.4
- Save Now button repurposed to Refresh - this will restart the LibHistoire Listener and go back over all events
- - Also will now allow instant retrieval of newly enabled guilds
- Duplicate check function added to script to ensure the refresh doesn't write existing data

3.32
- Fixed export to csv script to include all fields

3.31
- LibHistoire now used for all data fetching
- Ensured data is writing correctly to file and not overwriting old data
- Status now needs to be fixed
- saved variables version increased to start all save data blank for use with libhistoire's stored data

3.2
- Switch added for Gold or All Data - All Data is default
- Lua to CSV updated to work with the above
- You can dynamically switch between All Data or Gold by changing the On/Off and running /gbl then /reloadui to get the variable to save

3.1
- Updated to use LibHistoire
- Data is now collected using LibHistoire and /gbl just saves whatever has been collected
Archived Files (15)
File Name
Version
Size
Uploader
Date
3.54
8kB
myristican
04/08/21 06:21 PM
3.54
9kB
myristican
04/08/21 06:08 PM
3.53
8kB
myristican
03/11/21 07:32 PM
3.53
8kB
myristican
03/08/21 02:03 PM
3.52
8kB
myristican
01/11/21 05:06 PM
3.51
8kB
myristican
01/05/21 05:59 PM
3.5
8kB
myristican
01/04/21 07:37 PM
3.41
7kB
myristican
12/31/20 07:26 PM
3.4
7kB
myristican
12/28/20 03:07 PM
3.32
7kB
myristican
12/22/20 12:31 PM
3.31
7kB
myristican
12/20/20 06:47 PM
3.3
7kB
myristican
12/20/20 04:40 PM
3.2
9kB
myristican
12/17/20 11:30 AM
3.1
8kB
myristican
12/16/20 06:14 PM
3.0.0
8kB
myristican
12/04/20 09:02 AM


Post A Reply Comment Options
Unread 04/12/21, 08:48 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Originally Posted by myristican
Looks like thats working, new version uploaded.

Let me know if you have any issues.
Nailed it, it grabbed ATT pricing from LibPrice! I am so happy now, huge QOL update. Also, the export went *way* faster than when it used MM. The huge benefit is it will fall back on TTC pricing now if no other data is available.
Last edited by Kwoung : 04/12/21 at 08:49 PM.
Report comment to moderator  
Reply With Quote
Unread 04/12/21, 08:08 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Ohh.. will check it out in a few, you are amazing!
Report comment to moderator  
Reply With Quote
Unread 04/12/21, 04:05 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Looks like thats working, new version uploaded.

Let me know if you have any issues.
Report comment to moderator  
Reply With Quote
Unread 04/12/21, 03:51 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Originally Posted by Kwoung
I hate to keep asking for stuff, but I really really want to get away from Master Merchant as it slows my game to a crawl and this is the only reason I still have it installed. Any chance you could maybe swap to using LibPrice for this data instead of MM?
Testing a change now, will let you know
Report comment to moderator  
Reply With Quote
Unread 04/12/21, 02:14 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Originally Posted by Kwoung
I hate to keep asking for stuff, but I really really want to get away from Master Merchant as it slows my game to a crawl and this is the only reason I still have it installed. Any chance you could maybe swap to using LibPrice for this data instead of MM?
I can have a look into it.

Unsure why MM would slow your game right down, mine gives blips but its because its indexing something like 180 days worth of data and then pulling that every time I use one of the graphs or whatever. The items with more volume then give a bit of lag during fetch, but of course you can drop that down to 30 days or less if you really needed.

If you need the price then it's important, if you don't care about the price then you can just not use MM and it will return nil to that value.

Saying that and reading the piece that pulls the price, it should be pretty easy to chuck libprice at it, I'll have a look when i get some time
Report comment to moderator  
Reply With Quote
Unread 04/12/21, 01:52 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
I hate to keep asking for stuff, but I really really want to get away from Master Merchant as it slows my game to a crawl and this is the only reason I still have it installed. Any chance you could maybe swap to using LibPrice for this data instead of MM?
Report comment to moderator  
Reply With Quote
Unread 04/05/21, 01:29 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Originally Posted by Kwoung
You rock, thanks! Been waiting on ZOS to fix the user last online bug so I could purge inactive members, but didn't want to boot anyone by accident who may have made item donations to our guild bank. You saved the day yet again!
New upload should be available shortly, let me know if it resolves it.
Report comment to moderator  
Reply With Quote
Unread 04/05/21, 01:06 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
You rock, thanks! Been waiting on ZOS to fix the user last online bug so I could purge inactive members, but didn't want to boot anyone by accident who may have made item donations to our guild bank. You saved the day yet again!
Report comment to moderator  
Reply With Quote
Unread 04/05/21, 12:33 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Originally Posted by Kwoung
Looks like last nights patch broke the export feature again. Looks like all the data is in the LUA, but it is not converting and I get a blank CSV file.

lua.exe: GuildBankLedger_to_csv.lua:18: attempt to perform arithmetic on local 't5' (a nil value)
stack traceback:
GuildBankLedger_to_csv.lua:18: in function 'split'
GuildBankLedger_to_csv.lua:47: in function 'TableHistory'
GuildBankLedger_to_csv.lua:132: in main chunk
[C]: ?
Scratch that, found an issue, one of the old bits of code to do status' that I haven't worked on to fix no longer works.
Give me about an hour as I have some stuff to do and I'll upload a new version with the fix, if you want to edit it in the meantime its this section line 240 i've commented out:

Lua Code:
  1. local desc = _G[self.ref_desc(guild_index)]
  2.     self.ConvertCheckboxToText(desc)
  3.     -- self:SetStatusNewestSaved(guild_index)
  4. end
Report comment to moderator  
Reply With Quote
Unread 04/05/21, 12:23 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Originally Posted by Kwoung
Looks like last nights patch broke the export feature again. Looks like all the data is in the LUA, but it is not converting and I get a blank CSV file.

lua.exe: GuildBankLedger_to_csv.lua:18: attempt to perform arithmetic on local 't5' (a nil value)
stack traceback:
GuildBankLedger_to_csv.lua:18: in function 'split'
GuildBankLedger_to_csv.lua:47: in function 'TableHistory'
GuildBankLedger_to_csv.lua:132: in main chunk
[C]: ?
Oh! That looks nice! I haven't had a look at what is in the patch notes, as I don't have any current data right now, are you able to throw me an example of some of the bits of data in the GBLData.lua from when youve exported and reloadui?

I'll run something myself too, but i recently had to redo my GuildBankLedger.lua as changing guilds broke it for some reason.
Report comment to moderator  
Reply With Quote
Unread 04/05/21, 12:15 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Looks like last nights patch broke the export feature again. Looks like all the data is in the LUA, but it is not converting and I get a blank CSV file.

lua.exe: GuildBankLedger_to_csv.lua:18: attempt to perform arithmetic on local 't5' (a nil value)
stack traceback:
GuildBankLedger_to_csv.lua:18: in function 'split'
GuildBankLedger_to_csv.lua:47: in function 'TableHistory'
GuildBankLedger_to_csv.lua:132: in main chunk
[C]: ?
Last edited by Kwoung : 04/05/21 at 12:18 PM.
Report comment to moderator  
Reply With Quote
Unread 03/11/21, 09:56 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
The last version I uploaded to change the api version number to stop it showing as out of date didnt upload properly.
So if you notice the addon has gone missing grab the latest version it should be fixed in that upload
Report comment to moderator  
Reply With Quote
Unread 02/01/21, 06:32 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Thats very odd, theres not a chance there is a hole in your libhistoire data is there, its not something you would easily be able to find unfortunately. Only way that would be obvious would be to look through the data file for GBL and try and find if the transactions are in there.
That would at least rule out the export as being the part that is messing with the data, GBL can only pull whatever LH has stored so if its not there then it won't know about it, and you can cause holes in your LH data.
Report comment to moderator  
Reply With Quote
Unread 02/01/21, 06:27 PM  
Kwoung

Forum posts: 0
File comments: 87
Uploads: 0
Originally Posted by myristican
Originally Posted by Kwoung
New issue, I apparently have a hole in my data. I exported the data and a husband & wife who made deposits did not appear in the export, but do on the guild bank history in game. LibHistoire says it has all the data, I even did a rescan, but their deposits still don't appear. Any clue as to why?

I am very worried they are not the only ones and my guild members will think we are ripping them off for their raffle entries.
Hey,
Can't say i've come across that at all when I've been looking, which part is it they dont appear in? The bit from the "export" button? How many days do you have that set to export?
It was originally a 8 day export, but did a rescan and a 30 day export and while all their previous deposits showed, the latest didn't. I have deposits both before and after theirs showing as well.
Report comment to moderator  
Reply With Quote
Unread 02/01/21, 04:59 PM  
myristican
AddOn Author - Click to view AddOns

Forum posts: 10
File comments: 23
Uploads: 1
Originally Posted by Kwoung
New issue, I apparently have a hole in my data. I exported the data and a husband & wife who made deposits did not appear in the export, but do on the guild bank history in game. LibHistoire says it has all the data, I even did a rescan, but their deposits still don't appear. Any clue as to why?

I am very worried they are not the only ones and my guild members will think we are ripping them off for their raffle entries.
Hey,
Can't say i've come across that at all when I've been looking, which part is it they dont appear in? The bit from the "export" button? How many days do you have that set to export?
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump:

Support AddOn Development!

You have just downloaded by the author . If you like this AddOn why not consider supporting the author? This author has set up a donation account. Donations ensure that authors can continue to develop useful tools for everyone.