GuildBankLedger - 3.x - Updated : Plug-Ins & Patches : Elder Scrolls Online AddOns

(8 Kb)

Download

Updated: 04/12/21 04:04 PM

Patch for:
GuildBankLedger-discontinued.

Add Favorite

Install Help

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:	57
Total downloads:	6,031
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
GuildBankLedger - 3.x - Updated	3.54	8kB	myristican	04/08/21 06:21 PM
GuildBankLedger - 3.x - Updated	3.54	9kB	myristican	04/08/21 06:08 PM
GuildBankLedger - 3.x - Updated	3.53	8kB	myristican	03/11/21 07:32 PM
GuildBankLedger - 3.x - Updated	3.53	8kB	myristican	03/08/21 02:03 PM
GuildBankLedger - 3.x - Updated	3.52	8kB	myristican	01/11/21 05:06 PM
GuildBankLedger - 3.x - Updated	3.51	8kB	myristican	01/05/21 05:59 PM
GuildBankLedger - 3.x - Updated	3.5	8kB	myristican	01/04/21 07:37 PM
GuildBankLedger - 3.x - Updated	3.41	7kB	myristican	12/31/20 07:26 PM
GuildBankLedger - 3.x - Updated	3.4	7kB	myristican	12/28/20 03:07 PM
GuildBankLedger - 3.x - Updated	3.32	7kB	myristican	12/22/20 12:31 PM
GuildBankLedger - 3.x - Updated	3.31	7kB	myristican	12/20/20 06:47 PM
GuildBankLedger - 3.x - Updated	3.3	7kB	myristican	12/20/20 04:40 PM
GuildBankLedger - 3.x - Updated	3.2	9kB	myristican	12/17/20 11:30 AM
GuildBankLedger - Updated - Gold only Version	3.1	8kB	myristican	12/16/20 06:14 PM
GuildBankLedger - Updated - Gold only Version	3.0.0	8kB	myristican	12/04/20 09:02 AM

Comment Options

Page 3 of 4

01/04/21, 04:17 AM
BalaCroft Forum posts: 3 File comments: 27 Uploads: 0	I have exactly the same issue as Kwoung. When I log in to game and after the MM scan is done, fps drops to 2 and ping 999+ and nothing work, Whole computer is lagging like no tomorrow. It took me so long to pin point it to this addon. I was reinstalling MM and libgistoire.lib many times. Then I turened all addons off one by one and it was this one doing it. Like it constantly was requesting data and made computer work really hard. This started after the new years.

01/03/21, 06:50 PM

Kwoung

Forum posts: 0

File comments: 87

Uploads: 0

Originally Posted by myristican

Originally Posted by Kwoung

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.

Hey there,

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.

Actually no, I definitely do not want to export all that. But I saw you previously mentioned you are working on being able to export a range already I think? For me, the last 8-10 days is perfect, I just need a Sunday -> Sunday range for our raffle actually. The way it used to work with 10 days was fine, it was not unmanageable to deal with the spreadsheet.

BTW, what duplicate function?
We have a lot of members make duplicate deposits in a very short time frame, I hope I am not missing any raffle entries. As I type this, I am watching the chars appear 1 per second, as I am running the addon now and about to do a export. My whole computer is l;agged out.

Last edited by Kwoung : 01/03/21 at 06:54 PM.

01/02/21, 02:16 PM

myristican

Forum posts: 10

File comments: 23

Uploads: 1

Originally Posted by Kwoung

01/02/21, 01:59 PM
Kwoung 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.

01/01/21, 10:53 AM
myristican Forum posts: 10 File comments: 23 Uploads: 1	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.

12/31/20, 06:06 PM
Wraith2018 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.

12/31/20, 06:43 AM

myristican

Forum posts: 10

File comments: 23

Uploads: 1

Re: Update: all is ok now.

Originally Posted by Wraith2018

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.

Hi there,

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.

12/31/20, 12:59 AM
Wraith2018 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.

12/30/20, 11:56 PM
Wraith2018 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.

12/22/20, 12:56 PM

myristican

Forum posts: 10

File comments: 23

Uploads: 1

Originally Posted by Kwoung

Seems like the latest update neither updates the addon screen with the number of records exported and the last one...

Working on this tonight, making changes just trying to get them to actually show in the status box.

Last edited by myristican : 12/22/20 at 12:57 PM.

12/22/20, 12:27 PM

myristican

Forum posts: 10

File comments: 23

