Comment by DiggyJohnson
3 days ago
That is amazing. For odd reasons I had to get real familiar with ISBN as well. What did that sql command look like if you don’t mind me asking?
3 days ago
That is amazing. For odd reasons I had to get real familiar with ISBN as well. What did that sql command look like if you don’t mind me asking?
Literally just a join against a lookup table of alternate ISBNs. So the ISBNs in the reading list were first “expanded” with all possible titles, then they were matched to the books actually in the library.
The ISBN alternatives table was just groups with an integer ID shared by each group. My import process synthesised this from worldcat data, which was more messy.