Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Artemis Dalvik
Science and Trade Institute Caldari State
0
|
Posted - 2014.08.18 20:35:00 -
[1] - Quote
Hey all,
Ive been looking for a tool to dump item manufacturing information from the crius db to a csv for import into a spreadsheet. Does such a tool exist? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3676
|
Posted - 2014.08.18 21:39:00 -
[2] - Quote
take a look on my site, from the SDE link.
predumped. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Artemis Dalvik
Science and Trade Institute Caldari State
0
|
Posted - 2014.08.19 14:15:00 -
[3] - Quote
I can work with this. Thanks |
Fluffy Monkei
Monkei Buisness
0
|
Posted - 2014.08.20 15:32:00 -
[4] - Quote
The csv are very hard for me to work with. Has anyone parsed them into human understandable spreadsheets? The format of the csv seems to be broken down to one line for each input for each process on each blueprint and I can't get it to show all the materials for production. |
Fjord Prefect
Imperial Academy Amarr Empire
0
|
Posted - 2014.08.22 08:20:00 -
[5] - Quote
I imported the mysql database from fuzzwork with phpmyadmin (thanks btw) works like a champ.
Took a couple tries to get it to work, kept timing out, nothing really hard. Had to adjust the settings in the .ini to make it work with 250meg+ sql file.
Now I can do all the queries I could ever want with PHP using PDO, it's a breeze. Also creating custom .CSV files with PHP is very easy.
Just wanted to toss this out there as PHP + MYSQL is pretty simple to get going especially with wampserver. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3705
|
Posted - 2014.08.22 11:43:00 -
[6] - Quote
Fluffy Monkei wrote:The csv are very hard for me to work with. Has anyone parsed them into human understandable spreadsheets? The format of the csv seems to be broken down to one line for each input for each process on each blueprint and I can't get it to show all the materials for production.
The problem is, there are 917 different materials (for manufacturing.)
That makes a spreadsheet which is pivoted very very wide. And not particularly human usable.
What you're wanting is to create a pivot table for just the things you're interested in.
You'll probably want to create an intermediate table, if this is for human consumption, filling in the typenames with a vlookup.
Drop the activity ID and the typeid/typename for the blueprint into the report filter
Drop the material type id/name into the column labels.
drop the quantity into the values, and set it to sum.
(you'll get a bunch of errors about it being too big. ignore them. Filtering it will make it work.)
Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3705
|
Posted - 2014.08.22 11:46:00 -
[7] - Quote
Fjord Prefect wrote:I imported the mysql database from fuzzwork with phpmyadmin (thanks btw) works like a champ.
Took a couple tries to get it to work, kept timing out, nothing really hard. Had to adjust the settings in the .ini to make it work with 250meg+ sql file.
Now I can do all the queries I could ever want with PHP using PDO, it's a breeze. Also creating custom .CSV files with PHP is very easy.
Just wanted to toss this out there as PHP + MYSQL is pretty simple to get going especially with wampserver.
phpmyadmin's a nasty interface
If you have direct access to the mysql server (if it's running on your machine, for example) or can create SSH tunnels to the server it's on, then HeidiSQL works reasonably.
ssh tunnels work by connecting to SSH on the server, then taking all the traffic going to a local port, and throwing it at the port on the server (or a remote server, from the server you're connected to). Works quite well, if you have SSH access. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
SJ Astralana
Syncore
61
|
Posted - 2014.08.23 04:00:00 -
[8] - Quote
It's almost to the point where Spreadsheets Online has evolved to Developers Online Hyperdrive your production business: Eve Production Manager |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3712
|
Posted - 2014.08.23 14:38:00 -
[9] - Quote
SJ Astralana wrote:It's almost to the point where Spreadsheets Online has evolved to Developers Online
Meh.
The lookups involved for the materials for industry have reduced substantially (as long as you use a converted copy, like mine) going to a single table.
Sure, the installation cost stuff is more complicated, but people have done the work for you, to make that far easier to get your hands on. (Qoi's api, Lockefox's google docs functions, my sample excel sheet)
I will say, however:
A spreadsheet isn't an appropriate tool for what most people use it for. It works, but it's not good. I'd, by far, recommend using a database for this, with a few simple scripts to handle the loading, and maybe a spreadsheet for displaying the output.
I'd recommend, if you have the time to learn, working with something like php (from XAMPP) or python to load data from the API, then drop it into a database (XAMPP comes with mysql) then maybe use the excel connector for XAMPP to get it into an excel sheet for display.
While Excel is simple to use for a one off load, it's a bit of a pain to get it working and archiving your data off. That's what databases are designed for. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Artemis Dalvik
Science and Trade Institute Caldari State
0
|
Posted - 2014.08.29 16:34:00 -
[10] - Quote
Completely agree. As someone just getting started in industry I am baffled by some of the tooling people use. Ive seen spreadsheets that require a dozen modifications just to add a new product, and extending the materials list is either a hack or a rewrite of multiple sheets. Not to mention constant GET failures from trying to query eve-central too fast in a google doc.
Eve-cost is interesting but a bit non user friendly, and its impossible to quickly get an overview of profitability on your products. IPH is non portable and crashes on my Win7 machine (not to mention its written in Visual Basic). There are so many cool things you could do with data analysis and tooling that Im just not seeing. Maybe all the good stuff is kept secret ;)
|
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |