Thread: Bulk edit replace problem
View Single Post
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,079
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 offline   Reply With Quote