Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies| Author: | bb300511  | | Posted: | Sep 23, 2019 14:11 | | Subject: | complete minifigures | | Viewed: | 91 times | | Topic: | Inventories | | Status: | Open | |
| How can I search for complete mini-figures by price. I do not care what type
of mini figure it is, I want to purchase in bulk for a good price.
|
| Author: | Hygrotus | | Posted: | Sep 23, 2019 03:51 | | Subject: | Re: 6547 - Stickered Parts and Assembly | | Viewed: | 24 times | | Topic: | Inventories | |
| In Inventories, WilliamH writes:
| | I've added the missing stickered parts (4461pb03 and 4461pb04) and assembly
(BA13pb03) to the catalog for this set. I've no interest in learning the
complexities of adding these as alternates/counterparts, so if someone else wants
to update the inventory, please feel free to do so.
|
Done 
|
| Author: | WilliamH | | Posted: | Sep 23, 2019 03:45 | | Subject: | 6547 - Stickered Parts and Assembly | | Viewed: | 47 times | | Topic: | Inventories | | Status: | Open | |
| I've added the missing stickered parts (4461pb03 and 4461pb04) and assembly
(BA13pb03) to the catalog for this set. I've no interest in learning the
complexities of adding these as alternates/counterparts, so if someone else wants
to update the inventory, please feel free to do so.
|
 |
| Author: | Teup | | Posted: | Sep 3, 2019 13:28 | | Subject: | Re: download as XML actually saves as a TXT file | | Viewed: | 30 times | | Topic: | Inventories | |
| In Inventories, Jallington59 writes:
| | In Inventories, Teup writes:
| | In Inventories, Jallington59 writes:
| | Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.
I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.
thanks
|
XML is not a file type, it just refers to a way to structure data in plain text.
It only means that item data is placed in between tags with pointy brackets.
A file in XML formatting can have any kind of extension: txt, xls, html, ...
If you need another extension, you can just rename the file. If that doesn't
work, then probably you need something else than an XML formatted file. What
do you need it for?
|
Thank you.
I am trying to copy my inventory over to Brickowl. They ask for XML files.
I get "Lot ID" errors from every format I've used
|
Ah yes. I've written my own converter for this. But you can use Brickstock:
Brickstock can read Bricklink xml formatted files, and save them as bsx. That
bsx file should be fit for upload on BrickOwl.
|
|
| Author: | Jallington59 | | Posted: | Sep 3, 2019 13:25 | | Subject: | Re: download as XML actually saves as a TXT file | | Viewed: | 25 times | | Topic: | Inventories | |
| In Inventories, Teup writes:
| | In Inventories, Jallington59 writes:
| | Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.
I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.
thanks
|
XML is not a file type, it just refers to a way to structure data in plain text.
It only means that item data is placed in between tags with pointy brackets.
A file in XML formatting can have any kind of extension: txt, xls, html, ...
If you need another extension, you can just rename the file. If that doesn't
work, then probably you need something else than an XML formatted file. What
do you need it for?
|
Thank you.
I am trying to copy my inventory over to Brickowl. They ask for XML files.
I get "Lot ID" errors from every format I've used
|
|
| Author: | Teup | | Posted: | Sep 2, 2019 18:27 | | Subject: | Re: download as XML actually saves as a TXT file | | Viewed: | 27 times | | Topic: | Inventories | |
| In Inventories, Jallington59 writes:
| | Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.
I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.
thanks
|
XML is not a file type, it just refers to a way to structure data in plain text.
It only means that item data is placed in between tags with pointy brackets.
A file in XML formatting can have any kind of extension: txt, xls, html, ...
If you need another extension, you can just rename the file. If that doesn't
work, then probably you need something else than an XML formatted file. What
do you need it for?
|
|
| Author: | Jallington59 | | Posted: | Sep 2, 2019 17:34 | | Subject: | download as XML actually saves as a TXT file | | Viewed: | 41 times | | Topic: | Inventories | | Status: | Open | |
| Hi,
Trying to export my inventory into an xML file.
The download option offers XML as a format, but when the file saves, it is a
.txt file.
I cannot use TXT files with other sites so I need to know if there is a way to
truly pull my inventory as XML.
thanks
|
|
| Author: | LordSkylark | | Posted: | Aug 27, 2019 03:22 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 45 times | | Topic: | Inventories | |
| In Inventories, tEoS writes:
| | I like the idea of adding and inventorying these boxes (especially the ones w/o
a peek hole), though I wish it could have been done years ago. Still, as they
say, better late than never.
| | Wow, people will throw an instant tirade about any new idea we try out. It is
no wonder that the corporate BrickLink employees and developers don't want
to try anything new, either. Everything that is tried receives just whinging
and moaning from the user base. I think I now have a good idea about what drove
Jaclyn away from the site.
In any case, we have heard all of the feedback and will be reversing course on
the inventories. We had planned to make an announcement in a few days concerning
this to ask for feedback on what had been done, but we wanted stuff in place
for users to look at. So this thread was not a complete loss to us, but you did
jump the gun on us, Jonas.
Please bear with us as we work out the kinks.
Cheers,
Randy
|
|
I've glad that they not have catalog entries of their own.
The only way it will work in actually set inventories, is if there is a way to
part down parts in sets easily. If so, I think it would be good.
|
|
| Author: | SylvainLS | | Posted: | Aug 25, 2019 12:29 | | Subject: | Re: Excel | | Viewed: | 34 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | […]
| | It worked fine until point 7
Then I just got error messages.
|
=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula
|
Ah, okay, my fault: no quotes around the region.
And to get the correct values for the region, try this:
— start editing the cell by deleting the region,
— do not validate, just let the text cursor where the region will be,
— go to the page with the colour and select the area (the two columns with colours
IDs and names), the formula should now have the correct region,
— validate.
If that cell now has the correct value, then you can edit the formula again to
add the $ so you can use it in the other cells.
|
|
| Author: | paulvdb | | Posted: | Aug 25, 2019 12:28 | | Subject: | Re: Excel | | Viewed: | 28 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | In Inventories, BarbaraH writes:
| | In Inventories, SylvainLS writes:
| | In Inventories, BarbaraH writes:
| | […]
| | Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
|
For the first part:
1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).
2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.
You should now have the inventory in a table.
If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:
1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).
2. Open it from Excel like above.
Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.
3. Select and copy the first two columns (others are not needed).
4. Go back to the inventory file.
5. Create a new page (it’s cleaner) and paste the colours names and IDs.
6. Add a column in the inventory for the colour names.
7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.
8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.
9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.
Now all the items have the colour code and names.
|
| | Hope that’s clear and helping
|
It worked fine until point 7
Then I just got error messages.
|
=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula
|
Not sure if this works different in other language versions of Excel, but based
on how I work with formulas in my Dutch version of Excel I think the correct
version of that formula should be =VLOOKUP(E3;Page2!$A$3:$B$217;2;false)
The false at the end of the formula makes sure that it will only look for the
exact value in the list of colors. Otherwise it will use the nearest value if
your cell E3 has a value that's not in the list of colors.
|
|
| Author: | BarbaraH | | Posted: | Aug 25, 2019 10:37 | | Subject: | Re: Excel | | Viewed: | 32 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | In Inventories, SylvainLS writes:
| | In Inventories, BarbaraH writes:
| | […]
| | Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
|
For the first part:
1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).
2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.
You should now have the inventory in a table.
If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:
1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).
2. Open it from Excel like above.
Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.
3. Select and copy the first two columns (others are not needed).
4. Go back to the inventory file.
5. Create a new page (it’s cleaner) and paste the colours names and IDs.
6. Add a column in the inventory for the colour names.
7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.
8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.
9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.
Now all the items have the colour code and names.
|
| | Hope that’s clear and helping
|
It worked fine until point 7
Then I just got error messages.
|
=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula
|
|
| Author: | BarbaraH | | Posted: | Aug 25, 2019 10:34 | | Subject: | Re: Excel | | Viewed: | 30 times | | Topic: | Inventories | |
| In Inventories, SylvainLS writes:
| | In Inventories, BarbaraH writes:
| | […]
| | Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
|
For the first part:
1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).
2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.
You should now have the inventory in a table.
If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:
1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).
2. Open it from Excel like above.
Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.
3. Select and copy the first two columns (others are not needed).
4. Go back to the inventory file.
5. Create a new page (it’s cleaner) and paste the colours names and IDs.
6. Add a column in the inventory for the colour names.
7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.
8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.
9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.
Now all the items have the colour code and names.
|
| | Hope that’s clear and helping
|
It worked fine until point 7
Then I just got error messages.
|
|
| Author: | SylvainLS | | Posted: | Aug 24, 2019 12:27 | | Subject: | Re: Excel | | Viewed: | 41 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | […]
| | Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
|
For the first part:
1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).
2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.
You should now have the inventory in a table.
If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:
1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).
2. Open it from Excel like above.
Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.
3. Select and copy the first two columns (others are not needed).
4. Go back to the inventory file.
5. Create a new page (it’s cleaner) and paste the colours names and IDs.
6. Add a column in the inventory for the colour names.
7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.
8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.
9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.
Now all the items have the colour code and names.
Hope that’s clear and helping
|
|
| Author: | Cob | | Posted: | Aug 24, 2019 11:58 | | Subject: | Re: Excel | | Viewed: | 28 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | Is there a way of downloading an inventory of a specific set as an Excel file?
|
Use BrickStock and save the file. Open the BrickStock in excel.
You will have to open as read only but can save as anything else.
|
|
| Author: | BarbaraH | | Posted: | Aug 24, 2019 10:30 | | Subject: | Re: Excel | | Viewed: | 44 times | | Topic: | Inventories | |
| In Inventories, SylvainLS writes:
| | In Inventories, paulvdb writes:
| | In Inventories, BarbaraH writes:
| | In Inventories, BarbaraH writes:
| | Is there a way of downloading an inventory of a specific set as an Excel file?
|
The two file options in the download tab are not Excel
|
You can open the tab-delimited text file in Excel and save it as an Excel file.
|
Actually, you could also import the XML version but the tab-delimited file contains
the items current names 
Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
|
|
| Author: | SylvainLS | | Posted: | Aug 24, 2019 10:18 | | Subject: | Re: Excel | | Viewed: | 41 times | | Topic: | Inventories | |
| In Inventories, paulvdb writes:
| | In Inventories, BarbaraH writes:
| | In Inventories, BarbaraH writes:
| | Is there a way of downloading an inventory of a specific set as an Excel file?
|
The two file options in the download tab are not Excel
|
You can open the tab-delimited text file in Excel and save it as an Excel file.
|
Actually, you could also import the XML version but the tab-delimited file contains
the items current names
Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
|
| Author: | paulvdb | | Posted: | Aug 24, 2019 09:23 | | Subject: | Re: Excel | | Viewed: | 38 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | In Inventories, BarbaraH writes:
| | Is there a way of downloading an inventory of a specific set as an Excel file?
|
The two file options in the download tab are not Excel
|
You can open the tab-delimited text file in Excel and save it as an Excel file.
|
| Author: | BarbaraH | | Posted: | Aug 24, 2019 09:20 | | Subject: | Re: Excel | | Viewed: | 47 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | Is there a way of downloading an inventory of a specific set as an Excel file?
|
The two file options in the download tab are not Excel
|
| Author: | BarbaraH | | Posted: | Aug 24, 2019 05:50 | | Subject: | Excel | | Viewed: | 154 times | | Topic: | Inventories | | Status: | Open | |
| | Is there a way of downloading an inventory of a specific set as an Excel file? |
|
| Author: | TheBrickGuys | | Posted: | Aug 23, 2019 17:34 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 61 times | | Topic: | Inventories | |
| | |
Folks, if anything is going to improve in the catalog, we need to give some freedom
and grace to our admins so they can try things out. I can understand if people
get frustrated when they find something has changed and it no longer works for
them, but please understand that we have the long-term interests of the site
in mind, and also that we can adjust and/or reverse any decision that is made.
Regarding these sleeves, we have needed to add them to the catalog for quite
a while now, because of the need to search by the number printed on the sleeve.
Strictly speaking, this is not a PCC, but it's still a number people can
use for reference. Specifically, we want to give the ability to sellers to sell
the parts in the sleeves without having to open the sleeves. The only way they
can do this is to have a reference database showing the contents of every sleeve.
Because our partout system is not yet capable of handling subparts, we're
probably not going to be able to add these sleeves to the regular section of
inventories. Maybe if we change the image and description we can do it, but right
now sellers will end up listing things in their store that buyers cannot identify.
Please have patience as we make some adjustments.
|
+1
I think this is a long time coming and a darn good add to the catalog. I hate
having to open the cardboard packages to know what is inside them.
Thank you for adding them and the hard work you guys are doing in regards to
things like this! Whenever changes are made there will always be a good number
of people who will hate the changes which I can respect to a degree for there
has been changes that took me a while to get used to but as mentioned, we need
to give some latitude to the people in charge of making these changes to see
what works and what does not and give constructive criticism and not just criticism.
Jim
|
|
| Author: | axaday | | Posted: | Aug 22, 2019 23:53 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 51 times | | Topic: | Inventories | |
| In Inventories, randyf writes:
| | In Inventories, axaday writes:
| | The journey is the destination?
|
|
I finished one of yours, Majesty.
|
| Author: | randyf | | Posted: | Aug 22, 2019 13:51 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 40 times | | Topic: | Inventories | |
| In Inventories, axaday writes:
| | The journey is the destination?
|
|
| Author: | axaday | | Posted: | Aug 22, 2019 13:48 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 33 times | | Topic: | Inventories | |
| In Inventories, randyf writes:
| | In Inventories, axaday writes:
| | In Inventories, randyf writes:
| | In Inventories, axaday writes:
| | So should I start uploading these? I have quite a few.
|
Yes. You can go ahead.
|
Do we have any way of looking for which ones we lack? At this point I realize
they are EVERYWHERE, but will we be able to tell when it is done?
|
I don't think we will know when it is done or really care if it ever is.
We just want to get as much information into the database as possible and have
a resource for all those people who want to know what comes in those little cardboard
sleeves without having to open them to sell.
Cheers,
Randy
|
The journey is the destination?
|
|
| Author: | randyf | | Posted: | Aug 22, 2019 12:41 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 42 times | | Topic: | Inventories | |
| In Inventories, axaday writes:
| | In Inventories, randyf writes:
| | In Inventories, axaday writes:
| | So should I start uploading these? I have quite a few.
|
Yes. You can go ahead.
|
Do we have any way of looking for which ones we lack? At this point I realize
they are EVERYWHERE, but will we be able to tell when it is done?
|
I don't think we will know when it is done or really care if it ever is.
We just want to get as much information into the database as possible and have
a resource for all those people who want to know what comes in those little cardboard
sleeves without having to open them to sell.
Cheers,
Randy
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
