Discussion Forum: Thread 263536

 Author: mfav View Messages Posted By mfav
 Posted: Feb 8, 2020 21:08
 Subject: Description standardization note
 Viewed: 154 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

mfav (174)

Location:  USA, Vermont
Member Since Contact Type Status
Aug 4, 2010 Contact Member Buyer
Buying Privileges - OK
It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

So:

Three eyeballs, Three earlobes

or

3 eyeballs, 3 earlobes

not

Three eyeballs, 3 earlobes

...that kind of thing.

There are pros and cons for each option. Please investigate how the search mechanism
works to see which option yields better results.
 Author: Admin_Russell View Messages Posted By Admin_Russell
 Posted: Feb 8, 2020 21:24
 Subject: Re: Description standardization note
 Viewed: 66 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Admin_Russell

Location:  USA, California
Member Since Contact Type Status
May 9, 2017 Contact Member Admin
Buying Privileges - OKSelling Privileges - OK
BrickLink Administrator
In Catalog, mfav writes:
  It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

So:

Three eyeballs, Three earlobes

or

3 eyeballs, 3 earlobes

not

Three eyeballs, 3 earlobes

...that kind of thing.

There are pros and cons for each option. Please investigate how the search mechanism
works to see which option yields better results.

Unfortunately, single digits are thrown out of many of the search results. But
I think in general one would find more numerals in item names than the words
spelled out simply because it makes the name shorter.
 Author: mfav View Messages Posted By mfav
 Posted: Feb 8, 2020 22:49
 Subject: Re: Description standardization note
 Viewed: 55 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

mfav (174)

Location:  USA, Vermont
Member Since Contact Type Status
Aug 4, 2010 Contact Member Buyer
Buying Privileges - OK
In Catalog, Admin_Russell writes:
  Unfortunately, single digits are thrown out of many of the search results.

Aren't you the fella to talk to to get that changed, Mister Site Manager?


  But I think in general one would find more numerals in item names than the words
spelled out simply because it makes the name shorter.

While that is undoubtedly true, it's not particularly helpful in any way.
If you search, say, legs assemblies...

search for "three" you get two results
search for "3" you get: The following keywords were excluded from your search:
3
...however there are 13 entries containing "3"

Isn't the point of StormBluser's standardization plan to fix this stuff?
To paraphrase the StormBluser: why name something like this when 75% of the search
words are invalid?

Again, I'll make the point you need to distinguish between identification
and discovery. The identification of a thing is irrelevant if it can't be
discovered. People use the search box to find things, they don't browse 180,000
individual items looking for "3". Hope you get my drift.

Aren't you the number one proponent of making the catalog useful? Let's
figure out a way to make it useful.
 Author: hpoort View Messages Posted By hpoort
 Posted: Feb 9, 2020 03:00
 Subject: Re: Description standardization note
 Viewed: 42 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

hpoort (389)

Location:  Netherlands, Groningen
Member Since Contact Type Status
Oct 11, 2014 Contact Member Buyer
Buying Privileges - OK
In Catalog, Admin_Russell writes:
  In Catalog, mfav writes:
  It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

So:

Three eyeballs, Three earlobes

or

3 eyeballs, 3 earlobes

not

Three eyeballs, 3 earlobes

...that kind of thing.

There are pros and cons for each option. Please investigate how the search mechanism
works to see which option yields better results.

Unfortunately, single digits are thrown out of many of the search results. But
I think in general one would find more numerals in item names than the words
spelled out simply because it makes the name shorter.

Please drop the keyword exclusion altogether.

It does not make sense to make use of a full text English language keyword exclusion
list, when the contents of the database is actually not normal full text English,
but a specific dialect: Bricklink English (EN-BL) in which it makes more sense
to search for keywords like 'with' and 'without' and for single
digits. It should be easy to adjust the database configuration. No programming
involved.

Hans-Peter
 Author: StormChaser View Messages Posted By StormChaser
 Posted: Feb 9, 2020 03:29
 Subject: Re: Description Standardization Note
 Viewed: 51 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

StormChaser (372) 
(was bluser13161)

Location:  USA, Oklahoma
Member Since Contact Type Status
Sep 10, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Store Name
BrickLink Catalog Associate (?)
In Catalog, mfav writes:
  It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

I have noticed this before and definitely agree it needs to be worked on. The
problem is (and I'm starting to understand the rearranging the chairs thing)
there are too many problems.

In the case of this problem, you can't even find the problem because you
can't search for it. So it would involve examining every single catalog
entry. All 100K+ of them.

And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .
 Author: FreeStorm View Messages Posted By FreeStorm
 Posted: Feb 9, 2020 03:59
 Subject: Re: Description Standardization Note
 Viewed: 38 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FreeStorm (229)

Location:  Switzerland, Vaud
Member Since Contact Type Status
Dec 14, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: FreeStorm Shop
In Catalog, StormChaser writes:
  In the case of this problem, you can't even find the problem because you
can't search for it. So it would involve examining every single catalog
entry. All 100K+ of them.

What do you want to find?

Something like this?
"* three *" = 153 results
"* 3 *" = 6675 results
"* three *" AND "* 3 *" = 16 results

As example, last search find:
"Technic, Panel Car Spoiler 3 x 8 with Three Holes and Black and Yellow Danger
Stripes and Mud Pattern (Stickers) - Set 7968"

"Primo Brick 1 x 1 with Three Flowers and Number 3 on Opposite Side Pattern"

Of course,I made query to find only for "three" and "3" on same description,
but with a regexp it should be simple to spot every "word digit" with "digit"
on same description like "blah with two legs and 1 arm"

Some other incoherence (digit 3 should be between '' when you have pattern
after):
"*number 3 *pattern*" = 22 result
"*number '3' *pattern*" = 3 result

If you know what you want to find, it should be easy to make a search query,
to spot the majority of incoherence.

-Fred
 Author: FreeStorm View Messages Posted By FreeStorm
 Posted: Feb 9, 2020 06:07
 Subject: Re: Description Standardization Note
 Viewed: 26 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FreeStorm (229)

Location:  Switzerland, Vaud
Member Since Contact Type Status
Dec 14, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: FreeStorm Shop
My search for parts with integers and words numbers in description (of course
dimension like "1 x 2 x 2" is not included on integer number search)

result = 58 parts
You can start with "only" 58 parts and not 100K+

PS: my search is not perfect, but it not the goal
The goal is to reduce the search results for human brain analysis

==================

13252pb01
Windscreen 12 x 6 x 2 with Locking Dual 2 Fingers Hinge with SW Red Five X-wing
Starfighter Pattern (4 Stickers) - Set 10240

14222pb009
Duplo, Brick 1 x 3 x 2 Round Top, Cut Away Sides with Number 1 and Two Stars
in Circle Pattern

18455
Hinge Brick 2 x 4 Locking with 1 Finger on Top at One End

21557pb01
Minifigure, Headgear Helmet with Respiratory Pipe and SW Ep. 7 TIE Fighter Pilot
First Order with Two White Lines Pattern

21557pb03
Minifigure, Headgear Helmet with Respiratory Pipe and SW Ep. 8 TIE Fighter Pilot
First Order with Three White Lines Pattern

230.1stk01a
Sticker for Set 230-1 - Two Sheet Version - Sheet 1 - (4319)

230.1stk02a
Sticker for Set 230-1 - Two Sheet Version - Sheet 2 - (4096)

232stk01a
Sticker for Set 232 - Two Sheet Version - Sheet 1 - (4424)

232stk02a
Sticker for Set 232 - Two Sheet Version - Sheet 2 - (4102)

2335pb141
Flag 2 x 2 Square with Checkered Pattern on One Side, 2 Black Diagonal Corners
(Sticker) - Set 4982

24902
Cloth Cape with 4 Holes, Slit and Two Long Panels, Large Buildable Figures

2958pb002
Technic, Disk 3 x 3 with 4 Black Sections on One Side and 8 on Reverse Pattern

30350cpb033L
Tile, Modified 2 x 3 with 2 Clips (thick U clips) with 'FR ALL FOR ONE allinol'
Pattern Model Left Side (Sticker) - Set 8678

30350cpb033R
Tile, Modified 2 x 3 with 2 Clips (thick U clips) with 'FR ALL FOR ONE allinol'
Pattern Model Right Side (Sticker) - Set 8678

30360pb03
Cylinder 3 x 6 x 2 2/3 Horizontal with Two Scratched Space Police 3 Badges Pattern
(Stickers) - Set 5972

30414pb01
Brick, Modified 1 x 4 with 4 Studs on One Side with Black and Yellow Danger Stripes
Pattern (Sticker) - Set 7781

30414pb02
Brick, Modified 1 x 4 with 4 Studs on One Side with Train Logo White on Yellow
Background Pattern (Sticker) - Set 7939

3068bpb0112
Tile 2 x 2 with Groove with Grille Five Bar Pattern 1 (Sticker) - Set 7256

3068bpb0135
Tile 2 x 2 with Groove with Grille Five Bar Pattern 2 (Sticker) - Set 7256

3068bpb0141
Tile 2 x 2 with Groove with One White Triangle Pattern 1 (Sticker) - Set 7252

3068bpb0398
Tile 2 x 2 with Groove with One White Triangle Pattern 2 (Sticker) - Set 7252

3068bpb0672
Tile 2 x 2 with Groove with Two Yellow Stripes and Black Number 7 in White Circle
Pattern (Sticker) - Set 8154

3069bpb618
Tile 1 x 2 with Groove with Two Black Boxes with 3 Stripes Pattern (Sticker)
- Set 8681

31000pb28
Primo Brick 1 x 1 with Three Flowers and Number 3 on Opposite Side Pattern

31000pb29
Primo Brick 1 x 1 with Two Snakes and Number 2 on Opposite Side Pattern

32171pb032
Throwbot Disk, Jet / Judge, 3 pips, Jet throwing two disks Pattern

32171pb059
Throwbot Disk, Blaster, 6 pips, Blaster and two 'bots with fire background
Pattern

3298pb011
Slope 33 3 x 2 with Red Number 2 and Two Green Stripes Pattern

36315
Mini Doll, Cape Cloth, 5 Curly Points, One Side Black, One Side Dark Turquoise

41855pb09
Brick, Modified 2 x 2 x 2/3 Two Studs, Lip End with Silver/Black/Red Number 3
Left Half Pattern

41855pb10
Brick, Modified 2 x 2 x 2/3 Two Studs, Lip End with Silver/Black/Red Number 3
Right Half Pattern

42380apb01
Foam, Soccer Target 10 x 9 with One Hole and Number 5 and Soccer Ball (Football)
Pattern (Stickers) - Set 3423

4318
Boat Mast 2 x 2 x 9 2/3 Bar with Slot on Top and 2 Finger Hinge on Two Sides

45399
Garage Door 1 x 12 x 9 with Three Windows, Locking Dual 2 Finger Hinges

45403
Brick, Modified 5 x 12 with Two 1 x 2 Cutouts, 3 Holes on Side

45403c01
Brick, Modified 5 x 12 with Two 1 x 2 Cutouts, 1 Hole and 2 Fixed Rotatable Friction
Pins on Side

47456pb003
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with 8 Black Stripes Pattern
(Stickers) - Set 8122

47456pb008L
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with Rust and 3 Rivets Pattern
Model Left Side (Sticker) - Set 70143

47456pb008R
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with Rust and 4 Rivets Pattern
Model Right Side (Sticker) - Set 70143

47457pb02
Brick, Modified 2 x 2 x 2/3 Two Studs, Curved Slope End with Yellow Triangle
on 3 Bars Pattern

48452cx1pb02
Technic Turntable Large Type 2 with Black Outside Gear Section with Two Silver
Tread Plates Pattern (Stickers) - Set 8292

5005358cdb02
Paper, Cardboard Backdrop for Set 5005358, Card with Two Square Holes and Pictures
of 5 Minifigures

52886
Mini Doll, Cape Cloth, Friends, Tapered with 1 Small Top Hole - Traditional Starched
Fabric, One Side Shiny

58006
Mini Doll, Cape Cloth, Scalloped 3 Points - Traditional Starched Fabric, One
Side Shiny

61484pb004
Windscreen 5 x 6 x 2 Curved Top Canopy with 4 Studs with Fire Logo with Two White
Stripes Pattern (Sticker) - Set 7207

61547pb01
Mini Doll, Cape Cloth, Bell Shaped with 3 Notches, One Side Magenta, One Side
Dark Purple

61667pb01
Mini Doll, Cape Cloth, 2 Long Tails, One Side Glitter

89509
Propeller 1 Blade 14L with Two Pin Holes and Four Axles

90640pb008
Hero Factory Armor with Ball Joint Socket - Size 4 with Three Stripes Pattern

BA013pb04
Stickered Assembly 2 x 4 with Six Ice Creams Pattern (Sticker) - Set 6414 - 2
Tiles 2 x 2

BA087pb01
Stickered Assembly 2 x 2 x 2 with Butterfly and Two Flowers Pattern (Sticker)
- Set 6410 - 1 Brick 1 x 2, 1 Brick 2 x 2

bb0141ac45
Electric, Wire 4.5V with two light gray 2-prong Type 1 connectors, 45 Studs Long

bb0141ac96
Electric, Wire 4.5V with two light gray 2-prong Type 1 connectors, 96 Studs Long

bb0236bc96
Electric, Wire 4.5V with two blue 2-prong Type 2 connectors (with cross-cut pins),
96 Studs Long

duploracer01
Duplo Car Formula One with Yellow Wheels and Yellow Number 1 Pattern

duploracer02
Duplo Car Formula One with Blue Bottom and Yellow Number 2 Pattern

duploracer02a
Duplo Car Formula One with Blue Bottom and Yellow Number 2 Pattern, 1 Stud in
Cab

x277
Hinge 1 x 4 Triangle with Two Pins, Locking 1 Finger
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 06:09
 Subject: Re: Description Standardization Note
 Viewed: 35 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5973)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, FreeStorm writes:
  My search for parts with integers and words numbers in description (of course
dimension like "1 x 2 x 2" is not included on integer number search)

result = 58 parts
You can start with "only" 58 parts and not 100K+

PS: my search is not perfect, but it not the goal
The goal is to reduce the search results for human brain analysis

==================

13252pb01
Windscreen 12 x 6 x 2 with Locking Dual 2 Fingers Hinge with SW Red Five X-wing
Starfighter Pattern (4 Stickers) - Set 10240

14222pb009
Duplo, Brick 1 x 3 x 2 Round Top, Cut Away Sides with Number 1 and Two Stars
in Circle Pattern

That's a good start
  
18455
Hinge Brick 2 x 4 Locking with 1 Finger on Top at One End

21557pb01
Minifigure, Headgear Helmet with Respiratory Pipe and SW Ep. 7 TIE Fighter Pilot
First Order with Two White Lines Pattern

21557pb03
Minifigure, Headgear Helmet with Respiratory Pipe and SW Ep. 8 TIE Fighter Pilot
First Order with Three White Lines Pattern

230.1stk01a
Sticker for Set 230-1 - Two Sheet Version - Sheet 1 - (4319)

230.1stk02a
Sticker for Set 230-1 - Two Sheet Version - Sheet 2 - (4096)

232stk01a
Sticker for Set 232 - Two Sheet Version - Sheet 1 - (4424)

232stk02a
Sticker for Set 232 - Two Sheet Version - Sheet 2 - (4102)

2335pb141
Flag 2 x 2 Square with Checkered Pattern on One Side, 2 Black Diagonal Corners
(Sticker) - Set 4982

24902
Cloth Cape with 4 Holes, Slit and Two Long Panels, Large Buildable Figures

2958pb002
Technic, Disk 3 x 3 with 4 Black Sections on One Side and 8 on Reverse Pattern

30350cpb033L
Tile, Modified 2 x 3 with 2 Clips (thick U clips) with 'FR ALL FOR ONE allinol'
Pattern Model Left Side (Sticker) - Set 8678

30350cpb033R
Tile, Modified 2 x 3 with 2 Clips (thick U clips) with 'FR ALL FOR ONE allinol'
Pattern Model Right Side (Sticker) - Set 8678

30360pb03
Cylinder 3 x 6 x 2 2/3 Horizontal with Two Scratched Space Police 3 Badges Pattern
(Stickers) - Set 5972

30414pb01
Brick, Modified 1 x 4 with 4 Studs on One Side with Black and Yellow Danger Stripes
Pattern (Sticker) - Set 7781

30414pb02
Brick, Modified 1 x 4 with 4 Studs on One Side with Train Logo White on Yellow
Background Pattern (Sticker) - Set 7939

3068bpb0112
Tile 2 x 2 with Groove with Grille Five Bar Pattern 1 (Sticker) - Set 7256

3068bpb0135
Tile 2 x 2 with Groove with Grille Five Bar Pattern 2 (Sticker) - Set 7256

3068bpb0141
Tile 2 x 2 with Groove with One White Triangle Pattern 1 (Sticker) - Set 7252

3068bpb0398
Tile 2 x 2 with Groove with One White Triangle Pattern 2 (Sticker) - Set 7252

3068bpb0672
Tile 2 x 2 with Groove with Two Yellow Stripes and Black Number 7 in White Circle
Pattern (Sticker) - Set 8154

3069bpb618
Tile 1 x 2 with Groove with Two Black Boxes with 3 Stripes Pattern (Sticker)
- Set 8681

31000pb28
Primo Brick 1 x 1 with Three Flowers and Number 3 on Opposite Side Pattern

31000pb29
Primo Brick 1 x 1 with Two Snakes and Number 2 on Opposite Side Pattern

32171pb032
Throwbot Disk, Jet / Judge, 3 pips, Jet throwing two disks Pattern

32171pb059
Throwbot Disk, Blaster, 6 pips, Blaster and two 'bots with fire background
Pattern

3298pb011
Slope 33 3 x 2 with Red Number 2 and Two Green Stripes Pattern

36315
Mini Doll, Cape Cloth, 5 Curly Points, One Side Black, One Side Dark Turquoise

41855pb09
Brick, Modified 2 x 2 x 2/3 Two Studs, Lip End with Silver/Black/Red Number 3
Left Half Pattern

41855pb10
Brick, Modified 2 x 2 x 2/3 Two Studs, Lip End with Silver/Black/Red Number 3
Right Half Pattern

42380apb01
Foam, Soccer Target 10 x 9 with One Hole and Number 5 and Soccer Ball (Football)
Pattern (Stickers) - Set 3423

4318
Boat Mast 2 x 2 x 9 2/3 Bar with Slot on Top and 2 Finger Hinge on Two Sides

45399
Garage Door 1 x 12 x 9 with Three Windows, Locking Dual 2 Finger Hinges

45403
Brick, Modified 5 x 12 with Two 1 x 2 Cutouts, 3 Holes on Side

45403c01
Brick, Modified 5 x 12 with Two 1 x 2 Cutouts, 1 Hole and 2 Fixed Rotatable Friction
Pins on Side

47456pb003
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with 8 Black Stripes Pattern
(Stickers) - Set 8122

47456pb008L
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with Rust and 3 Rivets Pattern
Model Left Side (Sticker) - Set 70143

47456pb008R
Brick, Modified 2 x 3 x 2/3 Two Studs, Wing End with Rust and 4 Rivets Pattern
Model Right Side (Sticker) - Set 70143

47457pb02
Brick, Modified 2 x 2 x 2/3 Two Studs, Curved Slope End with Yellow Triangle
on 3 Bars Pattern

48452cx1pb02
Technic Turntable Large Type 2 with Black Outside Gear Section with Two Silver
Tread Plates Pattern (Stickers) - Set 8292

5005358cdb02
Paper, Cardboard Backdrop for Set 5005358, Card with Two Square Holes and Pictures
of 5 Minifigures

52886
Mini Doll, Cape Cloth, Friends, Tapered with 1 Small Top Hole - Traditional Starched
Fabric, One Side Shiny

58006
Mini Doll, Cape Cloth, Scalloped 3 Points - Traditional Starched Fabric, One
Side Shiny

61484pb004
Windscreen 5 x 6 x 2 Curved Top Canopy with 4 Studs with Fire Logo with Two White
Stripes Pattern (Sticker) - Set 7207

