Shopping at LEGO or Amazon?
Please use our links: LEGO.com Amazon
As an Amazon Associate we earn from qualifying purchases.

How to Download a Set List

BorgataBorgata Member Posts: 22
edited January 2013 in The Database
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?

Comments

  • JosephJoseph Member Posts: 651
    edited January 2013
    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/
  • BorgataBorgata Member Posts: 22
    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!
  • BorgataBorgata Member Posts: 22
    No one has any suggestion for my problem?

    Or perhaps is it impossible to obtain what I need?
  • The_IveysThe_Iveys USA::Florida::ValricoMember Posts: 64
    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
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,547
    edited January 2014
    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.
  • aceadon1aceadon1 Member Posts: 1
    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!
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,547
    The API is the preferred method of getting the data now.
Sign In or Register to comment.

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com Amazon

Recent discussions Categories Privacy Policy

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.