Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 09-19-2013, 03:30 PM   #1
Riva3000
Calibre fan
Riva3000 began at the beginning.
 
Riva3000's Avatar
 
Posts: 28
Karma: 10
Join Date: Jul 2011
Location: Europe
Device: iRex 800SG, iPhone 3GS (shelved: iRex iLiad, KindleDX, Adam tablet)
Unhappy Way to couple/group book records which are basicaly same book in different languages?

Which would be the best way to do this ?

Might be a bit ambiguous idea, but thats all I have in my head now. Seeing the chaos of different titles in my calibre library, a lot of which are basicaly the same book.
Riva3000 is offline   Reply With Quote
Old 09-20-2013, 10:49 AM   #2
Sabardeyn
Guru
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 644
Karma: 1242364
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
I'm not sure that there is an effective way to handle this situation in the current version of calibre.

At present calibre depends on a single record corresponding to a specific printing of a book. In this way it can account for multiple editions (original, illustrated, anniversary, etc), printings (re-printed without changes but different publisher or date), and other issues where either the title and/or the metadata changes. Effectively, there is a one-to-one relationship: 1 record in calibre = 1 real book.

What you are looking for is more of a 1 record = Nth book(s) situation. A one-to-many situation as found in relational databases. Unfortunately calibre does not easily handle these situations.

The primary stumbling block for something like this is how to handle the metadata. The title is easy; simply choose a primary language and enter all book titles fully translated to that language. You could account for the original language by adding "(language)" to the title, and/or equivalent tags or entries in the language field.

Which is fine. But now how do you deal with some of the other data, like publisher, published, date, and rating? Because the info displayed in these fields may be substantially different. Possibly including tags (due to poor translation issues?).

As I understand it, Kovid is looking into the idea and working toward a relational database solution which maintains current functionality... but he's also said it's a long-term project, not something that will be implemented any time soon. (Please note this is my phrasing based on my potentially faulty memory of Kovid's comments - so don't blame him if I got it wrong.)


The only thing I can think to recommend is adding your own unique identifier: MyID. Perhaps with five digits and making use of leading zeros (for proper sorting)? That would allow you to have 99,999 unique books (not titles, you can have unlimited titles) written in any language, by any publisher, at any time, etc. The problem becomes one of keeping track of your MyID listing/usage.

You could make the MyID a custom column and keep track of it separately, rather than adding it as an ID (per existing field). Or a derived custom column, with MyID# and MyIDName.

Hope this explanation and suggestion is of some use to you.


PS: Hmm... You might even be able to just use the book's title (MyIDName) as a tag. Then you could search for "The Hobbit", and get a listing of every edition within your library, regardless of differences within the rest of the metadata.
Sabardeyn is offline   Reply With Quote
Reply

Tags
book, calbre, languages, record, versions

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
group an ARBITRARY subset of records RotAnal Library Management 6 10-09-2012 11:53 AM
One book in diffrent languages jasambre Library Management 9 01-07-2012 02:16 PM
Bargain (Kindle) From the Hachette Book Group ($0.99-2.99) arcadata Deals and Resources (No Self-Promotion or Affiliate Links) 13 06-29-2011 07:42 PM
Merge book records doesn't copy author and title ? JackLiu Calibre 4 09-25-2010 11:36 PM


All times are GMT -4. The time now is 09:18 PM.


MobileRead.com is a privately owned, operated and funded community.