Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies Author: | SylvainLS | Posted: | Nov 10, 2018 15:40 | Subject: | Re: Fourth Catalog Project Underway | Viewed: | 39 times | Topic: | Catalog | |
|
| In Catalog, mfav writes:
| | Well, it could be done with only one field: plain, printed, stickered, moulded…
(I.e. allowing “plain” (nil/null/none/empty…) as a type of decoration.)
|
Maybe. Depends on the results you want to get. It might work in a flat sense
if you limit a part to having only one of those attributes. As an ENUM field,
it would not allow for a printed + stickered + molded part. As a SET field it
would allow for a plain, printed, stickered, molded part (which wouldn't
make sense).
It's a big complicated proposition which would require a big complicated
solution to be highly effective.
|
I prefer one nullable field to twin-fields (boolean field + non-nullable field)
but I’m no DB expert, so efficiency rules (speed-wise and size-wise, but also
readability, extensibility, “error-prone-ness”…) that apply to programs may not
apply to DBs.
Anyway that’s an argument which is only valid if you really insist on doing everything
(or a maximum) on the DB side, and it’s feeble because there’s always something
to be done outside the DB, like verifying what comes in and out of the DB, like
checking for non-sensical values, which should be done even if the DB already
does it.
Well, all that is moot: we’re not in a position to do anything or to propose
anything
|
|
Author: | SylvainLS | Posted: | Nov 10, 2018 14:23 | Subject: | Re: Fourth Catalog Project Underway | Viewed: | 36 times | Topic: | Catalog | |
|
| In Catalog, mfav writes:
| […]
| It would be wonderful if there could be two check boxes for Decorated and Sticker.
|
Now, from a database perspective, this is where it starts to get complicated.
You need to first distinguish between Decorated and Not Decorated. That would
be one field. Then distinguish the type of decoration: sticker, printed, molded...that
would be a second field.
|
Well, it could be done with only one field: plain, printed, stickered, moulded…
(I.e. allowing “plain” (nil/null/none/empty…) as a type of decoration.)
| | However, that actually would require data and some real coding.
|
Yes. That's why I say a new database is needed. The current structure is
pretty long in the tooth.
At the moment problems that would be more elegantly solved by revising the database
are being kludged by attempting to incorporate all the various descriptive attributes
into the item Description/Name. While that may be successful to a degree, it
limits or eliminates the possibilities of providing checkboxes and whatnot to
refine a search.
|
Like alternate numbers which, unless it has changed or I misremember, are poorly
handled with a string field (thus limiting their number and complicating searches).
Anyway, all that could have been rendered painless if not at the design stage,
at least in a redesign, by abstracting and factoring the database access.
|
|
Author: | SylvainLS | Posted: | Nov 10, 2018 12:48 | Subject: | Re: Baseplates not (easy) to find | Viewed: | 45 times | Topic: | Catalog | |
|
| In Catalog, building4ever writes:
| | The Years Released data for parts and sets only refers to the year they were
FIRST released, not all the years they were produced and available in stores.
The old Death Star 10188 only has 2008 as its Year, even though it was produced
for many years after that.
Is that what you are asking?
Jen
|
Thank you, but I still find it confusing. Because the base plate 48x48 gray is
indicated as "Years Released: 1980 - 2016".
I would interpret this as a "final" production year (which is wrong), Similar
for 3811 (at least saying 1978-2018).
|
A precision: As Jennifer said, the years for the sets are the years the sets
were first released. But the years for the parts are the oldest and newest years
of the sets they appear in, they are automatically calculated.
|
|
Author: | SylvainLS | Posted: | Nov 8, 2018 15:29 | Subject: | Re: Catalog: Strongly disagree 3830c0 deletion | Viewed: | 57 times | Topic: | Catalog | |
|
| In Selling, StormChaser writes:
| […]
Until I get around to addressing this issue, part assemblies are kind of up
in the air.
|
This one seems more 6 ft under than up in the air.
|
Author: | SylvainLS | Posted: | Nov 8, 2018 14:52 | Subject: | Re: Q about (Other) Minifigures Have Moved! | Viewed: | 27 times | Topic: | Catalog | |
|
| In Catalog, randyf writes:
| […]
Turns out that I can see those X's and faded-yellow backgrounds because of
my Administrative privileges now. I really think those additions should be added
for everyone. I will see if I can bump this suggestion up the chain.
|
Perks of the position
|
|
Author: | SylvainLS | Posted: | Nov 8, 2018 11:46 | Subject: | Re: Try that again | Viewed: | 31 times | Topic: | Catalog | |
|
| In Catalog, Rob_and_Shelagh writes:
| In Catalog, calsbricks writes:
| - Not swure thie is correct in the catalogue. In all 3 sets that
it comes in there is an white rubber band which holds the two halves
together. The instructions show the rubber band being used in each case. Should
there be an inventory for the part?
|
As currently set up in the catalogue 29112pb01 is for 1 piece i.e. half of the
assembly
|
Maybe add a simple line in the picture to show it’s both sides of the same part
and not two parts.
| and the band is just another separate part. For an assembly the inventory
would need to be 2 x 29112pb01 plus one band but typically assemblies like this
are not catalogued.
|
It would need a pin too
|
|
Author: | SylvainLS | Posted: | Nov 5, 2018 09:16 | Subject: | Re: Inventory Change Request for Set 6445-1 | Viewed: | 18 times | Topic: | Inventories Requests | |
|
| In Inventories Requests, Hygrotus writes:
| […]
oops, this shows how careful you must be, almost missed it How there is in
sealed bag part with sticker applied? Bags were reseald evidently.
|
Soon, there’ll be deepfakes videos of LEGO sealed sets opening
|
|
Author: | SylvainLS | Posted: | Nov 5, 2018 09:03 | Subject: | Re: Inventory Change Request for Set 21309-1 | Viewed: | 16 times | Topic: | Inventories Requests | |
|
| In Inventories Requests, Hygrotus writes:
| In Inventories Requests, SylvainLS writes:
| * Add 8 Part 44302a Dark Bluish Gray Hinge Plate 1 x 2 Locking with 2 Fingers on End with Bottom Groove (match ID 1)
* Change 8 Part Dark Bluish Gray 44302 Hinge Plate 1 x 2 Locking with 2 Fingers on End (undetermined type) {Regular to Alternate} {match ID 0 to 1}
|
In this situation when only undetermine was in inventory and no related alternate
we can get rid off this undetermine You checked variant from sealed set content.
In this situation we simply change undetermine to confirmed variant.
|
The “no related alternate” part of the rule was a bit fuzzy in my mind (half-remembering
the 4599 Tap situation)
| Everything will be approved and I will correct it manualy.
|
Thanks.
|
|
Author: | SylvainLS | Posted: | Nov 5, 2018 08:00 | Subject: | Inventory Change Request for Set 21309-1 | Viewed: | 22 times | Topic: | Inventories Requests (Entry) | Status: | Open | |
|
| Please make changes to the following inventory:
* Add 8 Part 44302a Dark Bluish Gray Hinge Plate 1 x 2 Locking with 2 Fingers on End with Bottom Groove (match ID 1)
* Change {1 to 2} Part Light Bluish Gray 24246 Tile, Modified 1 x 1 Half Circle Extended (Stadium) with Groove (Extra)
* Change {2 to 4} Part Pearl Gold 85861 Plate, Round 1 x 1 with Open Stud (Extra)
* Change 8 Part Dark Bluish Gray 44302 Hinge Plate 1 x 2 Locking with 2 Fingers on End (undetermined type) {Regular to Alternate} {match ID 0 to 1}
Comments from Submitter:
Sealed set.
85861 appears in 4 bags, 24246 appears in 2 bags, each bag had one extra for them.
|
|
Author: | SylvainLS | Posted: | Nov 4, 2018 12:45 | Subject: | Re: Inventories pending approval | Viewed: | 17 times | Topic: | Inventories | |
|
| In Help, Hygrotus writes:
| In Help, SylvainLS writes:
| Is there a way to find it
|
Yes go to Catalog main page, find section What's New, column "More" there
you have "Pending approval". There is everything what is pending: items, images,
invetories, change requests.
|
Many thanks again!
|
Author: | SylvainLS | Posted: | Nov 4, 2018 12:17 | Subject: | Re: Inventories pending approval | Viewed: | 22 times | Topic: | Inventories | |
|
| In Help, Hygrotus writes:
Many thanks!
Is there a way to find it or should I bookmark the page?
(Not linked from the Catalog/Inventories page https://www.bricklink.com/catalogInv.asp
)
|
|
Author: | SylvainLS | Posted: | Nov 4, 2018 09:42 | Subject: | Inventories pending approval | Viewed: | 87 times | Topic: | Inventories | Status: | Open | |
|
| Is there a way to see an inventory which is “pending approval” (when you’re not
the submitter)?
Or at least a way to know why it’s pending?
I can’t find either….
|
|
Author: | SylvainLS | Posted: | Nov 4, 2018 08:29 | Subject: | Re: Second Catalog Project Underway | Viewed: | 30 times | Topic: | Catalog | |
|
| In Catalog, Lauren_Luke writes:
| [Teup] writes:
| Now I'm confused, I thought this beehive shape is a cartoonesque representation
of bee/wasp nest in trees (that actually look like this)?
|
Yes, you are right, the ' cone ' shape is a cartoonesque representation
of a bee nest, naturally made by bees. [Do an image search on ' Bee
Nest ']. The real thing is more a ball or egg shape in dark tan (ish) color/colour.
Bee hives are man/minifig made and bee nests are naturally made
by bees.
|
They are wasp and hornet nests, not bee.
|
|
Author: | SylvainLS | Posted: | Nov 4, 2018 08:28 | Subject: | Re: Second Catalog Project Underway | Viewed: | 32 times | Topic: | Catalog | |
|
| In Catalog, Teup writes:
| […]
Now I'm confused, I thought this beehive shape is a cartoonesque representation
of bee/wasp nest in trees (that actually look like this)? Or are they like
jugs or something like that made by beekeepers? I tried to google but I don't
find any "real" version (man made or otherwise) of this type of beehive, that's
why I'm still not sure... :o
|
Look at Wikipedia, they have pictures (esp. on English and French versions, a
little less on the “Nederlands” one).
Some wasps and hornets make roundish nests (cardboard-looking material which
is actually saliva and dirt or wood), but they don’t show rings. And they aren’t
bees.
Only some man-made rope hives show rings.
And man has kept bees for milleniums, so the shape is in our cultural memories.
| So my comparison with spiderweb could be off, though it doesn't exactly matter
for the Animal,Accessory argument in and of itself because they are usually man
made anyway.
|
Without the rapid official use as a cotton-candy, I’d actually have agreed with
the Animal, Accessory possibility.
| But you're right if this part will be used for other stuff in the future.
It would be much like the fez situation then. I don't actually expect it,
but let's see.
I'm actually ok with minifig hat
|
Yes, because it goes around a head but on the other hand, when you have the piece
in hand and don’t know what it is, do you readily realize it goes around a head
and think “Hat!” or do you first look at its conical shape?
Tough case
|
|
Author: | SylvainLS | Posted: | Nov 4, 2018 07:44 | Subject: | Re: Second Catalog Project Underway | Viewed: | 28 times | Topic: | Catalog | |
|
| In Catalog, Teup writes:
| Mostly positive changes, thanks for the update. I am sorry but...reeeeaally people.....
the beehive.... noooooo
Please think about it. If a SPIDER-WEB is Animal,Accessory then a BEE-HIVE, surely
is Animal,Accessory too? I even saw someone even suggesting Minifig,Utensil and
I wonder where on earth that came from, as it has neither to do with minifigs
(except as headgear), nor utensils...
|
As WoutR already pointed out, Beehives aren’t made by bees but by minifigs… er
humans.
Bees live in hollow trunks or such cavities, they don’t build such nests.
| The beehive discussion really has me tearing
my hair, to me it feels like there's some wheel and people go "hmmm... 'door'
maybe? or 'aircraft'?"
Just promise me when LEGO releases a bird nest, then SPIDER-WEB, BEE-HIVE, and
BIRD-NEST will all be Animal,Accessory
|
This part already is:
1. a (man-made) beehive,
2. a cotton-candy,
And it can be:
3. a wasp or hornet nest,
4. a Chinese lantern,
5. a Bibendum head,
and undoubtedly many many other things, especially when other colours will appear.
It already has too many very different usages.
Therefore, we can’t categorize it according to its usages.
Therefore, we only can use its shape and connectivity for categorization purposes.
(Moreover and anyway, shape and connectivity should always be the main features
used for categorization as usage generally isn’t known when you stumble upon
the part and are using the catalogue to find it.)
And this part is cone-based, sort of, and can go on a minifig head.
So it’s a Cone or a Minifig Hat.
QED
|
|
Author: | SylvainLS | Posted: | Nov 3, 2018 21:58 | Subject: | Re: Second Catalog Project Underway | Viewed: | 46 times | Topic: | Catalog | |
|
| In Catalog, StormChaser writes:
| […]
| Slides - create new category titled Slide
|
Not many people objected here, but some felt the rope bridge was a problem and
wanted to see these all combined with stairs and conveyors in one category.
The problem would be titling that category. You may notice that there aren't
many (if any) part categories which have titles like Stairs, Conveyors, Bridges,
and the Like. Part categories are simple, direct, and singular. That was wise
and I'd like to keep it that way. So I'll hold off on this one, too,
for further thought and await any further comments.
|
Building Elements would have been my suggestion if it could be understood
in a restricted sense.
Or Large Building Elements.
| | Power Bursts - move to Minifigure, Utensil
|
The consensus here was a new category titled Effect. Not a bad idea, but it
seems like it would be hard to understand. Even Power Effect seems questionable,
though better. It would be great if we could come up with a title to describe
all forms of effects (waves, flames, power bolts, etc.) and group them all together
as suggested.
I thought Plasma Effect would be perfect, but Wikipedia tells me that flame is
not a plasma. So what about Plasma / Gas Effect?
|
(BURP is already in use….)
And aren’t some of them neither plasma nor gas (nor liquid) but energy? Qi/chi?
Phlogiston?
| Still no mention of flame
in the title, though, which some wanted to see.
|
(Wow, dangerous to mix Flame with Gas Effects….)
| Open to suggestions and am hoping
for some along these lines.
|
What about Powers and Natural Effects?
That would cover supernatural projections and simple flames and spouts/jets/waves.
|
|
Author: | SylvainLS | Posted: | Nov 2, 2018 08:54 | Subject: | Re: Quattro Leg? | Viewed: | 25 times | Topic: | Catalog | |
|
| In Catalog, WhiteVanMan writes:
| […]
| I don’t know anything about McDonald’s characters, but wouldn’t Quattro be their
here-depicted four-legged spiderish characer?
|
What you have said does kinda make sense, but surely the naming of the set could
be a little 'clearer'?
|
Yes it could
|
|
Author: | SylvainLS | Posted: | Nov 2, 2018 08:13 | Subject: | Re: Quattro Leg? | Viewed: | 23 times | Topic: | Catalog | |
|
| In Catalog, WhiteVanMan writes:
| Hi
I saw this on Amazon Prime, and I was instantly curious as to what the name really
means
Why is this packaged as a McDonalds set, and it has nothing to do with Quattro?
Maybe this is an item that needs to be 'sorted out'?
|
I don’t know anything about McDonald’s characters, but wouldn’t Quattro be their
here-depicted four-legged spiderish characer?
|
|
Author: | SylvainLS | Posted: | Nov 1, 2018 12:23 | Subject: | Re: Part 3062old in projects AFOL | Viewed: | 45 times | Topic: | Suggestions | |
|
| In Suggestions, jpascual writes:
| […]
I did not know that the part 3062old has not been made for 50 years
|
On the part’s page, on the right of the picture, there’s the period the sets
in which the part appears.
The last time there was a set in which 3062old was included was 1967:
Be careful using this info for other parts though because the dates are those
of the sets. Sets that have been produced for a long time often have had their
latest runs use newer variants.
I could say it’s because the “modern” round brick is more versatile or whatever
(e.g. it can be place in the center of 4 studs) but that kind of decision often
ends up in:
The Ways Of The LEGO Group Are Mysterious
| because she is so useful and prettier than the two current versions
of the 3062. Could not do it again?
|
For similar purposes, they made
but they also discontinued this one.
Now they use
with pins.
You can also use
with a
|
|
Author: | SylvainLS | Posted: | Nov 1, 2018 09:35 | Subject: | Re: Part 3062old in projects AFOL | Viewed: | 36 times | Topic: | Suggestions | |
|
| In Suggestions, Biglesdug writes:
| In Suggestions, jpascual writes:
| Allow use of part 3062old in the projects for AFOL. It is prettier than the current
3062 and allows to make thinner columns more elegant.
|
Are you not allowed to use them now?
|
jpascual is talking about the Studio contest.
And 3062old is not an “active” part allowed in submissions. It’s not been produced
for more than 50 years!
|
|
Author: | SylvainLS | Posted: | Nov 1, 2018 09:25 | Subject: | Re: Catalog Project Request "Bar" vs. "Weapon" | Viewed: | 27 times | Topic: | Catalog | |
|
| In Catalog, Teup writes:
| […]
And, the 4L Bar is called "Bar 4L (Lightsaber Blade / Wand)", so I'd say
the other one is something like "Bar 1L with top and bottom stud (Lightsaber
Hilt)"
|
Actually, it’s 1.6L long if you don’t count the studs. That is, between two
plates attached to the studs, there’s room for 4 plates.
|
|
Author: | SylvainLS | Posted: | Oct 31, 2018 21:33 | Subject: | Re: Catalog Project Request "Bar" vs. "Weapon" | Viewed: | 29 times | Topic: | Catalog | |
|
| In Catalog, StormChaser writes:
| […]
To make an attempt at answering your question: this project will not launch until
we have clear written definitions for every single part category. At that time
any parts which do not fit their category definitions will be moved. Again,
I have no idea how long any of this will take or exactly how disruptive it will
be.
|
Hmm, that means some of the “(Other)” parts that are being categorized right
now might end up being moved again in a few weeks.
|
|
Author: | SylvainLS | Posted: | Oct 31, 2018 21:00 | Subject: | Re: Second Catalog Project Underway | Viewed: | 23 times | Topic: | Catalog | |
|
| In Catalog, brikomania writes:
| […]
Same goes for the hilt. The standard hilt is only used as a minifig hilt, right?
|
Wrong. It’s used for many things, just look at the pictures of the sets it has
been used this year alone: https://www.bricklink.com/catalogItemIn.asp?P=64567&in=S&itemYear=2018&ov=Y
| However that hilt-looking bar is used for other things so it makes sense for
it to be a bar.
|
|
|
Author: | SylvainLS | Posted: | Oct 31, 2018 18:51 | Subject: | Re: Second Catalog Project Underway | Viewed: | 33 times | Topic: | Catalog | |
|
| Okay, okay, I can’t refrain myself anymore:
Why is there a project for a second catalogue? The first one isn’t finished
yet.
There. I feel better. Sorry to unburden here. I’m out.
|
Author: | SylvainLS | Posted: | Oct 29, 2018 19:50 | Subject: | Re: Some recessed studs are recessed. | Viewed: | 39 times | Topic: | Catalog | |
|
| In Catalog, mfav writes:
| […]
I'll attach the first image without lines. If you think it's easier to
tell the difference without the lines please let me know.
|
*facepalm*
I see it now: I wrongly understood the stud was deeper, not also lower, so I
saw what I wanted to see.
Too many lines for my feeble mind
The last “two-halves” picture you posted is perfect.
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|