Mobileread
count pages, change author & title to all caps
#1  MOJOJE 07-03-2020, 07:22 AM
Good morning,

My laptop crashed and has just been repaired. In the process I lost my Calibre Library, all settings and most unfortunately over 800 books. However I do see where the laptop did retain the library.

I need to know how to set a column to Count pages. Also I would like to be able to change all titles to upper case as well as the author. I previously had this option under "bulk convert", but since I lost everything previous set up the way I liked it I cannot do any of this.

Help would be greatly appreciated. Thanks!
Reply 

#2  ownedbycats 07-03-2020, 09:43 AM
Quote MOJOJE
Good morning,

My laptop crashed and has just been repaired. In the process I lost my Calibre Library, all settings and most unfortunately over 800 books. However I do see where the laptop did retain the library.

I need to know how to set a column to Count pages. Also I would like to be able to change all titles to upper case as well as the author. I previously had this option under "bulk convert", but since I lost everything previous set up the way I liked it I cannot do any of this.

Help would be greatly appreciated. Thanks!
1. To set up a page count column, first right-click on the column headers and go to "Add your own columns." Then add an integer column. I call mine #pagecount. Restart Calibre.

Then go to Preferences (Ctrl+P if it's not visible on toolbar) and Plugins and Get New Plugins. Search for Count Pages. Install it in the toolbar or right-click menu, whichever is easier for you. Restart Calibre and the button/menu will appear and you can check out its options and define a pagecount column. (Make sure not to accidentally set wordcount to the same column too, I've done that before.)

show attachment »

2. Changing title to upper-case is still available via bulk metadata:

show attachment »

It can also be done in individual metadata by right-clicking the field and using the option in "Change case..." submenu.
Reply 

#3  Horus68 07-03-2020, 10:17 AM
Quote MOJOJE
However I do see where the laptop did retain the library.
So you have a folder with the old library? Does it have a file "metadata.db" ?

Then you should start by opening that folder as a Calibre library to see what you have actually lost (probably you only need to install plugins and make some software wide settings, as the library settings are still in the old library folder "metadata.db"):
Click the library button in Calibre:
- Switch/Create library...
- New location (enter the path to the old ebook folder)
- set: "Use the previously existing library at the new location"
Done

Note: the count pages is a custom column so it should be in the old library, maybe you only have to install the plugin "Count Pages" to automate the count)
Reply 

#4  theducks 07-03-2020, 05:21 PM
IF your Library is intact (metadata.db and all, all you need to do is configure the plugin to use the (still) existing columns.
Most PI store their configs in the Calibre Configuration folder, all the data is per Library. (Note taht some PI do keep some configs in the metadata.db because they are Library specific) keep a backup of you config folder. when you restor, you will just get a notice you PI's may be (really) out of date and you simply update those as usual.
Reply 

#5  MOJOJE 07-03-2020, 11:37 PM
Thanks everyone for your help. It worked out great. What I am now looking for is previously I had the option to bulk convert author name and also title to all caps using a string command in the Search and Replace tab in the Bulk Convert selection under the Edit Metadata button. Someone from this group had previously provided this information to me, it might possibly have been "theducks" but I am not sure. Can anyone help me with this please.
Reply 

#6  theducks 07-03-2020, 11:50 PM
There is a tick box to change the Title's case in the MDE (bulk mode). Tou then get to choose HOW once it has been ticked
Reply 

Today's Posts | Search this Thread | Login | Register