61547pb01
Mini Doll, Cape Cloth, Bell Shaped with 3 Notches, One Side Magenta, One Side
Dark Purple

61667pb01
Mini Doll, Cape Cloth, 2 Long Tails, One Side Glitter

89509
Propeller 1 Blade 14L with Two Pin Holes and Four Axles

90640pb008
Hero Factory Armor with Ball Joint Socket - Size 4 with Three Stripes Pattern

BA013pb04
Stickered Assembly 2 x 4 with Six Ice Creams Pattern (Sticker) - Set 6414 - 2
Tiles 2 x 2

BA087pb01
Stickered Assembly 2 x 2 x 2 with Butterfly and Two Flowers Pattern (Sticker)
- Set 6410 - 1 Brick 1 x 2, 1 Brick 2 x 2

bb0141ac45
Electric, Wire 4.5V with two light gray 2-prong Type 1 connectors, 45 Studs Long

bb0141ac96
Electric, Wire 4.5V with two light gray 2-prong Type 1 connectors, 96 Studs Long

bb0236bc96
Electric, Wire 4.5V with two blue 2-prong Type 2 connectors (with cross-cut pins),
96 Studs Long

duploracer01
Duplo Car Formula One with Yellow Wheels and Yellow Number 1 Pattern

duploracer02
Duplo Car Formula One with Blue Bottom and Yellow Number 2 Pattern

duploracer02a
Duplo Car Formula One with Blue Bottom and Yellow Number 2 Pattern, 1 Stud in
Cab

x277
Hinge 1 x 4 Triangle with Two Pins, Locking 1 Finger
 Author: FreeStorm View Messages Posted By FreeStorm
 Posted: Feb 9, 2020 06:26
 Subject: Re: Description Standardization Note
 Viewed: 33 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FreeStorm (229)

Location:  Switzerland, Vaud
Member Since Contact Type Status
Dec 14, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: FreeStorm Shop
For other type than Parts:
(after that I stop spaming)

=========================
BOOK
-------------------------

biocom01
Bionicle # 1 June 2001 Six Heroes One Destiny

biocom01sp1
Bionicle # 1 Six Heroes One Destiny Special San Diego Comic-Con 2003 Edition

biocom01sp2
Bionicle # 1 July 2003 Six Heroes One Destiny - Mini Version

biocom01a
Bionicle # 1 April 2001 Six Heroes One Destiny

9607b4
Set 9607 Activity Booklet 4 - {Machine using Belt and two Gears}

9603b34
Set 9603 Activity Card Application: Simulation 7 - Two Toting

9603b61
Set 9603 Activity Card Application: Invention 4 - One at a Time!

9603b34AU
Set 9603 Activity Card Application: Simulation 7 - Two Up AUS version (118022)

9603b61AU
Set 9603 Activity Card Application: Invention 4 - One at a Time! AUS version
(118122)


=========================
SET
-------------------------

046-1
28 assorted basic brick - white plus 8 flat plates - white plus one 10 x 10 stud
red base plate


=========================
GEAR
-------------------------

9804
Playtable with Two Bins, 2 Seats and Two Building Plates

4495784
Playtable with One Bin, 4 Seats and 4 Building Plates

4646117
Display Assembled Set, Cars 2 Six Main Characters in Plastic Case


=========================
MINIFIG
-------------------------

6453pb004
Duplo Figure, Child Type 2 Boy, Blue Legs, Red Top with White Stripes and Blue
Overalls with One Strap

6453pb003
Duplo Figure, Child Type 2 Boy, Blue Legs, Green Top with Blue Overalls with
one Strap

6453pb021
Duplo Figure, Child Type 2 Girl, Red Legs, White Top with Red Overalls with one
Strap

=========================
ORIGINAL_BOX
-------------------------

046-1
28 assorted basic brick - white plus 8 flat plates - white plus one 10 x 10 stud
red base plate
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 06:29
 Subject: Re: Description Standardization Note
 Viewed: 31 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5973)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, FreeStorm writes:
  For other type than Parts:
(after that I stop spaming)

=========================
BOOK
-------------------------

biocom01
Bionicle # 1 June 2001 Six Heroes One Destiny

