Using templates for file names, plugboards, composite columns, searches, tooltips - Page 13

stevehaley · 02-01-2011, 06:53 PM

Does anyone have any idea why my custom column has broken somewhere between version 7.37 and 7.43. It was working fine but now says unknown id str_title1.
Problem appears to be in the switch statement

code as follows:-
program:
stripped=re(field('series'), '^(A|The|An)\s+', '');
shortened=shorten(stripped, 4, '-' ,4);
initials=re(stripped, '[^\w]*(\w?)[^\s]+(\s|$)', '\1');
s_index=template('{series_index:0>2.0f}');
abrv=strcat(
switch( stripped,
'.\s', initials,
'.', shortened,
field('series')),
test(s_index, strcat(' ', s_index, ': '), ''),
field('title'));

str_title1=template('{series}{series_index:0>2.0f| |: }{title}');
str_title2 = template('{#alt_series_name}{series_index:0>2.0f| |: }{title}');
str_title3 = abrv;
str_title4 = template('{series_index:0>2.0f| |: }{title}');
str_title5 = field('title');
str_default =test(field('#alt_series_name'),str_title2, str_title1);

str_input = lowercase(field('#kindle_title_fmt'));

switch(str_input,
'Series and num',str_title1,
'alt and num',str_title2,
'short and num',str_title3,
'num only',str_title4,
'no series info',str_title5,
str_default);

kovidgoyal · 02-01-2011, 07:21 PM

You're better off opening a ticket as chaley who maintains this code doesn't visit mobileread any more.

stevehaley · 02-01-2011, 07:41 PM

On a second issue is there anyway to evaluate the formats and put a Y in a column if the book has a MOBI format?
suspect it is {formats:switch(.......)}
but not clever enough to get it working...
thks
stephen

pchrist7 · 02-03-2011, 10:22 AM

Quote:

Originally Posted by stevehaley

On a second issue is there anyway to evaluate the formats and put a Y in a column if the book has a MOBI format?
suspect it is {formats:switch(.......)}
but not clever enough to get it working...
thks
stephen

Hi stevehaley
In the absolutely first post in this thread, with the heading
"Common composite custom columns"
There's an example of a custom column set to Yes if ebook format is like "*EPUB*".

Display Yes if the book has an EPUB format. Template:{formats:contains(EPUB, Yes,)}

So what you're looking for might be something like this:

Code:

{formats:contains(MOBI, Y,)}

Did this help ?

BTW: Been here for approx. 6 months, so I also have to get used to the new layout, but it actually helps finding things faster.

nynaevelan · 02-04-2011, 10:00 AM

Sorry this is the wrong spot and I d not see a delete button.

nynaevelan · 02-04-2011, 10:09 AM

Hi All: I need a little assistance again with the composite column for the annotations, for some reason my annotations are not being updated each time. I do not know if it is something with my annotations or my system, but for some records they will not update although I know they have annotations. Is there a way to check the MBP file?

pchrist7 · 02-04-2011, 10:16 AM

Quote:

Originally Posted by nynaevelan

Hi All: I need a little assistance again with the composite column for the annotations, for some reason my annotations are not being updated each time. I do not know if it is something with my annotations or my system, but for some records they will not update although I know they have annotations. Is there a way to check the MBP file?

Hi nynaevelan
The mbp files are "binary" meaning you can't just read them.
You would a "hex editor" plus a description of the mbp file format to figure out what's actually in the files ( as far as I know )
What you could do is checking the time stamp to see if it's dated as you would expect.
What info is not updated as expected ?
The read % ?

theducks · 02-04-2011, 10:19 AM

Quote:

Originally Posted by nynaevelan

Sorry this is the wrong spot and I d not see a delete button.

No delete button.. It would disrupt the logical flow of these threads if users went back and completely changed/removed

their original material.

If you have not "submitted", just use your browser 'Back' button (or close it) without submitting... Gone.

You did the other (post-Submitted) way

nynaevelan · 02-04-2011, 10:23 AM

Quote:

Originally Posted by pchrist7

Hi nynaevelan
The mbp files are "binary" meaning you can't just read them.
You would a "hex editor" plus a description of the mbp file format to figure out what's actually in the files ( as far as I know )
What you could do is checking the time stamp to see if it's dated as you would expect.
What info is not updated as expected ?
The read % ?

I think that might be why Calibre is not picking up the files, when I look in the documents folder of the Kindle with the Explorer there is no timestamp to the file. The next step I tried was checking the annotations in Kindle for PC, updating them and loading them to the kindle. When I look at the files in the book on the kindle it shows the updated annotations but Calibre still will not update them. It is not updating the comments section or the column, and I know it is not working because it is not putting the + in the tags section.

pchrist7 · 02-04-2011, 10:50 AM

Quote:

Originally Posted by nynaevelan

I think that might be why Calibre is not picking up the files, when I look in the documents folder of the Kindle with the Explorer there is no timestamp to the file. The next step I tried was checking the annotations in Kindle for PC, updating them and loading them to the kindle. When I look at the files in the book on the kindle it shows the updated annotations but Calibre still will not update them. It is not updating the comments section or the column, and I know it is not working because it is not putting the + in the tags section.

Hi nynaevelan
First of all you have to tell explorer to show timestamps to see them.
What OS you using ?
A bit confused here - the problem is that books read on the Kindle are not updated, OR are you reading with K4PC as well ? And that's not replicated to the Kindle ?

nynaevelan · 02-04-2011, 11:06 AM

Quote:

Originally Posted by pchrist7

Hi nynaevelan
First of all you have to tell explorer to show timestamps to see them.
What OS you using ?
A bit confused here - the problem is that books read on the Kindle are not updated, OR are you reading with K4PC as well ? And that's not replicated to the Kindle ?

The issue is not with Explorer, it is showing the timestamps for everything else just not these files. I am on Win 7. I am reading the books on the kindle but it is quicker and easier to update them on K4PC, I only switched to K4PC because of this problem, the annotations were originally created on the kindle.

I have ALOT of annotations on my Wheel of Time books and I would like to get them into Calibre so that I can have backups there. I can see them on the kindle website but they are old versions, so I am updating them all with the current notes, highlights and bookmarks so that Calibre will be updated.

EDIT: Ok I think I was making problems for myself by using both the kindle and k4pc, I am back on track now. Sorry for the confusion.

pchrist7 · 02-05-2011, 01:39 AM

Quote:

Originally Posted by nynaevelan

EDIT: Ok I think I was making problems for myself by using both the kindle and k4pc, I am back on track now. Sorry for the confusion.

No problem. Glad you fixed it.
Have a nice weekend,

nynaevelan · 02-12-2011, 05:37 AM

Hi:

Has something changed with fetch annotations in 0.7.45, I tried to download the latest annotations from my kindle after upgrading to 0.7.45 and now none update in Calibre and all the mbp files change to an extension of asnx?

pchrist7 · 02-12-2011, 05:55 AM

Quote:

Originally Posted by nynaevelan

Hi:

Has something changed with fetch annotations in 0.7.45, I tried to download the latest annotations from my kindle after upgrading to 0.7.45 and now none update in Calibre and all the mbp files change to an extension of asnx?

Hi there
I havent upgraded calibre yet, but will soon. As far as I know, asnx is for the new K3 firmware, showing page no. as well as locations.
Havent installed new K3 firmware yet, so ..
Will get back to you once I have had a chance to upgrade/test calibre.

Edit: Just upgraded Calibre to 0.7.45 and did Fetch Annotations.
It works as expected/as usual from my K3.
Note: Did NOT update my K3 firmware yet, and have NOT added any plugins etc.
Yet ;-D Looking keenly at the collection creation pluging, but need time to experiment.
Could you have done other changes to get this issue ?

nynaevelan · 02-12-2011, 11:36 AM

Quote:

Originally Posted by pchrist7

Hi there
I havent upgraded calibre yet, but will soon. As far as I know, asnx is for the new K3 firmware, showing page no. as well as locations.
Havent installed new K3 firmware yet, so ..
Will get back to you once I have had a chance to upgrade/test calibre.

Edit: Just upgraded Calibre to 0.7.45 and did Fetch Annotations.
It works as expected/as usual from my K3.
Note: Did NOT update my K3 firmware yet, and have NOT added any plugins etc.
Yet ;-D Looking keenly at the collection creation pluging, but need time to experiment.
Could you have done other changes to get this issue ?

I don't have a k3, I have a k2, how does this affect the functionality for me because the annotations no longer work with 0.745. And other than adding the upgraded Kindle Collections plugin and adding a couple of recipes I have not changed anything.

02-01-2011, 07:21 PM	#182
kovidgoyal creator of calibre Posts: 45,604 Karma: 28548974 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You're better off opening a ticket as chaley who maintains this code doesn't visit mobileread any more. Last edited by kovidgoyal; 02-01-2011 at 07:25 PM.

02-04-2011, 10:00 AM	#185
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Sorry this is the wrong spot and I d not see a delete button. Last edited by nynaevelan; 02-04-2011 at 10:04 AM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Should composite columns appear in Grouped Searches?	ownedbycats	Library Management	3	02-13-2021 03:43 PM
Having problems with composite columns and save/send templates	Trel	Calibre	4	09-26-2016 03:21 PM
Tooltips for narrow columns	theducks	Library Management	7	03-16-2015 10:58 PM
Techniques to use plugboards, custom columns and templates	kovidgoyal	Library Management	0	01-26-2011 04:21 PM

02-01-2011, 06:53 PM	#181
stevehaley Junior Member Posts: 8 Karma: 10 Join Date: Nov 2010 Device: Kindle	Does anyone have any idea why my custom column has broken somewhere between version 7.37 and 7.43. It was working fine but now says unknown id str_title1. Problem appears to be in the switch statement code as follows:- program: stripped=re(field('series'), '^(A\|The\|An)\s+', ''); shortened=shorten(stripped, 4, '-' ,4); initials=re(stripped, '[^\w]*(\w?)[^\s]+(\s\|$)', '\1'); s_index=template('{series_index:0>2.0f}'); abrv=strcat( switch( stripped, '.\s', initials, '.', shortened, field('series')), test(s_index, strcat(' ', s_index, ': '), ''), field('title')); str_title1=template('{series}{series_index:0>2.0f\| \|: }{title}'); str_title2 = template('{#alt_series_name}{series_index:0>2.0f\| \|: }{title}'); str_title3 = abrv; str_title4 = template('{series_index:0>2.0f\| \|: }{title}'); str_title5 = field('title'); str_default =test(field('#alt_series_name'),str_title2, str_title1); str_input = lowercase(field('#kindle_title_fmt')); switch(str_input, 'Series and num',str_title1, 'alt and num',str_title2, 'short and num',str_title3, 'num only',str_title4, 'no series info',str_title5, str_default);

02-01-2011, 07:41 PM	#183
stevehaley Junior Member Posts: 8 Karma: 10 Join Date: Nov 2010 Device: Kindle	On a second issue is there anyway to evaluate the formats and put a Y in a column if the book has a MOBI format? suspect it is {formats:switch(.......)} but not clever enough to get it working... thks stephen

02-04-2011, 10:09 AM	#186
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Hi All: I need a little assistance again with the composite column for the annotations, for some reason my annotations are not being updated each time. I do not know if it is something with my annotations or my system, but for some records they will not update although I know they have annotations. Is there a way to check the MBP file?

02-12-2011, 05:37 AM	#193
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Hi: Has something changed with fetch annotations in 0.7.45, I tried to download the latest annotations from my kindle after upgrading to 0.7.45 and now none update in Calibre and all the mbp files change to an extension of asnx?