|
hi thanks for your reply, hope i can clarify
on a physical book is usually a barcode with the isbn number.
at firts when I add a new book I use a hand optical scanner to scan the isbn and add it in the option 'add by isbn number' and have Caz libre search for the additional information.
indeed calibre adds tje internal id, which i can read and add even to a custom field.
now I have many books, book cabinets, with shelves.
To find the book I want to, by cabinet, by shelf, scan the books somehow (excel for example) and add in calibre the corresponding cabinet number and shelf number in custom fields.
the same later maybe also for purchase price paid
I have found the isbn id is not always reliable, the internal id is.
so if I export all data, import t in excel, do my thing there with scanning, lookup the book and add the shelf etc, I want to export the fields
internal id preferably, plus sgelf, cabinet and optionally price, create for ex as mple a csv file to import back in calibre so the 2 or 3 custom fields will be populated.
alternatively if i have a odbc or other connection i can update in the data base directly.
perhaps by also scanning shelf and cabinet (i can generate barcodes and print thise in excel)
so scan: isbn sgelf cabinet, lookup in excel to populate complete set, save the fields i need as csv included id and or isbn, than import back
hope this clarifiesthanks again
|