| 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
|
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
|