BrickLink Discussion Forum

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:

calsbricks

Posted:

Feb 9, 2020 11:42

Subject:

Re: Description Standardization Note

Viewed:

36 times

Topic:

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:

calsbricks

Posted:

Feb 9, 2020 10:15

Subject:

Re: Description Standardization Note

Viewed:

46 times

Topic:

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 . . .

Author:

calsbricks

Posted:

Feb 9, 2020 06:29

Subject:

Re: Description Standardization Note

Viewed:

41 times

Topic:

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

Posted:

Feb 9, 2020 06:09

Subject:

Re: Description Standardization Note

Viewed:

51 times

Topic: