| Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies Author: | Turez | Posted: | Feb 9, 2020 16:12 | Subject: | Re: Inventory Change Request for Set 6667-1 | Viewed: | 25 times | Topic: | Inventories Requests | |
|
| In Inventories Requests, randyf writes:
| In Inventories Requests, Turez writes:
| In Inventories Requests, paulvdb writes:
| Please make changes to the following inventory:
* Add 5 Part 2412a Light Gray Tile, Modified 1 x 2 Grille without Bottom Groove / Lip (match ID 2)
* Change 5 Part Light Gray 2412b Tile, Modified 1 x 2 Grille with Bottom Groove / Lip {Regular to Alternate} {match ID 0 to 2}
Comments from Submitter:
https://forum.brickpirate.net/viewtopic.php?f=18&t=24109 shows 2412a. Set in my personal collection has 2412b so both variants should be in this inventory.
|
Unfortunately it is not clear if the parts used to build the set for that review
are original. They are definitly not new (at least the technic axle has clearly
visible signs of usage) and the user "TOOL" mentioned somewhere in another review
thread that he sometimes uses two copies of a set for the reviews (a new one
to show the sealed bags and a used one to show the parts and the completed model).
Therefore in this case I would not consider the photos as a reliable source.
Regards,
Jonas
|
I don't see any parts in that review that look particularly used. The Technic
axle has visible plastic flow lines in it, but I don't see any wear on it.
|
I have never seen anything like that on a new axle, but you may be right and
then everything is fine.
(Nevertheless I suggest to be careful with pics from that source. Here we can
see the wrong variant
for example:
https://forum.brickpirate.net/viewtopic.php?f=19&t=10447 )
|
|
Author: | randyf | Posted: | Feb 9, 2020 15:45 | Subject: | Re: Inventory Change Request for Set 6667-1 | Viewed: | 32 times | Topic: | Inventories Requests | |
|
| In Inventories Requests, Turez writes:
| In Inventories Requests, paulvdb writes:
| Please make changes to the following inventory:
* Add 5 Part 2412a Light Gray Tile, Modified 1 x 2 Grille without Bottom Groove / Lip (match ID 2)
* Change 5 Part Light Gray 2412b Tile, Modified 1 x 2 Grille with Bottom Groove / Lip {Regular to Alternate} {match ID 0 to 2}
Comments from Submitter:
https://forum.brickpirate.net/viewtopic.php?f=18&t=24109 shows 2412a. Set in my personal collection has 2412b so both variants should be in this inventory.
|
Unfortunately it is not clear if the parts used to build the set for that review
are original. They are definitly not new (at least the technic axle has clearly
visible signs of usage) and the user "TOOL" mentioned somewhere in another review
thread that he sometimes uses two copies of a set for the reviews (a new one
to show the sealed bags and a used one to show the parts and the completed model).
Therefore in this case I would not consider the photos as a reliable source.
Regards,
Jonas
|
I don't see any parts in that review that look particularly used. The Technic
axle has visible plastic flow lines in it, but I don't see any wear on it.
Cheers,
Randy
|
|
Author: | Turez | Posted: | Feb 9, 2020 15:22 | Subject: | Re: Inventory Change Request for Set 6667-1 | Viewed: | 28 times | Topic: | Inventories Requests | |
|
| In Inventories Requests, paulvdb writes:
| Please make changes to the following inventory:
* Add 5 Part 2412a Light Gray Tile, Modified 1 x 2 Grille without Bottom Groove / Lip (match ID 2)
* Change 5 Part Light Gray 2412b Tile, Modified 1 x 2 Grille with Bottom Groove / Lip {Regular to Alternate} {match ID 0 to 2}
Comments from Submitter:
https://forum.brickpirate.net/viewtopic.php?f=18&t=24109 shows 2412a. Set in my personal collection has 2412b so both variants should be in this inventory.
|
Unfortunately it is not clear if the parts used to build the set for that review
are original. They are definitly not new (at least the technic axle has clearly
visible signs of usage) and the user "TOOL" mentioned somewhere in another review
thread that he sometimes uses two copies of a set for the reviews (a new one
to show the sealed bags and a used one to show the parts and the completed model).
Therefore in this case I would not consider the photos as a reliable source.
Regards,
Jonas
|
|
Author: | randyf | Posted: | Feb 9, 2020 12:47 | Subject: | Re: Inventory Change Request for Set 4758-1 | Viewed: | 29 times | Topic: | Inventories Requests | |
|
| In Inventories Requests, axaday writes:
| In Inventories Requests, randyf writes:
| In Inventories Requests, axaday writes:
| Please make changes to the following inventory:
* Change 1 Part {Earth Orange to Dark Nougat} 30374 Bar 4L (Lightsaber Blade / Wand)
Comments from Submitter:
Pics to follow
|
Congratulations on being the first person to get a true Dark Nougat part into
an inventory!
|
I scrambled for it.
|
I knew you would.
|
|
Author: | StormChaser | Posted: | Feb 9, 2020 12:41 | Subject: | Re: 3297 smooth or rough surface? | Viewed: | 41 times | Topic: | Catalog | |
|
| In Catalog, Lamondera writes:
| Hello, I have two different versions of the slope 3297, some smooth and some
with a rough surface. Is there a single entry for both?
|
Yes, there is a single entry:
|
|
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: | calsbricks | Posted: | Feb 9, 2020 12:10 | Subject: | Re: Description Standardization Note | Viewed: | 40 times | Topic: | Catalog | |
|
| 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 | 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: | paulvdb | Posted: | Feb 9, 2020 11:54 | Subject: | Inventory Change Request for Set 6667-1 | Viewed: | 34 times | Topic: | Inventories Requests (Entry) | Status: | Open | |
|
| Please make changes to the following inventory:
* Add 5 Part 2412a Light Gray Tile, Modified 1 x 2 Grille without Bottom Groove / Lip (match ID 2)
* Change 5 Part Light Gray 2412b Tile, Modified 1 x 2 Grille with Bottom Groove / Lip {Regular to Alternate} {match ID 0 to 2}
Comments from Submitter:
https://forum.brickpirate.net/viewtopic.php?f=18&t=24109 shows 2412a. Set in my personal collection has 2412b so both variants should be in this inventory.
|
|
Author: | calsbricks | Posted: | Feb 9, 2020 11:42 | Subject: | Re: Description Standardization Note | Viewed: | 37 times | Topic: | Catalog | |
|
| 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.
|
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
|