Discussion Forum: Thread 252787 |
|
|
| | Author: | jameso321xyz | Posted: | May 27, 2019 23:36 | Subject: | Identify set number from only three parts | Viewed: | 80 times | Topic: | Inventories | Status: | Open | |
|
| I had a hundred or so parts bags that became a bit tedious to identify where
they were from although not impossible, but I was thinking grind a database against
them.
tldr
used the rebrickable public csv files in MS Access to create a crude Query where
given three parts and their specific color can more often than not narrow down
set origin or narrow to 2 or 3
I am not a database expert, I am a novice, but I work with consumer level computer
consulting for small businesses for 20 year etc.
I dont know how to serve it up on the Internet, but I am looking.
I have not written the front end to it because I dont know how yet (should be
easy)
I just thought this might be useful to other people in some capacity
Thanks for reading
|
|
|
|
| | | | | | | | | | |
| | | | | | Author: | jameso321xyz | Posted: | May 28, 2019 01:19 | Subject: | Re: Identify set number from only three parts | Viewed: | 28 times | Topic: | Inventories | |
|
| Nice! well, at least we are all on the same page sorta
In Inventories, Admin_Russell writes:
| In Inventories, jameso321xyz writes:
| I had a hundred or so parts bags that became a bit tedious to identify where
they were from although not impossible, but I was thinking grind a database against
them.
tldr
used the rebrickable public csv files in MS Access to create a crude Query where
given three parts and their specific color can more often than not narrow down
set origin or narrow to 2 or 3
I am not a database expert, I am a novice, but I work with consumer level computer
consulting for small businesses for 20 year etc.
I dont know how to serve it up on the Internet, but I am looking.
I have not written the front end to it because I dont know how yet (should be
easy)
I just thought this might be useful to other people in some capacity
Thanks for reading
|
Just use this:
https://www.bricklink.com/catalogIn.asp?viewMulti=Y
|
|
|
|
|
|
|
|