Comprehensive card lists by set

[sunshine]

Does anyone know where I could find card lists for every set in a nice excel spreadsheet or tab delimited text file (or in some other easily imported format)?

The end goal is to import the files into a database as a sort of master list, any help would be appreciated.

[Illissius]

You can get the whole Oracle as a text file somewhere; I can't remember where, but probably either gatherer or crystalkeep or the DCI's page. It's not CSV but written out line-by-line in a similar way as people do on forums etc. so you'll probably need some custom logic to parse it (especially things like split cards and flipping cards).

[Ebinsugewa]

Does anyone know where I could find card lists for every set in a nice excel spreadsheet or tab delimited text file (or in some other easily imported format)?

The end goal is to import the files into a database as a sort of master list, any help would be appreciated.

Can't you export MWS' library in this manner?

[sunshine]

Can't you export MWS' library in this manner?

You can't export the entire MWS library, well you could in theory but the program crashes if you try to export too many cards at once (more than 150 or something like that, and doing it 150 cards at a time didn't seem too appealing to me). I should preface this by saying I have a Mac as my primary workstation and run MWS on a netbook - so I'm limited to only 1gb of ram there.


You can get the whole Oracle as a text file somewhere; I can't remember where, but probably either gatherer or crystalkeep or the DCI's page. It's not CSV but written out line-by-line in a similar way as people do on forums etc. so you'll probably need some custom logic to parse it (especially things like split cards and flipping cards).

That would be perfect, let me know if you (or anyone else) recall's where to grab this from. I poked around a little bit at the places you mentioned before writing the OP and nothing of this sort jumped out at me.

Also, I have looked at the MWS .base files and they're mostly a garbled mess that would be too much trouble for me to parse through.

[MattH]

http://www.yawgatog.com/resources/oracle/

Doesn't cover Zendikar though.

[sunshine]

Sweet, that should be a big help. I don't even need the oracle texts, really just name and set, it should be easy to parse that info out though. I want to eventually import the information to a mySQL database with as little pre-processing as possible, so this is a nice step forward. Thanks a lot!

[4eak]

I think Yawgatog's textfiles seem painful to parse. Or am I just slow?

If you complete that database, please let me know. I want a copy.

Otherwise, I'll bot out a gatherer-crawling bot to parse out the data we need. We might want that just to handle updates and new card sets.




peace,
4eak

[sklay]

Actually, you can export the MWS data base, but you need another small program to do so.

Search for "cdsExplorer" and "midas.dll" in your favourite search engine.

1. Copy the Master.mwBase and rename it to something.cds.
2. Run "cdsExplorer" and create a new file (Ctrl+N).
3. Open your MasterBase CDS file.
4. You can play around with Filters etc. to filter the data you need.
5. Select all (Ctrl+A) (or parts of the data). Right click and "Save selection as".

Most of the time the Microsoft Excel format gives better results than CSV.

[Edit] You could skip step 4, export it to the Excel format and filter in your favourite spreadsheet program. That's probably better. Finally, your spreadsheet program should export the file to SQL or (clean) CSV.

[Illissius]

What do you need it for?