Discussion Forum: Catalog(Post New Message)
Redisplay Messages: Compact | Brief | All | Full      Show Messages: All | Without Replies

 Author: Stuart9 View Messages Posted By Stuart9
 Posted: Jun 24, 2020 14:44
 Subject: Re: Change Notification: Parts 4623 and 88072
 Viewed: 39 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Thanks, changes and dates noted.



In Catalog, StormChaser writes:
  NOTIFICATION OF CHANGES TO PARTS 4623 AND 88072

 
Part No: 4623  Name: Plate, Modified 1 x 2 with Bar Arm Up (Undetermined Type)
* 
4623 Plate, Modified 1 x 2 with Bar Arm Up (Undetermined Type)
Parts: Plate, Modified
[P=88072]

Members have recently identified two problems with these part variant entries:

1. The additional notes need to be updated.
2. Part 4623 comes in both 5 MM and 6 MM horizontal arm length versions.

A member has submitted a request for us to take action.

What changes will happen?
1. The title of Part 4623 currently in parentheses will be changed to
read "Undetermined Arm Length," but the part will not immediately be marked for
deletion.
2. A new catalog entry will be created with the part number 4623a and
the title "Plate, Modified 1 x 2 with Arm Up (Horizontal Arm Length 6mm)."
3. Part 88072 has 4623b as an alternate item number. The primary number
(88072) and alternate item number (4623b) will be switched for this part.
4. The additional notes for all three entries will be updated for brevity
and ease of comprehension.

When will these changes occur?
All four changes are planned to occur between the hours of 8 AM and 4 PM CST
on July 8th, 2020.

Why are these changes necessary?
The changes are necessary because Part 4623 comes in both 5 MM and 6 MM horizontal
arm lengths. The catalog does not currently recognize this fact and some inventories
include incorrect part variants.

How will these changes affect BrickLink members?
Sellers should move their for-sale listings from the undetermined entry to either
4623a or 4623b as soon as reasonably possible after the July 8th changes. Members
who object to one or more changes should immediately provide input with clear
reasons for their objections.
 Author: StormChaser View Messages Posted By StormChaser
 Posted: Jun 24, 2020 14:30
 Subject: Change Notification: Parts 4623 and 88072
 Viewed: 138 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
NOTIFICATION OF CHANGES TO PARTS 4623 AND 88072

 
Part No: 4623  Name: Plate, Modified 1 x 2 with Bar Arm Up (Undetermined Type)
* 
4623 Plate, Modified 1 x 2 with Bar Arm Up (Undetermined Type)
Parts: Plate, Modified
[P=88072]

Members have recently identified two problems with these part variant entries:

1. The additional notes need to be updated.
2. Part 4623 comes in both 5 MM and 6 MM horizontal arm length versions.

A member has submitted a request for us to take action.

What changes will happen?
1. The title of Part 4623 currently in parentheses will be changed to
read "Undetermined Arm Length," but the part will not immediately be marked for
deletion.
2. A new catalog entry will be created with the part number 4623a and
the title "Plate, Modified 1 x 2 with Arm Up (Horizontal Arm Length 6mm)."
3. Part 88072 has 4623b as an alternate item number. The primary number
(88072) and alternate item number (4623b) will be switched for this part.
4. The additional notes for all three entries will be updated for brevity
and ease of comprehension.

When will these changes occur?
All four changes are planned to occur between the hours of 8 AM and 4 PM CST
on July 8th, 2020.

Why are these changes necessary?
The changes are necessary because Part 4623 comes in both 5 MM and 6 MM horizontal
arm lengths. The catalog does not currently recognize this fact and some inventories
include incorrect part variants.

How will these changes affect BrickLink members?
Sellers should move their for-sale listings from the undetermined entry to either
4623a or 4623b as soon as reasonably possible after the July 8th changes. Members
who object to one or more changes should immediately provide input with clear
reasons for their objections.
 Author: M.Boss View Messages Posted By M.Boss
 Posted: Jun 23, 2020 22:06
 Subject: Darth Vader Head Mold Variance
 Viewed: 123 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
 
Part No: 30368  Name: Minifigure, Headgear Helmet SW Darth Vader
* 
30368 Minifigure, Headgear Helmet SW Darth Vader
Parts: Minifigure, Headgear

When comparing two Darth Vader figures I had, I discovered a mold variance between
two helmets. The "old" type came likey was made from 1999-2014, while The "new"
type appeared in the 2019 20th Anniversary Clone Scout Walker
 
Set No: 75261  Name: Clone Scout Walker – 20th Anniversary Edition
* 
75261-1 (Inv) Clone Scout Walker – 20th Anniversary Edition
198 Parts, 5 Minifigures, 2019
Sets: Star Wars: Star Wars Episode 3
I think
this new mold was created because in order to create the anniversary figure lego
wanted to use a 1 piece Vader helmet, as opposed to the 2 piece helmets they
switched to a couple of years ago. This mold variation deserves a note in the
catalog entry for the helmet,, or a variant added to the catalog, but I'm
not sure which. If someone wants to take the appropriate action from here, please
go ahead. See the attached image for the differences between the two.
 


 Author: TheBrickGuys View Messages Posted By TheBrickGuys
 Posted: Jun 23, 2020 16:41
 Subject: Re: bricklink lego piece not found
 Viewed: 34 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Crafteewon writes:
  In Catalog, foxbricks2009 writes:
  what if i have a piece that i know is lego but i can't find it in the catalog.
could we have a feature for adding your own piece? or should i just make a custom
item?
i have this 2x8 apple bush piece i can't find.

 
Part No: 6214px2  Name: Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
* 
6214px2 Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
Parts: Slope, Curved, Decorated

Not Bad, 2 Minutes!

Jim
 Author: Fox_Brickr View Messages Posted By Fox_Brickr
 Posted: Jun 23, 2020 15:42
 Subject: Re: bricklink lego piece not found
 Viewed: 36 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Cob writes:
  In Catalog, Crafteewon writes:
  In Catalog, foxbricks2009 writes:
  what if i have a piece that i know is lego but i can't find it in the catalog.
could we have a feature for adding your own piece? or should i just make a custom
item?
i have this 2x8 apple bush piece i can't find.

 
Part No: 6214px2  Name: Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
* 
6214px2 Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
Parts: Slope, Curved, Decorated

BrickLink search is very specific.

In this situation apple is incorrect, you must search for either apple* or apples

oh,i looked up apple and not apples, thank you!
 Author: Cob View Messages Posted By Cob
 Posted: Jun 23, 2020 15:39
 Subject: Re: bricklink lego piece not found
 Viewed: 26 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Crafteewon writes:
  In Catalog, foxbricks2009 writes:
  what if i have a piece that i know is lego but i can't find it in the catalog.
could we have a feature for adding your own piece? or should i just make a custom
item?
i have this 2x8 apple bush piece i can't find.

 
Part No: 6214px2  Name: Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
* 
6214px2 Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
Parts: Slope, Curved, Decorated

BrickLink search is very specific.

In this situation apple is incorrect, you must search for either apple* or apples
 Author: Fox_Brickr View Messages Posted By Fox_Brickr
 Posted: Jun 23, 2020 15:39
 Subject: Re: bricklink lego piece not found
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Crafteewon writes:
  In Catalog, foxbricks2009 writes:
  what if i have a piece that i know is lego but i can't find it in the catalog.
could we have a feature for adding your own piece? or should i just make a custom
item?
i have this 2x8 apple bush piece i can't find.

 
Part No: 6214px2  Name: Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
* 
6214px2 Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
Parts: Slope, Curved, Decorated

thank you!
 Author: Crafteewon View Messages Posted By Crafteewon
 Posted: Jun 23, 2020 15:38
 Subject: Re: bricklink lego piece not found
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, foxbricks2009 writes:
  what if i have a piece that i know is lego but i can't find it in the catalog.
could we have a feature for adding your own piece? or should i just make a custom
item?
i have this 2x8 apple bush piece i can't find.

 
Part No: 6214px2  Name: Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
* 
6214px2 Slope, Curved 8 x 2 x 4 Triple with 8 Studs with Red Apples Pattern
Parts: Slope, Curved, Decorated
 Author: Fox_Brickr View Messages Posted By Fox_Brickr
 Posted: Jun 23, 2020 15:36
 Subject: bricklink lego piece not found
 Viewed: 128 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
what if i have a piece that i know is lego but i can't find it in the catalog.
could we have a feature for adding your own piece? or should i just make a custom
item?
i have this 2x8 apple bush piece i can't find.
 




 Author: Stuart9 View Messages Posted By Stuart9
 Posted: Jun 21, 2020 18:14
 Subject: Re: Modified plate #4151
 Viewed: 41 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Tried to reply quickly and mixed up my tans.




In Catalog, iprice writes:
  In Catalog, Stuart9 writes:
  
 
Part No: 4151b  Name: Plate, Modified 8 x 8 with Grille and Hole in Center
* 
4151b Plate, Modified 8 x 8 with Grille and Hole in Center
Parts: Plate, Modified


Only supposed to be the b version found in :

 
Set No: 8107  Name: Fight for the Golden Tower
* 
8107-1 (Inv) Fight for the Golden Tower
559 Parts, 2 Minifigures, 2007
Sets: Exo-Force


Or

 
Set No: 6210  Name: Jabba's Sail Barge
* 
6210-1 (Inv) Jabba's Sail Barge
747 Parts, 8 Minifigures, 2006
Sets: Star Wars: Star Wars Episode 4/5/6


Wrong Sail Barge!
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jun 21, 2020 18:14
 Subject: Re: Modified plate #4151
 Viewed: 31 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Squeakie7 writes:
  What set uses 8 x 8 modified plate #4151 with grille in a dark tan? It is not
listed in the catalog.

You’re sure it isn’t a b (with hole)?
 
Part No: 4151b  Name: Plate, Modified 8 x 8 with Grille and Hole in Center
* 
4151b Plate, Modified 8 x 8 with Grille and Hole in Center
Parts: Plate, Modified {Dark Tan}
http://www.bricklink.com/catalogItemIn.asp?P=4151b&colorID=69&in=A

Or it could be from earlier versions of these sets and no one saw or said they
were Alternates (or rather Regular and 4151b an Alternate).
 Author: iprice View Messages Posted By iprice
 Posted: Jun 21, 2020 18:12
 Subject: Re: Modified plate #4151
 Viewed: 30 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Stuart9 writes:
  
 
Part No: 4151b  Name: Plate, Modified 8 x 8 with Grille and Hole in Center
* 
4151b Plate, Modified 8 x 8 with Grille and Hole in Center
Parts: Plate, Modified


Only supposed to be the b version found in :

 
Set No: 8107  Name: Fight for the Golden Tower
* 
8107-1 (Inv) Fight for the Golden Tower
559 Parts, 2 Minifigures, 2007
Sets: Exo-Force


Or

 
Set No: 6210  Name: Jabba's Sail Barge
* 
6210-1 (Inv) Jabba's Sail Barge
747 Parts, 8 Minifigures, 2006
Sets: Star Wars: Star Wars Episode 4/5/6


Wrong Sail Barge!
 Author: iprice View Messages Posted By iprice
 Posted: Jun 21, 2020 18:10
 Subject: Re: Modified plate #4151
 Viewed: 31 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Squeakie7 writes:
  What set uses 8 x 8 modified plate #4151 with grille in a dark tan? It is not
listed in the catalog.

Jabba's Sail Barge - 75020

https://www.bricklink.com/v2/catalog/catalogitem.page?S=75020-1&name=Jabba%27s%20Sail%20Barge&category=%5BStar%20Wars%5D%5BStar%20Wars%20Episode%204/5/6%5D#T=I

Strange it's not listed.
 Author: Squeakie7 View Messages Posted By Squeakie7
 Posted: Jun 21, 2020 17:58
 Subject: Modified plate #4151
 Viewed: 82 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
What set uses 8 x 8 modified plate #4151 with grille in a dark tan? It is not
listed in the catalog.
 Author: mjah5 View Messages Posted By mjah5
 Posted: Jun 21, 2020 16:38
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 36 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, jcvp17 writes:
  Hi!
For my personal Lego classification I am using the categories that you can see

Hi jcvp17
I like your classifications. I also love Barcelona.
 Author: jcvp17 View Messages Posted By jcvp17
 Posted: Jun 21, 2020 15:18
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 32 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hi!
For my personal Lego classification I am using the categories that you can see
in the attached image. It works quite well for me, although we already know that
any classification is subjective, arbitrary and can be improved
best regards
jcvp17
 
 Author: Gp8871 View Messages Posted By Gp8871
 Posted: Jun 21, 2020 12:24
 Subject: Re: Unknown part
 Viewed: 21 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, cycbuild writes:
  In Catalog, Gp8871 writes:
  Hello everybody!

Can anyone tell me what is this part, please?

Thanks

Here ya go
 
Part No: 11610  Name: Cone 1 x 1 Inverted with Bar
* 
11610 Cone 1 x 1 Inverted with Bar
Parts: Cone

Thank you... haven’t thought of searching in that category.

Have a nice day
 Author: cycbuild View Messages Posted By cycbuild
 Posted: Jun 21, 2020 12:09
 Subject: Re: Unknown part
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Gp8871 writes:
  Hello everybody!

Can anyone tell me what is this part, please?

Thanks

Here ya go
 
Part No: 11610  Name: Cone 1 x 1 Inverted with Bar
* 
11610 Cone 1 x 1 Inverted with Bar
Parts: Cone
 Author: Gp8871 View Messages Posted By Gp8871
 Posted: Jun 21, 2020 12:07
 Subject: Unknown part
 Viewed: 112 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hello everybody!

Can anyone tell me what is this part, please?

Thanks
 
 Author: mjah5 View Messages Posted By mjah5
 Posted: Jun 21, 2020 04:34
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hello Soviet, yorbrick, SylvainLS, jeslego, Adjour, m.ws et.al.
Thank-you for your insight and advise. Everyone uses Lego for their own purposes.
Some enjoy playing with it. Some use it to express their creativity. Some use
it to generate cash. All uses are perfectly fine. I like to organize. If I
buy a set, I see that set as fun to assemble but it does not require any organizing.
There is only very limited "chaos" in a boxed set of LEGO. On the other hand,
when I purchase a pile of bricks on eBay, I'm not that interested in the
individual elements, but rather on the huge amount of "chaos" that those elements
represent. I'm not buying the elements, I'm buying the "chaos" that
I can then apply my passion to organizing to remove the "chaos" from the elements.
If my SIPs never get completed I don't really care. I'm not going to
be selling the complete SIP, It will just be stored away. My collection of completed
SIPs holds no more interest for me other than as a measure of how much "chaos"
I have taken great pleasure in removing from the "World of Lost LEGO Elements".
Generally, the expression goes, "The means to the end." In my case I would say
that" The Means is the End."
Reading and thinking about all the great comments that my original post has sparked
has caused me to want to change how I describe myself as a LEGO user. While
I always knew I am not a "Master Builder" I had thought I was a "Master Collector".
The BL community has helped me to realize that I am more properly an "Amateur
Organizer". To suggest that I an a "Master Organizer" would also suggest that
my method of organizing is in some way superior. It's not! it's just
the method that suits my particular "flavour of OCD."

Lastly, regarding the terminology I needed for my DB, with your excellent advise,
I have decided to go with this sequence:
CATEGORY :: PART :: ELEMENT :: PIECE

Thanks to all community member.
If anyone want to discuss further the structure of my DB or how I intend to use
it feel free to carry on this discussion or to message me through this site.

BRICK ON all!
Mark, an "Amateur Organizer"
 Author: w.sm View Messages Posted By w.sm
 Posted: Jun 21, 2020 01:08
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 41 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, mjah5 writes:
I'm building a MySQL Database to keep track of my collection.


Why are you creating an SQL DB?

Have you thought of using sites that already exist for tracking your collection?

I'm not sure but I think rebrickable can do it.
 Author: Adjour View Messages Posted By Adjour
 Posted: Jun 20, 2020 22:22
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 47 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
  NEVER find yourself with 300+ sets to restore all at once. I did this too.
It complicates the process unnecessarily. If you have a pile of 1000 parts that
contains 600 you need to finish 8 sets, you have a manageable problem. If you
have a pile of 100k parts that contains the 600 you need to finish 8 sets, you
have a long, long slog ahead of you.

You can not store all of the parts ever produced. Holding odd bits for the day
that they are needed is a bit like waiting for Godot.

Every set has one or two parts that are unusually expensive. If you can quickly
identify these and determine whether you have them, you will be able to decide
if it makes economic sense to spend even one minute restoring this version of
the set. Ditto for Minifigs.



Took the words out of my mouth. This is primarily what I do, and I don't
have 40 sets in progress, let alone 300. I usually finish one lot at a time.
If the set doesn't have the figs, I usually wont bother saving it depending
on what it is.

I try also to buy lots of similar themes, so I have easy spare parts without
having to have "everything that ever existed". I just need "most" of what was
produced 1980- 2000 in my case.

I guess none of that is helpful really to the OP's question. I personally
wouldn't bother trying to set up my situation to operate this way, I would
work on getting the number of sets I intend to sell in my possession waaay down.
 Author: jeslego View Messages Posted By jeslego
 Posted: Jun 20, 2020 17:59
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 51 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, mjah5 writes:
  Hi all.
BACKGROUND: Let my start by saying that unlike my grandchildren, Marcus and
Soren, I am not a "Master Builder". I am a "Master Collector." My brick hobby
is to purchase long forgotten brick collections from parents of teen + former
brick fan that have been collecting dust in the basement or attic for years.
Once in my possession, I discard the fake pieces, wash the real ones then sort
them out looking for the special pieces that will tell me which sets the original
owner possessed.Then I try to re-assemble those sets.
PROBLEM: Currently, I have about 330 sets that I have identified as previously
owned. Those are my SIPs, "sets-in-progress." Each SIP has a container where
I store the parts that I've located. Together those 330 SIPs consist of
approximately 56,000 pieces. Of those, I have located about 23,000 pieces and
I am still looking for the other 23,000 pieces. I would guess my personal brick
collection consists of 100,000+ pieces that are not currently assigned to a SIP.
They are sorted and stored in other many other containers. When I need to locate
a piece for a SIP I look in about 5 "likely" containers then give up. Do I not
have the piece or is just in one of the many many "unlikely" containers?
SOLUTION: I'm building a MySQL Database to keep track of my collection.
Using BL's category system, there exist many bricks, slopes, arches etc.,
based more or less on shape. Within the sub-category bricks there are 1x1,
2x2, 2x4 etc., more or less based on size.
QUESTIONS: Q1;What are these sub-categories called? I would call them an ELEMENT.
is that correct? is there a better name for the sub-categories? Further, the
sub-categories such as 1x1 bricks of course come in many colours. Q2: What are
these sub-sub-categories called, or what are these ELEMENTs with a particular
colour called? I would call them a PART. Correct? Any other better name?
Q3; Lastly, if I hold in my hand, one blue 1x1 brick, what should that be called?
I would suggest that is a PIECE. Correct? Any better answer?
CATEGORY :: ELEMENT :: PART :: PIECE ??

I liked Sylvain's answer, but my perspective is a little different.

A very long time ago, I started doing what you are doing, with the intent of
creating a business for my kids. It pays okay, but not enough to support an
adult. It is something to do when there is nothing to do.

Defining the objects in a LEGO database can be done. But it will take lots of
time to populate and maintain. The data design time has already being expended
by other organizations. The structure of the Bricklink catalog may not be ideal,
but it is free.

As noted elsewhere in the thread, the mold numbers and even minor part variations
start to matter as set age to the point where they are bought for nostalgia or
collections. If this is your market, you will need a database that warns you
when to do more than just check the shape and color of the parts.

