Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies| Author: | mjah5  | | Posted: | Feb 26, 2024 15:18 | | Subject: | Re: Inventory Change Request for Set 4556-1 | | Viewed: | 44 times | | Topic: | Inventories Requests | |
|
| In Inventories Requests, normann1974 writes:
| | In Inventories Requests, mjah5 writes:
| | Please make changes to the following inventory:
* Delete 4 Part 6014b White Wheel 11mm D. x 12mm, Hole Notched for Wheels Holder Pin
* Add 4 Part 6014a White Wheel 11mm D. x 12mm, Hole Round for Wheels Holder Pin
|
|
| |
Here's an unboxing of set 4556. Watching the full resolution of the image,
I can see the notched hole of one of the wheels:
https://brickshelf.com/cgi-bin/gallery.cgi?i=2655465
It is possible, though, that during their time periods, the sets in question
(4556, 7034, 6636, 6459, 6468) could have come with round hole wheels, but unless
we get visual proof from sealed sets, I believe we will not make changes to these
sets based on speculation alone.
As such, I will reject your requests and you will need to recreate them if you
find solid evidence. Your requests will be kept in the forum for later reference
if the need arises.
/Jan
|
Thank-you for the reply and your research. I see the notched wheels in the image
you provided and I accept your decision. However, if the wheels are to remain
6014b for this set, I would recommend you delete the Inv ID 176898 counter part
30187c01 Yellow Tricycle with Dark Gray Chassis & White Wheels as that tricycle
specifies the 6014a wheel rather than the 6014b wheels.
As there currently no version of the Yellow Tricycle with Dark Gray Chassis &
White Wheels with the 6014b wheels, in the BL catalog, perhaps one could be created
and that one could be added as a counterpart to the set in question.
Kind Regards.
Mark
|
 |
| Author: | mjah5 | | Posted: | Feb 25, 2024 02:11 | | Subject: | Re: Parts 6014 Sets 6468 6459 4556 6636 7034 | | Viewed: | 46 times | | Topic: | Catalog | |
|
| Realized this this is the wrong method to submit chg request. Submitted 5 separate
change requests.
|
|
| Author: | mjah5 | | Posted: | Feb 25, 2024 02:08 | | Subject: | Inventory Change Request for Set 4556-1 | | Viewed: | 46 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Delete 4 Part 6014b White Wheel 11mm D. x 12mm, Hole Notched for Wheels Holder Pin
* Add 4 Part 6014a White Wheel 11mm D. x 12mm, Hole Round for Wheels Holder Pin
Comments from Submitter:
Hello
Collecting parts for 6468-1. Part 6014u is listed. Trying to decide between
6014a and 6014b. Colour of interest is white. Set year is 1999
Observations from catalog:
6014a: all colours 1991-2003, 163 sets -- year 1999, 24 sets -- 16 White,
2 Light Grey, 6 Yellow.
6014b: all colours 1999-2024, 563 sets -- year 1999, 1 set White
Further Part 6014a is a subpart in to Parts:
6014ac01(6014a 6015) and
30187c01 Tricycle with Dark Gray Chassis & White Wheels
Using part 30187c01, a search of the catalog identifies problems with inventories
of the following sets:
1) 6459-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014u
Recommend changing it to 6014a.
2) 6636-1 2002 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
3) 7034-1 2003 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
4) 4556-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
Of most interest to me in regard to set 6468-1 is the likely error in set 4556-1
as it is the only set in the year 1999 where part 6014b appears. I would argue
that if that set is changed to 6014a, then there would be no sets before 2000
where 6014b appears. That would suggest strongly that set 6468-1 should also
be changed to 6014a.
Hope this is helpful to the BL community
Regards
|
|
| Author: | mjah5 | | Posted: | Feb 25, 2024 02:06 | | Subject: | Inventory Change Request for Set 7034-1 | | Viewed: | 26 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Delete 2 Part 6014b White Wheel 11mm D. x 12mm, Hole Notched for Wheels Holder Pin
* Add 2 Part 6014a White Wheel 11mm D. x 12mm, Hole Round for Wheels Holder Pin
Comments from Submitter:
Hello
Collecting parts for 6468-1. Part 6014u is listed. Trying to decide between
6014a and 6014b. Colour of interest is white. Set year is 1999
Observations from catalog:
6014a: all colours 1991-2003, 163 sets -- year 1999, 24 sets -- 16 White,
2 Light Grey, 6 Yellow.
6014b: all colours 1999-2024, 563 sets -- year 1999, 1 set White
Further Part 6014a is a subpart in to Parts:
6014ac01(6014a 6015) and
30187c01 Tricycle with Dark Gray Chassis & White Wheels
Using part 30187c01, a search of the catalog identifies problems with inventories
of the following sets:
1) 6459-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014u
Recommend changing it to 6014a.
2) 6636-1 2002 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
3) 7034-1 2003 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
4) 4556-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
Of most interest to me in regard to set 6468-1 is the likely error in set 4556-1
as it is the only set in the year 1999 where part 6014b appears. I would argue
that if that set is changed to 6014a, then there would be no sets before 2000
where 6014b appears. That would suggest strongly that set 6468-1 should also
be changed to 6014a.
Hope this is helpful to the BL community
Regards
|
|
| Author: | mjah5 | | Posted: | Feb 25, 2024 02:04 | | Subject: | Inventory Change Request for Set 6636-1 | | Viewed: | 23 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Delete 6 Part 6014b White Wheel 11mm D. x 12mm, Hole Notched for Wheels Holder Pin
* Add 6 Part 6014a White Wheel 11mm D. x 12mm, Hole Round for Wheels Holder Pin
Comments from Submitter:
Hello
Collecting parts for 6468-1. Part 6014u is listed. Trying to decide between
6014a and 6014b. Colour of interest is white. Set year is 1999
Observations from catalog:
6014a: all colours 1991-2003, 163 sets -- year 1999, 24 sets -- 16 White,
2 Light Grey, 6 Yellow.
6014b: all colours 1999-2024, 563 sets -- year 1999, 1 set White
Further Part 6014a is a subpart in to Parts:
6014ac01(6014a 6015) and
30187c01 Tricycle with Dark Gray Chassis & White Wheels
Using part 30187c01, a search of the catalog identifies problems with inventories
of the following sets:
1) 6459-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014u
Recommend changing it to 6014a.
2) 6636-1 2002 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
3) 7034-1 2003 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
4) 4556-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
Of most interest to me in regard to set 6468-1 is the likely error in set 4556-1
as it is the only set in the year 1999 where part 6014b appears. I would argue
that if that set is changed to 6014a, then there would be no sets before 2000
where 6014b appears. That would suggest strongly that set 6468-1 should also
be changed to 6014a.
Hope this is helpful to the BL community
Regards
|
|
| Author: | mjah5 | | Posted: | Feb 25, 2024 02:01 | | Subject: | Inventory Change Request for Set 6459-1 | | Viewed: | 25 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Delete 8 Part 6014u White Wheel 11mm D. x 12mm (Undetermined Type)
* Add 8 Part 6014a White Wheel 11mm D. x 12mm, Hole Round for Wheels Holder Pin
Comments from Submitter:
Hello
Collecting parts for 6468-1. Part 6014u is listed. Trying to decide between
6014a and 6014b. Colour of interest is white. Set year is 1999
Observations from catalog:
6014a: all colours 1991-2003, 163 sets -- year 1999, 24 sets -- 16 White,
2 Light Grey, 6 Yellow.
6014b: all colours 1999-2024, 563 sets -- year 1999, 1 set White
Further Part 6014a is a subpart in to Parts:
6014ac01(6014a 6015) and
30187c01 Tricycle with Dark Gray Chassis & White Wheels
Using part 30187c01, a search of the catalog identifies problems with inventories
of the following sets:
1) 6459-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014u
Recommend changing it to 6014a.
2) 6636-1 2002 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
3) 7034-1 2003 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
4) 4556-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
Of most interest to me in regard to set 6468-1 is the likely error in set 4556-1
as it is the only set in the year 1999 where part 6014b appears. I would argue
that if that set is changed to 6014a, then there would be no sets before 2000
where 6014b appears. That would suggest strongly that set 6468-1 should also
be changed to 6014a.
Hope this is helpful to the BL community
Regards
|
|
| Author: | mjah5 | | Posted: | Feb 25, 2024 01:48 | | Subject: | Inventory Change Request for Set 6468-1 | | Viewed: | 30 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Delete 4 Part 6014u White Wheel 11mm D. x 12mm (Undetermined Type)
* Add 4 Part 6014a White Wheel 11mm D. x 12mm, Hole Round for Wheels Holder Pin
Comments from Submitter:
Hello
Collecting parts for 6468-1. Part 6014u is listed. Trying to decide between
6014a and 6014b. Colour of interest is white. Set year is 1999
Observations from catalog:
6014a: all colours 1991-2003, 163 sets -- year 1999, 24 sets -- 16 White,
2 Light Grey, 6 Yellow.
6014b: all colours 1999-2024, 563 sets -- year 1999, 1 set White
Further Part 6014a is a subpart in to Parts:
6014ac01(6014a 6015) and
30187c01 Tricycle with Dark Gray Chassis & White Wheels
Using part 30187c01, a search of the catalog identifies problems with inventories
of the following sets:
1) 6459-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014u
Recommend changing it to 6014a.
2) 6636-1 2002 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
3) 7034-1 2003 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
4) 4556-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
Of most interest to me in regard to set 6468-1 is the likely error in set 4556-1
as it is the only set in the year 1999 where part 6014b appears. I would argue
that if that set is changed to 6014a, then there would be no sets before 2000
where 6014b appears. That would suggest strongly that set 6468-1 should also
be changed to 6014a.
Hope this is helpful to the BL community
Regards
|
|
| Author: | mjah5 | | Posted: | Feb 24, 2024 23:48 | | Subject: | Parts 6014 Sets 6468 6459 4556 6636 7034 | | Viewed: | 88 times | | Topic: | Catalog | | Status: | Open | |
|
| Hello
Collecting parts for 6468-1. Part 6014u is listed. Trying to decide between
6014a and 6014b. Colour of interest is white. Set year is 1999
Observations from catalog:
6014a: all colours 1991-2003, 163 sets -- year 1999, 24 sets -- 16 White,
2 Light Grey, 6 Yellow.
6014b: all colours 1999-2024, 563 sets -- year 1999, 1 set White
Further Part 6014a is a subpart in to Parts:
6014ac01(6014a 6015) and
30187c01 Tricycle with Dark Gray Chassis & White Wheels
Using part 30187c01, a search of the catalog identifies problems with inventories
of the following sets:
1) 6459-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014u
Recommend changing it to 6014a.
2) 6636-1 2002 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
3) 7034-1 2003 lists parts White 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
4) 4556-1 1999 lists parts Yellow 30178c01 Tricycle but incorrectly lists the
white wheel as 6014b
Recommend changing it to 6014a.
Of most interest to me in regard to set 6468-1 is the likely error in set 4556-1
as it is the only set in the year 1999 where part 6014b appears. I would argue
that if that set is changed to 6014a, then there would be no sets before 2000
where 6014b appears. That would suggest strongly that set 6468-1 should also
be changed to 6014a.
Hope this is helpful to the BL community
Regards
|
|
| Author: | mjah5 | | Posted: | May 9, 2021 18:20 | | Subject: | Re: Dark Red Bionicle Weapon Staff of Light Blade | | Viewed: | 43 times | | Topic: | Colors | |
|
| In Colors, LifeInPlastic writes:
My bad. Sorry all.
|
|
| Author: | mjah5 | | Posted: | May 9, 2021 18:15 | | Subject: | Dark Red Bionicle Weapon Staff of Light Blade | | Viewed: | 88 times | | Topic: | Colors | | Status: | Open | |
|
| Hello All, I have two Item # 44813 Bionicle Weapon Staff of Light Blade. They
are neither Flat Silver nor Pearl Light Gray/Grey. I have included photos where
you can see the part number 44813 and the copyright c2002 LEGO Group. As well
on the reverse of both is the number 58813, also visible in the photos. Also
there are currently 13 sellers selling this part under the colour "Dark Red".
One seller includes a photo of the part against a green background. As you
can see the part isn't completely "Dark Red" but rather is partly semi-transparent.
I suggest we formalize this part with this colour scheme and add it to the catalog.
I make no suggestion that colour scheme should be associated with any particular
set, but clearly, it exists.
Regards
|
|
|
| Author: | mjah5 | | Posted: | Aug 9, 2020 15:03 | | Subject: | Inventory Change Request for Set 8154-1 | | Viewed: | 26 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Change {2 to 4} Part White 30586pb03 Plate, Modified 2 x 8 with Door Rail with Tread Plate Pattern (Sticker) - Set 8154 (Counterpart)
Comments from Submitter:
This Set contains 4 of these elements. Two are called for in the 1st instruction book and another two in the second instruction book. The sticker sheet have four of these stickers. Regards
|
|
| Author: | mjah5 | | Posted: | Jul 15, 2020 12:43 | | Subject: | Re: Inventory Change Request for Set 7163-1 | | Viewed: | 15 times | | Topic: | Inventories Requests | |
|
| In Inventories Requests, mjah5 writes:
| | Please make changes to the following inventory:
* Delete 1 Part 2609 Dark Gray Magnet Holder Tile 2 x 2 (Undetermined Type)
* Add 1 Part 2609b Dark Gray Magnet Holder Tile 2 x 2 - Tall Arms with Deep Notch
Comments from Submitter:
The catalog list 2609 (undetermined type) to include the colour Dark Gray. Further catalog items 2609a, 2609b and 2609c do not include the colour Dark Gray. The only set in the catalog with item 2609 (Dark Gray) is 7163-1. My 7163-1 set I can confirm that the Dark Gray element is actually a 2609b. I will attach two photo of the element to confirm shape and colour.
|
|
|
|
| Author: | mjah5 | | Posted: | Jul 15, 2020 12:42 | | Subject: | Inventory Change Request for Set 7163-1 | | Viewed: | 27 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Delete 1 Part 2609 Dark Gray Magnet Holder Tile 2 x 2 (Undetermined Type)
* Add 1 Part 2609b Dark Gray Magnet Holder Tile 2 x 2 - Tall Arms with Deep Notch
Comments from Submitter:
The catalog list 2609 (undetermined type) to include the colour Dark Gray. Further catalog items 2609a, 2609b and 2609c do not include the colour Dark Gray. The only set in the catalog with item 2609 (Dark Gray) is 7163-1. My 7163-1 set I can confirm that the Dark Gray element is actually a 2609b. I will attach two photo of the element to confirm shape and colour.
|
|
| Author: | mjah5 | | Posted: | Jun 21, 2020 16:38 | | Subject: | Re: Terminology - DB to organize my 100,000+ pcs | | Viewed: | 36 times | | Topic: | Catalog | |
|
| 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: | mjah5 | | Posted: | Jun 21, 2020 04:34 | | Subject: | Re: Terminology - DB to organize my 100,000+ pcs | | Viewed: | 35 times | | Topic: | Catalog | |
|
| 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: | mjah5 | | Posted: | Jun 20, 2020 17:36 | | Subject: | Re: Terminology - DB to organize my 100,000+ pcs | | Viewed: | 41 times | | Topic: | Catalog | |
|
| 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 | | Posted: | Jun 20, 2020 16:51 | | Subject: | Re: Terminology - DB to organize my 100,000+ pcs | | Viewed: | 43 times | | Topic: | Catalog | |
|
| 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 | | Posted: | Jun 20, 2020 16:32 | | Subject: | Re: Terminology - DB to organize my 100,000+ pcs | | Viewed: | 39 times | | Topic: | Catalog | |
|
| 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: | 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: | mjah5 | | Posted: | Jun 28, 2018 00:48 | | Subject: | Inventory Change Request for Set 30357-1 | | Viewed: | 21 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
|
| Please make changes to the following inventory:
* Add 1 Minifig cty925 Blue Jacket with Pockets and Orange Stripes, Blue Legs, Red Construction Helmet, Thin Grin (Alternate)
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
Canada, Ontario
)
)
)
)
