Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies Author: | mjah5 | Posted: | Jun 20, 2020 13:26 | Subject: | Terminology - DB to organize my 100,000+ pcs | Viewed: | 175 times | Topic: | Catalog | Status: | Open | |
|
| 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: | crepundi | Posted: | Jun 19, 2020 14:06 | Subject: | part 2494pb08 variants | Viewed: | 67 times | Topic: | Catalog | Status: | Open | |
|
| I noticed there are two versions of the 1 x 4 x 5 glass with 9 stripes,
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 and the wider from set 6540
Maybe there should be a remark about this.
Besides: how can I show a sticker sheet in a message?
Gisela
|
|
|
Author: | bricksahead | Posted: | Jun 18, 2020 15:12 | Subject: | Mold markings Duplo bed #4895 versus #76338 | Viewed: | 40 times | Topic: | Catalog | Status: | Open | |
|
| 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).
|
|
Author: | legohed | Posted: | Jun 18, 2020 12:24 | Subject: | Retirement Date List | Viewed: | 106 times | Topic: | Catalog | Status: | Open | |
|
| 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 | Posted: | Jun 17, 2020 15:44 | Subject: | Hinge brick assemblies with 2x2 top? | Viewed: | 95 times | Topic: | Catalog | Status: | Open | |
|
| Hello
I was about to sell a lot of assemblies of and and found out
that no such assemblies exist in the catalog like they do for the 3939c* assemblies
with 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: | StormChaser | Posted: | Jun 17, 2020 12:49 | Subject: | Pickable Models and In-Store Builds | Viewed: | 115 times | Topic: | Catalog | Status: | Open | |
|
| Looks like things are changing around here. Behold what we approved today:
|
|
Author: | electricbaer | Posted: | Jun 16, 2020 20:44 | Subject: | Sails still attached - qualify for entry? | Viewed: | 93 times | Topic: | Catalog | Status: | Open | |
|
| I've come across this rare gem - A full, uncut set of sails from the Carribbean
Clipper, still attached, never used. Well, obviously I'd classify this particular
one as used as I found it floating around in a box of parts. But anyway, I don't
see a catalog entry for the sails still being attached. I'd be happy to
submit them as an entry if they are quantifiable. I'd plan to straighten
them before posting a pic - They're still a tad bit wrinkly from taking a
bath, I mean, they are 31 years old
|
|
|
Author: | beasville | Posted: | Jun 16, 2020 09:55 | Subject: | incorrect or missing known colour | Viewed: | 84 times | Topic: | Catalog | Status: | Open | |
|
|
This part has 1 known colour listed: white. But the only picture is of this part
in red. This torso is found in one part, that part is also listed as white.
Could an additional known colour of red be added? The Torso assembly would be
red torso, red arms, red hands.
|
|
Author: | primadeluxe | Posted: | Jun 16, 2020 01:34 | Subject: | Tubes baseplates from the 70's vs newer ones | Viewed: | 125 times | Topic: | Catalog | Status: | Open | |
|
| All the baseplates from the 70's, which I have from original sets, have different
tubes (do you call them tubes?) compared with newer baseplates. I do not know
when this chance took place, but is it worth to add a note for these baseplates
as they come in different variations?
It would be a lot of work making pictures aspecially with all the baseplates
with white dots and I certainly do not have them all.
On the attached picture is a example from set 648-1. On the right the original
one from the 70's and on the left a newer one.
|
|
|
Author: | DianeGronas | Posted: | Jun 15, 2020 09:48 | Subject: | Tan Knit Sweater Minifig Torso (76382) | Viewed: | 95 times | Topic: | Catalog | Status: | Open | |
|
| Tan Knit Sweater Minifig Torso (76382) |
Author: | DianeGronas | Posted: | Jun 15, 2020 09:45 | Subject: | Sea Captain's White Hat (13553 / 31841) | Viewed: | 72 times | Topic: | Catalog | Status: | Open | |
|
| Sea Captain's White Hat (13553 / 31841) |
Author: | DianeGronas | Posted: | Jun 15, 2020 09:42 | Subject: | Sea Captain Torso (973 / 88585) | Viewed: | 53 times | Topic: | Catalog | Status: | Open | |
|
| Sea Captain Torso (973 / 88585) |
Author: | DianeGronas | Posted: | Jun 15, 2020 09:41 | Subject: | Captain Jones Minifig Torso (76382) | Viewed: | 51 times | Topic: | Catalog | Status: | Open | |
|
| Captain Jones Minifig Torso (76382) |
Author: | DianeGronas | Posted: | Jun 15, 2020 09:36 | Subject: | Obi-Wan Kenobi Large Figure Head (21939) | Viewed: | 88 times | Topic: | Catalog | Status: | Open | |
|
| Obi-Wan Kenobi Large Figure Head (21939) |
Author: | CTschumy | Posted: | Jun 15, 2020 04:21 | Subject: | Unknown Minifigure head variation | Viewed: | 95 times | Topic: | Catalog | Status: | Open | |
|
| Hi
I have a head which I cannot locate on Bricklink. I can find it in the blocked
open stud version, but cannot locate the head with the hollow stud version.
The head has the lego stamp inside the top stud
Item number 3626bpb0435 is for the blocked open stud version
Help please
Thanks
Chris
|
|
Author: | markim | Posted: | Jun 15, 2020 03:44 | Subject: | part inventory dplane3 | Viewed: | 55 times | Topic: | Catalog | Status: | Open | |
|
| Hey!
I am busy putting duplo into my inventory and ran into this little airplane.
It is not in a condition i want to sell it in, so i looked if it could be demolished
to smaller parts. In my idea it contains some wheels i cannot find in the catalog
and wheel pins number 2344. Can it be parted out?
Regards, Marielle
|
|
Author: | SurplusParts | Posted: | Jun 15, 2020 01:16 | Subject: | Can stickers over 2 parts be added? | Viewed: | 75 times | Topic: | Catalog | Status: | Open | |
|
| This is the dashboard sticker from
It is placed over 2 black arches 6005.
Can this placed in the catalogue as a stickered counterpart?
Asking as it is over 2 parts and not one it may not be.
Thanks
Douglas
|
|
Author: | IceWorm | Posted: | Jun 13, 2020 18:47 | Subject: | Harry Potter (Sorcerer's Stone) | Viewed: | 81 times | Topic: | Catalog | Status: | Open | |
|
| Hey, so I was wondering why BrickLink lists the Harry Potter and the Philosopher's
Stone items under the "Sorcerer's Stone" name? Even brickset uses the original
title as the subtheme. Just seems kinda odd.
|
Author: | normann1974 | Posted: | Jun 13, 2020 14:42 | Subject: | Textured variant of 30602 | Viewed: | 62 times | Topic: | Catalog | Status: | Open | |
|
| Today, I found a variant of with thin walls where the sides are slightly
textured. I found it only in yellow, all other parts have blank sides. There
is also a variant where the thin part of the back wall is slightly textured while
the sides are blank. Please consider updating the note on the part. I'll
be uploading the picture to the part. Accept it if you want it.
/Jan
|
|
|
Author: | infinibrix | Posted: | Jun 13, 2020 12:39 | Subject: | Minifigures being given incorrect codes? | Viewed: | 103 times | Topic: | Catalog | Status: | Open | |
|
| I don't know if its just me but with regards to the ideas and dimensions
themes would'nt it make sense to only give minifigures the 'idea'
and 'dim' codes if they don't already belong to an established and
existing theme? For instance all the Ideas Pirates of Barracuda Bay minifigs
should perhaps be given 'pi' numbers instead of 'idea' numbers?
Likewise dimensions Gimli, Gandalf, Legolas should maybe have a 'lor'
number instead of 'dim' same goes for Slimer and Stay Puft Marshmallow
man which also have 'dim' numbers instead of 'gb'
With the original ghostbusters minifigs from Ecto-1 it looks like they were already
changed from 'idea' numbers to 'gb' numbers with an i on the
end which might be a good way to keep some continuity on the site?
|
|
Author: | primadeluxe | Posted: | Jun 13, 2020 07:48 | Subject: | Fancy a quiz about stickers set 374-1? | Viewed: | 70 times | Topic: | Catalog | Status: | Open | |
|
| Here we go: (the answers are on the bottom of this message)
1. How many Classic Fire Logo stickers are on the stickersheet of set 374-1?
2. How many Classic Fire Logo stickers are on the counterparts together?
3. Which counterpart is responsible for the difference?
4. Can we just rename this counterpart? Yes or No?
5. Why not?
6. What can we do about this?
If you have correctly answered all the 6 questions, your price is the title 'logical
thinker of the day'!
Cheers, Wilbert
Answers:
1. Five
2. Six (3009pb043L: one; 3009pb043R: one; 3001oldpb07: two (both sides); BA067pb01:
two (both sides)
3. Part 3001oldpb07 (look closely to the frontpage of the instructions as the
instructions itself are not conclusive)
4. No
5. As counterpart 3001oldpb07 is also related to set 590-1, which has the right
number of Classic Fire Logo stickers on the stickersheet (six), which by the
way is not proven by the (frontpage of the) instructions. But ok .....!
6. I really do not know hahaha! No seriously: add a new counterpart for set 374-1.
|
|
Author: | 1271moggy | Posted: | Jun 12, 2020 07:43 | Subject: | Set 3178 | Viewed: | 64 times | Topic: | Catalog | Status: | Open | |
|
| Just wondering if anyone has a sealed set of .
I am parting out an incomplete set bought off Ebay and have a query with part
.
The current inventory lists the undetermined part 3794 in LBG, but I have found
LBG during part out.
So hence the request for a sealed set to check which variant is used, and to
correct the catalogue if needed.
Linda
|
|
Author: | jsnhghs | Posted: | Jun 11, 2020 03:43 | Subject: | Why listed as US rather than uk? | Viewed: | 95 times | Topic: | Catalog | Status: | Open | |
|
| Please can someone tell me why c88us and c89us are listed as US when it is a
UK catalogue?
|
Author: | DeanS | Posted: | Jun 10, 2020 15:45 | Subject: | Item approval/change request | Viewed: | 45 times | Topic: | Catalog | Status: | Open | |
|
| I have added the image to minifig hp223
I would like to upload my inventory of these
I also have weight: 3.8 grams
and the description should read:
"Cho Chang (Set 40419) Grin / Frown"
Thanks!
-Dean
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|