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 02-13-2013, 06:50 AM   #1
anthony.burton4
Enthusiast
anthony.burton4 began at the beginning.
 
Posts: 42
Karma: 10
Join Date: Aug 2010
Device: iPhone
Bulk removal of rating field

I have a custom field which uses the rating (1-5) datatype.

How can I use the bulk edit screen to set books to unrated?

If I select all the books, go tot he edit screen, enter 0 stars, or leave it saying unrated and check the apply changes box, nothing happens. I can only get it to work when ALL of the selected books have the same rating, eg. I select all the 5 star rated books and set them to 0.
anthony.burton4 is offline   Reply With Quote
Old 02-13-2013, 07:56 AM   #2
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,699
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
(The Normal) 'Rating' is a spinbox, which has a choices of:Unchanged, 0,1, 2, 3, 4, 5 (stars)
There is no prior condition required.
Are you trying to use Search and Replace to make this change instead of the 'Custom Metadata' Tab?
theducks is offline   Reply With Quote
Old 02-13-2013, 10:43 AM   #3
anthony.burton4
Enthusiast
anthony.burton4 began at the beginning.
 
Posts: 42
Karma: 10
Join Date: Aug 2010
Device: iPhone
Can't use Search & Replace for this operation as the field does not appear in the list.

I'll repeat the scenario to avoid confusion.

I have 2 books, one marked with 5 stars, one with 2 stars.

I select both the books and open up the bulk edit screen.

The custom field I want to reset is currently displaying "unrated".
Attempt#1: I check the "Apply changes" checkbox next to this field and click Apply.
The data is unchanged.
Attempt#2: I set the field to 0 stars and check the "Apply changes" box and click apply.
The data is unchanged.

Anyway - I've found a workaround now - should have spotted this before.
If I set both books to 1 star and click apply, and then set it to unrated and click apply, the field is successfully set to unrated. I just can't go directly from a mixed result set to unrated for some reason...

Note a similar thing happens with text based custom fields too - however I use the search and replace with a "(.*)" regex expression to empty them so I've worked around the problem.

Using calibre 64 bit 0.9.16

Last edited by anthony.burton4; 02-13-2013 at 10:45 AM.
anthony.burton4 is offline   Reply With Quote
Old 02-13-2013, 11:09 AM   #4
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,699
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by anthony.burton4 View Post
Can't use Search & Replace for this operation as the field does not appear in the list.

I'll repeat the scenario to avoid confusion.

I have 2 books, one marked with 5 stars, one with 2 stars.

I select both the books and open up the bulk edit screen.

The custom field I want to reset is currently displaying "unrated".
Attempt#1: I check the "Apply changes" checkbox next to this field and click Apply.
The data is unchanged.
Attempt#2: I set the field to 0 stars and check the "Apply changes" box and click apply.
The data is unchanged.

Anyway - I've found a workaround now - should have spotted this before.
If I set both books to 1 star and click apply, and then set it to unrated and click apply, the field is successfully set to unrated. I just can't go directly from a mixed result set to unrated for some reason...

Note a similar thing happens with text based custom fields too - however I use the search and replace with a "(.*)" regex expression to empty them so I've worked around the problem.

Using calibre 64 bit 0.9.16
Something is odd.
Anytime I set a value in a field, the box for that field automatically ticks.

Search and replace: Custom fields start with a # and usually appear at the top of the list
theducks is offline   Reply With Quote
Old 02-13-2013, 09:15 PM   #5
anthony.burton4
Enthusiast
anthony.burton4 began at the beginning.
 
Posts: 42
Karma: 10
Join Date: Aug 2010
Device: iPhone
Rating fields do not appear in the Search and Replace screen.

It should be reasonably straightforward to reproduce my problem.
anthony.burton4 is offline   Reply With Quote
Old 02-13-2013, 10:58 PM   #6
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,699
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by anthony.burton4 View Post
Rating fields do not appear in the Search and Replace screen.

It should be reasonably straightforward to reproduce my problem.
You have me confused
You said a CUSTOM rating field.

OK
I just tested for you on 9.18 XP Pro SP3

I set random (1-5)stars in 5 books
Then I selected all those books and tapped E for bulk edit mode.
I then used the spin box to set to '0 Stars' (default is unchanged)
Clicked Apply
Clicked OK to exit.
A 5 books are now back at 0 (I don't use ratings)
theducks is offline   Reply With Quote
Old 02-14-2013, 09:29 AM   #7
anthony.burton4
Enthusiast
anthony.burton4 began at the beginning.
 
Posts: 42
Karma: 10
Join Date: Aug 2010
Device: iPhone
I said exactly what I meant - perhaps you're not familiar with custom fields though?

I have a custom field which uses the rating (1-5) datatype.

Standard fields behave correctly.
Custom fields do not.
anthony.burton4 is offline   Reply With Quote
Old 02-14-2013, 09:42 AM   #8
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,699
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by anthony.burton4 View Post
I said exactly what I meant - perhaps you're not familiar with custom fields though?

I have a custom field which uses the rating (1-5) datatype.

Standard fields behave correctly.
Custom fields do not.
I don't have a Custom Rating type field, so I could not say.

What I find surprising is one of the prime developers has not stepped in on this question.

(Note: I have been using Custom fields since they first appeared. Users are always finding new ways to use things that the developers did not envision. )
theducks is offline   Reply With Quote
Old 02-14-2013, 11:09 AM   #9
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 25,989
Karma: 5036765
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You will have to wait till chaley gets back, custom fields are his bailiwick, though looking at the dialog, I'm guessing you forgot to check the "apply changes" checkbox to the right of the custom rating field.

Last edited by kovidgoyal; 02-14-2013 at 11:12 AM.
kovidgoyal is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data from Title field to IDs field rlh3 Library Management 9 09-24-2012 08:12 AM
[Old Thread] Bulk ISBN Removal brewjono Calibre 8 05-04-2011 06:15 PM
Bulk Meta Data Edit Resetting Custom Field toomuchreading Calibre 8 10-22-2010 10:19 PM
Bulk edit - how to set the rating to 0 stars? highwaykind Calibre 3 02-01-2010 01:17 PM
Feature Request for Edit Meta Information window's Rating field RoninTech Calibre 15 02-05-2009 08:45 PM


All times are GMT -4. The time now is 04:21 AM.


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