But if your market is making people happy by providing them with a fun building
experience that is less costly than what it would be to buy the sets new, than
there are some shortcuts you can take.

Everything you need to finish a set is available for sale. Hence the real question
becomes whether it is less expensive to look for it in your inventory or on line.


There is a core of basic LEGO parts. Sort those by shape. They will be the
bulk of what you have in your 100k inventory. Storage is naturally self sorting.
Bricks, plates, slopes, wings, arches, lift arms, small technic parts, etc.
This speeds the bulk of your searches.

NEVER find yourself with 300+ sets to restore all at once. I did this too.
It complicates the process unnecessarily. If you have a pile of 1000 parts that
contains 600 you need to finish 8 sets, you have a manageable problem. If you
have a pile of 100k parts that contains the 600 you need to finish 8 sets, you
have a long, long slog ahead of you.

You can not store all of the parts ever produced. Holding odd bits for the day
that they are needed is a bit like waiting for Godot.

Every set has one or two parts that are unusually expensive. If you can quickly
identify these and determine whether you have them, you will be able to decide
if it makes economic sense to spend even one minute restoring this version of
the set. Ditto for Minifigs.

If you want to build and maintain databases, by all means do so. But a better
database will not help you complete sets any faster. If your time is worth $60
per hour and it takes you a minute to tag, store, and record the location of
a $1 part, you will lose money on said part when you pay for its storage space
or go to transfer it to a set.

Good Luck
 Author: mjah5 View Messages Posted By mjah5
 Posted: Jun 20, 2020 17:36
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 41 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, SylvainLS writes:
  First, that you have trouble finding names for your entities is a big clue they
are the wrong entities.

Vocabulary-wise, “element,” ”part” and “piece” are mostly the same thing.
LEGO uses “design” for the mould (and decor ) and “element” for design + colour.
LEGO’s “DesignID” is the number most often used by BL, LDraw and others as a
“part ID” or “name” (the text explaining the part is then a “description”).
And LEGO’s “ElementID,” the 6-digit number that appears in their instructions,
is what BL calls a PCC / Part-Colour-Code.

So, you found out that BL’s categories are “more or less based on shape.” That
means they aren’t.
Then you thought about colours. “Everybody knows” you don’t sort LEGO by colour

Then you found that many pieces share the same shape and are distinguished by
their size. Not all are.

So, what are you trying to do with this? Are you are trying to categorize your
parts to fit them in containers?
Then what you found out is that parts have attributes: general shape, size, colour,
and you “more or less” ordered them: shape first, then colour, then size.
Okay, that’s some sort of sieve system to define containers.
But why do you need to put that in you DB?

You have a list of parts of one side, your inventory, and lists of parts on the
other side, the wanted parts for the sets.
How will the database be used? You need to know first if the exact part (ID
+ colour) is in your inventory and, second, where it’s stored if it is.
Where do this categorization of yours is used in the DB?
Nowhere that I see.

Or do you want to have an algorithm that takes a BL part (ID + description +
colour) and turns out a container number?
But does it have to be in the DB? Not that I see.

So I don’t see a need to complicate your DB. You just need to have four main
tables: parts (BL id + description), colours, inventories (list of parts in a
given colour and in a given quantity), and containers (association between a
location and parts).

Besides, you’ll quickly find all “shapes” don’t divise regularly (or at all)
into “colours” or “sizes” (most of the heads are yellow; slopes first divise
by angle, not size; Technic connectors don’t come in many colours nor sizes; etc.).
Especially if you use BL categories as “shapes.”

On this note, here’s a rough categorization that some sellers (who sort many
parts) use as a first sieve:
  Bricks & Arches
  Brick Modified & Round
  Plate
  Plate Modified & Round
  Slope
  Technic
  Tile & Panel
  Minifig
  Other
They are about the same size in a “standard” collection. This might help you
devise your containers’ organization.

Hello SylvainLS, thank-you for the very useful information. You raise some very
good points. in my initial message I did not describe the structure of the DB
I am building because it was un-necessary to the information I was seeking and
would have taken far to many keystrokes and doubtlessly many readers wouldn't
have cared less and some would have been confused regardless. However, since
you raised the issue, I'll try to be brief.
My SIPs are managed adequately by BL using the WANTED LISTS. While I may in
the future move that info into the DB, currently the DB is just for my unassigned
pieces. My plan is to assign each of my existing containers into the `Containers`
table. There will also be a `Colours` and a `Categories` table. The Containers
table will be linked to the Colours and Categories tables. Some containers will
have only one colour and one category, but as you point out some. container will
colour and category lines, such as the container for my "larger-ish" TRANSparent
pieces.
My next table will, as you suggest, be for PARTS linking part descriptions to
category descriptions. The last table will be, likely called ELEMENTS will link
PARTS to COLOURS and to a particular container and will list a ELEMENT count
for the for that container. Were I to have many Blue 2x4 bricks that I required
a second container, the ELEMENTS table would have two or more entries (a one
to many relationship).
Once all set up, my PLAN FOR USE is to use the BL WANTED LISTS to identify missing
SIP elements then to query my DB to identify which one or more of my containers
hold those elements. Update both DBs then move on to the next missing Element.
If I don't have the missing element then I can use BL to purchase it. Right
now, I don't want to purchase anything from BL because I'm not 100% certain
I don't already have it somewhere.
Like I said, thank-you for your excellent and helpful information on sorting,
storing and managing my collection.
Regards, Mark
 Author: mjah5 View Messages Posted By mjah5
 Posted: Jun 20, 2020 16:51
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 43 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, yorbrick writes:
  It is the other way around. A 1x1 brick is a part. A 1x1 brick in blue is an
element. A single piece in your hand can be called piece or part or element,
whatever you want really.

Hello yorbrick, thank-you for the information. I like your suggestion and will
likely go with it.
Regards, Mark
 Author: mjah5 View Messages Posted By mjah5
 Posted: Jun 20, 2020 16:32
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 39 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, Soviet writes:
  Interesting, I would love to see a photo of your "SIP wall". Maybe you should
look into buying boxes and instructions to fully complete the sets?

To answer your question, Category Element Part seems correct, but I think
that Part is already a Piece, by your nomenclature. I guess the proper BrickLink
way would be Category Item (for a certain item) and then maybe Piece for an
Item in specific color. Maybe you should also introduce "Mold" into the database,
because--as you probably know--some of the old items used to look quite
different.

But my most important point is: if you're adding all your pieces to a database,
why not add them to BrickLink inventory? Even better, you can try Rebrickable,
which will give you a lot of interesting options when looking into completing
sets.

