Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies| Author: | SylvainLS  | | Posted: | Oct 11, 2019 18:01 | | Subject: | Re: Undetermined 3183 | | Viewed: | 51 times | | Topic: | Catalog | |
| In LEGO, axaday writes:
| |
I have this in a set and I want to determine it, but I'm a little lost.
It has the 4 slots, but I can't tell from the limited pics the long and short
socket. Can someone help?
|
The four I have are the same length but as one has two slots and the others 4,
I guess they are all “long.”
The length is a bit more than a stud: you can’t put a brick in front of the socket
and aligned on studs. (You can put a plate because the slots are high enough
for the tiny “bit more.”)
Oh, if you have
those are shorter, by around 1mm.
|
 |
| Author: | SylvainLS | | Posted: | Oct 10, 2019 18:28 | | Subject: | Re: Brick Color | | Viewed: | 31 times | | Topic: | Colors | |
| In Colors, iprice writes:
| | […]
I concur with the brownish looking older greys.
The light greys look yellow compared to lbg.
|
Yes. The “Bluish” aren’t bluish, they are really grey. They only appear bluer
than the old greys because those were actually yellowish. But they already had
a name and people were used to their names and tints, so the newer ones were
named “Bluish.”
|
|
| Author: | SylvainLS | | Posted: | Oct 10, 2019 15:35 | | Subject: | Re: Brick Color | | Viewed: | 42 times | | Topic: | Colors | |
| In Colors, linesbusy writes:
| | How do you tell the difference between Dark Grey and Dark Bluish Grey bricks?
I want to make sure I purchase ones that match what I already have.
|
Depends, what do you have? 
If it’s post-2005, it’s DBG.
If it’s pre-2004, it’s DG.
In between, well, the Big Colour Shift happened in 2004 but LEGO used their stocks
for a while 
You can also check the inventories of your sets. If both greys were used for
a set, it’s generally noted in the inventory (Alternates section).
Also some parts exist only, or are much more frequent, in one dark grey.
|
|
| Author: | SylvainLS | | Posted: | Oct 10, 2019 11:24 | | Subject: | Re: 49699 a Panel?! | | Viewed: | 41 times | | Topic: | Catalog | |
| In Catalog, Turez writes:
| | In Catalog, Teup writes:
| |
I can't discover anything panel-ish about this part. I'd say it's
window, door, technic, other, vehicle, or pretty much anything except a panel...
 What do you think it should be?