Uploads: 1

Originally Posted by Kwoung

Looks like the script maybe...

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]=

Also looks to be no line breaks, not sure if that matters.

I've fixed the script to export, I'll be updating the package shortly.

EDIT - Live now.

Last edited by myristican : 12/22/20 at 12:32 PM.

12/22/20, 01:23 AM

Kwoung

Forum posts: 0

File comments: 87

Uploads: 0

Originally Posted by myristican

Originally Posted by Kwoung

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.

Can you check the lua saved variables and let me know if the MM price is showing there? Just need to know if its the Export script that's the issue or not.

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:

[5979] = "1608503059\t@Myristican\twd_item\tnil\t1\tshadowspun gloves^p\t|H0:item:43545:337:50:0:0:0:0:0:0:0:0:0:0:0:0:5:0:0:0:10000:0|h|h\t39.090909090909\t1445631659",
                        [5980] = "1608507119\t@Myristican\tdep_item\tnil\t1\tshadowspun gloves^p\t|H0:item:43545:337:50:0:0:0:0:0:0:0:0:0:0:0:0:5:0:0:0:10000:0|h|h\t39.090909090909\t1445677151",
                        [5981] = "1608507126\t@Myristican\twd_item\tnil\t1\tshadowspun gloves^p\t|H0:item:43545:337:50:0:0:0:0:0:0:0:0:0:0:0:0:5:0:0:0:10000:0|h|h\t39.090909090909\t1445677281",
                        [5982] = "1608566430\t@UndeadHumanity\tdep_item\tnil\t1\tRunebox: Snowball Buddy\t|H0:item:171330:124:6:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t1541.1707317073\t1446187943",
                        [5983] = "1608588742\t@Arienor0791\tdep_gold\t10000\tnil\tnil\tnil\tnil\t1446378065"

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.

Looks like the script maybe...

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]=

Also looks to be no line breaks, not sure if that matters.

Last edited by Kwoung : 12/22/20 at 01:24 AM.

12/21/20, 09:29 PM

myristican

Forum posts: 10

File comments: 23

Uploads: 1

Originally Posted by Kwoung

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.

Lua Code:

[5979] = "1608503059\t@Myristican\twd_item\tnil\t1\tshadowspun gloves^p\t|H0:item:43545:337:50:0:0:0:0:0:0:0:0:0:0:0:0:5:0:0:0:10000:0|h|h\t39.090909090909\t1445631659",
                        [5980] = "1608507119\t@Myristican\tdep_item\tnil\t1\tshadowspun gloves^p\t|H0:item:43545:337:50:0:0:0:0:0:0:0:0:0:0:0:0:5:0:0:0:10000:0|h|h\t39.090909090909\t1445677151",
                        [5981] = "1608507126\t@Myristican\twd_item\tnil\t1\tshadowspun gloves^p\t|H0:item:43545:337:50:0:0:0:0:0:0:0:0:0:0:0:0:5:0:0:0:10000:0|h|h\t39.090909090909\t1445677281",
                        [5982] = "1608566430\t@UndeadHumanity\tdep_item\tnil\t1\tRunebox: Snowball Buddy\t|H0:item:171330:124:6:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|h|h\t1541.1707317073\t1446187943",
                        [5983] = "1608588742\t@Arienor0791\tdep_gold\t10000\tnil\tnil\tnil\tnil\t1446378065"

12/21/20, 03:33 PM
Kwoung 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.

12/17/20, 07:30 AM

Baertram

Super Moderator

Forum posts: 4989

File comments: 6040

Uploads: 78

It will not be shown in Minion if it's in the Discontinued/Outdated ESOUI section.

Originally Posted by myristican

Originally Posted by Baertram

Your zip file is packaged wrong.
The foldername is missing. Minion won't be able to find nor install this file properly this way.

Please include the folder (must be exactly named the same as the txt file! "GuildBankLedger") and put all files in there.
The lua file for the csv is not specified inside the txt file, maybe this is correct, maybe not. I do not know the old addon. But the code of the file NewGuildBankLedger_to_csv.lua won't be loaded ingame this way.

And maybe add to the description, that you've added the dependency to a new lib:
LibHistoire
, so users are able to see and install it directly. Else they would need to check it ingame first.

Thanks, it wasn't on Minion originally so didnt think about that but I have changed it.
The other file is ran manually so thats fine not being loaded, updated the desc. also.

Page 3 of 4

Report this File

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.

[Disable these notices]