| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lacei
The Scope
   |
Posted - 2009.12.29 21:45:00 -
[1]
I am not very proficient in sql and eve-online toolkit db dumps.
What I am looking for Microsoft excel format data dump of dominion data.
Itembpo | components | minerals | etc | etc
For updating my datadump sheet for my excel production model
Any help would be greatly appreciated.
|
SK Rooster
No Trademark
|
Posted - 2009.12.30 02:25:00 -
[2]
the easiest way would probably be to download Jercy Fravowitz MySQL conversion of the Dominion MSSQL datadump from
http://eve.no-ip.de/dom103/dom103-mysql5-sql-v1/
then you can use Regular Expressions to parse the data into a format you see fit (thats what i am doing)
|
Catari Taga
Centre Of Attention
Rough Necks
|
Posted - 2009.12.30 03:43:00 -
[3]
Wouldn't it be easier to use his XML conversion since Excel can read XML?
Apart from that there are a couple of production spreadsheets around, you could just copy from those also.
|
SK Rooster
No Trademark
|
Posted - 2009.12.30 03:59:00 -
[4]
 Originally by: Catari Taga
Wouldn't it be easier to use his XML conversion since Excel can read XML?
Apart from that there are a couple of production spreadsheets around, you could just copy from those also.
except for his XML sheet will not load unless you create a Schema for it
|
Catari Taga
Centre Of Attention
Rough Necks
|
Posted - 2009.12.30 04:12:00 -
[5]
Originally by: SK Rooster
Originally by: Catari Taga
Wouldn't it be easier to use his XML conversion since Excel can read XML?
Apart from that there are a couple of production spreadsheets around, you could just copy from those also.
except for his XML sheet will not load unless you create a Schema for it
Hmm, I just tried the first table on the list and it loaded fine into my Excel 2003. Anyway it was just a suggestion, even adding a schema sounds easier to me than converting from mySQL but you do what works best for you!
|
Holick
Caldari
Solar Nexus.
OWN Alliance
|
Posted - 2009.12.31 16:16:00 -
[6]
Originally by: Catari Taga
Apart from that there are a couple of production spreadsheets around, you could just copy from those also.
I have found that the production sheets around are incorrect? Do know if there is one out there that is correct. EVEN evemeep is incorrect??
|
Lutz Major
Austriae Est Imperare Orbi Universo
|
Posted - 2010.01.01 10:30:00 -
[7]
Originally by: Holick
I have found that the production sheets around are incorrect? Do know if there is one out there that is correct. EVEN evemeep is incorrect??
Do you have any example about the incorrect behaviour? Or do you only assume they are wrong? AFAIK evemeep 3.X has the latest data dump available...
|
Holick
Caldari
Solar Nexus.
OWN Alliance
|
Posted - 2010.01.04 19:20:00 -
[8]
I compared the EveMeep 3.X lastest version to raven bpo, domi bpo, and vagabond -4/-4 bpc and the numbers were off quite a bit. not entirely material in prices but in quantity like trit was off by 750k.
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |