Go to Page... |
Compatibility: | Flames of Ambition (6.3.5) |
Updated: | 04/12/21 04:04 PM |
Created: | 12/04/20 09:02 AM |
Monthly downloads: | 89 |
Total downloads: | 6,437 |
Favorites: | 4 |
MD5: | |
Categories: | Plug-Ins & Patches, ESO Tools & Utilities |
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 |
Comment Options |
Baertram |
View Public Profile |
Send a private message to Baertram |
Find More Posts by Baertram |
Add Baertram to Your Buddy List |
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
12/17/20, 07:30 AM | |||
|
It will not be shown in Minion if it's in the Discontinued/Outdated ESOUI section.
|
||
|
Baertram |
View Public Profile |
Send a private message to Baertram |
Find More Posts by Baertram |
Add Baertram to Your Buddy List |
12/21/20, 03:33 PM | |
Forum posts: 0
File comments: 87
Uploads: 0
|
Seems like the latest update neither updates the addon screen with the number of records exported and the last one, nor does it add the MM price to the export either.
|
|
Kwoung |
View Public Profile |
Send a private message to Kwoung |
Find More Posts by Kwoung |
Add Kwoung to Your Buddy List |
12/21/20, 09:29 PM | ||
|
It should look like this: (You can see the MM price in the second to last field, the last field being the item ID.) Lua Code:
I'm aware of the Addon Setting screen Status no longer working, as I've changed a lot of the backend code to use LibHistoire the way that this had been pulling the status etc. no longer worked, so I took out the bits that caused it to stop loading. I'll be looking into a fix for it when I have some more time this week. |
|
|
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
12/22/20, 01:23 AM | |||
Forum posts: 0
File comments: 87
Uploads: 0
|
Code:
"1603333333\t@anon001\tdep_item\tnil\t9\tGrease\t|H0:item:75357:30:25:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t3.8576344383756\t1397693067",[26]="1603333335\t@anon001\tdep_item\tnil\t7\tIchor\t|H0:item:75358:30:25:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t18.457837672583\t1397693083",[27]="1603333341\t@anon001\tdep_item\tnil\t2\tMudcrab Chitin\t|H0:item:77591:31:25:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t458.04997847868\t1397693143",[28]="1603333346\t@anon001\tdep_item\tnil\t14\tSlime\t|H0:item:75359:30:25:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t38.703807025088\t1397693163",[29]="1603336873\t@anon001\tdep_item\tnil\t3\tDeni\t|H0:item:45833:20:11:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t17.12883168154\t1397729923",[30]="1603336875\t@anon001\tdep_item\tnil\t5\tflax^ns\t|H0:item:4463:30:6:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t9.2631354674833\t1397729935",[31]="1603336879\t@anon001\tdep_item\tnil\t1\tJayde\t|H0:item:45821:20:23:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t82.698838248436\t1397729959",[32]="1603336880\t@anon001\tdep_item\tnil\t2\tJejota\t|H0:item:45851:21:11:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t3.1403005121472\t1397729973",[33]="1603336882\t@anon001\tdep_item\tnil\t1\tMakko\t|H0:item:45832:20:11:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t19.742805825622\t1397729989",[34]="1603336888\t@anon001\tdep_item\tnil\t1\tOdra\t|H0:item:45807:20:23:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t68.351851851852\t1397730035",[35]="1603336888\t@anon001\tdep_item\tnil\t1\tPorade\t|H0:item:45856:20:13:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t14.284195887553\t1397730041",[36]="1603336897\t@anon001\tdep_item\tnil\t2\tTa\t|H0:item:45850:20:11:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t6.8781910508859\t1397730141",[37]=
Last edited by Kwoung : 12/22/20 at 01:24 AM.
|
||
|
Kwoung |
View Public Profile |
Send a private message to Kwoung |
Find More Posts by Kwoung |
Add Kwoung to Your Buddy List |
12/22/20, 12:27 PM | ||
|
EDIT - Live now.
Last edited by myristican : 12/22/20 at 12:32 PM.
|
|
|
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
12/22/20, 12:56 PM | ||
|
Last edited by myristican : 12/22/20 at 12:57 PM.
|
|
|
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
12/30/20, 11:56 PM | |
Forum posts: 0
File comments: 12
Uploads: 0
|
I'd hate to discourage anyone, but this doesn't seem ready for prime-time yet.
1. Intended design objectives have not been documented. (Unacceptable. Users (well, me at least) likely assume it's just a typical update to keep current with underlying ZoS programming). 2. The functionality of the program has been changed (again, undocumented). - There is no longer a “Server Poll Option Delay” slider/input. Perhaps no longer required, as it appears that this version of GBL runs near-instantly. - There’s no longer a “fetching events xxx” periodic status update. As above, perhaps unnecessary as it appears to run near-instantly. - The extracted dataset is different than the latest version of GBL. First, the “time_secs” field is in the format from many months past, with a “T” between date and time (rather than in the latest GBL’s Excel-friendly format). Arguably a step backwards. Second, there is a new undocumented “id” field on the right side. BOTH require amending my Excel file. I realize no one cares, but I’m no genius, and it took hundreds of hours to create the tables, formulas and macros … so I cringe every time changes are made. If it adds value, please explain and it will likely be welcomed! - Additionally, the records now encompass a month and a half of transactions (rather than the previous version’s 10’ish days). It’s undocumented what the objective is, nor how long the records will be retained. Hopefully not long enough to slow everything to a crawl. 3. In the absence of such documentation, I pressed the generic “Refresh Data Now” button a number of times (first without realizing there had been functionality changes; later after toggling the “which guild” and “gold vs all” options. My extracted .csv now contains a mix of 4 and 5 records per transaction (ie: I see 4 identical transactions for records a week or more old; and 5 identical transactions for this past week’s records. My first couple hours trying to rectify this have failed, and I fear my history is now compromised irreparably. Help please? I’ve rerun GBL; turned off all other addons; and rebooted/rerun so far. I’m going to try to uninstall and re-install the Greymoor patch version next. 4. “End of run” messaging reads as follows (I think: it kinda flowed with MM messages): === start Starting refresh for Enabled Guilds Starting SetupListenerFunction 91215 MYGUILDNAME GBL: Listener Started Guildbankledger: /reloadui, Log out or Quit to write to file. Refresh complete ==== end Most of those words mean nothing to me, as a user. I’d strongly prefer: GBL started. GBL completed successfully. Write to .lua file by one of: /reloadui, Log Out to character select, or Quit ESO 5. Changing dates: I honestly don't know how you could ever make everyone happy. It was certainly fine before, imo. Please just ensure that the minimum solution retains the "past 10'ish days" of history, no matter what. Background: I've used GuildBankLedger in various iterations for well over a year -- ever since ZoS changed the underlying code to retain only 10'ish days of info. I've built an extensive automated raffle Excel worksheet that isolates the raffle week's info ... creates tickets, runs the raffle and populates mail templates for both the winners and the guild at large, according to my guild's rules. Have over a year’s history of winners and deposit/withdrawls. Graphs and charts. I adore the Guildbankledger program. Has made managing a raffle and guild deposits easy and enormously value-added. I'll personally tolerate a LOT of changes (yet prefer none) ... if it helps keep the core program viable over time. But please test and document first! Christmas wishes? Extract my sticker-book to .csv !!! I'll check back in case you have questions or require clarification. |
|
Wraith2018 |
View Public Profile |
Send a private message to Wraith2018 |
Find More Posts by Wraith2018 |
Add Wraith2018 to Your Buddy List |
12/31/20, 12:59 AM | |
Forum posts: 0
File comments: 12
Uploads: 0
|
Update: all is ok now.
Made backups of GuildbankLedger from both Live\Addons\ and Live\SavedVariables
Using minion, uninstalled GuildBankLedger - 3.x - Updated. Did NOT select the option to remove SavedVariables. Manually (as it's not part of minion) reinstalled the previously working Greymoor version. Files zip downloaded, then copied/extracted to live\Addons\GuildBankLedger\ AND THEN the GuildBankLedger.lua program was copied to Live\SavedVariables\ ... replacing what was there. Entered ESO, ran as normal. Worked. Data is fine; no duplicate transactions. Extracted fields are as before. All good. I really value and appreciate anyone keeping this program viable. So thank you, sincerely. |
|
Wraith2018 |
View Public Profile |
Send a private message to Wraith2018 |
Find More Posts by Wraith2018 |
Add Wraith2018 to Your Buddy List |
12/31/20, 06:43 AM | ||
|
Re: Update: all is ok now.
Did you get it all working with this version or end up falling back to an older one with just the updates to make it compatible? Most of the front page of this Addon does explain the differences and detail the changes, removing the old fetch guild history and replacing it with libhistoire meant I had to strip ALL of the existing config to collect guild data. As you said the 10 days was due to a chance made my ZOS to guild history, libhistoire lets that event data last as long as what you have captured, so this is now more of a leave it running, do a quit and log back in to get the most current and pretty much never need to worry about pressing the "save now" button to capture data. - Granted yes I could do with explaining better on the front page exactly that and I'll endeavour to go back and add a kinda "whats different" or "what to expect" section. Its by far the biggest change and because of that, and to remove further things that put strain on the server, I've had to drop status messages and look at new ways to report back how far it has currently run etc. What I have noticed is that my duplicate function isnt working as intended, it looked like it was when I last tested. - I am fixing this today. I do try to do as much testing as possible but appreciate it is never going to be exactly the same as someone loading it for the first time, or moving to this version from the previous iteration from 5 years ago. As for the messages, most of them dont ever actually show up in the chat window because of when they are loaded, and yes I forgot to turn off some that I was using for debugging. Status messages are something I'm working on, I just need to get the right bits of script to pull events being processed etc. from libhistoire. I apologise if this has caused any issues with what you currently had, the Time I'm using a different function for, it just uses the time straight from libhistoire, as it stores the actual time of the event rather than the previous "time since event" which then had to be calculated from the current time. The ID is part of libhistoire to keep track of events, so it knows what to store and when, and also as part of the dupe function. Feel free to message me directly if you have any specific queries around your own setup and ill help where I can and again I am sorry you had so many issues, but thank you for feedback as, with all things if no one says there is an issue sometimes you might never know. |
|
|
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
12/31/20, 06:06 PM | |
Forum posts: 0
File comments: 12
Uploads: 0
|
Thanks, I'm good.
<< Double typo in your post I think: “chance made my ZOS” should read “change made by ZoS” >>
Yes, I un-installed your version and have reinstalled my previously working one. From this week’s extract, it appears I now have zero issues. Thank you for your concern. I can’t use your version without a significant re-write to my Excel file, and don’t personally see any advantage to doing so at the moment. The “duplicated transaction” issue is for sure a big one. I’m actually confused as to how I managed to download your version last week. So far I’m concluding something between “my own fault” and “senility” (neither good ). I did notice it in a whack of minion “updates” I initiated the other day. You mention (and it’s understood now) that your version is an update to Ziggr’s wonderful original version from 5 years ago. FYI, Splat has had a working version since Aug, 2019 (Scalebreaker release) … that I’ve personally been using (with great success) since ZoS re-wrote it’s guild history coding and assassinated any/all working automated raffles. [Note that it’s my understanding that the raffle addon(s) have been re-written & fixed since then.] Also please note that the absolute last thing I’d wish to do is get between two developers. There’s no reason I can think of why they can’t co-exist, but if they do, it reinforces the need for good clear documentation. The change in “time format” was made May 15, 2020 after being requested by an end user … and the prior version had used the format you now do. Both are fine, but I’ve come to appreciate making it “Excel” friendly is “a good thing”. The version you use requires a bit of mental gymnastics (for any and all Excel users) to convert to the generic Excel format. Your call, of course. With respect to your version, I’d like to offer the following: I’d certainly retain the “Press this button to run the extract” … if ONLY to support your internal diagnostics and report to the user that the resulting .lua file is ready to go. Just my 2cents, of course. Pretty much concur with all your comments. We can certainly agree to disagree on documentation. I’d personally think you may wish to consider something like: - Update to Ziggr’s version (recognizing that 2 now exist. I don’t know what protocol is to recognize Spat’s version, but you may wish to make contact. Above my pay grade!) - Supports minion updating (always a good thing, imo) - Will create a database of guild transactions (deposits and withdrawls) that starts from the date you first use this addon … and each subsequent data extract (if done weekly, for example) will completely over-write the previous one (back to that start date). (my understanding of this; but obviously correct if I’m mistaken) - Excludes, for security reasons, any bidding and gold transactions related to the acquisition of a guild’s trader kiosk. Optionally allows the database to include “items” deposited and/or withdrawn. (ie: non-gold transactions, such as a guildee depositing a motif, or withdrawing a soul gem). If a user decides to modify this setting, only transactions from that point forward will reflect that change. (total guess by me on the last statement, but random selecting/deselecting the option is likely to give inconsistent results, I’d think) Just trying to help, from a layperson’s perspective. I know nothing of fetches, listeners, refreshes, libhistoire, or any .lua coding. I did write a layperson’s guide on converting the .lua to .csv that may be of use to you (Splat’s version comments dated Mar 9, 2020). Overall, I remain thrilled that folks support this notion of extracting of bank transactions to enable raffles and guild donation support. I also appreciate how difficult a task it is. I noticed you've had near-300 downloads already; Splat's is at near-1,500. A lot of users seem to get value from this, to be sure. Cheers, and thank you again for your efforts to keep this transactional extract alive. |
|
Wraith2018 |
View Public Profile |
Send a private message to Wraith2018 |
Find More Posts by Wraith2018 |
Add Wraith2018 to Your Buddy List |
01/01/21, 10:53 AM | |
|
Okay, I thought that might have been the case, I was offline when you posted before so wasnt much I could do to help.
The duplication issue has been resolved now, but the refresh button has a very very different usage in this version as the data is collected from the first time you run it and the refresh is to reiterate over all stored events and pull in any that you have missed. (Its a libhistoire thing, again thats the main difference with this version) I've seen those patches yes, I actually didnt see them until after I had already made the same changes to the original so it never served me any purpose to look into it further. Those particular updates are just to make the existing version carry on working, what I have is essentially a full rework of the entire addon. I was annoyed at only have 10 days worth of data, which is what started me down this path, libhistoire was recommended to me by other developers, due to the server load that using the old command causes. It doesn't actually write over any of the existing history, it only ever appends, unlike the previous version that destroyed all the data and wrote brand new data each time. This is a constantly running process to collect all the bank history that you have access to. This is the same way that MM3 works, just without the fancy interface that I don't have time to write, and with less helpful messages. There is actually a refresh function in MM that does the same thing and reiterates through data, its a really resource heavy process when it has to run through thousands of events, so i would never recommend that you spam that button, it wont make any difference and you would be better off enabling guilds and doing a /reloadui to get the data for them. If events are missing its the same process as with the current one, you quit, log back in, wait for libhistoire to update its stuff, reloadui again and that savedvariables file will have the latest data added. (Yes i need some sort of status adding or a message to say new events have been processed but its a work in progress and a lot of extra code needed) The biggest thing here is that you basically need never worry about requesting the data, just leave the addon to do its thing and the data will be saved for you. Personally I only use the gold data for a raffle so I just filter it, sort by date, filter out anything but the right guild and gold deposits and then copy that to a new sheet where i do my final "tweaking" to give a result for who wins what. So as for your date comment, this will actually go back through any data you have for that guild since you installed libhistoire. This is the biggest and by far the most important change to this addon. Yes I've added a few bits here and there for duplicates and for only having gold transactions, but the biggest change and the most amount of code is for how it collects events from libhistoire and then processes them. Most of youre issues seem to be around your own spreadsheet, personally I can work perfectly fine with the time output the way it is, it can still be sorted and its easy to find the last thing you were looking for using the time. I'm a lot more used to excel and formula and all of that though so maybe its why I don't have an issue, I can't speak for your experience or expertise with excel and if you have put many hours work into making some sort of automated macro for yours then fine. What I will add is that you can use whatever lua to csv script you want, I took mine from the original addon which is why it is different, but you can edit it or just use another one. Like I said, I used the original addon with my own changes to get it to continue pulling data originally and didnt touch the lua to csv script. All I've done is add an extra field for it to export across, but you could just as easily delete this field from that script. It is completely required for it to be stored in the savedvariables though for duplication checks so it has to be saved. I've updated the info for the addon now so hopefully people can understand a bit more about what this is. |
|
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
01/02/21, 01:59 PM | |
Forum posts: 0
File comments: 87
Uploads: 0
|
Hi, just a heads up. GBL seems to be lagging my game/computer to death for considerable time after login. Our guild bank is pretty active, so there are a lot of transactions. It took me a while to pinpoint the addon causing the issue, and this is the culprit it seems. Just a wild guess, but I think it has to do with it scanning LibHistoire and the 300,000+ records in there. BTW, my last export was about 64K records long, which made it problematic to deal with.
Unfortunately it has made my game neigh unplayable, so I have to disable it unless I want to actively export the history. Any chance you can go back to us having to "activate" the export process and generating a message when it completes, instead of it running all the time? I would much prefer that to having to load/unload the addon. BTW, my LibHistoire.lua in SavedVariables is 18.3mb and growing.
Last edited by Kwoung : 01/02/21 at 02:00 PM.
|
|
Kwoung |
View Public Profile |
Send a private message to Kwoung |
Find More Posts by Kwoung |
Add Kwoung to Your Buddy List |
01/02/21, 02:16 PM | ||
|
I can certainly see that being an issue, on first run it will run through all events that you have stored in libhistoire for bank history for the selected guilds, I might be able to tweak the duplicate function slightly to speed up that process as I think that causes a lot of lag, although when adding the events as they come in it should take considerably less time at least. The idea of it running in the background is so that it doesn't have to do this MASSIVE run each time you want to run it. I do suspect some of the lag is from the way my duplicate check is working, which is not ideal for that many records I'm sure. I do need to improve the way this works as I'm not overly happy with how it runs currently. Do you want to have an export of ALL of that data using this addon? It sounds like considering you have an 18mb libhistoire save that you have a huge amount of data sat there. |
|
|
myristican |
View Public Profile |
Send a private message to myristican |
Find More Posts by myristican |
Add myristican to Your Buddy List |
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.