Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 08-08-2018, 01:12 PM   #1
StegBook
Member
StegBook began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2014
Device: Kindle Paperwhite 5
Bulk edit replace problem

I'm trying to use Bulk Edit to copy from the series name to the series index.

I have "The Secret Cold War 4[1]" in the series column and I want to change the index to 4 but am getting the following error

I'm using
Search Field: series
Search For: \d
Destination Field: series_index



calibre, version 3.28.0
ERROR: Failed: could not convert string to float: The Secret Cold War

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 168, in do_it
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 445, in do_all
File "site-packages\calibre\db\cache.py", line 63, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1092, in set_field
File "site-packages\calibre\db\write.py", line 540, in set_books
File "site-packages\calibre\db\write.py", line 540, in <dictcomp>
File "site-packages\calibre\db\write.py", line 141, in adapt_series_index
File "site-packages\calibre\db\write.py", line 96, in adapt_number
ValueError: could not convert string to float: The Secret Cold War


Any help is appreciated
StegBook is offline   Reply With Quote
Old 08-08-2018, 06:56 PM   #2
theducks
Well trained by Cats
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: 31,042
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by StegBook View Post
I'm trying to use Bulk Edit to copy from the series name to the series index.

I have "The Secret Cold War 4[1]" in the series column and I want to change the index to 4 but am getting the following error

I'm using
Search Field: series
Search For: (\d)
Destination Field: series_index



calibre, version 3.28.0
ERROR: Failed: could not convert string to float: The Secret Cold War

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 168, in do_it
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 445, in do_all
File "site-packages\calibre\db\cache.py", line 63, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1092, in set_field
File "site-packages\calibre\db\write.py", line 540, in set_books
File "site-packages\calibre\db\write.py", line 540, in <dictcomp>
File "site-packages\calibre\db\write.py", line 141, in adapt_series_index
File "site-packages\calibre\db\write.py", line 96, in adapt_number
ValueError: could not convert string to float: The Secret Cold War


Any help is appreciated
You captured nothing, so the replace failed
theducks is online now   Reply With Quote
Advert
Old 08-08-2018, 09:46 PM   #3
StegBook
Member
StegBook began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2014
Device: Kindle Paperwhite 5
Quote:
Originally Posted by theducks View Post
You captured nothing, so the replace failed
I'm still getting the same cannot convert from string to float error
StegBook is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Edit Search & Replace expressions? OldLincoln Library Management 6 01-14-2017 06:00 PM
Bulk Metadata Edit search replace Question Paltieldav Library Management 5 03-01-2016 06:12 AM
Edit metadata in bulk vs search and replace inl1ner Library Management 6 07-14-2014 06:58 PM
Calibre Bulk edit Mode says Search/Replace invalid when it is not even used tempura Library Management 10 04-03-2014 05:23 PM
2 Questions about Bulk Edit Search & Replace BookJunkieLI Library Management 6 02-19-2012 01:39 PM


All times are GMT -4. The time now is 04:16 PM.


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