|
|
Thread Tools | Search this Thread |
10-07-2014, 02:00 AM | #1 |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
How to format pubdate so I only get year in the catalog output please?
How to format pubdate so I only get year in the catalog output please?
not like: PHP Code:
2014 2003 etc Thank you in advance |
10-07-2014, 06:12 AM | #2 |
null operator (he/him)
Posts: 20,532
Karma: 26944418
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
From ===>>> The calibre template language — Using functions in templates
{pubdate:format_date(yyyy)} BR Last edited by BetterRed; 10-07-2014 at 06:14 AM. |
Advert | |
|
10-08-2014, 06:23 AM | #3 | |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
Quote:
I don't even know where to start. The page link has 19 page of info and doesn't tell me where the editing template is, if there's one Would you please tell me step by step how to get to functions in templates such as: 1) Go to "Preferences" 2) do this in "change calibre behavior" 3) do that in "import/export" |
|
10-08-2014, 09:48 AM | #4 |
Well trained by Cats
Posts: 29,761
Karma: 54401244
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
By 'Catalog output' you mean the one created using the right click option on the conversion icon?
or do you mean 'On the Spreadsheet' view? Preferences: Tweaks: (it is one of the Date format tweaks |
10-08-2014, 12:02 PM | #5 | |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
Quote:
Code:
'2014-03-04T00:00:00+02:00 '2003-05-13T00:00:00+03:00 Code:
2014 2003 |
|
Advert | |
|
10-08-2014, 02:02 PM | #6 | |
Well trained by Cats
Posts: 29,761
Karma: 54401244
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
That is a 'timestamp' format You will probably have to clean it up using the substring function of your spreadsheet. |
|
10-08-2014, 04:09 PM | #7 | |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
Quote:
I'm trying to avoid that. Any other options like editing the output template or something please? |
|
10-08-2014, 04:23 PM | #8 |
Grand Sorcerer
Posts: 11,728
Karma: 6690881
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Create a new custom column "built from other columns" (not like tags). Set the template for that column to what BetterRed suggested:
Code:
{pubdate:format_date(yyyy)} |
10-08-2014, 04:59 PM | #9 |
null operator (he/him)
Posts: 20,532
Karma: 26944418
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
@millan - chaley beat me to it
But my bad I should have deduced you were referring to a CSV catalogue BR Last edited by BetterRed; 10-08-2014 at 05:39 PM. Reason: ack chaley |
10-09-2014, 01:16 PM | #10 |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
Thank you all again.
I think I'll be able to start doing it. Would you please tell me how to get to the interface for the below point please: Code:
Create a new custom column "built from other columns" |
10-09-2014, 06:58 PM | #11 | |
null operator (he/him)
Posts: 20,532
Karma: 26944418
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
BR |
|
10-10-2014, 12:05 AM | #12 |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
|
10-31-2014, 02:47 AM | #13 |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
It was working Ok.
I have checked it today some of the items under Year Published Column comes up as "BAD DATE" as shown below. Any solution please? Last edited by millan; 10-31-2014 at 02:56 AM. |
10-31-2014, 03:06 AM | #14 |
null operator (he/him)
Posts: 20,532
Karma: 26944418
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
@millan - could you put the database published date into the book list alongside your Year Published - right click column headings and select Show Column->Published, and post a screen shot showing both.
Also have a look at the Published Date in Metadata edit for one of those BAD DATE's I suspect the Year Published template needs to be adjusted to cope with undefined dates or something like that BR |
10-31-2014, 03:33 AM | #15 |
Enthusiast
Posts: 35
Karma: 10
Join Date: Oct 2014
Device: none
|
Thank you for your prompt response BetterRed
I added the published date into the book list alongside my Year Published - had a look at the Published Date in Metadata changed the days of the month for one of those BAD DATE's I have even deleted the Year Published column and recreated again Do you think it might be something to do with my installation of the Calibre's new update I have installed today? posting the screen shot showing both |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Any way to change the title output for the catalog? | MiniMouse | Library Management | 2 | 03-02-2014 10:31 AM |
New Feature Request - Save Catalog Output Options | nynaevelan | Library Management | 0 | 02-11-2012 12:33 PM |
Calibre catalog format | skipray | Library Management | 1 | 02-17-2011 01:10 AM |
Problem making catalog ePub output | slantybard | Library Management | 6 | 02-04-2011 07:27 PM |
Calibre Catalog Output Now Flags Wishlist | Tom SKP | Library Management | 0 | 11-20-2010 09:10 AM |