Quantcast
Download
(45 Kb)
Download
Updated: 12/20/16 09:24 PM
Pictures
File Info
Compatibility:
One Tamriel (2.6)
Updated:12/20/16 09:24 PM
Created:05/20/16 11:36 AM
Monthly downloads:95
Total downloads:456
Favorites:3
MD5:
2.6
Guild Sales Quota
Version: 2.6.4
by: ziggr [More]
Does your guild enforce a sales quota? Use Master Merchant to see top sellers? If so, you can do all this from within Master Merchant and do not need this add-on.

But if you also want to record sales to a spreadsheet, that's where this add-on comes in.

This add-on scans Master Merchant sales history, summarizes gold totals for your guild's sellers and buyers over last week, then writes that to a SavedVariables file. It can then convert that SavedVariables file to a comma-separated-value file suitable for import into a spreadsheet.

This add-on also scans guild bank deposits and records each member's deposited total during the week.

Optional: integrates with Shissu's Guild Tools to fetch each member's join date. This is to help guildmasters give new members a bit of a grace period before enforcing sales quotas.

Column list:
  • guild name
  • week ending on date
  • player account @name
  • sold: gold earned in the guild trader last week
  • bought: gold spent in the guild trader last week
  • is a guild member? Many buyers aren't members.
  • is a newbie? Anyone who joined in the last 10 days. (optional, requires Shissu's Guild Tools)
  • joined: when did they join the guild (optional, requires Shissu's Guild Tools)
  • gold deposited: amount deposited to guild bank during the week
  • columns to help you audit which sales contributed to the total for the reported week: sales count, first/last sales time, buyer, amount.

Instructions:
  1. Click "Save Data Now" button. Add-on will scan Master Merchant and guild membership lists.
  2. Log out (or relog). ESO will then save data, writing SavedVariables/GuildSalesQuota.lua.
  3. From a terminal window, run
    % cd ~/Documents/Elder Scrolls Online/live/AddOns/GuildSalesQuota
    % lua GuildSalesQuota_to_csv.lua
    (Or drag and drop GuildSalesQuota_to_csv.lua onto lua52.exe) This creates SavedVariables/GuildSalesQuota.csv
  4. Import GuildSalesQuota.csv into a spreadsheet.

GuildSalesQuota_to_csv.lua requires that you have downloaded and installed a standalone Lua interpreter, presumably from lua.org.

--Z
2.6.4 2016-12-20
  • Add 5 hours of slop for GuildGoldDeposits integration, so that gold deposits/raffle ticket purchases made for Sunday raffles will still count towards last week's quota. Yes this implies that a single ticket purchase during the slop range will erroneously meet TWO week's quotas. It's either this or you have to tell the add-on which exact ticket purchase was the cutoff. That's no fun.

2.6.3 2016-10-28
  • Add sale_ct, first/last sale columns, to help with auditing. With this data you can go to Master Merchant, filter on the seller, and identify exactly which sales contributed to the reported week's total.

2.6.2 2016-10-18
  • Add "is_newbie", "joined", and "gold_deposited" columns

2.6.1 2016-10-05
  • Increment API version for ESO 2.6 (One Tamriel). No other changes.

2.5.1 2016-08-06
  • Increment API version for ESO 2.5 (Shadows of the Hist).
  • Fix nil value error for players with multiple ESO accounts.
    Code:
    lua: GuildSalesQuota_to_csv.lua:138: attempt to index a nil value (global 'guild_name')
    stack traceback:
        GuildSalesQuota_to_csv.lua:138: in main chunk
        [C]: in ?

2.4.1 2016-05-31
  • Increment API version for ESO 2.4 (Dark Brotherhood). No other changes.

2.3.11.1 2016-05-20
Initial release.
Optional Files (0)


Archived Files (6)
File Name
Version
Size
Author
Date
2.6.3
45kB
ziggr
10/28/16 02:02 PM
2.6.2
44kB
ziggr
10/18/16 11:24 PM
2.6.1
42kB
ziggr
10/05/16 07:58 PM
2.5.1
42kB
ziggr
08/06/16 05:10 PM
2.4.1
42kB
ziggr
05/31/16 08:02 PM
2.3.11.1
42kB
ziggr
05/20/16 11:36 AM


There have been no comments posted to this file.
Be the first to add one.



Category Jump: