test content
What is the Arc Client?
Install Arc

Export guild donation log with 500 records is too short

stschiffstschiff Member, NW M9 Playtest Posts: 18 Arc User
Hey there,
I recently wrote a small tool for a few friendly guilds to import the donation log data that gets Neverwinter lets you export with the 'ExportGuildDonationLog' command.

Unfortunately some leaders of a few bigger guilds said that they would love to use the tool, but the limit of 500 records makes it impossible for them, because they would need to export several times a day to get complete coverage.

On active days half of our members accounts donate to the guild, averaging to 20 entries per donating account. A guild can contain 150 accounts, so in a full guild scaling that up you'd have ~75 accounts donating 20 items on average, requiring the log to be 1500 records long to cover a day. (A dev with database access could find out the real limit rather quickly i'd assume.)

Probably you could change the data to be kept for a certain amount of days, like a week or 5 or 3 days, which would be a major improvement aswell.

I don't know how the data is structured, but who knows, maybe its just a line that needs to be changed in order for some more people to be happy :smiley:

Comments

  • micky1p00micky1p00 Member, NW M9 Playtest Posts: 3,594 Arc User
    edited May 2018
    There is also an important issue there that the time column doesn't have the time zone. If someone reads this, please add a another column with time zone, or unix timestamp, or the zone to the current one, or anything.

    The current problem is when 2 players in different locales exported the log, and one trying to stitch the logs together. It's prone to "all hell broke loose and corrupted the data". Less problem when each user can parse and upload, So while I've put a notice "the one that exports needs to upload to the DB or world ends" it's still bad that such 'bug' exists.
    And way more problem for local programs.

    @miasmat
    Post edited by micky1p00 on
  • stschiffstschiff Member, NW M9 Playtest Posts: 18 Arc User
    Yep, annoying as hell, especially when said locales contain commas in them breaking the csv format completely :blush:

    I heard @terramak might take a look at the time format and might probably even give us an ID of some sort to distuinguish the ressourcetype across different language versions. That would be awesome to the max :smiley:
  • tripsofthrymrtripsofthrymr Member, Neverwinter Moderator, NW M9 Playtest Posts: 1,624 Community Moderator
    I did suggest a locale-neutral date format to @terramak e.g. YYYYMMDDhhmmss. The previous comment about the time zone affecting time stamps is worth considering. Hopefully, the actual times are server times (else different client clocks create challenges when combinding logs).
    Caritas Guild Founder (Greycloak Alliance)

    Sci-fi author: The Gods We Make, The Gods We Seek, and Ji-min
Sign In or Register to comment.