View Single Post
Old 11-28-2017, 03:11 AM   #11
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,450
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Pizza_Cant_Read View Post
I fear that amid beers and banging my head on the keyboard something here was lost.

Right next to "Library" in the top toolbar is "Device". After the initial sync it shows all of the documents I have in Calibre Companion. Just as with any other device I expect to be able to highlight those documents, right click and choose "Save to Library". Instead it hangs at 0% for <30 minutes before displaying the error I provided in an earlier post. Meanwhile Activity Monitor shows the process eating 100% of the CPU's resources. And that is after my phone is disconnected. I can't even kill it. Something weird is going on somewhere.
It seems like the problem is on the calibre side. Calibre does use lots of resources when adding multiple books to a library, and it can take time. Calibre also does a lot of upfront processing before starting to add any books. That is why a standard calibre "hint" is to add books a few at a time. If calibre takes too long then CC will time out.

Questions:

1) Have you tried adding the books to your library 1 or 2 at a time? This could avoid calibre spending a lot of time upfront, thus avoiding the timeouts.

2) Have you tried using calibre's device view "Save to disk" (not the one in the library view) to copy the book files from your iOS device onto your calibre computer? If this works (and it might because it avoids the add-to-library step) then once you have the books you can add them directly to calibre. I just tried it with Android CC and 20 books. It worked fine, taking 1/4 second per book.
Quote:
Any tips on how to get the meta data (specifically the series information) from CC and back in calibre? Because of limited time, it will take me weeks to find sources, rename them within calibre, repopulate the series column plus any conversion. Any advice you can offer on how I can do this more easily would be very much appreciated!

<3 Thanks <3

-pcr
There is no easy way that I know of to get an easy-to-use electronic copy of CC's metadata.

One possibility that on Android would be a rather large pain: in CC make a backup that contains the database. Copy that backup to the calibre computer. Open it, extract the database, then for each book extract the JSON-formatted metadata. I don't know if these steps are even possible on iOS CC.

Personally, I wouldn't bother with all the faffing around. Given that you have all the metadata on the iOS device and given that you can easily see it, I would do it by hand, assuming I can upload the formats as discussed above. First I would add the book files to calibre using the "use metadata in book file" option. Sort the list in calibre by title. Do the same sort in CC. Then for each book in calibre, find that book in CC (it should be easy if they are sorted the same), open CC book details, then enter the series metadata into calibre. Android CC supports swiping to see the book details of the "next" book. If iOS CC supports that (and I think it does), swipe to the next book. A down-arrow in calibre should take you to the same book. This process takes some seconds per book, which for 1,000 books translates to less than 2 hours.

BTW: do you happen to have a copy of calibre's metadata.db left over from the original disaster, even an older one? If so then you can recover more easily. What you would do is:
  1. Create an empty calibre library. Close calibre.
  2. Copy the recovered metadata.db to the empty calibre library.
  3. Restart calibre. You should see all your books. Of course, the actual books aren't there. Calibre doesn't care.
  4. Assuming you can recover the books using the device view "save to disk", then for each book file recovered, click on the same book in calibre then drag the book file onto the book details panel in calibre. That adds the book file to calibre's library using the existing book/metadata.
chaley is offline   Reply With Quote