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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Looking for data file source - module and trade item names
Author
Previous Topic Next Topic
Isabella BlackScholes
AnnaBelle Farms
#1 - 2012-09-08 15:54:00 UTC
Looking for a shortcut to building my excel spreadsheets for trading. Rather than input trade good names manually, I would rather just import the names of different trade items into my charts. Much easier to delete in bulk than type in thousands of item names. There are some excellent resources available online, but I have not found one that would allow a quick export in bulk.

Can anybody provide a link to such? Thanks in advance.
Lutz Major
Austriae Est Imperare Orbi Universo
#2 - 2012-09-09 19:45:59 UTC
Here is a file, that I just extracted from the data dump.
It contains all items, that have a market group associated (and are published)

http://eve-files.com/dl/257423
Isabella BlackScholes
AnnaBelle Farms
#3 - 2012-09-09 23:22:21 UTC
Thank you very much. This should prove helpful.
Huttan Funaila
Caldari Provisions
Caldari State
#4 - 2012-09-10 17:32:53 UTC
You can also get them from the static data dump from the community toolkit:
http://community.eveonline.com/community/toolkit.asp

If you need the free (called "express") version of SQL Server:
http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Two posts on working with the database from the toolkit:
http://k162space.com/2012/04/13/working-with-eve-static-data/
http://phoenixdiaries.co.uk/eve-online-database-dump
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-09-10 18:21:05 UTC
Alternatively, if you don't want to touch MS SQL, I've got conversions and extracts:

http://www.fuzzwork.co.uk/dump/

XLS/CSV and MySQL (xls is for the line break encoding) for individual tables
MySQL for the entire DB

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter