How to Download a Set List

Borgata

I've this little request, I hope it is licit!

I'd like to gather LEGO set's data from brickset's database, obtaining a text file that contains the following data:
- Theme / Subtheme(s)
- Set number
- Set name
- Release Year

Example (tab-delimited):

Category Name Number Name Year Released
Castle > Knights Kingdom II 8781-1 The Castle of Morcia 2004
Bionicle > Rahaga 4869-1 Rahaga Pouks 2005
City > Police 7235-1 Police Motorcycle 2005
...

Is it possible to obtain this list?

Joseph

I'm not very good with these kinds of things, so I may be way off; but you might want to take a look at: http://www.brickset.com/webservices/

Borgata

I already took a look, but I hoped in something that don't requires to make a software to use it (or didn't I understood well?).
I hoped in something like a download page, or something similar.

PS: could someone fix the error in the title of the topic? I don't find the way to do that!

Borgata

No one has any suggestion for my problem?

Or perhaps is it impossible to obtain what I need?

The_Iveys

Borgata, you may have to ask the admin for this. I can get the data you want (not the format, and some extraneous info - but generally your data) using the Advanced Queries interface under "More...". There is no way to export the data, though. What you need (I think) is an admin to run this query for you:

SELECT Theme, Subtheme, Number, SetName, YearFrom FROM SETS
WHERE (Theme IS NOT NULL) AND (Subtheme IS NOT NULL) AND (Number IS NOT NULL) AND (SetName IS NOT NULL) AND (YearFrom IS NOT NULL)
ORDER BY Theme ASC, Subtheme ASC

and export the data back out to you.

If you want to see the query I designed, it's here: http://www.brickset.com/search/advanced/run/?q=1268

Good luck!

The_Iveys

Huw

You can currently download the database at http://www.brickset.com/export/all but that won't be available after the new site launches as I want to encourage use of the web services.

aceadon1

Is it still possible to get an export of the database to something like .csv? I've tried the above link but nothing seems to happen.

Thanks!

Huw

The API is the preferred method of getting the data now.