I was going to cross post this to a bunch of music echos but couldn't figure how to in Synchronet. I also figure if you read it here, you'd probably see it 5 times on the other networks...
anyway, I digress. As some of you may know, I have a huge collection of about 3,500 CDs that I want to sell. People keep asking me to make a list but it's a daunting task.
I started off manually typing in each CD into an Excel sheet on my computer, which is incredibly slow. I decided to get a barcode reader to help speed up the process. This is conneted to my Windows PC and scans the barcode and writes out to my ssh session as keyboard input.
I wrote a shell script on my Linux box to do a lookup on MusicBrainz and Discogs and write the results to a file that I could import into Excel, but not getting great results due to how the barcode data was entered so...
Now I have a local database of the Discogs data and a local MusicBrainz server just for fun, so I can fiddle around with data and create indexes and the like. Success! About 75% of the CDs are already in one or both of these databases.
But what a pain getting that list into Excel and then updating it as a Google Sheet. Google API to the rescue!
I converted the xlsx sheet to a Google sheet and, using the api, once I confirm the scanned barcode pulled back the correct data, when I save it automatically updates the Google sheet!
This means, anyone who wants to look at the list can check back daily as I add a batch of CDs to the list. No prices as yet, Probably $2 per CD, $3.50 for a double, and $4 for 3 disc set. $1 for CD singles. Maybe a bit extra for some factory sealed ones, signed, rare, parental advisory etc.
Anyway, if you want to take a look at the list, it's here...
https://docs.google.com/spreadsheets/d/1tMXms_Lf5O-Dua-sxEKzK84wpIVuWfL4EcO8zutKmX4/edit?usp=sharing
It's interesting how we can use a lot of different bits to make a larger job easier.
--- SBBSecho 3.24-Linux
* Origin: End Of The Line BBS - endofthelinebbs.com (21:2/101)