Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies| Author: | FreeStorm  | | Posted: | Feb 10, 2020 16:16 | | Subject: | Re: Inventory change on minifig | | Viewed: | 33 times | | Topic: | Inventories | |
| In Inventories, Admin_Russell writes:
| | ...there are two different versions of instructions, showing two different sticker
configurations. It is likely that both minifigures in the catalog are correct.
|
Should we add a note to set 641-1 to explain that it can come with different
instruction and sticker sheet?
How can I modify inventory for minifig?
You can see the problem there:
https://www.bricklink.com/catalogItemIn.asp?P=3840pb01&in=M
|
 |
| Author: | FreeStorm | | Posted: | Feb 10, 2020 15:28 | | Subject: | Re: Inventory change on minifig | | Viewed: | 32 times | | Topic: | Inventories | |
| In Inventories, FreeStorm writes:
| | In Inventories, randyf writes:
| | In Inventories, FreeStorm writes:
| | What is the procedure when the inventory of a minifig is wrong?
Should I make the inventory change request like with set, or create a new minifig
and mark for deletion the older one?
Of course, the picture is also wrong.
-Fred
|
Which minifig?
|
|
and
[m=con004]
[m=con007]
Sticker on one side only of the vest (if sticker sheet is the right one):
[m=pln056]
|
|
| Author: | FreeStorm | | Posted: | Feb 10, 2020 15:15 | | Subject: | Re: Inventory change on minifig | | Viewed: | 40 times | | Topic: | Inventories | |
| In Inventories, randyf writes:
| | In Inventories, FreeStorm writes:
| | What is the procedure when the inventory of a minifig is wrong?
Should I make the inventory change request like with set, or create a new minifig
and mark for deletion the older one?
Of course, the picture is also wrong.
-Fred
|
Which minifig?
|
|
| Author: | FreeStorm | | Posted: | Feb 10, 2020 15:08 | | Subject: | Inventory change on minifig | | Viewed: | 74 times | | Topic: | Inventories | | Status: | Open | |
| What is the procedure when the inventory of a minifig is wrong?
Should I make the inventory change request like with set, or create a new minifig
and mark for deletion the older one?
Of course, the picture is also wrong.
-Fred
|
|
| Author: | FreeStorm | | Posted: | Feb 9, 2020 12:40 | | Subject: | Re: Description Standardization Note | | Viewed: | 40 times | | Topic: | Catalog | |
| 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: | FreeStorm | | Posted: | Feb 9, 2020 12:01 | | Subject: | Re: Description Standardization Note | | Viewed: | 35 times | | Topic: | Catalog | |
| 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: | FreeStorm | | Posted: | Feb 9, 2020 06:26 | | Subject: | Re: Description Standardization Note | | Viewed: | 38 times | | Topic: | Catalog | |
| 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: | FreeStorm | | Posted: | Feb 9, 2020 06:07 | | Subject: | Re: Description Standardization Note | | Viewed: | 53 times | | Topic: | Catalog | |
| 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: | FreeStorm | | Posted: | Feb 9, 2020 03:59 | | Subject: | Re: Description Standardization Note | | Viewed: | 46 times | | Topic: | Catalog | |
| 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 | | Posted: | Feb 6, 2020 06:07 | | Subject: | Inventory Change Request for Set 7760-1 | | Viewed: | 24 times | | Topic: | Inventories Requests (Entry) | | Status: | Open | |
| Please make changes to the following inventory:
* | | 7760-1 (Inv) Electric Diesel Locomotive (Diesel Shunter Locomotive)
144 Parts, 2 Minifigures, 1980
Sets: Train: 12V |
* Change {1 to 2} Part Blue 3004pb033 Brick 1 x 2 with White '7760' Pattern (Sticker) - Set 7760 (Counterpart)
Comments from Submitter:
Add another part for right side of the locomotive.
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
