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

csv to bricklink xml

ModeltrainmanModeltrainman In the Disney Infinity Toybox, Windows, or digging through LEGO parts in the USA.Member Posts: 270
My friend found some Brickheadz that he wanted to build, but the parts list is in CSV. How does one convert that to Bricklink's XML, they use, with their custom tags?

Comments

  • aapaap GermanyMember Posts: 7

    Can You show an example of a CSV? If it is from rebrickable.com, it would look like this:

    Part,Color,Quantity
    11476,19,2
    11477,25,2
    ...

    Then would be the easiest way finding the Brickheadz on their site and use Export parts -> Bricklink XML. A corresponding XML would look like this:

    <INVENTORY>
    <ITEM><ITEMTYPE>P</ITEMTYPE><ITEMID>11476</ITEMID><COLOR>2</COLOR><MINQTY>2</MINQTY></ITEM>
    <ITEM><ITEMTYPE>P</ITEMTYPE><ITEMID>11477</ITEMID><COLOR>4</COLOR><MINQTY>2</MINQTY></ITEM>
    ...
    </INVENTORY>

    This format could You generate in a text editor or a spreadsheet like Excel, the Problems are the different color number lists and part number lists (minor differences for printed parts or part variations) that are used.

    I've written a program to generate a readable csv from the Rebrickable CSV Export fro my paperless set inventories.
    Contact me if You need further assistance.

    Greetings Andreas

  • ModeltrainmanModeltrainman In the Disney Infinity Toybox, Windows, or digging through LEGO parts in the USA.Member Posts: 270
    1211 6058177 11211 Brick, Modified 1 x 2 with Studs on 1 Side 1 15 White Solid Colors 1 0.83
    11476 6186049 11476 Plate, Modified 1 x 2 with Clip Horizontal on Side 68 484 Dark Orange Solid Colors 4 0.448
    11477 6186009 11477 Slope, Curved 2 x 1 No Studs 68 484 Dark Orange Solid Colors 6 0.306
    15068 6104344 15068 Slope, Curved 2 x 2 No Studs 68 484 Dark Orange Solid Colors 15 0.552
    15573 6051511 15573 Plate, Modified 1 x 2 with 1 Stud with Groove and Bottom Stud Holder (Jumper) 1 15 White Solid Colors 2 0.296
    22885 6123809 22885 Brick, Modified 1 x 2 x 1 2/3 with Studs on 1 Side 86 71 Light Bluish Gray Solid Colors 19 1.257
    2420 4603737 2420 Plate 2 x 2 Corner 68 484 Dark Orange Solid Colors 5 0
    24201 6172927 24201 Slope, Curved 2 x 1 Inverted 1 15 White Solid Colors 4 0.361
    2431 243126 2431 Tile 1 x 4 11 0 Black Solid Colors 2 0.52
    2431 6074893 2431 Tile 1 x 4 68 484 Dark Orange Solid Colors 2 0.52
    25269 6172383 25269 Tile, Round 1 x 1 Quarter 11 0 Black Solid Colors 1 0.106
    25269 6172366 25269 Tile, Round 1 x 1 Quarter 1 15 White Solid Colors 6 0.106
    25269 6145570 25269 Tile, Round 1 x 1 Quarter 2 19 Tan Solid Colors 12 0.106
    25269 6170390 25269 Tile, Round 1 x 1 Quarter 5 4 Red Solid Colors 3 0.106
    25269 6149677 25269 Tile, Round 1 x 1 Quarter 88 70 Reddish Brown Solid Colors 2 0.106
    26604 6223225 26604 Brick, Modified 1 x 1 with Studs on 2 Sides, Adjacent 48 378 Sand Green Solid Colors 4 0.442
    3003 300328 3003 Brick 2 x 2 6 2 Green Solid Colors 3 1.151
    3003 4550359 3003 Brick 2 x 2 104 29 Bright Pink Solid Colors 2 1.154
    3004 4109995 3004 Brick 1 x 2 2 19 Tan Solid Colors 2 0.792
    3005 300521 3005 Brick 1 x 1 5 4 Red Solid Colors 2 0.425
    3010 4211225 3010 Brick 1 x 4 88 70 Reddish Brown Solid Colors 2 1.585
    3020 4535928 3020 Plate 2 x 4 68 484 Dark Orange Solid Colors 2 1.16
    3020 4114309 3020 Plate 2 x 4 2 19 Tan Solid Colors 2 1.16
    3020 302021 3020 Plate 2 x 4 5 4 Red Solid Colors 1 1.137
    3020 4211186 3020 Plate 2 x 4 88 70 Reddish Brown Solid Colors 1 1.16
    3021 302121 3021 Plate 2 x 3 5 4 Red Solid Colors 2 0.864
    3021 4211189 3021 Plate 2 x 3 88 70 Reddish Brown Solid Colors 2 0.864
    3021 6224275 3021 Plate 2 x 3 68 484 Dark Orange Solid Colors 5 0.864
    3022 4615606 3022 Plate 2 x 2 68 484 Dark Orange Solid Colors 2 0.601
    3022 4216695 3022 Plate 2 x 2 88 70 Reddish Brown Solid Colors 2 0.599
    3022 302228 3022 Plate 2 x 2 6 2 Green Solid Colors 2 0.606
    3022 4114084 3022 Plate 2 x 2 2 19 Tan Solid Colors 2 0.612
    3022 302221 3022 Plate 2 x 2 5 4 Red Solid Colors 4 0.59
    3023 302301 3023 Plate 1 x 2 1 15 White Solid Colors 1 0.339
    3023 302321 3023 Plate 1 x 2 5 4 Red Solid Colors 1 0.338
    3023 4570877 3023 Plate 1 x 2 68 484 Dark Orange Solid Colors 16 0.338
    3023 4113917 3023 Plate 1 x 2 2 19 Tan Solid Colors 5 0.335
    3023 4211063 3023 Plate 1 x 2 85 72 Dark Bluish Gray Solid Colors 2 0.335
    3024 4210719 3024 Plate 1 x 1 85 72 Dark Bluish Gray Solid Colors 8 0.18
    3024 6186012 3024 Plate 1 x 1 68 484 Dark Orange Solid Colors 9 0.18
    3024 4221744 3024 Plate 1 x 1 88 70 Reddish Brown Solid Colors 2 0.179
    3024 302423 3024 Plate 1 x 1 7 1 Blue Solid Colors 8 0.18
    3024 302421 3024 Plate 1 x 1 5 4 Red Solid Colors 2 0.175
    30414 4143254 30414 Brick, Modified 1 x 4 with 4 Studs on 1 Side 1 15 White Solid Colors 2 1.618
    3045  3045 Slope 45 2 x 2 Double Convex 69 28 Dark Tan Solid Colors 4 0.9
    30565 4570451 30565 Plate, Round Corner 4 x 4 69 28 Dark Tan Solid Colors 4 1.7
    3068b 4507045 3068b Tile 2 x 2 with Groove 69 28 Dark Tan Solid Colors 1 0.477
    3069b 4614158 3069b Tile 1 x 2 with Groove 68 484 Dark Orange Solid Colors 2 0.255
    3069b 306921 3069b Tile 1 x 2 with Groove 5 4 Red Solid Colors 2 0.255
    3069b 4211151 3069b Tile 1 x 2 with Groove 88 70 Reddish Brown Solid Colors 2 0.253
    3069b 306926 3069b Tile 1 x 2 with Groove 11 0 Black Solid Colors 2 0.254
    32028 4249563 32028 Plate, Modified 1 x 2 with Door Rail 1 15 White Solid Colors 4 0.449
    32028 4612575 32028 Plate, Modified 1 x 2 with Door Rail 5 4 Red Solid Colors 4 0.45
    32028  32028 Plate, Modified 1 x 2 with Door Rail 68 484 Dark Orange Solid Colors 2 0.44
    36841  36841 Bracket 1 x 1 - 1 x 1 68 484 Dark Orange Solid Colors 2 0.28
    3700 370021 3700 Technic, Brick 1 x 2 with Hole 5 4 Red Solid Colors 6 0.772
    3700 4211111 3700 Technic, Brick 1 x 2 with Hole 85 72 Dark Bluish Gray Solid Colors 2 0.756

  • ModeltrainmanModeltrainman In the Disney Infinity Toybox, Windows, or digging through LEGO parts in the USA.Member Posts: 270
    My friend says the creator says that's Studio's parts list.

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.