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-21-2021, 04:37 AM   #1
ownedbycats
Wizard
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 3,049
Karma: 12968188
Join Date: Oct 2018
Device: Kobo Aura HD
How do I convert a composite column to a regular text one?

I have a composite column used in a save template.

Since it uses a fairly complex GPM template and is only actually needed when sending a book to device, for performance reasons I'd like to change that to a regular text column and have Action Chains update it with my send-to-device chain.

What would be the best way to change it?

Last edited by ownedbycats; 09-21-2021 at 05:02 AM.
ownedbycats is online now   Reply With Quote
Old 09-21-2021, 05:42 AM   #2
chaley
Grumpy old git
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.
 
chaley's Avatar
 
Posts: 9,963
Karma: 3493677
Join Date: Jan 2010
Location: UK
Device: Reader
You can't change the column type.

The best approach is to create a new column and delete the composite. That avoids the implicit type change because you aren't reusing the lookup key. If you really use the composite in only one place then delete it and then create the new column with the same lookup key.
chaley is offline   Reply With Quote
Old 09-21-2021, 05:56 AM   #3
ownedbycats
Wizard
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 3,049
Karma: 12968188
Join Date: Oct 2018
Device: Kobo Aura HD
Is there a way to copy the composite output to the new coumn?
ownedbycats is online now   Reply With Quote
Old 09-21-2021, 05:57 AM   #4
chaley
Grumpy old git
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.
 
chaley's Avatar
 
Posts: 9,963
Karma: 3493677
Join Date: Jan 2010
Location: UK
Device: Reader
Quote:
Originally Posted by ownedbycats View Post
Is there a way to copy the composite output to the new coumn?
Bulk search and replace using "template" as the source and the new column as the destination.
chaley is offline   Reply With Quote
Old 09-21-2021, 06:20 AM   #5
ownedbycats
Wizard
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 3,049
Karma: 12968188
Join Date: Oct 2018
Device: Kobo Aura HD
Thanks. That worked. I got it all converted over and the chain set up.

Calibre is running faster! I think it's because #kobopath also pulled some stuff from my composite #kobostatus column (which in turn also checked a bunch of other columns).

Last edited by ownedbycats; 09-21-2021 at 06:24 AM.
ownedbycats 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
Help with a composite column ownedbycats Library Management 2 07-08-2020 10:06 AM
Need help with composite column BookJunkieLI Library Management 2 07-03-2019 11:42 AM
Composite Column BetterRed Calibre 12 09-01-2013 04:58 AM
Set value of another column from composite? dirgeon Library Management 1 02-03-2013 11:40 AM
Composite column or not ? Bertrand Library Management 3 08-24-2011 01:27 AM


All times are GMT -4. The time now is 03:19 PM.


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