| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dawne Xi
3D Salvage and Acquisitions
5
   |
Posted - 2012.02.18 00:38:00 -
[1] - Quote
I know everyone seems to using this SQL stuff and I've downloaded all the stuff suggested, and I just can't understand it at all.. I'm too used to Excel I guess and can work with CSV files..
Is anyone doing the database dumps in CSV format anymore? I know a few that used to, but they seemed to have stopped playing or stopped doing it.
I'd kill for a CSV dump of Crucible :) or for someone to show me how I can take the files anyone has linked here and just click a button and get them myself .. because really that SQL stuff is way beyond me.
Thanks in advance, be gentle and try not to laugh at me too much :) |
Steve Ronuken
Fuzzwork Enterprises
235
|
Posted - 2012.02.18 01:48:00 -
[2] - Quote
Any particular tables you're looking for?
Unfortunately, using the database needs a knowledge of SQL. It's not particularly complex. But you'd need to learn it.
Loading the dump isn't too hard, into a local mysql copy (if you download the mysql version), but then accessing it is a trifle harder.
If it's not the whole thing, drop me a reply or an eve mail, and I'll see what I can do (Tomorrow, probably)
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator and other 'useful' utilities. |
Louis Vitton
Invictus Australis
Northern Coalition.
14
|
Posted - 2012.02.18 04:16:00 -
[3] - Quote
http://w3schools.com/sql/default.asp |
Callean Drevus
Icosahedron Crafts and Shipping
Silent Infinity
100
|
Posted - 2012.02.18 09:55:00 -
[4] - Quote
Will try and see if I can do a csv dump
Developer/Creator of EVE Marketeer
|
Deamos
Caldari Provisions
Caldari State
108
|
Posted - 2012.02.19 16:07:00 -
[5] - Quote
If I remember correctly, the usually have a SQLite version of the database dump. If that is the case, use this to extract the table information and create a CSV. Much easier and you can create only the CSVs you need. |
LifeHatesMe
SKULLDOGS INDUSTRY'S
ROL.Citizens
0
|
Posted - 2012.03.07 10:29:00 -
[6] - Quote
humm, CSV is really for small files.
Eve Online database is 130mb+
The best thing I'd say is import into MySQL using a data dump program, then use phpMyAdmin to browse through the table contents :) |
Dawne Xi
3D Salvage and Acquisitions
5
|
Posted - 2012.03.08 07:03:00 -
[7] - Quote
This was the site I was using but they've stopped putting out CSV dumps .. I don't know exactly what tables I'd need but these are the files I was using..
Are these the tables just dumped out? And would that be easy enough to do?
Thanks for the replies and the link on SQL .. I'll look into messing around with it some.
http://eve.no-ip.de/dom103/dom103-excel-v1/ |
Steve Ronuken
Fuzzwork Enterprises
283
|
Posted - 2012.03.08 12:46:00 -
[8] - Quote
http://www.fuzzwork.co.uk/dump/
Dumped from the recent mysql database conversion. (DBIx::Dump's really useful. Glad I found out about it)
Dumped in xls format, as CSV doesn't handle cells with new lines too well. One zip with them all, the individual files bzip2'ed.
I'll try to remember to do it again, the next time there's a release.
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator and other 'useful' utilities. |
Dawne Xi
3D Salvage and Acquisitions
7
|
Posted - 2012.03.08 20:46:00 -
[9] - Quote
You are a life saver and I'm still going to see about this SQL stuff others linked in the thread
Thank you so much :))
Dawne |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |