View Single Post
12/11/14, 09:04 PM   #5
dopiate
AddOn Author - Click to view addons
Join Date: Jun 2014
Posts: 142
Originally Posted by sirinsidiator View Post
If you want to do it the "right" way, you should use a lua script outside of the game to load the savevars file and export it into the required form from there.
A short search on google shows that there is a library that allows you to create excel files from lua, which should make this rather easy.
She said saved variables not using lua source to manipulate Excel, so I'm not sure that link is helpful (but I could be wrong - we didn't get much information to go on).

I have already done what she asked - it's ESO LUA savariables to csv.

An example from one sale is...

from saved variables...

Code:
                    ["SalesData"] = 
                    {
                        [45061] = 
                        {
                            ["1:0:1:12"] = 
                            {
                                ["sales"] = 
                                {
                                    [1] = 
                                    {
                                        ["buyer"] = "@FootJuice",
                                        ["wasKiosk"] = false,
                                        ["guild"] = "Black Market Traders",
                                        ["timestamp"] = 1416586399,
                                        ["seller"] = "@dOpiate",
                                        ["itemLink"] = "|H0:item:45061:30:1:0:0:0:0:0:0:0:0:0:0:0:0:3:0:0:10000:0|hiron sabatons^p|h",
                                        ["price"] = 350,
                                        ["quant"] = 1,
                                    },
                                },
                                ["itemIcon"] = "/esoui/art/icons/gear_orc_heavy_feet_a.dds",
                            },
                        },

my program produces...

Code:
Black Market Traders,iron sabatons,1,1416586399,350,@FootJuice,@dOpiate,1:0:1:12
hundreds and hundreds of times (my current database has 773 lines) - I even offered her the code.

It works flawlessly.

there are 700+ GSA users and I'm getting no complainants - and since I check and re-check for new items I have routines to weed out duplicates.

Anyway -- I guess we aren't clear on exactly what she wants until she replies.

-d
  Reply With Quote