Bulk Clear Custom Column Date - Not Working

BetterRed · 02-15-2013, 07:09 PM

If I select multiple books, go into Bulk Metadata Edit and click the Clear "<columnname>" Date on a Custom Column of type Date then nothing happens; the dates don't get cleared, even if they are all the same date.

Don't know if it 'worked before' because this is first time I wanted to do it.

Windows 7 & Calibre 0.9.19

BR

theducks · 02-15-2013, 09:15 PM

Quote:

Originally Posted by BetterRed

If I select multiple books, go into Bulk Metadata Edit and click the Clear "<columnname>" Date on a Custom Column of type Date then nothing happens; the dates don't get cleared, even if they are all the same date.

Don't know if it 'worked before' because this is first time I wanted to do it.

Windows 7 & Calibre 0.9.19

BR

Something similar (Rating) has been reported https://www.mobileread.com/forums/sho...05&postcount=1
It may be that all Custom fields are affected. We will have to wait for Chaley to get back (from wherever)

kovidgoyal · 02-15-2013, 10:01 PM

Did you click the apply changes checkbox next to the field?

chaley · 02-15-2013, 10:53 PM

@kovid: there are problems when bulk setting several custom column types to None, sometimes when the cells being set contain different values. The problem comes from an optimization that existed before the "apply changes" checkbox was added (a long time ago). I will look at fixing it in a couple of weeks.

BetterRed · 02-16-2013, 12:06 AM

@theducks - I had look at the rating one, its a problem if the custom column in the selected books have mixed values - OK if their all the same - you can work around by doing a sort by the custom column and do the reset in batches

But that wont work for dates - even though 10 books might show they were proof read on the 2012-12-15, I believe dates are in held in the db as something like the number of femto-seconds since the year dot, so... no two dates are ever the same.

@kovidgoyal, yep, ticked the box - normally it gets ticked automagically, I tried forcing it - sadly to no avail.

@chaley, in your own good time. Let me know if you'd like me to test?

BR

chaley · 02-23-2013, 05:04 AM

I made the changes. They are available in the current 'trunk' source and will be in the next calibre release.

02-15-2013, 07:09 PM	#1
BetterRed null operator (he/him) Posts: 20,605 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Bulk Clear Custom Column Date - Not Working If I select multiple books, go into Bulk Metadata Edit and click the Clear "<columnname>" Date on a Custom Column of type Date then nothing happens; the dates don't get cleared, even if they are all the same date. Don't know if it 'worked before' because this is first time I wanted to do it. Windows 7 & Calibre 0.9.19 BR Last edited by BetterRed; 02-15-2013 at 07:12 PM. Reason: clarity

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
custom date column from two state column	Dopedangel	Library Management	7	01-03-2012 08:20 AM
Custom column: "Updated date", when adding new "versions" of the same file?	enriquep	Library Management	16	11-03-2011 10:46 AM
"Date Added" custom column?	cheechwhiz	Library Management	1	08-20-2011 10:25 AM
Custom column for date added	Gunnerp245	Calibre	2	07-08-2011 04:39 PM
Can't clear "custom" date field?	joegearhart	Calibre	5	12-20-2010 03:32 AM

02-15-2013, 10:01 PM	#3
kovidgoyal creator of calibre Posts: 43,909 Karma: 22669818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Did you click the apply changes checkbox next to the field?

02-15-2013, 10:53 PM	#4
chaley Grand Sorcerer Posts: 11,753 Karma: 7029857 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	@kovid: there are problems when bulk setting several custom column types to None, sometimes when the cells being set contain different values. The problem comes from an optimization that existed before the "apply changes" checkbox was added (a long time ago). I will look at fixing it in a couple of weeks.

02-16-2013, 12:06 AM	#5
BetterRed null operator (he/him) Posts: 20,605 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@theducks - I had look at the rating one, its a problem if the custom column in the selected books have mixed values - OK if their all the same - you can work around by doing a sort by the custom column and do the reset in batches But that wont work for dates - even though 10 books might show they were proof read on the 2012-12-15, I believe dates are in held in the db as something like the number of femto-seconds since the year dot, so... no two dates are ever the same. @kovidgoyal, yep, ticked the box - normally it gets ticked automagically, I tried forcing it - sadly to no avail. @chaley, in your own good time. Let me know if you'd like me to test? BR

02-23-2013, 05:04 AM	#6
chaley Grand Sorcerer Posts: 11,753 Karma: 7029857 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	I made the changes. They are available in the current 'trunk' source and will be in the next calibre release.

Advert

Advert