Hey folks,
i wrote a program a while ago to import and interpret guild donation logs.
Unfortunately working together with the moderators we couldn't find a way to guarantee a way to securely provide the program executables, so I can only post a link to the source of the tool. It's located on
https://github.com/chrisheib/NWO-Donation-Monitor.
Feel free to download the source and compile it in Microsoft Visual Studio 2017.
To do so, first download and install Microsoft Visual Studio 2017 from a trusted source, then visit the page with the source and click 'clone or download' and then 'save as ZIP'. Extract the files from the zip and open up the 'NW-Spendenmonitor.sln' in Visual Studio. Then you should be able to click 'Run!' or similar to start the program.
Instructions:
1. In Neverwinter execute the command 'ExportGuildDonationLog E:\Neverwinterlogs\donation.csv'. As path chose one which neverwinter has permission to write to. If you've use the command correctly, a message should pop up in the system channel. Sometimes you need to execute the command twice.
2. Start the tool and click 'Import'. Now choose the file you exported in step one. If you let 'rename file' ticked, the file will be renamed with the date of the last entry, so you wont overwrite it the next time you export the log. Awesome for binding the export command to a key. If an error pops up, click 'Cancel' and repeat step one.
3. Enter a date and choose one of the reports from the dropdown menu. There currently are statistics for gems, surplus equipment, influence, vouchers, and an overview of all ressources. You should now see the magic in the field below
You can also make you own statements via SQL. Type them into the SQL box visible when clicking 'SQL history' and hit 'Query'. A good starting point is 'select * from input'.
Please remember neverwinter does only provide the last 500 entries in the log, so to have a complete coverage of all donations you must export the log every few days, depending on guild size and activity.
The source is open, if youre interesting in taking a look or helping me, feel free to answer
Feel free to try it out and make suggestions.