Soviet, thank-you for the information and assistance. I will be sending you
a personal message with a picture of my SIPs and my many containers of unassigned
pieces.
The issue of mould differences and older pieces general is a concern. I try
to keep my SIPs period correct. I have separate containers for older pieces
where the PIP marks are on the side rather than in the middle of one of the studs
as is the case I do use BL to manage my SIPS. Currently I have 358 Wanted Lists,
one per SIP. I had considered using BL's Inventory feature to manage my
unassigned pieces, however, that is only available to Sellers members, not to
Buyers. Therefore, I'm using this project as a learning opportunity to develop
a DB with a web interface. Programming is my other passion.
Regards, Mark
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jun 20, 2020 15:06
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 40 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, mjah5 writes:
  Hi all.
BACKGROUND: Let my start by saying that unlike my grandchildren, Marcus and
Soren, I am not a "Master Builder". I am a "Master Collector." My brick hobby
is to purchase long forgotten brick collections from parents of teen + former
brick fan that have been collecting dust in the basement or attic for years.
Once in my possession, I discard the fake pieces, wash the real ones then sort
them out looking for the special pieces that will tell me which sets the original
owner possessed.Then I try to re-assemble those sets.
PROBLEM: Currently, I have about 330 sets that I have identified as previously
owned. Those are my SIPs, "sets-in-progress." Each SIP has a container where
I store the parts that I've located. Together those 330 SIPs consist of
approximately 56,000 pieces. Of those, I have located about 23,000 pieces and
I am still looking for the other 23,000 pieces. I would guess my personal brick
collection consists of 100,000+ pieces that are not currently assigned to a SIP.
They are sorted and stored in other many other containers. When I need to locate
a piece for a SIP I look in about 5 "likely" containers then give up. Do I not
have the piece or is just in one of the many many "unlikely" containers?
SOLUTION: I'm building a MySQL Database to keep track of my collection.
Using BL's category system, there exist many bricks, slopes, arches etc.,
based more or less on shape. Within the sub-category bricks there are 1x1,
2x2, 2x4 etc., more or less based on size.
QUESTIONS: Q1;What are these sub-categories called? I would call them an ELEMENT.
is that correct? is there a better name for the sub-categories? Further, the
sub-categories such as 1x1 bricks of course come in many colours. Q2: What are
these sub-sub-categories called, or what are these ELEMENTs with a particular
colour called? I would call them a PART. Correct? Any other better name?
Q3; Lastly, if I hold in my hand, one blue 1x1 brick, what should that be called?
I would suggest that is a PIECE. Correct? Any better answer?
CATEGORY :: ELEMENT :: PART :: PIECE ??

First, that you have trouble finding names for your entities is a big clue they
are the wrong entities.

Vocabulary-wise, “element,” ”part” and “piece” are mostly the same thing.
LEGO uses “design” for the mould (and decor ) and “element” for design + colour.
LEGO’s “DesignID” is the number most often used by BL, LDraw and others as a
“part ID” or “name” (the text explaining the part is then a “description”).
And LEGO’s “ElementID,” the 6-digit number that appears in their instructions,
is what BL calls a PCC / Part-Colour-Code.

So, you found out that BL’s categories are “more or less based on shape.” That
means they aren’t.
Then you thought about colours. “Everybody knows” you don’t sort LEGO by colour

Then you found that many pieces share the same shape and are distinguished by
their size. Not all are.

So, what are you trying to do with this? Are you are trying to categorize your
parts to fit them in containers?
Then what you found out is that parts have attributes: general shape, size, colour,
and you “more or less” ordered them: shape first, then colour, then size.
Okay, that’s some sort of sieve system to define containers.
But why do you need to put that in you DB?

You have a list of parts of one side, your inventory, and lists of parts on the
other side, the wanted parts for the sets.
How will the database be used? You need to know first if the exact part (ID
+ colour) is in your inventory and, second, where it’s stored if it is.
Where do this categorization of yours is used in the DB?
Nowhere that I see.

Or do you want to have an algorithm that takes a BL part (ID + description +
colour) and turns out a container number?
But does it have to be in the DB? Not that I see.

So I don’t see a need to complicate your DB. You just need to have four main
tables: parts (BL id + description), colours, inventories (list of parts in a
given colour and in a given quantity), and containers (association between a
location and parts).

Besides, you’ll quickly find all “shapes” don’t divise regularly (or at all)
into “colours” or “sizes” (most of the heads are yellow; slopes first divise
by angle, not size; Technic connectors don’t come in many colours nor sizes; etc.).
Especially if you use BL categories as “shapes.”

On this note, here’s a rough categorization that some sellers (who sort many
parts) use as a first sieve:
  Bricks & Arches
  Brick Modified & Round
  Plate
  Plate Modified & Round
  Slope
  Technic
  Tile & Panel
  Minifig
  Other
They are about the same size in a “standard” collection. This might help you
devise your containers’ organization.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Jun 20, 2020 14:26
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
  QUESTIONS: Q1;What are these sub-categories called? I would call them an ELEMENT.
is that correct? is there a better name for the sub-categories? Further, the
sub-categories such as 1x1 bricks of course come in many colours. Q2: What are
these sub-sub-categories called, or what are these ELEMENTs with a particular
colour called? I would call them a PART. Correct? Any other better name?
Q3; Lastly, if I hold in my hand, one blue 1x1 brick, what should that be called?
I would suggest that is a PIECE. Correct? Any better answer?
CATEGORY :: ELEMENT :: PART :: PIECE ??

It is the other way around. A 1x1 brick is a part. A 1x1 brick in blue is an
element. A single piece in your hand can be called piece or part or element,
whatever you want really.
 Author: Soviet View Messages Posted By Soviet
 Posted: Jun 20, 2020 14:09
 Subject: Re: Terminology - DB to organize my 100,000+ pcs
 Viewed: 49 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Interesting, I would love to see a photo of your "SIP wall". Maybe you should
look into buying boxes and instructions to fully complete the sets?

To answer your question, Category Element Part seems correct, but I think
that Part is already a Piece, by your nomenclature. I guess the proper BrickLink
way would be Category Item (for a certain item) and then maybe Piece for an
Item in specific color. Maybe you should also introduce "Mold" into the database,
because--as you probably know--some of the old items used to look quite
different.

But my most important point is: if you're adding all your pieces to a database,
why not add them to BrickLink inventory? Even better, you can try Rebrickable,
which will give you a lot of interesting options when looking into completing
sets.

In Catalog, mjah5 writes:
  Hi all.
BACKGROUND: Let my start by saying that unlike my grandchildren, Marcus and
Soren, I am not a "Master Builder". I am a "Master Collector." My brick hobby
is to purchase long forgotten brick collections from parents of teen + former
brick fan that have been collecting dust in the basement or attic for years.
Once in my possession, I discard the fake pieces, wash the real ones then sort
them out looking for the special pieces that will tell me which sets the original
owner possessed.Then I try to re-assemble those sets.
PROBLEM: Currently, I have about 330 sets that I have identified as previously
owned. Those are my SIPs, "sets-in-progress." Each SIP has a container where
I store the parts that I've located. Together those 330 SIPs consist of
approximately 56,000 pieces. Of those, I have located about 23,000 pieces and
I am still looking for the other 23,000 pieces. I would guess my personal brick
collection consists of 100,000+ pieces that are not currently assigned to a SIP.
They are sorted and stored in other many other containers. When I need to locate
a piece for a SIP I look in about 5 "likely" containers then give up. Do I not
have the piece or is just in one of the many many "unlikely" containers?
SOLUTION: I'm building a MySQL Database to keep track of my collection.
Using BL's category system, there exist many bricks, slopes, arches etc.,
based more or less on shape. Within the sub-category bricks there are 1x1,
2x2, 2x4 etc., more or less based on size.
QUESTIONS: Q1;What are these sub-categories called? I would call them an ELEMENT.
is that correct? is there a better name for the sub-categories? Further, the
sub-categories such as 1x1 bricks of course come in many colours. Q2: What are
these sub-sub-categories called, or what are these ELEMENTs with a particular
colour called? I would call them a PART. Correct? Any other better name?
Q3; Lastly, if I hold in my hand, one blue 1x1 brick, what should that be called?
I would suggest that is a PIECE. Correct? Any better answer?
CATEGORY :: ELEMENT :: PART :: PIECE ??
 Author: mjah5 View Messages Posted By mjah5
 Posted: Jun 20, 2020 13:26
 Subject: Terminology - DB to organize my 100,000+ pcs
 Viewed: 175 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hi all.
BACKGROUND: Let my start by saying that unlike my grandchildren, Marcus and
Soren, I am not a "Master Builder". I am a "Master Collector." My brick hobby
is to purchase long forgotten brick collections from parents of teen + former
brick fan that have been collecting dust in the basement or attic for years.
Once in my possession, I discard the fake pieces, wash the real ones then sort
them out looking for the special pieces that will tell me which sets the original
owner possessed.Then I try to re-assemble those sets.
PROBLEM: Currently, I have about 330 sets that I have identified as previously
owned. Those are my SIPs, "sets-in-progress." Each SIP has a container where
I store the parts that I've located. Together those 330 SIPs consist of
approximately 56,000 pieces. Of those, I have located about 23,000 pieces and
I am still looking for the other 23,000 pieces. I would guess my personal brick
collection consists of 100,000+ pieces that are not currently assigned to a SIP.
They are sorted and stored in other many other containers. When I need to locate
a piece for a SIP I look in about 5 "likely" containers then give up. Do I not
have the piece or is just in one of the many many "unlikely" containers?
SOLUTION: I'm building a MySQL Database to keep track of my collection.
Using BL's category system, there exist many bricks, slopes, arches etc.,
based more or less on shape. Within the sub-category bricks there are 1x1,
2x2, 2x4 etc., more or less based on size.
QUESTIONS: Q1;What are these sub-categories called? I would call them an ELEMENT.
is that correct? is there a better name for the sub-categories? Further, the
sub-categories such as 1x1 bricks of course come in many colours. Q2: What are
these sub-sub-categories called, or what are these ELEMENTs with a particular
colour called? I would call them a PART. Correct? Any other better name?
Q3; Lastly, if I hold in my hand, one blue 1x1 brick, what should that be called?
I would suggest that is a PIECE. Correct? Any better answer?
CATEGORY :: ELEMENT :: PART :: PIECE ??
 Author: primadeluxe View Messages Posted By primadeluxe
 Posted: Jun 19, 2020 14:26
 Subject: Re: part 2494pb08 variants
 Viewed: 26 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Nice catch! Ask for a note and submit your image to show the differences.

In Catalog, crepundi writes:
  I noticed there are two versions of the 1 x 4 x 5 glass with 9 stripes,
 
Part No: 2494pb08  Name: Glass for Window 1 x 4 x 5 with 9 White Stripes Pattern (Sticker) - Sets 6386 / 6540
* 
2494pb08 Glass for Window 1 x 4 x 5 with 9 White Stripes Pattern (Sticker) - Sets 6386 / 6540
Parts: Window, Glass & Shutter, Decorated
one has more wider and the other one more narrow stripes.
Looking at the sticker sheets of the two sets this part comes from I believe
the narrow one is from set 6386
 
Set No: 6386  Name: Police Command Base
* 
6386-1 (Inv) Police Command Base
347 Parts, 4 Minifigures, 1986
Sets: Town: Classic Town: Police
and the wider from set 6540
 
Set No: 6540  Name: Pier Police
* 
6540-1 (Inv) Pier Police
315 Parts, 4 Minifigures, 1991
Sets: Town: Classic Town: Police
Maybe there should be a remark about this.


Besides: how can I show a sticker sheet in a message?

Gisela
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jun 19, 2020 14:18
 Subject: Re: part 2494pb08 variants
 Viewed: 27 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, crepundi writes:
  I noticed there are two versions of the 1 x 4 x 5 glass with 9 stripes,
 
Part No: 2494pb08  Name: Glass for Window 1 x 4 x 5 with 9 White Stripes Pattern (Sticker) - Sets 6386 / 6540
* 
2494pb08 Glass for Window 1 x 4 x 5 with 9 White Stripes Pattern (Sticker) - Sets 6386 / 6540
Parts: Window, Glass & Shutter, Decorated
one has more wider and the other one more narrow stripes.
Looking at the sticker sheets of the two sets this part comes from I believe
the narrow one is from set 6386
 
Set No: 6386  Name: Police Command Base
* 
6386-1 (Inv) Police Command Base
347 Parts, 4 Minifigures, 1986
Sets: Town: Classic Town: Police
and the wider from set 6540
 
Set No: 6540  Name: Pier Police
* 
6540-1 (Inv) Pier Police
315 Parts, 4 Minifigures, 1991
Sets: Town: Classic Town: Police
Maybe there should be a remark about this.


Besides: how can I show a sticker sheet in a message?

Stickers are parts.

 
Part No: 6386stk01  Name: Sticker Sheet for Set 6386 - (190805)
* 
6386stk01 Sticker Sheet for Set 6386 - (190805)
Parts: Sticker Sheet
 
Part No: 6540stk01  Name: Sticker Sheet for Set 6540 - (820671)
* 
6540stk01 Sticker Sheet for Set 6540 - (820671)
Parts: Sticker Sheet
 Author: crepundi View Messages Posted By crepundi
 Posted: Jun 19, 2020 14:06
 Subject: part 2494pb08 variants
 Viewed: 67 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
