Newbie question: automate changing collection info
Aderi ao LibraryThing para poder publicar.
Este tópico está presentemente marcado como "adormecido"—a última mensagem tem mais de 90 dias. Pode acordar o tópico publicando uma resposta.
I have used LibraryThing for a long time to keep track of where my books are stored. I have done this by creating collections ("Box 1", "Box 2", "Office shelves", etc.) and assigning books to them. Last year I moved houses, and all of my books are in different places now. I have a spreadsheet with one row per book that includes the old and new location (collection) info. Is there a way to update the locations in bulk? I would love to avoid clicking through the update collection process ~1400 times for every book in my library.
Thanks for any help.
Having said that, it sounds like the feature you are looking for is a standard LibraryThing feature called PowerEdit. That's the lightning bolt in the row of buttons at the top of your catalog. You can use that to select multiple books from whatever subset of books you have displayed and then add or remove them from specific collections.
I think the functionality is fairly straightforward once you enter PowerEdit mode but if you do have follow-up questions about how to make it work, feel free to ask here in this thread.
FROM MyBooksCollections o
JOIN UpdateList n
WHERE o.Collection = n.OldCollection
INSERT INTO MyBooksCollections (BookId, Collection)
SELECT BookId, NewCollection
Technically it is possible to do so - code can be written to go to the edit page, to click on the 'show all' button, to select the right collections etc and then save. However it isn't straightforward and certainly not a quick job
Power Edit is the way to do this as mentioned by rosalita. It makes moving all of "Box 2" to "Shelf 8" easy. If your boxes have been randomly distributed to different collections then you are probably going to have to manually change all the records.
To add to andyl's description, I tried to write this (using Selenium, so going through the GUI) when writing my script to automatically manual add a work. I gave up, because I couldn't get the "open collection list" -> "check these boxes" flow right. I believe I ran in to trouble with regards to not being able to identify the specific check boxes in relation to the collection I wanted (the collections themselves have specific static IDs). It probably is possible, but I just gave up on collections all together really.