MailAttachmentLog-discontinued : Discontinued & Outdated : Elder Scrolls Online AddOns

(5 Kb)

Download

Updated: 01/14/17 08:53 PM

Add Favorite

Install Help

Portal

Bugs

Features

Pictures

File Info

Compatibility:	One Tamriel (2.6)
Updated:	01/14/17 08:53 PM
Created:	03/25/16 11:36 PM
Monthly downloads:	14
Total downloads:	2,097
Favorites:	3
MD5:
Categories:	Discontinued & Outdated, Discontinued & Outdated

MailAttachmentLog-discontinued

Version: 2.6.2

by: ziggr [More]

*** No longer supported ***

----

Do people email you lots of items for weekly guild auctions? Crafting materials? Need to keep track of them?

This add-on scans your mailbox, then saves all messages and attachments to a SavedVariables file. It can then convert that SavedVariables file to a CSV comma-separated-value file suitable for import into a spreadsheet.

Go to Controls > Key Bindings > Mail Attachment Log. Assign a key binding.
Hit the key binding you assigned earlier.
Log out or Quit. ESO will then save data, writing SavedVariables/MailAttachmentLog.lua.
From a terminal window, run
% cd ~/Documents/Elder Scrolls Online/live/AddOns/MailAttachmentLog
% lua MailAttachmentLog_to_csv.lua
This creates SavedVariables/MailAttachmentLog.csv
Import MailAttachmentLog.csv into a spreadsheet.

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

Optional: if you have Master Merchant installed, MailAttachmentLog will look up average price information and use it to calculate attachment value.

--Z

2.6.2 2017-01-14

Clean up CSV output a bit. Include item counts and per-item Master Merchant price. Omit gold attachment lines.

2.6.1 2016-10-05

Increment API version for ESO 2.6 (One Tamriel). No other changes.

2.4.1 2016-08-06

Increment API version for ESO 2.5 (Shadows of the Hist). No other changes.

2.4.1 2016-05-31

Increment API version for ESO 2.4 (Dark Brotherhood). No other changes.

2.3.7.2 2016-03-25

Include missing key bindings.xml file
Fix math error in calculating approx gold worth

2.3.7.1 2016-03-25
Initial release.

Optional Files (0)

Archived Files (5)

File Name	Version	Size	Uploader	Date
MailAttachmentLog	2.6.1	5kB	ziggr	10/05/16 07:58 PM
MailAttachmentLog	2.5.1	5kB	ziggr	08/06/16 05:28 PM
MailAttachmentLog	2.4.1	5kB	ziggr	05/31/16 08:05 PM
MailAttachmentLog	2.3.7.2	4kB	ziggr	03/26/16 12:16 AM
MailAttachmentLog	2.3.7.1	4kB		03/25/16 11:36 PM

Comment Options

06/13/19, 11:43 PM

Rushinator

Forum posts: 0

File comments: 34

Uploads: 0

Originally Posted by ziggr

Uncomment-out the six-line WriteLine() call in MailAttachmentLog_to_csv.lua, at the top of its function Message()

That will probably restore the CSV lines that record any mailed gold.

Probably.

--Z

Lua Code:

-- Parse one email message and its attachments
function Message(msg)
    date_str = iso_date(msg.ts)
 
    -- WriteLine{ date_str   = date_str
    --          , sender     = msg.from
    --          , value_gold = msg.gold    <-- HERE is the attached gold line
    --          , item_name  = msg.subject
    --          , item_link  = ""
    --          }
    TOTAL_GOLD = TOTAL_GOLD + msg.gold
    if not msg.attach then return end
    for _, att in ipairs(msg.attach) do
        gold = ""

PS: if you want to write or adapt your own Lua-to-CSV converter, you can see the mailed gold amounts in the SavedVariables/MailAttachementLog.lua file under MailAttachmentLogVars["Default"][account_name]["$AccountWide"]["history"][mail_message_index].gold:

Code:

MailAttachmentLogVars =
{
    ["Default"] = 
    {
        ["@ziggr"] = 
        {
            ["$AccountWide"] = 
            {
                ["version"] = 1,
                ["history"] = 
                {
                    [1] = 
                    {
                        ["body"] = "An item you listed has sold. (|H0:item:56038:25:4:0:0:0:0:0:0:0:0:0:0:0:0:7:1:0:0:10000:0|h|h)\n\nAttached is your profit, after deductions.",
                        ["ts"] = 1458942773,
                        ["mail_id_s"] = "2.3347013448636e-315",
                        ["from"] = "Guild Store",
HERE -->                ["gold"] = 6231,
                        ["mail_id"] = 0.0000000000,
                        ["attach_ct"] = 0,
                        ["subject"] = "Item Sold",
                    },
                },
            },
        },
    },
}

THANK YOU SO MUCH! It worked perfectly & I now have a solution to do all my donations through the mail until ZOS re-enables addon access to the Guild History.

This is a life saver for many Trade GMs who won't have to manually copy the deposits/gold mail donations.

My guild gets hundreds of guild bank deposits each week & that's not including mail donations.

I dreaded having to copy hundreds of mails manually but thanks to your addon, I can do it in minutes (not including loading time).

Thank you! I'll be sharing this solution with many GMs.

Have a great week.

06/12/19, 10:21 AM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Lua Code:

-- Parse one email message and its attachments
function Message(msg)
    date_str = iso_date(msg.ts)
 
    -- WriteLine{ date_str   = date_str
    --          , sender     = msg.from
    --          , value_gold = msg.gold    <-- HERE is the attached gold line
    --          , item_name  = msg.subject
    --          , item_link  = ""
    --          }
    TOTAL_GOLD = TOTAL_GOLD + msg.gold
    if not msg.attach then return end
    for _, att in ipairs(msg.attach) do
        gold = ""

Code:

MailAttachmentLogVars =
{
    ["Default"] = 
    {
        ["@ziggr"] = 
        {
            ["$AccountWide"] = 
            {
                ["version"] = 1,
                ["history"] = 
                {
                    [1] = 
                    {
                        ["body"] = "An item you listed has sold. (|H0:item:56038:25:4:0:0:0:0:0:0:0:0:0:0:0:0:7:1:0:0:10000:0|h|h)\n\nAttached is your profit, after deductions.",
                        ["ts"] = 1458942773,
                        ["mail_id_s"] = "2.3347013448636e-315",
                        ["from"] = "Guild Store",
HERE -->                ["gold"] = 6231,
                        ["mail_id"] = 0.0000000000,
                        ["attach_ct"] = 0,
                        ["subject"] = "Item Sold",
                    },
                },
            },
        },
    },
}

Last edited by ziggr : 06/12/19 at 10:28 AM.

06/12/19, 04:58 AM
Rushinator Forum posts: 0 File comments: 34 Uploads: 0	Hi, if possible please update this addon to also log gold deposits. I know its been discontinued but with ZOS disabling Guild History (for who knows how long), all donations now have to be done through the mail & this is the only addon that I know of that can handle it. It's just missing the ability to log gold. If this is a limitation of the api then I guess nothing can be done. Have a great week and thank you for creating this addons in the first place!

01/30/18, 07:22 AM
Rushinator Forum posts: 0 File comments: 34 Uploads: 0	Discontinued? This is one of my most used addons for guild management. Use it all the time to easily log all the donation mails I get. Did something happen with APIs or something? If possible I hope you can reconsider dropping it but if you have too then thank you anyway for the wonderful addon for as long as it has lasted. Its made my guildwork so much easier. Last edited by Rushinator : 01/30/18 at 09:28 AM.

07/12/17, 01:01 PM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Originally Posted by wolfstar

