These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

csv dump of jita complex reaction prices
Author
Previous Topic Next Topic
Decimat Draconia
Brutor Tribe
Minmatar Republic
#1 - 2012-01-19 00:24:19 UTC  |  Edited by: Decimat Draconia
Hi

Being a bit lazy here but I'm short on time, what I'm after is a simple dump of Jita prices for complex reactions.

It has to be in .csv format and just the cheapest sell order will suffice.

I'm writing an assignment for my students in which they will need to pull in csv file, I'm basing the assignment on T2 manufacturing and haven't got enough time to run a MSSQL server and run my own queries.

Can anyone direct me to a source.

Failing that I will have to get the server up and running and work out the query, its been a long time since I last did SQL so I'm sure I'll be making use of this thread again.

Cheers


edit: I'm going to need the price of a couple of T2 ships in the dump also, minmatar interdictor, hac's and logis should be enough

ps. It's a spreadsheet assignment I'm writing
Louis Vitton
Viziam
Amarr Empire
#2 - 2012-01-19 05:11:40 UTC
Not what you are looking for exactly but it will have it inside of it.

http://eve-central.com/home/develop.html#csv
Decimat Draconia
Brutor Tribe
Minmatar Republic
#3 - 2012-01-23 00:11:50 UTC
I have looked at this but I don't know the region, system and station id for Jita 4/4 or the type id for the advanced materials I need to filter.

Have had a quick search on Eve central but can't find the details there.
Decimat Draconia
Brutor Tribe
Minmatar Republic
#4 - 2012-01-23 00:13:42 UTC  |  Edited by: Decimat Draconia
I think I've located the meta data, thanks for your help

edit: the meta data is in .sql format so I still have some problems

2nd edit: I took a guess the station ID for Jita would be 60003760
roigon
TURN LEFT
#5 - 2012-01-23 01:56:02 UTC
I understand you need CSV because you are just trying to get some data to put in spreadsheets, however because of the mssql comment I wanted to point out that EVEDev supplies conversion dumps for mysql, postgress and lightsql. Especially lightsql is well suited for light scripts and such where you don't really want to bother with having to manage a sql server.

EVEDev also provides some wiki pages explaining the structure of the database. These are linked from the page I linked earlier.

Let me also compliment you on creating interesting assignments for your students, even if you are lazy ;)
Decimat Draconia
Brutor Tribe
Minmatar Republic
#6 - 2012-01-23 10:19:45 UTC  |  Edited by: Decimat Draconia
An excellent resource thank you very much for directing me.

I've been playing with XML but am limited to what details I can pull from eve central. I will be able to run a few queries on the database and find the component requirements for a variety of blueprint without having to store pages of data in the spreadsheet. I'll export this into a CSV file from there.

It's nice to incorporate my own interests when I write an assignment, I'm sure the students will share my enthusiasm.Idea
Decimat Draconia
Brutor Tribe
Minmatar Republic
#7 - 2012-01-23 22:15:49 UTC  |  Edited by: Decimat Draconia
Struggling with a MYSQL query at the moment:

SELECT *
FROM invTypeMaterials, invTypes
WHERE invTypeMaterials.materialTypeID = invTypes.typeID
AND invTypeMaterials.typeID =11536

I'm want to pull the details of 6 typeID in one table to export, I don't know the correct syntax for the query