|
Since
is an arch, 49699 should perhaps just be a slope
|
I don’t quite follow the logic here
Half an arch might be a slope but, surely, an arch + an inverted arch is not
a slope, it’s a cylinder! 
| | At least it has something in common with
|
Okay but then it should be a Slope AND a Slope Inverted. And both Double. So
does that make it Quadruple or Double-Double?
We really need a catmin who is used to deep and rigorous classifications.
I don’t know, maybe an entomologist or something like that? 
|
|
| Author: | SylvainLS | | Posted: | Oct 10, 2019 09:16 | | Subject: | Re: 49699 a Panel?! | | Viewed: | 62 times | | Topic: | Catalog | |
| In Catalog, firestar246 writes:
| | In Catalog, Teup writes:
| |
I can't discover anything panel-ish about this part. I'd say it's
window, door, technic, other, vehicle, or pretty much anything except a panel...
What do you think it should be?
|
My first thought is technic or window frame
|
Well:
1. Window (or door) frame implies you could put a glass or panel (or door)
inside. That seems very unlikely with the technic holes in the way.
2. It’s been used in System (City) sets for now BUT it sure looks like a Technic
Brick, yet not really.
So Technic could do but not really “Technic Brick” and there are no similar parts
(that I know of) in the other Technic categories, that would mean it should fall
in the general “Technic” category, which is already overpopulated.
I’m not envying the catmins
|
|
| Author: | SylvainLS | | Posted: | Oct 8, 2019 14:17 | | Subject: | Re: How rare is a flat silver 2x4 brick? | | Viewed: | 83 times | | Topic: | Colors | |
| In Colors, mmookk61 writes:
| | […]
It took me a while but I misunderstood the purpose of this post at first. I
had originally thought that it was to arrange a trade for a rare brick for possibly
another rare brick. You know, 3 or 4 messages to establish the trade. Then
the trade happening via bricklink Private messages because, why would anyone
one else be interested in the details of one person's trade?
However, as I stated, I was wrong. This thread was meant to be a long, rambling,
time consuming library of Australian slang and possibly insults(I don't truthfully
know as I don't have the Australian to American translator to hand).
|
Looks like Devil.R is not alone¹: they answer multiple times to the same messages
and they keep answering to themselves.
(¹That expression may have a figurative colloquial meaning, at least it has one
in French, but I’m not implying that. IOW, if you think I’m saying something
demeaming, honi soit qui mal y pense )
That thread could be a bit more sufferable if other people² (whose answers trigger
my reading: I’m an optimist and always hope for something useful to be said)
would correctly cut the quotes, and eventually decide if they want to top-post
or bottom-post.
(²Regulars should lead by example.)
| | Shoot yeah! Let's make this thread a record breaker of waste. See you all
here again and soon and often 
|
Someone’s waste is someone else’s treasure. Well, sometimes
|
|
| Author: | SylvainLS | | Posted: | Sep 12, 2019 19:26 | | Subject: | Re: Change time zone | | Viewed: | 38 times | | Topic: | Suggestions | |
| In Suggestions, hpoort writes:
| | In Suggestions, HallBricks writes:
| | It would be great if I could change the time zone on BrickLink. Maybe not the
most necessary feature, but it feels like it wouldn't be that difficult of
a thing to implement.
|
Have you ever thought about it's complexity?
|
Very simple: everything is stored in UTC and presented in a local/chosen TZ.
The UTC → local TZ conversion is done with a standard, well tested library.
There. The complexity is outsourced.
Besides, it’s just about presentation. Official times are those in the database,
on the server, in UTC.
I stopped watching after he began talking about DST (“autumn in England”).
And that’s absurd. He talks about a programmer who:
1. doesn’t know what TZs are,
2. adds cases one by one instead of, finally, learning what’s it about,
3. and thus reinvents the wheel, spoke by spoke.
Yes, timezones are complex (and involve politics, therefore also totally insane)
and that’s why you don’t cobble up something in your garage.
Yes, timezones change frequently (remember, politics), but you just update the
TZ data the library uses.
One could do the same kind of video about 3D geometry or any other complex or
complicated but already well known feature.
Just showing a given UTC time in a chosen TZ should be easy peasy.
|
|
| Author: | SylvainLS | | Posted: | Sep 7, 2019 11:59 | | Subject: | Re: found wrong category | | Viewed: | 30 times | | Topic: | Catalog | |
| In Catalog, Teup writes:
| | […]
So if printed parts never even have a different category than their parent part,
why is it apparently needed that these parts are assigned a category manually? […]
|
There are lots of reasons why something isn’t automatized. The main ones are:
1. You have to realize it’s stupid work.
2. “You can automatize that?!” The users don’t even know they can ask for it
to be done.
3. And, of course, “there’s something else more urgent to do.”
You thought about it because you’re lazy (in a good way ) and you needed to
do the job yourself.
|
| Author: | SylvainLS | | Posted: | Sep 7, 2019 11:48 | | Subject: | Re: found wrong category | | Viewed: | 38 times | | Topic: | Catalog | |
| In Catalog, Teup writes:
| | […]
(or better: change the "legs assembly" category in "lower body" and move all
short legs, mermaid tails and ghost lower bodies there too) […]
|
Yes, please.
|
| Author: | SylvainLS | | Posted: | Aug 26, 2019 17:19 | | Subject: | Re: Do part numbers change? | | Viewed: | 26 times | | Topic: | Catalog | |
| In Catalog, Teup writes:
| | […]
€20 I spent on a programmer
|
That’s what, one pizza and a coke?
|
| Author: | SylvainLS | | Posted: | Aug 25, 2019 12:29 | | Subject: | Re: Excel | | Viewed: | 34 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | […]
| | It worked fine until point 7
Then I just got error messages.
|
=VLOOKUP(E3;"$Page2.$A$3.$B$217";2)that's my formula
|
Ah, okay, my fault: no quotes around the region.
And to get the correct values for the region, try this:
— start editing the cell by deleting the region,
— do not validate, just let the text cursor where the region will be,
— go to the page with the colour and select the area (the two columns with colours
IDs and names), the formula should now have the correct region,
— validate.
If that cell now has the correct value, then you can edit the formula again to
add the $ so you can use it in the other cells.
|
|
| Author: | SylvainLS | | Posted: | Aug 24, 2019 12:27 | | Subject: | Re: Excel | | Viewed: | 41 times | | Topic: | Inventories | |
| In Inventories, BarbaraH writes:
| | […]
| | Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
Okay, this is obviously beyond my skill set. Anyone like to show me, preferably
via screen shots, exactly how to do this. Please.
|
For the first part:
1. Download the set inventory as Tab-delimited (should give you a “S-NNN-1.txt”
file).
2. Open Excel, open the file from Excel (or drag and drop it), it should give
you an import dialog where you can tweek things (delimiters, how numbers are
read, locale…) but you shouldn’t have to change anything because the tab-delimited
file is pretty simple/default.
You should now have the inventory in a table.
If you want to get colour names instead (or rather, besides) their code, well,
my Excel is a bit rusty (I use LibreOffice now) but this should do it:
1. Download the colour table as Tab-delimited (should give you a “colors.txt”
file).
2. Open it from Excel like above.
Note that it should be possible to cross/match from an external file but I’m
not sure how, so we’ll do it in one file, the one we have the inventory in.
3. Select and copy the first two columns (others are not needed).
4. Go back to the inventory file.
5. Create a new page (it’s cleaner) and paste the colours names and IDs.
6. Add a column in the inventory for the colour names.
7. Use the VLOOKUP function for the first item: “=VLOOKUP( E3 ; region ; 2 )”.
“E3” should be the cell with the colour code for the first item (line 3). “region”
is the whole region with the colours in the second page (e.g. “$Page2.A3.B217”).
“2” is because we want the value in the 2nd column, the colour name.
8. Add a $ before every value in the region (e.g. if it was “$Page2.A3.B217”,
make it “$Page2.$A$3.$B$217”). That will block the values (they won’t change
when the formula is moved or copy-pasted or dragged.
9. Apply the formula all the way down, for all the items by dragging the bottom-right
handle.
Now all the items have the colour code and names.
Hope that’s clear and helping
|
|
| Author: | SylvainLS | | Posted: | Aug 24, 2019 10:18 | | Subject: | Re: Excel | | Viewed: | 41 times | | Topic: | Inventories | |
| In Inventories, paulvdb writes:
| | In Inventories, BarbaraH writes:
| | In Inventories, BarbaraH writes:
| | Is there a way of downloading an inventory of a specific set as an Excel file?
|
The two file options in the download tab are not Excel
|
You can open the tab-delimited text file in Excel and save it as an Excel file.
|
Actually, you could also import the XML version but the tab-delimited file contains
the items current names
Colours are only numbers though. So you’ll need to import the colour table (same
form) to cross the tables.
|
|
| Author: | SylvainLS | | Posted: | Aug 21, 2019 16:56 | | Subject: | Re: Cardboard sleeves in inventories | | Viewed: | 53 times | | Topic: | Inventories | |
| In Inventories, yorbrick writes:
| | […]
It is probably a stupid question, but does BL have a test server where such changes
can be tried out without affecting how regular users use the site or allowing
regular users to snoop or interrupt the testing of ideas?
It seems crazy that any ideas that get tried out (that do affect regular users)
need to be made on the client facing server.
|
(Snide: BL doesn’t even have _one_ working website. )
There was a second website where users (mainly sellers) were encouraged to go
when BL2 was to come (the new skin, the new main page, the new WLs, etc.). It
had an older version of the database, with no impact on the actual database.
Some people went there, made bug reports and remarks, and then the update was
put in production as it was and the people who didn’t go to the second site were
angry because they hadn’t known and those who went were angry too because they
weren’t heard.
And then everybody was adverse to any change. Go figure.
Anyway, the “sleeves” changes are on the catalogue, the database, not the website,
its skin and features. So that would mean the catmins would have changed a copy
of the database, then told us “eh, go see what we did,” and then we would have
had a discussion, and maybe a few back and forth, and in the end, they would
have to do all the final changes again on the real database because they don’t
have a direct access to the database and can’t write scripts or do partial saves
and partial updates and the actual database would have changed in the meanwhile
too.
|
|
| Author: | SylvainLS | | Posted: | Aug 11, 2019 09:02 | | Subject: | Re: 4460 a/b: wrong height | | Viewed: | 34 times | | Topic: | Catalog | |
| In Catalog, JusTiCe8 writes:
| | Thank you both for the heads up.
Still, parts have "Size: 2 x 1 x 3 in studs"
This is the issue, when many units are used, they have to be explicitly written
to avoid such confusion, as history tells us, help page on BL are not enough.
I suggest to add a note on each single page of inventory for parts (done
by front "code" obviously, default design for parts for instance) about the units
used. Kind of studs from width/length, brick height for height.
|
Or that the size be formatted as “2 x 1 x 3 (studs x studs x bricks)” or, better,
“2 studs x 1 stud x 3 bricks.”
And these suggestions have been made almost every time a remark such as yours
was made but nothing changed
|
|
| Author: | SylvainLS | | Posted: | Aug 10, 2019 17:55 | | Subject: | Re: Inventory Change Request for Set 6386-1 | | Viewed: | 26 times | | Topic: | Inventories Requests | |
| In Inventories Requests, ziddi writes:
| | Please make changes to the following inventory:
* Add 1 Part 3022 Black Plate 2 x 2
* Add 1 Part 3176 Black Plate, Modified 3 x 2 with Hole
Comments from Submitter:
Steps 10 and 13 of the helicopter, pages 3 and 4
|
Déjà dans l’inventaire, en Alternate.
Il y a une note dans l’inventaire:
«
Redesigned during production.
There are at least 2 different versions of instructions for this set. The differences
for the second version are indicated in this inventory in the Alternate Items
section with Match ID 99.
Quick overview of redesign: The attachment of the rotor assembly on the helicopter
was upgraded for increased stability of the rotor and tail section.
»
|
|
| Author: | SylvainLS | | Posted: | Aug 1, 2019 12:16 | | Subject: | Re: 928 wrong plate? | | Viewed: | 58 times | | Topic: | Catalog | |
| In Catalog, legoman77 writes:
| | […]
It is hard to believe that Lego makes
mistakes, most of us think that they are gods on Mt Olympus. They also contribute
to problems and often in the distant past put whatever they had into sets. The
old set 800 (I think that that is the number) called for a garage and they substituted
something totally different. They had ran out of the correct parts.
|
Considering Greek gods are far from paragons of perfection, subject to their
whims, inconsistent, unreasonable, and uncaring of us, mortals, I’d say “most
of us” are on to something here
|
|
| Author: | SylvainLS | | Posted: | Jul 31, 2019 13:16 | | Subject: | Re: How to compare parts lists with my inventory | | Viewed: | 28 times | | Topic: | Inventories | |
| In Inventories, VOTB writes:
| | If you put all the items you want into a "want list" you can visit your own store
and see what parts you have that are on that want list.
At the top of the page under your "Shop," "Terms," and "Feedback" tabs you will
see "Wanted List." If you click on that you can cycle through your want lists
and see what you have.
|
And you can part out a set in a WL here: https://www.bricklink.com/v2/wanted/partout.page
|
|
| Author: | SylvainLS | | Posted: | Jul 26, 2019 11:13 | | Subject: | Re: Either a bonafide brain-fart, or a seizure... | | Viewed: | 37 times | | Topic: | Suggestions | |
| In Suggestions, Teup writes:
| | In Suggestions, SylvainLS writes:
| | In Suggestions, cycbuild writes:
| | In Suggestions, Teup writes:
| | In Suggestions, cycbuild writes:
| | Sylvain has spent a lot of time familiarizing himself with BrickLink, and is
a frequent contributor here. There's no need to be so relentlessly dismissive.
|
I agree. But in all fairness we can't ignore the question in the back of
our minds: When is this guy finally going to buy some more LEGO?
|
|
My wallet has the reverse question
Though getting around 700€ of LEGO for around 15€ thanks to coupons and destocking
made us both quite happy a couple months ago
|
Wow!  Then my question changes... Why is this guy not selling any LEGO?
|
What, with all the problems you sellers continuously whine about on the forum?
Besides, MY precious, MINE!
|
|
| Author: | SylvainLS | | Posted: | Jul 26, 2019 10:00 | | Subject: | Re: Either a bonafide brain-fart, or a seizure... | | Viewed: | 45 times | | Topic: | Suggestions | |
| In Suggestions, cycbuild writes:
| | In Suggestions, Teup writes:
| | In Suggestions, cycbuild writes:
| | Sylvain has spent a lot of time familiarizing himself with BrickLink, and is
a frequent contributor here. There's no need to be so relentlessly dismissive.
|
I agree. But in all fairness we can't ignore the question in the back of
our minds: When is this guy finally going to buy some more LEGO?
|
|
My wallet has the reverse question
Though getting around 700€ of LEGO for around 15€ thanks to coupons and destocking
made us both quite happy a couple months ago
| | ::Gallic shrug::
|
Indeed
|
|
| Author: | SylvainLS | | Posted: | Jul 26, 2019 08:07 | | Subject: | Re: Either a bonafide brain-fart, or a seizure... | | Viewed: | 42 times | | Topic: | Suggestions | |
| In Suggestions, popsicle writes:
That’s not funny. That’s insulting.
| | I don't know what you're babbling about here in your sleep
deprived state
|
And another insult.
| | Here is what I actually said "I really don't know if I'll take your advise
on this particular question, as earnestly as I would some others here. You've
got no skin in the game, as they say."
|
And I said, several times:
1. Buyers are a part of the selling game. Or please explain to me to whom would
you send those notifications and who’s gonna pay for the orders?
Might I remind you sellers only get a bit more than 97% of the money whereas
buyers pay 100%.
2. You linked a message from a 0-fb buyer as motive for this idea.
Can’t you just even answer arguments with counter arguments? Do you have to
always resort to condescension and making fun of people in every discussion you
take part?
I thought this time would be different because you started the thread but I was
wrong. You still believe it’s some sort of game of which you’re the best player
and in which you can loftily praise and admonish.
You’re just a bully.
|
|
| Author: | SylvainLS | | Posted: | Jul 25, 2019 23:56 | | Subject: | Re: Either a bonafide brain-fart, or a seizure... | | Viewed: | 41 times | | Topic: | Suggestions | |
| In Suggestions, popsicle writes:
| | […]
| | | | gallic friend, as a non seller and not much of a buyer (it
would appear from your history here) I really don't know if I'll take
your advise on this particular question, as earnestly as I would some
others here. You've got no skin in the game, as they say.
|
You’re talking about sellers reaching to buyers. I’d have thought buyers’ opinions
would be of interest to you.
But maybe it’s a cultural thing. After all, EU is opt-in while the USA are opt-out.
Recipients like to be in the loop here, not treated like kettle/cattle….
Besides, if you only consider sellers or very frequent buyers then I don’t understand
why you linked the message of a zero feedback buyer as a motive for your idea.
Or is there a “too much but not enough” range of buyers you’re excluding?
| | But I am glad you came out to play with me again
|
Make up your mind: you just said you don’t want me and my kind on the field
|
"you and your kind?" Feeling persecuted, are you? No, my dove. To me you are
one-of-a-kind.
|
Once again, make up your mind.
You said you didn’t want to consider my opininon because I’m a non seller, neither
0- nor “enough”- (whatever that would be) FB buyer. I thought that applied to
all non sellers, neither 0- nor “enough”- (whatever that would be) FB buyers,
or even all buyers-only.
Doesn’t that fall under the phrase “me and my kind”?
And now you’re saying I’m alone. So it’s only my opinion you don’t want to consider?
So, either you don’t want me-and-my-kind’s opinion or you don’t want my opinion.
That’s not my feeling persecuted, that’s your dismissing my opinion.
It’s your right not wanting to care about someone’s opinion but, besides being
inconsistent with first having asked everyone’s opinions, you can’t both say
you don’t care about someone’s opinion and then deny you said it.
And, by the way, stop giving me names. I’m not your pigeon or any other pet.
That’s condescending.
| | But why all the hostility, are we not best of friends
|
Seems to me your best friend is liquid and bubbly.
| | It's the middle of the night for you in France. Try not to dwell on thoughts
of me, and what I think. Get some sleep...
|
Don’t mind my sleep, I sleep like a baby: I wake up every other hour and I cry.
Or maybe this one: I sleep very well, some nights I even sleep more than once!
|
|
| Author: | SylvainLS | | Posted: | Jul 25, 2019 22:08 | | Subject: | Re: Either a bonafide brain-fart, or a seizure... | | Viewed: | 46 times | | Topic: | Suggestions | |
| In Suggestions, popsicle writes:
| | […]
It's sounds like you've been working on it, keep it up!
|
Not really, I was only reacting to what you wrote, no hard work involved.
That’s a first….
| | gallic friend, as a non seller and not much of a buyer (it
would appear from your history here) I really don't know if I'll take
your advise on this particular question, as earnestly as I would some
others here. You've got no skin in the game, as they say.
|
You’re talking about sellers reaching to buyers. I’d have thought buyers’ opinions
would be of interest to you.
But maybe it’s a cultural thing. After all, EU is opt-in while the USA are opt-out.
Recipients like to be in the loop here, not treated like kettle/cattle….
Besides, if you only consider sellers or very frequent buyers then I don’t understand
why you linked the message of a zero feedback buyer as a motive for your idea.
Or is there a “too much but not enough” range of buyers you’re excluding?
| | But I am glad you came out to play with me again
|
Make up your mind: you just said you don’t want me and my kind on the field
|
|
| Author: | SylvainLS | | Posted: | Jul 25, 2019 20:14 | | Subject: | Re: Either a bonafide brain-fart, or a seizure... | | Viewed: | 84 times | | Topic: | Suggestions | |
| In Suggestions, popsicle writes:
No, no, you tempter, I won’t ask if it felt alone in there!
| | A type of reverse want list. That is, a way that sellers could peruse the current
want lists to specific buyer's needs, to then as a seller, proactively engage
members like Wayne with offers on items they have on their want list.
Kinda like amping-up the want list and selling process, by getting the sellers
more involved in increasing their sales by actually selling
It's just a rough draft of an idea. Limitations, restriction and other refinements
of the idea, expected.
But hey, BL shot-callers, it speaks directly to upping the sales numbers!
|
Hmm, let’s see if I understand correctly.
Now, the buyer can search the stores that have the most items for their WLs.
They need to actualize their search from time to time to see if new sellers /
better matches appear.
And you’d want that search to be automatized so that the buyer receive a notification
for their whole WL?
If that’s it, when will that notification be sent? When the WL is X% fulfill(able)?
— If X is too high, many WLs will never have such a notification.
— If X is too low, that could make for a lot of notifications.
Or do you just want the search to be reversed, that a seller actively search
for WLs they can fulfill with their inventory?
Here again, percentage of fulfillment could be what makes it useful or spamful.
Anyway, I’m not sure it’s very different from the already existing WL notification
system except it would be for several parts at once, not one by one.
I rarely use that, indeed because that would cause too many notifications for
common parts and it doesn’t tell me if the seller has other parts, so adding
that multiple parts feature could be interesting. Though I’m not sure I would
opt in: it’s as easy to make a search from time to time.
A related question: Can’t sellers easily see on how many WLs their parts are
so that they can decide when to send notifications?
I mean, do you have to browse all your inventory part by part to have this info?
|
|
| Author: | SylvainLS | | Posted: | Jul 23, 2019 19:56 | | Subject: | Re: Plant 2417? | | Viewed: | 32 times | | Topic: | Catalog | |
| In Catalog, Biscuit_head writes:
| | Sustainability: avoidance of the depletion of natural resources in order to maintain
an ecological balance.
They're using less crude oil by no longer using it to make plant peices.
They could possibly make all of the parts from plants instead of oil once they
find enough sugar cane farms that can keep up with the demand.
|
No, they couldn’t. Most of the parts are ABS, not PE. Different plastics, different
processes.
PE can be made from ethanol. (Ahoy matey, sugar cane is rum!)
ABS is more complex.
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
