Bricklink wanted list

Creations, construction techniques, and news from the world of plastic toys

Moderators: fredde, Dr. X, ikensall

Bricklink wanted list

Postby Apollyon » Sun Jul 13, 2014 7:04 am

Is there an easy way to ceate a .xml file for Bricklink from an Excel/OpenOffice list in order to mass upload parts to a wanted list?
If you're not into Metal you are not my friend!
User avatar
Apollyon
My Little Pony
 
Posts: 1794
Joined: Sat Jul 25, 2009 5:14 am
Location: I am in Berlin bitch!

Re: Bricklink wanted list

Postby Nimja » Sun Jul 13, 2014 8:11 am

use LDDs Bill of Materials Function?you build it, adn you get an Xcel file of the bricks used.
What Mavericks sig is missing:
Silvawards 2013 wrote:Best Noob
Nominees
-Nimja
-Maverick
Winner: Maverick

Joke of the day
User avatar
Nimja
BAHsLHASDSKJFWHEIJUSN
BAHsLHASDSKJFWHEIJUSN
 
Posts: 665
Joined: Sat Nov 09, 2013 2:48 pm
Location: Location,Location

Re: Bricklink wanted list

Postby Apollyon » Sun Jul 13, 2014 8:22 am

I don't have LDD.
What i do have is a parts list in OpenOffice and i need to convert it to .xml which i can use to create a my wanted list in Bricklink.
What i do not know is how to convert the .ods to .xml
If you're not into Metal you are not my friend!
User avatar
Apollyon
My Little Pony
 
Posts: 1794
Joined: Sat Jul 25, 2009 5:14 am
Location: I am in Berlin bitch!

Re: Bricklink wanted list

Postby Tzan » Sun Jul 13, 2014 11:42 am

User avatar
Tzan
Pooplord
 
Posts: 4935
Joined: Sun Dec 30, 2007 4:41 pm
Location: Boston

Re: Bricklink wanted list

Postby Apollyon » Sun Jul 13, 2014 12:22 pm

Thanks, i did that as well. I wonder why this is so complicated. I could try to use a tool i just downloaded but it seems to be easier to enter all 307 entries manually rather than learning how to create a xml file.
If you're not into Metal you are not my friend!
User avatar
Apollyon
My Little Pony
 
Posts: 1794
Joined: Sat Jul 25, 2009 5:14 am
Location: I am in Berlin bitch!

Re: Bricklink wanted list

Postby Tzan » Sun Jul 13, 2014 1:36 pm

Let me read that for you.

Uhm, dude the top answer is Zamzar, they do that conversion for free.
User avatar
Tzan
Pooplord
 
Posts: 4935
Joined: Sun Dec 30, 2007 4:41 pm
Location: Boston

Re: Bricklink wanted list

Postby Apollyon » Sun Jul 13, 2014 7:24 pm

Uhm, that was the fist link that came up in my search as well but i thought it was a scam, i.e. accepting the terms means i have to pay an insane amount of money hidden somewhere int he tos.
If you're not into Metal you are not my friend!
User avatar
Apollyon
My Little Pony
 
Posts: 1794
Joined: Sat Jul 25, 2009 5:14 am
Location: I am in Berlin bitch!

Re: Bricklink wanted list

Postby Tzan » Sun Jul 13, 2014 7:39 pm

User avatar
Tzan
Pooplord
 
Posts: 4935
Joined: Sun Dec 30, 2007 4:41 pm
Location: Boston

Re: Bricklink wanted list

Postby Gungnir » Mon Jul 14, 2014 1:34 am

I just look up the parts and bookmark the pages.
Give a minifig an inch, and he'll murder for a mile.
User avatar
Gungnir
Dimmy
 
Posts: 710
Joined: Wed Jul 14, 2010 3:01 am

Re: Bricklink wanted list

Postby Zupponn » Mon Jul 14, 2014 2:25 am

Image
User avatar
Zupponn
Lovable and funny
Lovable and funny
 
Posts: 5617
Joined: Mon Mar 21, 2011 6:15 pm
Location: Wisconsin, land of the cheese

Re: Bricklink wanted list

Postby Tzan » Mon Jul 14, 2014 10:17 am

I like pizza and being right!

52,000 tweets in 2 years :shock:
User avatar
Tzan
Pooplord
 
Posts: 4935
Joined: Sun Dec 30, 2007 4:41 pm
Location: Boston

Re: Bricklink wanted list

Postby Apollyon » Mon Jul 14, 2014 11:19 am

The link works btw but the resulting file needs to be heavily edited. Best skip the xml part as i had already thought.
If you're not into Metal you are not my friend!
User avatar
Apollyon
My Little Pony
 
Posts: 1794
Joined: Sat Jul 25, 2009 5:14 am
Location: I am in Berlin bitch!

Re: Bricklink wanted list

Postby Tzan » Mon Jul 14, 2014 12:11 pm

So Zamzar worked? cool.

Did the xml not work because it didnt fit in with Briklink, or was the file just a mess in general?
User avatar
Tzan
Pooplord
 
Posts: 4935
Joined: Sun Dec 30, 2007 4:41 pm
Location: Boston

Re: Bricklink wanted list

Postby Apollyon » Mon Jul 14, 2014 12:54 pm

Tzan wrote:So Zamzar worked? cool.

Did the xml not work because it didnt fit in with Briklink, or was the file just a mess in general?


The output is nice but it does not fit with Bricklink. What it wants is this:

Code: Select all
<INVENTORY>
    <ITEM>
        <ITEMTYPE>P</ITEMTYPE>
        <ITEMID>3622</ITEMID>
        <COLOR>11</COLOR>
    </ITEM>
    <ITEM>
        <ITEMTYPE>P</ITEMTYPE>
        <ITEMID>3039</ITEMID>
    </ITEM>
   
</INVENTORY>


And what i get from Zamzar looks like this:

Code: Select all
<Records>
  <Record>
    <Row
      A="ITEMTYPE"
      B="ITEMID"
      C="COLOR"
      D="MINQTY"
      E="NOTIFY"
    />
  </Record>
  <Record>
    <Row
      A="P"
      B="3957"
      C="Dark Bluish Gray"
      D="1"
      E="N"
    />
  </Record>
  <Record>
    <Row
      A="P"
      B="3612"
      C="Black"
      D="20"
      E="N"
    />
  </Record>
  <Record>
    <Row
      A="P"
      B="6048"
      C="Black"
      D="10"
      E="N"
    />
  </Record>
If you're not into Metal you are not my friend!
User avatar
Apollyon
My Little Pony
 
Posts: 1794
Joined: Sat Jul 25, 2009 5:14 am
Location: I am in Berlin bitch!

Re: Bricklink wanted list

Postby Tzan » Mon Jul 14, 2014 9:01 pm

Let me congratulate you for trying... for you.
User avatar
Tzan
Pooplord
 
Posts: 4935
Joined: Sun Dec 30, 2007 4:41 pm
Location: Boston

Next

Return to Bricks

Who is online

Users browsing this forum: No registered users and 3 guests