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.
 

Does anyone do CSV file dumps anymore for the database?
Author
Previous Topic Next Topic
Dawne Xi
3D Salvage and Acquisitions
#1 - 2012-02-18 00:38:56 UTC
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
Vote Steve Ronuken for CSM
#2 - 2012-02-18 01:48:14 UTC
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)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Louis Vitton
Viziam
Amarr Empire
#3 - 2012-02-18 04:16:15 UTC
Callean Drevus
Perkone
Caldari State
#4 - 2012-02-18 09:55:09 UTC  |  Edited by: Callean Drevus
Will try and see if I can do a csv dump

UPDATE: Okey, I cannot actually export as CSV, and writing a script to do it is just a bit too much trouble.

Developer/Creator of EVE Marketeer
Deamos
Hideaway Hunters
The Hideaway.
#5 - 2012-02-19 16:07:36 UTC
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
LifeHatesUsAll
#6 - 2012-03-07 10:29:31 UTC
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
#7 - 2012-03-08 07:03:36 UTC
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
Vote Steve Ronuken for CSM
#8 - 2012-03-08 12:46:08 UTC
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.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Dawne Xi
3D Salvage and Acquisitions
#9 - 2012-03-08 20:46:12 UTC
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