Bag of Tricks Vol. 76: Guild Log Donation Parser by STSchiff

Bog of Tricks Logo

Welcome to the latest installment of our Bag of Tricks! On some days you will find useful tricks, gimmicks and ideas here that can make life in Neverwinter Online easier. Some of the stuff should be well known, but since even veterans learn something new every now and then, chance is you can, too.

Tracking guild donations for leaders can be a time-consuming task. For the longest time you needed to create your own spreadsheet and manually transfer any donation. In Module 12 the devs finally introduced a console command to export the guild donation log in a CSV format. That enabled guild leaders to at least import logs into their spreadsheet or database application, but they still needed to analyse the logs themselves.

German player STSchiff has now shared a tool on our message board that saves logs into a local database and allows to execute simple SQL queries against it. It’s very useful to create a donation ranking or check all donations for a certain time frame. The tool is in German, but STSchiff posted explanations on how to use it.

Since we know that you might be wary of using a third-party executable, we have attached the VirusTotal summary below. Thanks to STSchiff for making the life of guild leaders a bit easier!

VirusTotal .exe
VirusTotal .zip


Bag of Tricks Vol. 71: Data/Sheets on Weapon Enhancements and High-End Group Min/Maxing
Bag of Tricks Vol. 72: Hero’s Accord vs Other Activities
Bag of Tricks Vol. 73: Artifact Power Reference
Bag of Tricks Vol. 74: Campaign and Patronage Cheat Sheet
Bag of Tricks Vol. 75: PVP Damage Calculator by Darthtzarr


Neverwinter UN:Blogged is always looking for writers to contribute to the blog. If you are an active player and search for a way to spread your opinions, analysis, diaries or reviews to more than 40,000 regular visitors, then don’t hesitate and get in touch with us on our contact page or message board! We are currently especially looking for console and PVP content, but that’s not exclusive. There is no frequency requirement, you post how often you want.

NWO_Unblogged

NWO_Unblogged

We are always looking for people that contribute to this blog. For more information contact us via blog@nwo-uncensored.com or check the forum.

7 thoughts on “Bag of Tricks Vol. 76: Guild Log Donation Parser by STSchiff

  • Avatar
    January 27, 2018 at 6:12 pm
    Permalink

    Thanks for spreading this 🙂
    I would like to state that you don’t need any SQL-knowledge to use the program tho. You can just click on whatever statistic you want to see, like ‘How much influence did my members farm in the last week’, and the program shows the result without the need to build any queries manually.

    If anyone has any questions or ideas about this, feel free to ask about it in the forum thread.
    If you want me to translate it to english, please let me know, could surely do so.

    Reply
  • Avatar
    January 28, 2018 at 1:48 am
    Permalink

    Shame the devs don’t implement this on consol.
    Why can’t we have some simple mechanisms for this on the coffer screens on xbox.

    Reply
  • Avatar
    February 22, 2019 at 6:20 pm
    Permalink

    I am hoping I can still get this with j0sHi and the forum gone, I’m looking now…

    Reply
    • Avatar
      February 22, 2019 at 6:21 pm
      Permalink

      Nope, still can’t get in 🙁

      Reply
      • Avatar
        February 23, 2019 at 3:14 am
        Permalink

        Hey, you can find the program here: https://github.com/chrisheib/NWO-Donation-Monitor/releases Just load the latest .zip and off you go 🙂 Unfortunately the nice manual I wrote is gone T_T Basically set the language, export the log from the game with “/ExportGuildDonationLog E:\Neverwinterlogs\donation.csv” (Insert a path that fits for you. I bound that command to F11, makes it quite convenient to use.) Then click the import button, and bathe in numerical glory ^^’

        Reply
        • NWO_Unblogged
          February 23, 2019 at 8:28 am
          Permalink

          Sorry. This probably got blacklisted due to a link being included. I manually unblocked this and deleted duplicates. Cheers!

          Reply
        • Avatar
          February 23, 2019 at 9:20 am
          Permalink

          Oh, thanks for that, Schiff!

          😀

          Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.