calibre 0.6.0 released - Page 10

gai-jin · 08-04-2009, 05:59 PM

Quote:

Originally Posted by kovidgoyal

Searching always queries the inmemory database, otherwise it would be too slow on large collections

Is there a way to force Calibre to rescan all of the metadata and rebuild the in memory database?

kovidgoyal · 08-04-2009, 06:05 PM

No there isn't

user_none · 08-04-2009, 06:35 PM

Quote:

Originally Posted by gai-jin

Kovid -- In a previous thread, you said that a search for "format:false" should show all books with no formats available. I've tried that in .64 and .65, but I get no results. Searching for other formats (such as "format:mobi") works as expected.

Any idea what I'm doing wrong?

Is there any info I can give you to help troubleshoot?

format:false is working properly for me. Try adding an empty book (it's a sub option under add) and see if it filters with that one correctly.

gai-jin · 08-04-2009, 07:14 PM

Quote:

Originally Posted by user_none

format:false is working properly for me. Try adding an empty book (it's a sub option under add) and see if it filters with that one correctly.

That does work, and I also tried deleting one format of a book that was only available in that one format, and the book does now show up in format false.

So right now, I've got a LOT of books that show no formats available when I am on the edit metadata screen, and also on the small details pane below the book list when I select a book. But when I search for format:false, None of those show up in the results. Clearly, the 'in memory' database is out of sync with whatever Calibre looks at to populate the details pane. How can I fix that?

Do I just need to uninstall calibre and re-install it? Or would it still see the old data files and end up with the same issue?

If I do re-install, is all the work I've done on correcting metadata for books going to be lost, or does calibre save the changes in the original ebook when I make changes?

Sydney's Mom · 08-04-2009, 10:24 PM

For once, I hope I can help someone. I was trying to convert an epub book I had decrypted. I had used Calibre to convert such books to mobi format in the past. But this time I was getting an error message that it was an unknown format. I renamed the book "book.epub" (it had some extra stuff, book.xx.decrypted.epub),and it worked like a charm.

msr · 08-04-2009, 10:49 PM

Noticed an odd alphabetization issue when ordering books by title (v0.6.5).
* Books that begin with "The " alphabetize by the second word (as they should).
* Books that begin with "Thexxx" (e.g., There, Theory, or Theme) alphabetize correctly by the first word, whatever it happens to be.
* Books that begin with "The Thexxx" alphabetize by the "xxx". The "The" is removed twice. For example, "The Theory of Atlantis" will alphabetize as "ory of Atlantis" rather than "Theory of Atlantis".

The same exact pattern/error occurs with titles beginning with "A Axxx" (which is improper English, but still) and with "An Anxxx".

msr · 08-04-2009, 10:54 PM

I know this is not currently an option, but would it be possible to add the ability to export the meta-data list? Something simple like CSV or tab delimited would be fine. Even just author and title would be extremely useful.

kovidgoyal · 08-04-2009, 11:09 PM

Quote:

Originally Posted by msr

Noticed an odd alphabetization issue when ordering books by title (v0.6.5).
* Books that begin with "The " alphabetize by the second word (as they should).
* Books that begin with "Thexxx" (e.g., There, Theory, or Theme) alphabetize correctly by the first word, whatever it happens to be.
* Books that begin with "The Thexxx" alphabetize by the "xxx". The "The" is removed twice. For example, "The Theory of Atlantis" will alphabetize as "ory of Atlantis" rather than "Theory of Atlantis".

The same exact pattern/error occurs with titles beginning with "A Axxx" (which is improper English, but still) and with "An Anxxx".

Will be fixed in the next release. You can use the command

calibredb list

to generate a listing of entries in the database

slantybard · 08-05-2009, 12:27 AM

Ticket opened: 3083:

When I generate an ePub file from txt documents that don't have a proper cover/title page, calibre now generates a xhtml file with the title (h1) and author (h2) and "produced by calibre" (h4). It actually looks nice :-) but the h1, h2 and h4 headings are not resized properly on the prs505 and they take up so much space that the title is often not even visible on the screen and goes beyond the edges. I tried remapping the font key to take care of this, but it seems that the font key mapping size is not applied to this xhtml.

ldolse · 08-05-2009, 01:33 AM

Quote:

Originally Posted by gai-jin

So right now, I've got a LOT of books that show no formats available when I am on the edit metadata screen, and also on the small details pane below the book list when I select a book. But when I search for format:false, None of those show up in the results. Clearly, the 'in memory' database is out of sync with whatever Calibre looks at to populate the details pane. How can I fix that?

Do I just need to uninstall calibre and re-install it? Or would it still see the old data files and end up with the same issue?

If I do re-install, is all the work I've done on correcting metadata for books going to be lost, or does calibre save the changes in the original ebook when I make changes?

I noticed a bug during the .6 beta which I haven't had time to delve into in detail. Several of my books with no formats actually have formats in the actual book directory - use the 'Open Containing Folder' menu option to check this out. In my case these books also fail to match the format:false query. If you're seeing the same behavior as me then don't change the metadata for these books unless you have backups, as editing any of the data will delete the actual book Calibre doesn't see.

In my case I had no way to get anything to stick to these specific books, I could re-add formats, but they wouldn't save. I suspect completely deleting the book and re-adding will work. Since the query doesn't work I've resorted to clicking through the books in the list one-by-one to see which don't report having formats.

I took a glance at these books in a SQL database viewer. Nothing jumped out on the first check, but I'll look again.

Student1 · 08-05-2009, 02:22 PM

Hi Kovid,

hopefully this question hasn t been answered too many times already

! I'm still using 0.5.14 and was wondering if my current 40000+ database i have for it will survive the upgrade to 0.6.5 I m asking because it took me one month to insert all these books and would kill me to have to do it again if dbs are not compatible between versions

!

anyway thanks for all these great calibre versions

!

kovidgoyal · 08-05-2009, 02:24 PM

It should

That said, back it up before updating.

Student1 · 08-05-2009, 02:42 PM

Quote:

Originally Posted by kovidgoyal

It should

That said, back it up before updating.

Thanks you are the greatest! Will do a backup for sure thanks

!

user_none · 08-06-2009, 07:39 AM

@ldolse, The available formats should be read from the metadata by the formts function in library.database2.

@gai-jin,
@ldolse, Can one of you create a bug for this and attach your metadata.db file?

ldolse · 08-06-2009, 10:39 AM

I'll look at that code, though I'm probably not going to be much help for this. Note for these books it refuses to acknowledge any formats. They were originally put in the book directory by Calibre .5, so there's no issues with naming, etc there. Attempting to manually add a specific type of source file in the edit metadata dialog does nothing.

I'll go ahead and open a bug and attach my metadata.db.

edit:
bug is here: http://calibre.kovidgoyal.net/ticket/3092

08-06-2009, 10:39 AM	#150
ldolse Wizard Posts: 1,337 Karma: 123455 Join Date: Apr 2009 Location: Malaysia Device: PRS-650, iPhone	I'll look at that code, though I'm probably not going to be much help for this. Note for these books it refuses to acknowledge any formats. They were originally put in the book directory by Calibre .5, so there's no issues with naming, etc there. Attempting to manually add a specific type of source file in the edit metadata dialog does nothing. I'll go ahead and open a bug and attach my metadata.db. edit: bug is here: http://calibre.kovidgoyal.net/ticket/3092 Last edited by ldolse; 08-06-2009 at 11:26 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calibre 0.7.0 released!	kovidgoyal	Calibre	194	09-20-2010 02:04 PM
Calibre 0.7.0 released - see site details below	Paulc15	Kobo Reader	16	06-07-2010 12:27 PM
Calibre 0.6.55 released - see site for details	Paulc15	Kobo Reader	1	05-28-2010 08:54 PM
calibre 0.6.0 released!	kovidgoyal	News	86	08-12-2009 04:57 PM
calibre 0.5.0 released!	kovidgoyal	Calibre	99	03-12-2009 07:43 PM

08-04-2009, 06:05 PM	#137
kovidgoyal creator of calibre Posts: 45,378 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	No there isn't

08-04-2009, 10:24 PM	#140
Sydney's Mom Wizard Posts: 2,899 Karma: 6995721 Join Date: Dec 2008 Location: Idaho, on the side of a mountain Device: Kindle Oasis, Fire 3d Gen and 5th Gen and Samsung Tab S	For once, I hope I can help someone. I was trying to convert an epub book I had decrypted. I had used Calibre to convert such books to mobi format in the past. But this time I was getting an error message that it was an unknown format. I renamed the book "book.epub" (it had some extra stuff, book.xx.decrypted.epub),and it worked like a charm.

08-04-2009, 10:49 PM	#141
msr Member Posts: 23 Karma: 10 Join Date: Jul 2009 Device: Kindle2	Noticed an odd alphabetization issue when ordering books by title (v0.6.5). * Books that begin with "The " alphabetize by the second word (as they should). * Books that begin with "Thexxx" (e.g., There, Theory, or Theme) alphabetize correctly by the first word, whatever it happens to be. * Books that begin with "The Thexxx" alphabetize by the "xxx". The "The" is removed twice. For example, "The Theory of Atlantis" will alphabetize as "ory of Atlantis" rather than "Theory of Atlantis". The same exact pattern/error occurs with titles beginning with "A Axxx" (which is improper English, but still) and with "An Anxxx".

08-04-2009, 10:54 PM	#142
msr Member Posts: 23 Karma: 10 Join Date: Jul 2009 Device: Kindle2	I know this is not currently an option, but would it be possible to add the ability to export the meta-data list? Something simple like CSV or tab delimited would be fine. Even just author and title would be extremely useful.

08-05-2009, 12:27 AM	#144
slantybard my parent's oops... Posts: 492 Karma: 1477572 Join Date: Feb 2009 Device: Vx->Handera->Clie-> Axim->505->650->KPW/Aura ->L2->iOS/CBW	Ticket opened: 3083: When I generate an ePub file from txt documents that don't have a proper cover/title page, calibre now generates a xhtml file with the title (h1) and author (h2) and "produced by calibre" (h4). It actually looks nice :-) but the h1, h2 and h4 headings are not resized properly on the prs505 and they take up so much space that the title is often not even visible on the screen and goes beyond the edges. I tried remapping the font key to take care of this, but it seems that the font key mapping size is not applied to this xhtml.

08-05-2009, 02:22 PM	#146
Student1 Groupie Posts: 159 Karma: 170 Join Date: Feb 2009 Device: PRS-505	Hi Kovid, hopefully this question hasn t been answered too many times already ! I'm still using 0.5.14 and was wondering if my current 40000+ database i have for it will survive the upgrade to 0.6.5 I m asking because it took me one month to insert all these books and would kill me to have to do it again if dbs are not compatible between versions ! anyway thanks for all these great calibre versions !

08-05-2009, 02:24 PM	#147
kovidgoyal creator of calibre Posts: 45,378 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	It should That said, back it up before updating.

08-06-2009, 07:39 AM	#149
user_none Sigil & calibre developer Posts: 2,487 Karma: 1063785 Join Date: Jan 2009 Location: Florida, USA Device: Nook STR	@ldolse, The available formats should be read from the metadata by the formts function in library.database2. @gai-jin, @ldolse, Can one of you create a bug for this and attach your metadata.db file?

Advert

Advert