Quantcast
Download
(26 Kb)
Download
Updated: 08/03/20 10:11 AM
Pictures
File Info
Compatibility:
Stonethorn (6.1.0)
Greymoor (6.0.5)
Harrowstorm (5.3.4)
Dragonhold (5.2.5)
Scalebreaker (5.1.5)
Elsweyr (5.0.5)
Updated:08/03/20 10:11 AM
Created:07/25/20 01:53 PM
Monthly downloads:192
Total downloads:193
Favorites:3
MD5:
Categories:Bags, Bank, Inventory, Data Mods
6.0.5
CraftBagger
Version: 1.06.02
by: Cuhlen [More]
CraftBagger


The CraftBagger addon is an Elder Scrolls Online utility with a singular purpose: To export the contents of your craftbag(s) to disk so that the data can be pulled into Excel or other tools for analysis.

NOTE: This was designed for Windows PCs, though if your computer can run Powershell, it should work as well. (Powershell is available for MAC and Linux). If you DO get this to work on a mac or linux machine, please let me know!

As a crafter in Elder Scrolls Online, I am always looking for resources. I have target amounts of things that I wish to manufacture in order to meet whatever profit goal I currently have, and determining how many resources I need is a monumental effort to do manually. This is why this addon was created. Instead of manually picking through my craft bag in game and keeping track in excel of how many of each item I have and what their cost is, with CraftBagger, I can export that data and then easily import it into Excel.

CraftBagger has two components; the lua based addon code which will cause Elder Scrolls Online to dump your craft bag contents (across all accounts) to a 'saved variables' file. The second component is a command line based powershell script that will parse the non-standard output of the saved variables .lua file and save the contents as .CSV files (one per account).

Elder Scrolls Online does not allow addons to create their own files, so CraftBagger is unable to export your craft bag contents directly to CSV. Because of this, using CraftBagger is a multi-step process:

  • enter the command /savecraftbag from the in-game chat window.
    This will dump your craft bag to a saved variable.
  • enter the command /reloadui, or simply logout (or wait up to 3 minutes).
    This will cause Elder Scrolls Online to save the 'saved variables' to disk.
  • execute the batch file 'run.cmd' from your AddOns\CraftBagger folder, located in %HOMEDRIVE%%HOMEPATH%\Documents\Elder Scrolls Online\live\AddOns\CraftBagger
This will create a CraftBagger-{AccountName}.csv file in this folder. You can then import that CSV file into excel or your spreadsheet software of choice. (It will create one file per account, assuming each account has contents in the craftbag)

If you have the library 'LibPrice' installed, then the csv file will contain 'suggested price' information, pulled from which ever pricing addon you use (Master Merchant, Tamriel Trade Center, Arkadius Trade Tools, etc).


Windows Help
Windows sometimes knows when you download a file from the internet and sets a security flag on the file to block it from being executed. If you get a warning about running files from the internet, you may have to unblock the .ps1 and .cmd files. To do so, from windows explorer right click on the CraftBaggerCSVExport.ps1 script and select 'properties', then check the 'Unblock' box in the bottom 'security' section of the dialog. Do the same for the run.cmd file.



Windows should stop blocking you from executing the script now.

Creating a Desktop Shortcut
Unfortunately, Windows does not support easily 'pinning' a batch file (.cmd or .bat) to your start menu or taskbar. However, there is a workaround that will allow you to create a desktop shortcut to running the run.cmd file.

Step 1: Right-click on an empty space on your desktop, select 'New', and then click on 'Shortcut'


Step 2: Enter the following text:
cmd /c "%HOMEDRIVE%%HOMEPATH%\Documents\Elder Scrolls Online\live\AddOns\CraftBagger\run.cmd"



Step 3: Give the shortcut a name and click on 'finish'


This will put an icon on your desktop so now all you have to do is click on the icon to refresh the CSV.
1.03 first release
1.04 updated manifest file to fix minion issue
1.05 still trying to get minion to see it - changing category
1.06 updated the run.cmd script to work properly when ran as a shortcut
1.06.02 updated run.cmd script to include homepath
Optional Files (0)


Archived Files (4)
File Name
Version
Size
Uploader
Date
1.06
26kB
Cuhlen
07/28/20 02:18 PM
1.05
26kB
Cuhlen
07/27/20 04:07 PM
1.04
26kB
Cuhlen
07/27/20 02:18 PM
1.03
24kB
Cuhlen
07/27/20 05:27 AM


Post A Reply Comment Options
Unread Yesterday, 11:56 AM  
Kayrne

Forum posts: 0
File comments: 2
Uploads: 0
Originally Posted by Cuhlen
Originally Posted by Kayrne
Hi,

great addon and i was looking for this kind of addon for a long time!

I have a simple request or question for your addon:
Is it possible to add the date and time code to the .csv?
So the .csv would not be overwritten

Thank you very much

greetings
I can look into making that an option. For my use, I like binding it as a data source in excel, which would not work if the file name was different with every export, but sure.. i'll look into it.
Ok Interesting. What do you do in excel with this data?

Right now I want to you use your addon to create a statistic of needed ressources for doing crafting dailies. So therefore I wanted to have different files but ofc I can save them manually.
So if it makes too much trouble it is no problem
Report comment to moderator  
Reply With Quote
Unread Yesterday, 06:56 PM  
Cuhlen
AddOn Author - Click to view AddOns

Forum posts: 4
File comments: 3
Uploads: 1
Originally Posted by Kayrne
Hi,

great addon and i was looking for this kind of addon for a long time!

I have a simple request or question for your addon:
Is it possible to add the date and time code to the .csv?
So the .csv would not be overwritten

Thank you very much

greetings
I can look into making that an option. For my use, I like binding it as a data source in excel, which would not work if the file name was different with every export, but sure.. i'll look into it.
Report comment to moderator  
Reply With Quote
Unread 08/11/20, 02:07 PM  
Kayrne

Forum posts: 0
File comments: 2
Uploads: 0
Hi,

great addon and i was looking for this kind of addon for a long time!

I have a simple request or question for your addon:
Is it possible to add the date and time code to the .csv?
So the .csv would not be overwritten

Thank you very much

greetings
Report comment to moderator  
Reply With Quote
Unread 08/09/20, 11:09 AM  
Cuhlen
AddOn Author - Click to view AddOns

Forum posts: 4
File comments: 3
Uploads: 1
Prices

I'm having some issues with the prices returned from LibPrice. Some things are coming back much much too high and way out of alignment with ATT or TTC average prices.

I'm considering changing the call I make to LibPrice to only return data from Tamriel Trade Center.

In my early experimenting though, the results I'm getting back from even TTC (through libprice) are not the same prices you can get from the ttc website. Certainly too high in some situations, but not by a huge amount. I'm thinking that TTC addon data is maybe a day old. Anyway, still looking at it.

Open to any thoughts/considerations.
Report comment to moderator  
Reply With Quote
Unread 07/28/20, 06:39 PM  
Akopian Atrebates

Forum posts: 6
File comments: 164
Uploads: 0
That is a great starting place though. Thanks! Now I have something to dig into.


Originally Posted by Cuhlen
All mods save their data to something called a 'saved variables' lua file. ATT saves multiple files containing sales data for the entire guild(s) that you belong to.

Essentially, these files are just lua 'tables' that have been saved to disk. Probably the easiest way to read in this data, manipulate it, and then save it out to excel will be to use lua.

A quick google search leads to some of the same links I reviewed for this addon.

https://stackoverflow.com/questions/...ing-with-excel

this author has a quick lua script to write any lua table to csv
http://nocurve.com/2014/03/05/simple...ite-using-lua/

basically;

Code:
function write(path, data, sep)
    sep = sep or ','
    local file = assert(io.open(path, "w"))
    for i=1,#data do
        for j=1,#data[i] do
            if j>1 then file:write(sep) end
            file:write(data[i][j])
        end
        file:write('\n')
    end
    file:close()
end
Please note that i've not tested this code.
Report comment to moderator  
Reply With Quote
Unread 07/28/20, 06:04 PM  
Cuhlen
AddOn Author - Click to view AddOns

Forum posts: 4
File comments: 3
Uploads: 1
All mods save their data to something called a 'saved variables' lua file. ATT saves multiple files containing sales data for the entire guild(s) that you belong to.

Essentially, these files are just lua 'tables' that have been saved to disk. Probably the easiest way to read in this data, manipulate it, and then save it out to excel will be to use lua.

A quick google search leads to some of the same links I reviewed for this addon.

https://stackoverflow.com/questions/...ing-with-excel

this author has a quick lua script to write any lua table to csv
http://nocurve.com/2014/03/05/simple...ite-using-lua/

basically;

Code:
function write(path, data, sep)
    sep = sep or ','
    local file = assert(io.open(path, "w"))
    for i=1,#data do
        for j=1,#data[i] do
            if j>1 then file:write(sep) end
            file:write(data[i][j])
        end
        file:write('\n')
    end
    file:close()
end
Please note that i've not tested this code.
Report comment to moderator  
Reply With Quote
Unread 07/27/20, 04:51 PM  
Akopian Atrebates

Forum posts: 6
File comments: 164
Uploads: 0
Neat! Now if I could do this is a separate context . . .

Oh oh oh! This is something I have been looking for for a while. What I would like is a utility that could import data from Arkadius Trade Tool about my sales to an excel sheet. I just don't really know how to parse it all and do it properly. Just never had to work with excel that way. As it is right now, I enter my personal data manually and getting updated data takes some time--even with a few macros thrown in there to automate some of the process. Anyway, if you cannot do that, I would LOVE if you could point me to a source where maybe I can learn how to do it.
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: