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 09-14-2016, 06:19 AM   #1
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
Bulk MDE S&R questions

A custom column date can be cleared via the purpose built button that is automatically created in the Bulk MDE Custom Columns tab. But it would suit my purposes better if I could do it via saved Bulk MDE S&R definition. I have two related Bulk S&R definitions - a_move_date, b_counter++ - this would be a third - d_clear date

So I am looking for a Bulk MDE S&R definition to clear a custom date
===============

Has anyone any thoughts on how I could get calibre to support lists of dates? I assume it can't be done without major effort.

So, my idea is to convert a date value into a YYYY-MM-DD formatted string and store that in a tag-like value. Should I ever want use any arithmetic or date template functions I would have to reconvert the strings back to dates.

So the question is - can someone furnish a Bulk MDE definition that will convert a custom date value into to a 'YYYY-MM-DD' string and append it to a custom tag-like value.

I would name the definition c_save_date
================

So now I would have the following definitions -- a_move_date, b_counter++, c_save_date, d_clear date -- that I would execute consecutively in that order.

Failure to execute the definitions in the right order, or inadvertently skipping a step, could result in data loss.

So, it would be useful if I could put those four definitions into a group and execute the group in a single operation, anyone have any thoughts on that?

BR

Last edited by BetterRed; 09-14-2016 at 07:33 AM.
BetterRed is offline   Reply With Quote
Old 09-14-2016, 09:40 AM   #2
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 7,927
Karma: 2046464
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by BetterRed View Post
A custom column date can be cleared via the purpose built button that is automatically created in the Bulk MDE Custom Columns tab. But it would suit my purposes better if I could do it via saved Bulk MDE S&R definition. I have two related Bulk S&R definitions - a_move_date, b_counter++ - this would be a third - d_clear date

So I am looking for a Bulk MDE S&R definition to clear a custom date
See attachment 1. Note that there is a problem with the current release of calibre where the date isn't cleared properly. I have submitted a fix.
Click image for larger version

Name:	Clipboard03.jpg
Views:	19
Size:	165.9 KB
ID:	151616
Quote:
So the question is - can someone furnish a Bulk MDE definition that will convert a custom date value into to a 'YYYY-MM-DD' string and append it to a custom tag-like value.
See attachment.
Click image for larger version

Name:	Clipboard02.jpg
Views:	20
Size:	183.8 KB
ID:	151615
Quote:
So, it would be useful if I could put those four definitions into a group and execute the group in a single operation, anyone have any thoughts on that?
I know of no way to do that.
chaley is offline   Reply With Quote
Old 09-14-2016, 07:10 PM   #3
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
I had tried to do the date clear, when it didn't work I gave up in disgust - with myself

Someone we know will now have the stats they wanted

BR
BetterRed is offline   Reply With Quote
Old 09-14-2016, 11:51 PM   #4
Terisa de morgan
Wizard
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 3,695
Karma: 3554614
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Aura, Kobo Mini, Kobo Aura HD, elephone, iPad, Galaxy Tab3 8
Quote:
Originally Posted by BetterRed View Post
So, it would be useful if I could put those four definitions into a group and execute the group in a single operation, anyone have any thoughts on that?

BR
My idea, as I've done it for other things: A plugin wich includes the operations. I don't know anything else.
Terisa de morgan is online now   Reply With Quote
Old 09-15-2016, 02:27 AM   #5
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 720
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Thanks to both Chaley and BetterRed for helping me solve a problem.

If someone should take the time to write a plugin, let me know and gladly test it out.
Tanjamuse is offline   Reply With Quote
Old 09-15-2016, 04:34 AM   #6
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by Terisa de morgan View Post
My idea, as I've done it for other things: A plugin wich includes the operations. I don't know anything else.
Terisa de morgan - am I right in assuming it would be relatively easy to write a PI to execute a specific set of S&R operations, as in Tanjamuse' - a_move_date, b_increment_counter, c_save_history, and d_clear_date sequence. Essentially everything would be hard coded.

As compared to a generic version with selection from a list, ordering of operations etc, saving of configuration in json... - as in View Manager, Reading List etc.

Quote:
Originally Posted by Tanjamuse View Post
Thanks to both Chaley and BetterRed for helping me solve a problem.

If someone should take the time to write a plugin, let me know and gladly test it out.
@Tanjamuse - If, as I've suggested above, it's relatively easy to write a 'private' PI specific for your needs then maybe you could write it (with help of course) and just as importantly you could maintain it.

BR
BetterRed is offline   Reply With Quote
Old 09-15-2016, 04:37 AM   #7
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 720
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Quote:
Originally Posted by BetterRed View Post
Terisa de morgan - am I right in assuming it would be relatively easy to write a PI to execute a specific set of S&R operations, as in Tanjamuse' - a_move_date, b_increment_counter, c_save_history, and d_clear_date sequence. Essentially everything would be hard coded.

As compared to a generic version with selection from a list, ordering of operations etc, saving of configuration in json... - as in View Manager, Reading List etc.


@Tanjamuse - If, as I've suggested above, it's relatively easy to write a 'private' PI specific for your needs then maybe you could write it (with help of course) and just as importantly you could maintain it.

BR
Why not, I'm game
Tanjamuse is offline   Reply With Quote
Old 09-15-2016, 05:03 AM   #8
Terisa de morgan
Wizard
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 3,695
Karma: 3554614
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Aura, Kobo Mini, Kobo Aura HD, elephone, iPad, Galaxy Tab3 8
Quote:
Originally Posted by BetterRed View Post
Terisa de morgan - am I right in assuming it would be relatively easy to write a PI to execute a specific set of S&R operations, as in Tanjamuse' - a_move_date, b_increment_counter, c_save_history, and d_clear_date sequence. Essentially everything would be hard coded.
Yes, you're right. You would need to configure only custom columns and the other things are simple (more or less, as I have been able to do them ). But, anyway, if I did a plugin I wouldn't really do as a S&R but some basic operations in python and metadata update.
Terisa de morgan is online now   Reply With Quote
Old 09-15-2016, 06:40 AM   #9
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by Terisa de morgan View Post
Yes, you're right. You would need to configure only custom columns and the other things are simple (more or less, as I have been able to do them ). But, anyway, if I did a plugin I wouldn't really do as a S&R but some basic operations in python and metadata update.
Yes that what I thought - use the bulk S&R definitions as the specifications for a regular PI.

BR
BetterRed is offline   Reply With Quote
Old 09-15-2016, 06:41 AM   #10
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 7,927
Karma: 2046464
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by BetterRed View Post
Yes that what I thought - use the bulk S&R definitions as the specifications for a regular PI.

BR
Out of curiosity, why are you considering doing it this way (emulating a series of search/replace) instead of a library-closed plugin?
chaley is offline   Reply With Quote
Old 09-15-2016, 08:36 AM   #11
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
It wouldn't be 'emulating' as I understand the word - the PI coder (hopefully Tanjamuse) would use the S&R definitions as the specification for a developing the PI. The S&R definitions would be the prototype - do IT people still do that.

I suggest Tanjamuse use the S&R definitions she now has as he basis for developing the workflow for her stats and once she has that working satisfactorily she can consider developing a PI to further automate the workflow.

There's a facet to the process Tanja hasn't raised here, which is dealing with the Evernote notes she raises against the books on her Tab. These relate to errors and omissions in the book metadata and changes to the book contents.

BR

A long time ago I wrote an emulator for the EE KDF 9 on IBM 360 - seemed a good idea at the time.

Last edited by BetterRed; 09-15-2016 at 08:38 AM.
BetterRed is offline   Reply With Quote
Old 09-15-2016, 10:01 AM   #12
Terisa de morgan
Wizard
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 3,695
Karma: 3554614
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Aura, Kobo Mini, Kobo Aura HD, elephone, iPad, Galaxy Tab3 8
Quote:
Originally Posted by BetterRed View Post
Yes that what I thought - use the bulk S&R definitions as the specifications for a regular PI.

BR
Not really the S&R but the requirements for the S&R and the steps:
1.- Recoger custom column (date) from db and format it as string => S&R could be useful here for format
2.- Recover custom column (tag) from db
3.- Append string to tag
4.- Save tags
5.- Save empty date
Terisa de morgan is online now   Reply With Quote
Old 09-15-2016, 10:22 AM   #13
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by Terisa de morgan View Post
Not really the S&R but the requirements for the S&R and the steps:
1.- Recoger custom column (date) from db and format it as string => S&R could be useful here for format
2.- Recover custom column (tag) from db
3.- Append string to tag
4.- Save tags
5.- Save empty date
Maybe I should have used the words 'functional specification', i.e. the PI would implement what the S&R definitions do in respect of outcomes, but not necessarily how they do it.

But we're jumping the gun, lets get the S&R based solution working, which is awaiting 2.68 for a change chaley made yesterday and testing time. It may well be that Tanja and I can reduce the number of step from 4 to 2 and eliminate the danger of data loss if there's a missed or out of order step - in which case the need for a PI would be moot.

BR

Last edited by BetterRed; 09-15-2016 at 10:27 AM.
BetterRed is offline   Reply With Quote
Old 09-15-2016, 10:31 AM   #14
Terisa de morgan
Wizard
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 3,695
Karma: 3554614
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Aura, Kobo Mini, Kobo Aura HD, elephone, iPad, Galaxy Tab3 8
Quote:
Originally Posted by BetterRed View Post
Maybe I should have used the words 'functional specification', i.e. the PI would implement what the S&R definitions do in respect of outcomes, but not necessarily how they do it.

But we're jumping the gun, lets get the S&R based solution working, which is awaiting 2.68 for a change chaley made yesterday and testing time. It may well be that Tanja and I can reduce the number of step from 4 to 2 and eliminate the danger of data loss if there's a missed or out of order step - in which case the need for a PI would be moot.

BR
Ok, let's me know how it goes (out of curiosity )
Terisa de morgan is online now   Reply With Quote
Old 09-15-2016, 10:38 AM   #15
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 7,490
Karma: 6867503
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by Terisa de morgan View Post
Ok, let's me know how it goes (out of curiosity )
More likely Tanja will let you know by seeking your help to hold her hand through her first PI. Even if its not warranted she seems keen to giving it a whirl

Thanks for your input - much appreciated

BR
BetterRed is offline   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
bulk operations - a couple of questions ms233 Library Management 13 08-30-2014 03:55 AM
Bulk search & replace question Capricorn Calibre 0 08-23-2013 06:12 AM
2 Questions about Bulk Edit Search & Replace BookJunkieLI Library Management 6 02-19-2012 02:39 PM
Can only import books from one of two MDE accounts kikibobo Library Management 2 01-13-2012 10:40 AM


All times are GMT -4. The time now is 12:57 PM.


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