ESOUI

ESOUI (https://www.esoui.com/forums/index.php)
-   AddOn Help/Support (https://www.esoui.com/forums/forumdisplay.php?f=164)
-   -   MM - Export Guild store sales history to CSV (https://www.esoui.com/forums/showthread.php?t=10635)

kaaylim 07/17/23 05:05 AM

MM - Export Guild store sales history to CSV
 
Hello,

Returning players after 2 years here, I need some help.

I used to export Guild stores sale history to csv with the help of PacrooTI tool:
https://esotoolset.github.io/

With the change of MM, this is no longer possible (MMdata replaced by GSdata).
I tried with the arkadius files, but there is no name of the item (only ItemID) and I need the name of items for my crazy spreadsheeds.

So I am wondering if any of you extract data from the files in order to export to csv or txt. How do you do?
If not, is there any list of correspondance for ItemID - name of item (and quality etc)???

Many thanks!

PS: also, just wondering why I cannot post directly in the comments section of Master Merchant Addon itself. It says "closed".

Sharlikran 07/17/23 06:56 AM

Normally people say post in the mods comments section but it is closed. So while usually that's not the preferred method and someone would probably mention it, your post here is totally fine, with one small exception.

The sticky post answers your question as to why you can not post in the comments section and there is a link to the documentation. Which includes an index. From which you can find a troubleshooting section should you have Lua errors.

In your case though there is a section on how to export sales data and the format. I think I will add a toggle at some point to omit the itemLink from the export because it isn't really needed for the export. The name of the item is already included and parsing the export with the itemLink there would just make it more difficult. It probably will not work with that site though.

kaaylim 07/17/23 03:05 PM

Hi,

Thanks for answering. I tried the MM export fonction, but I don't think that is what i'm looking for. It's quite hard to read, but it seems there is very few info.

The tool I linked used to provide a line for EVERY sales with buyer, seller, guild, itemlink, name, date, price, etc..
Here is an example : https://docs.google.com/spreadsheets...it?usp=sharing

(example given by Revry on ESO forum)

In Mastermerchant.lua after export I only see :

*some parameters for each of my character
* a list of seller in the guild (I guess),
*and maybe something about my sales only (but no name, just item ID, like that;
[137856] =
{
["1:0:4:0:0"] = 18500,
},

I'm not a programmer so I don't know much about lua or how to convert to csv.

Any help would be very appreciated.

Cheers,

And SHarlikran, an HUGE thank you for your addon!!!

kaaylim 07/17/23 03:13 PM

Quote:

Originally Posted by kaaylim (Post 48140)
Hi,


In Mastermerchant.lua after export I only see :

*some parameters for each of my character
* a list of seller in the guild (I guess),
*and maybe something about my sales only (but no name, just item ID, like that;
[137856] =
{
["1:0:4:0:0"] = 18500,
},

Please forgive me, I realised I did not fully read the doc and was using the wrong command (export instead of sales)
I will try and see if I can get something out of it.
Thanks!

Sharlikran 07/17/23 04:44 PM

Please do, because there is no way you will get what you are looking for trying to process the various 18 files.


All times are GMT -6. The time now is 07:16 AM.

vBulletin © 2024, Jelsoft Enterprises Ltd
© 2014 - 2022 MMOUI