Question about exporting to custom directory with Calibre.

[Q9Nine]

Hey all,

So I'm just starting to dig into Calibre and I love it. Wish I hadn't shelled out cash for the Alfa reading program. Calibre is much better.

One of the things I want to do with Calibre is edit all my ebook files to perfection, then export them automatically into a nice directory format. Calibre can do this, but I'm having an issue. The format I'd like to export to is:

Author name (Last, first) / [Publishing Year] Title / Author - Title.epub

So for example, it'd look like this in Windows:

Martin, George R.R. / [2005] A Feast for Crows (Book 4) / George R.R. Martin - A Feast for Crows (Book 4).epub

I'd also like to have series incorporated (which, in the case of this example, would be "A Song of Ice and Fire").

Here's what my export string looks like right now:

{author_sort}/[{pubdate}] {title}/{authors} - {title}

I think I can figure out the series bit, but I'm having a more annoying problem. When the save to disk export happens, it includes the Month and Year, not just the year. So it gets messed up in terms of sorting by year (see attached screenshot). Anyone have any idea how to make it so it just adds the year, not the month?

Cheers, much appreciated.

[BetterRed]

I think you should be able to use format_date function to 'extract' the year, see http://manual.calibre-ebook.com/template_lang.html

BR

[eschwartz]

relevant bits are:

Originally Posted by @calibre manual

format_date(x, date_format) – format_date(val, format_string) – format the value, which must be a date field, using the format_string, returning a string. The formatting codes are:

yy : the year as two digit number (00 to 99).
yyyy : the year as four digit number.

So in advanced formatting mode that would be: {pubdate:format_date(yyyy)}

[Q9Nine]

Excellent, that worked great. Thanks. One more question:

My titles, when exported, are coming out as Title Sort, not title. So instead of:

"A Game of Thrones" it is "Game of Thrones, A" in Windows Explorer.

Any idea how to change that behavior when saving to disk?

Thanks,
Q

[eschwartz]

Originally Posted by Q9Nine

Excellent, that worked great. Thanks. One more question:

My titles, when exported, are coming out as Title Sort, not title. So instead of:

"A Game of Thrones" it is "Game of Thrones, A" in Windows Explorer.

Any idea how to change that behavior when saving to disk?

Thanks,
Q

If you use {title} you should get Title. There is a separate template for {title_sort}. Are you sure you aren't using {title_sort}?

[kovidgoyal]

{title} gives you title sort by default (for legacy compatibility, when there was no title_sort). You can change that behavior via Preferences->Tweaks.