There have been a lot of changes this year to the base game. Will there be an update? It would be useful to log who sent the items and how many of each (didn't notice that in the screenshot).

MailAttachmentLog 2.6.2 continues to work well. I know of no game changes to mail or mail attachments that require a change to MailAttachmentLog.

MailAttachmentLog 2.6.2 does indeed include item counts in its CSV output file. I did not bother to update the screenshot when I added that column.

I've updated the screenshot to show the "ct" column:

07/11/17, 09:27 PM
wolfstar Forum posts: 0 File comments: 256 Uploads: 0	There have been a lot of changes this year to the base game. Will there be an update? It would be useful to log who sent the items and how many of each (didn't notice that in the screenshot).

01/19/17, 10:26 PM

Rushinator

Forum posts: 0

File comments: 34

Uploads: 0

Originally Posted by ziggr

Originally Posted by Rushinator

Hi, so I love the idea of this addon and it's definitely something I want to use to log donations but after using it the first time it seems to have broken Master Merchant.

MailAttachmentLog only reads, not writes, Master Merchant data. So I think it unlikely that MailAttachmentLog somehow scribbled over another add-on's data. More likely, the data got corrupted during an ESO crash or ALT+F4 exit, with ESO only partially writing a MM SavedVariables file before ending.

Sorry it happened. Usually MM can repair over the damage the next time it writes data. I'm not an expert at surgically repairing MM data if that doesn't work.

--Z

Thank you for the reply! The client didn't crash as I logged out to save the MailAttachment info but maybe logging out interrupted MM? IDK. My MM database was at 500k+ so maybe it just got too big?

Unfortunately the MM database has gone poof. It's rebuilt the last 10 days from the guild history so it's more of an annoyance than anything as thanks to Guild Sales Quota I already have the last 3 weeks of data exported that I can use (thank you =D) for guild management. I also have my laptop's MM history that I can use as well.

Anyways I just wanted to let you know in case you had any thoughts on it. In the future I'm just going to remember to backup my MM files weekly, haha.

01/19/17, 07:29 PM

ziggr

Forum posts: 27

File comments: 275

Uploads: 10

Originally Posted by Rushinator

Hi, so I love the idea of this addon and it's definitely something I want to use to log donations but after using it the first time it seems to have broken Master Merchant.

01/19/17, 07:53 AM
Rushinator Forum posts: 0 File comments: 34 Uploads: 0	Hi, so I love the idea of this addon and it's definitely something I want to use to log donations but after using it the first time it seems to have broken Master Merchant. After logging back in (after logging out to save the file) I got the errors below. Since they are MM errors I don't know if you'll be able to help but at the very least I just want to let you know there may be an issue. Thank you for the awesome addon! user:/AddOns/MasterMerchant/MasterMerchant_Guild.lua:206: operator < is not supported for number < string stack traceback: user:/AddOns/MasterMerchant/MasterMerchant_Guild.lua:206: in function 'MMGuild:addSaleByDate' user:/AddOns/MasterMerchant/MasterMerchant.lua:3001: in function 'MasterMerchant:InitPurchaseHistory' user:/AddOns/MasterMerchant/MasterMerchant.lua:2599: in function 'Queue' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:37: in function 'LEQ:Next' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:44: in function 'func' EsoUI/Libraries/Globals/globalapi.lua:194: in function '(anonymous)' user:/AddOns/MasterMerchant/MasterMerchant_Guild.lua:206: operator < is not supported for number < string stack traceback: user:/AddOns/MasterMerchant/MasterMerchant_Guild.lua:206: in function 'MMGuild:addSaleByDate' user:/AddOns/MasterMerchant/MasterMerchant.lua:2977: in function 'MasterMerchant:InitSalesHistory' user:/AddOns/MasterMerchant/MasterMerchant.lua:2601: in function 'Queue' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:37: in function 'LEQ:Next' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:44: in function 'func' EsoUI/Libraries/Globals/globalapi.lua:194: in function '(anonymous)' user:/AddOns/MasterMerchant/MasterMerchant_Guild.lua:206: operator < is not supported for number < string stack traceback: user:/AddOns/MasterMerchant/MasterMerchant_Guild.lua:206: in function 'MMGuild:addSaleByDate' user:/AddOns/MasterMerchant/MasterMerchant.lua:2927: in function 'MasterMerchant:InitItemHistory' user:/AddOns/MasterMerchant/MasterMerchant.lua:2600: in function 'Queue' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:37: in function 'LEQ:Next' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:44: in function 'func' EsoUI/Libraries/Globals/globalapi.lua:194: in function '(anonymous)' user:/AddOns/MasterMerchant/MasterMerchant_Util.lua:44: operator .. is not supported for boolean .. string stack traceback: user:/AddOns/MasterMerchant/MasterMerchant_Util.lua:44: in function 'MasterMerchant.concat' user:/AddOns/MasterMerchant/MasterMerchant_Util.lua:44: in function 'MasterMerchant.concat' user:/AddOns/MasterMerchant/MasterMerchant_Util.lua:183: in function 'MasterMerchant:indexEverything' user:/AddOns/MasterMerchant/MasterMerchant_Util.lua:226: in function 'Queue' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:37: in function 'LEQ:Next' user:/AddOns/MasterMerchant/Libs/LibExecutionQueue-1.0/LibExecutionQueue-1.0.lua:44: in function 'func' EsoUI/Libraries/Globals/globalapi.lua:194: in function '(anonymous)'

04/26/16, 04:21 PM

dominoid

Forum posts: 34

File comments: 276

Uploads: 2

Re: no keybind available

Originally Posted by Delirya

Hey Zigg! I saw this and it sounds great, but I don't see an option to set a keybinding in controls. I've tried reinstalling with no luck. I would reeeeally love this to work!

It's simply the folder name. Change "MailAttachmentLog 2.3.7.2" to simply "MailAttachmentLog".

04/14/16, 09:17 AM
Delirya Forum posts: 0 File comments: 17 Uploads: 0	no keybind available Hey Zigg! I saw this and it sounds great, but I don't see an option to set a keybinding in controls. I've tried reinstalling with no luck. I would reeeeally love this to work!

Report this File