I'm confused - do you want to copy data from an external database into a calibre library database or vice-versa.
And when you say 'scan the books by isbn number which are on a certain shelf in a certain cabinet" are you referring to optical scanning or reading a database.
The calibre ID is the library database books table row number that SQLite assigns when a book is added, it won't be in your ODBC database unless you have a way of putting it there - and it may change.
Which plugins did you try that don't work, IIRC the Import List plugin matches on title and author using exact, similar, and fuzzy algorithms, and I have a vague notion that the Job Spy Import from CSV tool might have an ISBN matching option.
BR
|