I noticed there are two versions of the 1 x 4 x 5 glass with 9 stripes,
 
Part No: 2494pb08  Name: Glass for Window 1 x 4 x 5 with 9 White Stripes Pattern (Sticker) - Sets 6386 / 6540
* 
2494pb08 Glass for Window 1 x 4 x 5 with 9 White Stripes Pattern (Sticker) - Sets 6386 / 6540
Parts: Window, Glass & Shutter, Decorated
one has more wider and the other one more narrow stripes.
Looking at the sticker sheets of the two sets this part comes from I believe
the narrow one is from set 6386
 
Set No: 6386  Name: Police Command Base
* 
6386-1 (Inv) Police Command Base
347 Parts, 4 Minifigures, 1986
Sets: Town: Classic Town: Police
and the wider from set 6540
 
Set No: 6540  Name: Pier Police
* 
6540-1 (Inv) Pier Police
315 Parts, 4 Minifigures, 1991
Sets: Town: Classic Town: Police
Maybe there should be a remark about this.


Besides: how can I show a sticker sheet in a message?

Gisela
 
 Author: lego.12vtrains View Messages Posted By lego.12vtrains
 Posted: Jun 19, 2020 06:51
 Subject: Re: Train wheels
 Viewed: 42 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Thanks for reporting this and for the hint.
 Author: StormChaser View Messages Posted By StormChaser
 Posted: Jun 19, 2020 00:48
 Subject: Re: Train wheels
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, lego.12vtrains writes:
  Hi StormChaser,

from your words I suspect these guidelines will become more and more restrictive, and this fact scares me enough

The actual catalog guidelines page will be opened for public comment and subsequent
modification before being implemented. So watch for that and take the opportunity
to provide feedback on anything you find objectionable or frightening.
 Author: lego.12vtrains View Messages Posted By lego.12vtrains
 Posted: Jun 18, 2020 16:27
 Subject: Re: Train wheels
 Viewed: 54 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hi StormChaser,

thanks for taking part in the discussion and for explaining us the reasons of
this rejection, I perfectly understand that first of all you Admins want to get
your guidelines figured out before taking some decisions, but from your words
I suspect these guidelines will become more and more restrictive, and this fact
scares me enough: how could more restrictive guidelines help the catalogue to
become more precise and accurate?
 Author: primadeluxe View Messages Posted By primadeluxe
 Posted: Jun 18, 2020 16:00
 Subject: Re: Mold markings Duplo bed #4895 versus #76338
 Viewed: 25 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
It is a nice catch! You should ask for a note at catalog requests and submit
a image with the difference. Cheers!

In Catalog, bricksahead writes:
  Part #76338 is considered an alternate item id for part #4895. I noticed that
Duplo bed, part #4895 has a mold marking in the center of the bed while Duplo
bed, part #76338 has a mold marking inside a bottom tube.

Is this something that should be added to the catalog?

I checked 17 beds, part #76388, and they all have mold markings inside a bottom
tube, and 7 beds, part #4895 that all have mold marking on top of the bed (in
the center).

 
Part No: 4895  Name: Duplo, Furniture Bed 3 x 5 x 1 2/3
* 
4895 Duplo, Furniture Bed 3 x 5 x 1 2/3
Parts: DUPLO, Furniture
 Author: bricksahead View Messages Posted By bricksahead
 Posted: Jun 18, 2020 15:12
 Subject: Mold markings Duplo bed #4895 versus #76338
 Viewed: 40 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Part #76338 is considered an alternate item id for part #4895. I noticed that
Duplo bed, part #4895 has a mold marking in the center of the bed while Duplo
bed, part #76338 has a mold marking inside a bottom tube.

Is this something that should be added to the catalog?

I checked 17 beds, part #76388, and they all have mold markings inside a bottom
tube, and 7 beds, part #4895 that all have mold marking on top of the bed (in
the center).

 
Part No: 4895  Name: Duplo, Furniture Bed 3 x 5 x 1 2/3
* 
4895 Duplo, Furniture Bed 3 x 5 x 1 2/3
Parts: DUPLO, Furniture
 Author: legohed View Messages Posted By legohed
 Posted: Jun 18, 2020 14:22
 Subject: Re: Retirement Date List
 Viewed: 37 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, yorbrick writes:
  In Catalog, legohed writes:
  Hi all,


New member here...

I'm interested to know if there is a list anywhere of the sets with their
retirement date.

I see the 'year released' on all the item pages, but nothing on retirement.

If anyone can help I'd be most grateful

Thanks!

Do you mean already retired sets? If so, look on brickset, they have data the
sets were available direct from LEGO so about as close to a retirement date as
you can get.

For future retirements, there are only guesses.


Thank you!
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Jun 18, 2020 12:28
 Subject: Re: Retirement Date List
 Viewed: 31 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, legohed writes:
  Hi all,


New member here...

I'm interested to know if there is a list anywhere of the sets with their
retirement date.

I see the 'year released' on all the item pages, but nothing on retirement.

If anyone can help I'd be most grateful

Thanks!

Do you mean already retired sets? If so, look on brickset, they have data the
sets were available direct from LEGO so about as close to a retirement date as
you can get.

For future retirements, there are only guesses.
 Author: legohed View Messages Posted By legohed
 Posted: Jun 18, 2020 12:24
 Subject: Retirement Date List
 Viewed: 106 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hi all,


New member here...

I'm interested to know if there is a list anywhere of the sets with their
retirement date.

I see the 'year released' on all the item pages, but nothing on retirement.

If anyone can help I'd be most grateful

Thanks!
 Author: normann1974 View Messages Posted By normann1974
 Posted: Jun 18, 2020 06:30
 Subject: Re: Hinge brick assemblies with 2x2 top?
 Viewed: 65 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
  As far as I know they are not assemblies because they came separate in the sets.
I have separated hundreds/thousands without causing any damage.

I believe that assemblies are not only made for pre-assembled parts in sets.
Example:

 
Part No: 2878c02  Name: Train Wheel RC, Holder with 2 Black Train Wheel RC Train and Chrome Silver Train Wheel RC Train, Metal Axle (2878 / 57878 / x1687)
* 
2878c02 (Inv) Train Wheel RC, Holder with 2 Black Train Wheel RC Train and Chrome Silver Train Wheel RC Train, Metal Axle (2878 / 57878 / x1687)
Parts: Wheel

This part is even easier to disassemble than the hinges, and have no risk of
inducing stress marks.