biocom01sp1
Bionicle # 1 Six Heroes One Destiny Special San Diego Comic-Con 2003 Edition

biocom01sp2
Bionicle # 1 July 2003 Six Heroes One Destiny - Mini Version

biocom01a
Bionicle # 1 April 2001 Six Heroes One Destiny

9607b4
Set 9607 Activity Booklet 4 - {Machine using Belt and two Gears}

9603b34
Set 9603 Activity Card Application: Simulation 7 - Two Toting

9603b61
Set 9603 Activity Card Application: Invention 4 - One at a Time!

9603b34AU
Set 9603 Activity Card Application: Simulation 7 - Two Up AUS version (118022)

9603b61AU
Set 9603 Activity Card Application: Invention 4 - One at a Time! AUS version
(118122)


=========================
SET
-------------------------

046-1
28 assorted basic brick - white plus 8 flat plates - white plus one 10 x 10 stud
red base plate


=========================
GEAR
-------------------------

9804
Playtable with Two Bins, 2 Seats and Two Building Plates

4495784
Playtable with One Bin, 4 Seats and 4 Building Plates

4646117
Display Assembled Set, Cars 2 Six Main Characters in Plastic Case


=========================
MINIFIG
-------------------------

6453pb004
Duplo Figure, Child Type 2 Boy, Blue Legs, Red Top with White Stripes and Blue
Overalls with One Strap

6453pb003
Duplo Figure, Child Type 2 Boy, Blue Legs, Green Top with Blue Overalls with
one Strap

6453pb021
Duplo Figure, Child Type 2 Girl, Red Legs, White Top with Red Overalls with one
Strap

=========================
ORIGINAL_BOX
-------------------------

046-1
28 assorted basic brick - white plus 8 flat plates - white plus one 10 x 10 stud
red base plate

Not spamming - helping the community and the catalogue people who do not have
your abilities.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 04:49
 Subject: Re: Description Standardization Note
 Viewed: 32 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5973)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, StormChaser writes:
  In Catalog, mfav writes:
  It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

I have noticed this before and definitely agree it needs to be worked on. The
problem is (and I'm starting to understand the rearranging the chairs thing)
there are too many problems.

In the case of this problem, you can't even find the problem because you
can't search for it. So it would involve examining every single catalog
entry. All 100K+ of them.

And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . .

The answer is really quite simple - talk to a SQL person and they will advise
you how to organise your query to find precisely what you want. It isn't
rocket science. .
 Author: constructibles View Messages Posted By constructibles
 Posted: Feb 9, 2020 09:38
 Subject: Re: Description Standardization Note
 Viewed: 36 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

constructibles (333)

Location:  USA, North Carolina
Member Since Contact Type Status
May 8, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Constructibles Custom Sets
In Catalog, StormChaser writes:
  
And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .

Export the catalog to txt, and open in Excel. This will give you pretty much
unlimited ability to search. Write an Excel formula to find what you are looking
for. You can even write a formula to create the desired replacement title
if you like, then just copy paste the change back to BL.

Regexp is a little harder to do, but Google “Excel Regexp” and you’ll get some
examples how to create your own function Using Excel VB.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 10:15
 Subject: Re: Description Standardization Note
 Viewed: 44 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5973)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, constructibles writes:
  In Catalog, StormChaser writes:
  
And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .

Export the catalog to txt, and open in Excel. This will give you pretty much
unlimited ability to search. Write an Excel formula to find what you are looking
for. You can even write a formula to create the desired replacement title
if you like, then just copy paste the change back to BL.

Regexp is a little harder to do, but Google “Excel Regexp” and you’ll get some
examples how to create your own function Using Excel VB.

Or if you are just not into programming or that technical you could follow the
guidelines set out here for using the advanced filter option in Excel

https://support.microsoft.com/en-gb/help/2720580/using-advanced-filters-in-excel-2010

Good luck with that.

My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 11:42
 Subject: Re: Description Standardization Note
 Viewed: 28 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5973)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, calsbricks writes:
  In Catalog, constructibles writes:
  In Catalog, StormChaser writes:
  
And perhaps, when the next problem comes along, examining all of them again.
It almost makes a person think that there must be a better way . . .

Export the catalog to txt, and open in Excel. This will give you pretty much
unlimited ability to search. Write an Excel formula to find what you are looking
for. You can even write a formula to create the desired replacement title
if you like, then just copy paste the change back to BL.

Regexp is a little harder to do, but Google “Excel Regexp” and you’ll get some
examples how to create your own function Using Excel VB.

Or if you are just not into programming or that technical you could follow the
guidelines set out here for using the advanced filter option in Excel

https://support.microsoft.com/en-gb/help/2720580/using-advanced-filters-in-excel-2010

Good luck with that.

My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Guess what - as an exercise I just tried this in Brickstok - it works a treat.
Use the filters to suggest the description contains a number or the word for
that number.

The only problem is once it found them all I could not easily mass update them.
The search works great though.
 Author: FreeStorm View Messages Posted By FreeStorm
 Posted: Feb 9, 2020 12:01
 Subject: Re: Description Standardization Note
 Viewed: 26 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FreeStorm (229)

Location:  Switzerland, Vaud
Member Since Contact Type Status
Dec 14, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: FreeStorm Shop
In Catalog, calsbricks writes:
  My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Of course changes should be made on DB directly with write logs into "change-log
table" as well (to have an history of what is made)

But for that, you need SQL guy (not your nephew) and "real" database.
Please don't play with Excel
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Feb 9, 2020 12:10
 Subject: Re: Description Standardization Note
 Viewed: 35 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5973)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Catalog, FreeStorm writes:
  In Catalog, calsbricks writes:
  My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Of course changes should be made on DB directly with write logs into "change-log
table" as well (to have an history of what is made)

But for that, you need SQL guy (not your nephew) and "real" database.
Please don't play with Excel

No fears I am not a programmer and neither is he - we leave it to those that
have a passion for it.
 Author: FreeStorm View Messages Posted By FreeStorm
 Posted: Feb 9, 2020 12:40
 Subject: Re: Description Standardization Note
 Viewed: 34 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

FreeStorm (229)

Location:  Switzerland, Vaud
Member Since Contact Type Status
Dec 14, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: FreeStorm Shop
In Catalog, calsbricks writes:
  In Catalog, FreeStorm writes:
  In Catalog, calsbricks writes:
  My preferred option is to let your SQL guy (that is if you have one. Our belief
from the Chicago round table discussion was that none of the developers at that
time had any SQL experience whatsoever) spend 10 minutes producing your query
(9 minutes for understanding the table and 1 minute for writing the query. Once
the results are in front of you it might be possible for your sql guy to write
an update query to do all the updates at once.

This is almost as simple as changing colour names from one to another

Of course changes should be made on DB directly with write logs into "change-log
table" as well (to have an history of what is made)

But for that, you need SQL guy (not your nephew) and "real" database.
Please don't play with Excel

No fears I am not a programmer and neither is he - we leave it to those that
have a passion for it.

How can I say?
The "you" on my messages was not directed to a specific person,it's addressed
to everybody and nobody
 Author: BrickCompulsion View Messages Posted By BrickCompulsion
 Posted: Feb 9, 2020 04:58
 Subject: Re: Description standardization note
 Viewed: 37 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

BrickCompulsion (1075)

Location:  United Kingdom, England
Member Since Contact Type Status
Mar 16, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Brick Compulsion
I totally support this change
Consistency is key
Maybe search and change all you can find and then put it out there on here for
messages about items missed. That’s if the sql person is on holiday or unavailable
 Author: StormChaser View Messages Posted By StormChaser
 Posted: Feb 10, 2020 13:28
 Subject: Re: Description standardization note
 Viewed: 31 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

StormChaser (372) 
(was bluser13161)

Location:  USA, Oklahoma
Member Since Contact Type Status
Sep 10, 2002 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Store Name
BrickLink Catalog Associate (?)
In Catalog, mfav writes:
  It would be good for consistency in the catalog description if all instances
of numbers were either integers or words, not arbitrarily some of each.

Agreed. Have added it to the Catalog Roadmap (currently item 29):

https://www.bricklink.com/help.asp?helpID=2476