I should know this by now!!

LadyLou · 09-07-2011, 05:22 AM

Number one; Where do I find the 'database' as against the books showing in my library (calibre) I get a message that 'this title is in the database already do I want to add the book anyway) I have never worked this one out

Secondly, in Author list some on my authors are seperated I have tried fixing this by copy and pasting their names so that they are exactly the same (even though they look it already) This worked in a couple of cases but most are still seperated, and can I use a first (given) name order or surname order?

I have Barack Obama above Douglas Adams: Piers Anthony above Alex Archer etc.!

Many thanks in advance

LadyLou · 09-07-2011, 05:46 AM

OK guys, panic over, I found an old thread for the author thingy and am now going to labouriously change those at fault in the metadata.

Still like to know where the database is though!

kennyc · 09-07-2011, 06:30 AM

If you run "welcome wizard" under preferences. It will display the current location of the library.

jackie_w · 09-07-2011, 08:46 AM

The database file is called metadata.db and is found in the same directory as the one containing all the books. It's at the top level i.e. the one which contains all the authorname sub-directories

Pinecone · 09-07-2011, 10:15 AM

The quick way is to highlight all the books by an author and select Edit MetaData by Bulk. Go to the author field and start typing in, it should show choices based on author names already in the database. Pick the one that is the way you want. Check the box to automatically set Author Sort and let it rip.

It will change all the author names to exactly the same and the author sort also.

A typical issue I would have is J.A. Jance, it would show up as JA Jance, J.A. Jance, J. A. Jance. This quickly gets them all in the same format.

Individual books (one book by an author) you have to do by hand.

LadyLou · 09-07-2011, 10:57 AM

Thanks guys, done the author thing, learnt from i tunes that I have to be precise. Had the devils' own job with Virginia Andrews and all the combinations for that!!

Whilst here, is there a quick way to sort tags, in that some are 'my' reads, some are other people in the household etc. it would be nice to pull up just mine.

itimpi · 09-07-2011, 12:10 PM

you can always type something like tags:"tagvalue" in the search field to restrict the books with a tag matching 'tagvalue'. If you want to do this often you can save the search for later re-use.

DoctorOhh · 09-07-2011, 06:37 PM

Quote:

Originally Posted by LadyLou

Whilst here, is there a quick way to sort tags, in that some are 'my' reads, some are other people in the household etc. it would be nice to pull up just mine.

You can add tags for each user, but to avoid these tags being used as collections on your reader place them in brackets. Example, use [LadyLou] as a tag and you can search or restrict your calibre library using this tag but it will not be used to create a collection on your Sony reader.

LadyLou · 09-09-2011, 06:14 AM

Thank you all so much, I have a 'simple senior' mind so step by step help is really appreciated. Working my way through my library now using all the info given.

09-07-2011, 05:22 AM	#1
LadyLou Enthusiast Posts: 46 Karma: 100 Join Date: Dec 2009 Device: Sony Touch	I should know this by now!! Number one; Where do I find the 'database' as against the books showing in my library (calibre) I get a message that 'this title is in the database already do I want to add the book anyway) I have never worked this one out Secondly, in Author list some on my authors are seperated I have tried fixing this by copy and pasting their names so that they are exactly the same (even though they look it already) This worked in a couple of cases but most are still seperated, and can I use a first (given) name order or surname order? I have Barack Obama above Douglas Adams: Piers Anthony above Alex Archer etc.! Many thanks in advance Last edited by LadyLou; 09-07-2011 at 05:27 AM.

09-07-2011, 05:46 AM	#2
LadyLou Enthusiast Posts: 46 Karma: 100 Join Date: Dec 2009 Device: Sony Touch	OK guys, panic over, I found an old thread for the author thingy and am now going to labouriously change those at fault in the metadata. Still like to know where the database is though!

09-07-2011, 06:30 AM	#3
kennyc The Dank Side of the Moon Posts: 35,872 Karma: 118716293 Join Date: Sep 2009 Location: Denver, CO Device: Kindle2; Kindle Fire	If you run "welcome wizard" under preferences. It will display the current location of the library.

09-07-2011, 08:46 AM	#4
jackie_w Grand Sorcerer Posts: 6,212 Karma: 16534894 Join Date: Sep 2009 Location: UK Device: Kobo: KA1, ClaraHD, Forma, Libra2, Clara2E. PocketBook: TouchHD3	The database file is called metadata.db and is found in the same directory as the one containing all the books. It's at the top level i.e. the one which contains all the authorname sub-directories

09-07-2011, 10:15 AM	#5
Pinecone Guru Posts: 902 Karma: 1660722 Join Date: Nov 2009 Location: Maryland Device: PRS-650, PRS-600, PRS-350	The quick way is to highlight all the books by an author and select Edit MetaData by Bulk. Go to the author field and start typing in, it should show choices based on author names already in the database. Pick the one that is the way you want. Check the box to automatically set Author Sort and let it rip. It will change all the author names to exactly the same and the author sort also. A typical issue I would have is J.A. Jance, it would show up as JA Jance, J.A. Jance, J. A. Jance. This quickly gets them all in the same format. Individual books (one book by an author) you have to do by hand.

09-07-2011, 10:57 AM	#6
LadyLou Enthusiast Posts: 46 Karma: 100 Join Date: Dec 2009 Device: Sony Touch	Thanks guys, done the author thing, learnt from i tunes that I have to be precise. Had the devils' own job with Virginia Andrews and all the combinations for that!! Whilst here, is there a quick way to sort tags, in that some are 'my' reads, some are other people in the household etc. it would be nice to pull up just mine.

09-07-2011, 12:10 PM	#7
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	you can always type something like tags:"tagvalue" in the search field to restrict the books with a tag matching 'tagvalue'. If you want to do this often you can save the search for later re-use.

09-09-2011, 06:14 AM	#9
LadyLou Enthusiast Posts: 46 Karma: 100 Join Date: Dec 2009 Device: Sony Touch	Thank you all so much, I have a 'simple senior' mind so step by step help is really appreciated. Working my way through my library now using all the info given.

Advert

Advert