/Jan
 Author: Stellar View Messages Posted By Stellar
 Posted: Jun 17, 2020 18:07
 Subject: Re: Pickable Models and In-Store Builds
 Viewed: 35 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, StormChaser writes:
  In Catalog, StormChaser writes:
  Behold what we approved today

Sorry, looks like we had a bit of a technological hiccup with these changes.
We're sorting it out.


ohhh hope to see them again soon
 Author: StormChaser View Messages Posted By StormChaser
 Posted: Jun 17, 2020 16:01
 Subject: Re: Pickable Models and In-Store Builds
 Viewed: 58 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, StormChaser writes:
  Behold what we approved today

Sorry, looks like we had a bit of a technological hiccup with these changes.
We're sorting it out.
 Author: edk View Messages Posted By edk
 Posted: Jun 17, 2020 15:53
 Subject: Re: Hinge brick assemblies with 2x2 top?
 Viewed: 51 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, normann1974 writes:
  Hello

I was about to sell a lot of assemblies of
 
Part No: 6134  Name: Hinge Brick 2 x 2 Top Plate
* 
6134 Hinge Brick 2 x 2 Top Plate
Parts: Hinge
and
 
Part No: 3937  Name: Hinge Brick 1 x 2 Base
* 
3937 Hinge Brick 1 x 2 Base
Parts: Hinge
and found out
that no such assemblies exist in the catalog like they do for the 3939c* assemblies
with
 
Part No: 3938  Name: Hinge Brick 1 x 2 Top Plate
* 
3938 Hinge Brick 1 x 2 Top Plate
Parts: Hinge
tops. So if I want to sell them on BL, I have to disassemble them
and I have found that to be very difficult. In many cases, it leaves stressmarks
on the small hooks on the bases, and then I need to discard them.

So, is there any project planned to make assemblies for these? They come in two
flavors depending on whether the top turns upwards or downwards, so the amount
of parts needed would approx. be doubled compared to the 3937c* assemblies. But
IMHO, it would really help sellers.

/Jan

As far as I know they are not assemblies because they came separate in the sets.
I have separated hundreds/thousands without causing any damage.
 Author: normann1974 View Messages Posted By normann1974
 Posted: Jun 17, 2020 15:44
 Subject: Hinge brick assemblies with 2x2 top?
 Viewed: 95 times
 Topic: Catalog
 Status:Open
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Hello

I was about to sell a lot of assemblies of
 
Part No: 6134  Name: Hinge Brick 2 x 2 Top Plate
* 
6134 Hinge Brick 2 x 2 Top Plate
Parts: Hinge
and
 
Part No: 3937  Name: Hinge Brick 1 x 2 Base
* 
3937 Hinge Brick 1 x 2 Base
Parts: Hinge
and found out
that no such assemblies exist in the catalog like they do for the 3939c* assemblies
with
 
Part No: 3938  Name: Hinge Brick 1 x 2 Top Plate
* 
3938 Hinge Brick 1 x 2 Top Plate
Parts: Hinge
tops. So if I want to sell them on BL, I have to disassemble them
and I have found that to be very difficult. In many cases, it leaves stressmarks
on the small hooks on the bases, and then I need to discard them.

So, is there any project planned to make assemblies for these? They come in two
flavors depending on whether the top turns upwards or downwards, so the amount
of parts needed would approx. be doubled compared to the 3937c* assemblies. But
IMHO, it would really help sellers.

/Jan
 Author: Rick_S. View Messages Posted By Rick_S.
 Posted: Jun 17, 2020 13:43
 Subject: Re: Pickable Models and In-Store Builds
 Viewed: 31 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, StormChaser writes:
  In Catalog, bje writes:
  Can I resubmit my pickable models from 2012 or are you just going to change
the instruction entries to sets?

It doesn't appear to cause any problems to change instructions to
sets, so for existing instructions this is probably what will occur - except
possibly in cases where there are large numbers of items for sale.

Here's one changed:

 
Set No: Torque  Name: Toys "R" Us Exclusive Build - Rod "Torque" Redline
* 
TORQUE-1 (Inv) Toys "R" Us Exclusive Build - Rod "Torque" Redline
30 Parts, 2011
Sets: Building Event: Cars: Cars 2

I tried listing those instructions when I listed the sticker sheet for the set
and it got denied, guess rules changed?
 Author: Proprietor View Messages Posted By Proprietor
 Posted: Jun 17, 2020 13:15
 Subject: Re: Pickable Models and In-Store Builds
 Viewed: 34 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
Add this one please!

[g=3850011]

A lot of the listings are already for the set and not the instructions.

In Catalog, StormChaser writes:
  In Catalog, bje writes:

Thanks!

  
  Can I resubmit my pickable models from 2012 or are you just going to change
the instruction entries to sets?

It doesn't appear to cause any problems to change instructions to
sets, so for existing instructions this is probably what will occur - except
possibly in cases where there are large numbers of items for sale.

Here's one changed:

 
Set No: Torque  Name: Toys "R" Us Exclusive Build - Rod "Torque" Redline
* 
TORQUE-1 (Inv) Toys "R" Us Exclusive Build - Rod "Torque" Redline
30 Parts, 2011
Sets: Building Event: Cars: Cars 2
 Author: StormChaser View Messages Posted By StormChaser
 Posted: Jun 17, 2020 13:10
 Subject: Re: Pickable Models and In-Store Builds
 Viewed: 44 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
In Catalog, bje writes:
  Can I resubmit my pickable models from 2012 or are you just going to change
the instruction entries to sets?

It doesn't appear to cause any problems to change instructions to
sets, so for existing instructions this is probably what will occur - except
possibly in cases where there are large numbers of items for sale.

Here's one changed:

 
Set No: Torque  Name: Toys "R" Us Exclusive Build - Rod "Torque" Redline
* 
TORQUE-1 (Inv) Toys "R" Us Exclusive Build - Rod "Torque" Redline
30 Parts, 2011
Sets: Building Event: Cars: Cars 2
 Author: starbeanie View Messages Posted By starbeanie
 Posted: Jun 17, 2020 13:09
 Subject: Re: Pickable Models and In-Store Builds
 Viewed: 41 times
 Topic: Catalog
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
I just submitted the set image for it.


In Catalog, bje writes:
  In Catalog, StormChaser writes:
  Looks like things are changing around here. Behold what we approved today:

 
Set No: ST  Name: LEGO Brand Store Exclusive Build - Castle Byers
* 
ST-1 (Inv) LEGO Brand Store Exclusive Build - Castle Byers
50 Parts, 2019
Sets: LEGO Brand: LEGO Brand Store: Building Event: Stranger Things



Whoot! Can I resubmit my pickable models from 2012 or are you just going to change
the instruction entries to sets?

Next Page: 5 More | 10 More | 25 More | 50 More | 100 More