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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Market monitor for any system. Spreadsheet and db issues.
Author
Previous Topic Next Topic
Haffsol
#1 - 2012-05-01 22:14:16 UTC  |  Edited by: Haffsol
I'm trying to build up my own spreadsheet to monitor items from the market. Now I'm fine with all the items entries since I downloaded the entire db. In the tutorial I used everything's related to the jita orders, so I know jita has ID=30000142

Now I'd like to add all the other main hubs (dodixie, amarr, rens) but I'd also like to check prices in any other system I am or I'm planning to go. Basically I need the ID for all the systems which are not included in the items db. After few hints and searches, I've found this: http://community.eveonline.com/community/toolkit.asp but I'm a total noob on db and I hate them pretty much as well. Anyway I installed Mysql5.5 just to find out it works from the command line and that clicking on the .sql file (or the .bak one) nothing magically happens. Great, so I installed a mysql frontend (heidisql) just to find out it asks for user and pass and I simply have no idea about which user&pass it is referring to or how to create a user and his password.

Question are 2, slightly different too:
1- how to install a db properly (mysql if possible) and how to make it parse that damn .sql file and have something "readable" (not a 6 billions line output in the shell I mean)?
2- any other way to have the systems IDs? Perhaps someone of you has a table somewhere that wants to share here?
Invictra Atreides
Toward the Terra
#2 - 2012-05-01 22:42:16 UTC
Dear Haffsol I must say I'm surprised by the effort you are doing just to get the IDs. Many would already give up after 5 min on google. But let me help you as it is easier for me because I got "Google Searching" trained to lvl 4 already.

Links:
- Station IDs
- Region IDs

I'm sorry I can't help you with your database problem, as I'm limited to only 5 google searches per day. But as a bonus I'll throw in this nice EVE API Tutorial for your Google docs spreadsheet.

Blog | Tutorials | Youtube "I don’t know everything, I just know what I know."
Haffsol
#3 - 2012-05-01 23:23:13 UTC
Oh nous! I'm notta gonna quit the fight against spreadsheets! But well I could temporary be tackled by db's P

In any case your station table looks so charming and could fit pretty well with my purposes. If it only worked :)

I'll try to explain why it's not. The line I use to import values from jita is this:
Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN("&typeid=",$A3:$A7),"/evec_api/marketstat/type/sell/min")

where usesystem=30000142 means Jita and typeid=",$A3:$A7),"/evec_api/marketstat/type/sell/min stands for "lower sell order of items from A3 to A7". Now if I try to roughly change the systemID with any other one it's just showing a nice serie of 0's so I had the great idea of changing it from "usesystem=xxxxx" into "usestation=xxxxx" and.... it shows me strange numbers, like 1 0.65 1 1 0.16 and values are the same any ID I try. Same with regions.

Also, google is not really friendly when you look for knowledge on the db. You API tuto seems very intersting and I promise I'll look into it....... after a good nap

o7
Invictra Atreides
Toward the Terra
#4 - 2012-05-01 23:50:38 UTC
Oh great Haffsol I have come yet again to aid you on your quest. Maybe this is the secret information you where looking for.





I just watched a fantasy movie, maybe thats why I just fell like writing like that ^_^ . Hope that information is more useful. Keep at it, spreadsheets and that DB are good stuff for EVE players. For some half the fun is in planing and learning than roleplaying and shooting.

Blog | Tutorials | Youtube "I don’t know everything, I just know what I know."
Haffsol
#5 - 2012-05-02 13:45:40 UTC  |  Edited by: Haffsol
allright, I've spent some time reading and checking and your tutorial is just awesome and made me undestand lots of things about queries and how cool the ImportXML() thing is. Also the last link you provided could be very fruitful. If it only worked Big smile

The link is ok but today it looks like eve-central didn't wake up yet so I cannot test a single thing.

In any case I'd say my problem is fixed, even if the original answer is still unsolved. I didn't get how to open the escalation.sql mega-file so while waiting for eve-central to wake up...... feel free to link me some other stuff :P

edit: sorta typo