MobileRead Forums - View Single Post

mike_bike_kite · 06-18-2013, 10:48 AM

With a 100 books that might be possible but unfortunately I have a few more than that

I'd of thought it would be straightforward (perhaps not simple but at least straightforward) to write something that would see if the title field appears as a valid author field. I guess if a book has a rating then it's a valid author. You'd also have to be careful of combinations like "Richard Dawkins", "Dawkins, Richard", "R Dawkins" etc.

I guess there are lot's of common patterns that can be removed ie (YYYY) etc.

It seems like this is something that could be automated. Obviously the program wouldn't have access to a complete book database but it might be enough just to look at other books the user has.

Some books also have the series name shoved in there at random positions which might be hard to spot by program.

Is there an accessible SQL database that holds the users library? I'd be happy to write the SQL to cover these sorts of issues and then perhaps someone more knowledgeable with Calibre could add it into a small option.

Mike

06-18-2013, 10:48 AM	#7
mike_bike_kite Digitally confused Posts: 500 Karma: 1500000 Join Date: Mar 2010 Location: London, UK Device: KPW, K2i, Nexus 7 32gb, Kobo Mini	With a 100 books that might be possible but unfortunately I have a few more than that I'd of thought it would be straightforward (perhaps not simple but at least straightforward) to write something that would see if the title field appears as a valid author field. I guess if a book has a rating then it's a valid author. You'd also have to be careful of combinations like "Richard Dawkins", "Dawkins, Richard", "R Dawkins" etc. I guess there are lot's of common patterns that can be removed ie (YYYY) etc. It seems like this is something that could be automated. Obviously the program wouldn't have access to a complete book database but it might be enough just to look at other books the user has. Some books also have the series name shoved in there at random positions which might be hard to spot by program. Is there an accessible SQL database that holds the users library? I'd be happy to write the SQL to cover these sorts of issues and then perhaps someone more knowledgeable with Calibre could add it into a small option. Mike Last edited by mike_bike_kite; 06-18-2013 at 10:59 AM.