Plugboard Help Please!

[PennyWise24]

I've searched and I can't seem to find the right program language. I have hundreds of books that are stand-alone (no series), and I have thousands that are in series. I'm wanting the upload format to be as such:

Series #01: Title 1
Series #02: Title 2
Series #03: Title 3
Series #04: Title 4
Series #05: Title 5 ......

Series #10: Title 10

And the standalone to just be the Title.

This is what I currently have and it's not working:

{series}' '{series_index:0>2s| #:| }{title}

I'm also trying to get the author's name to sort in my library list Last Name, First Name and show up that way in the Kindle Library. I'm hoping someone with more knowledge can help me. Thanks!

[chaley]

Moderator Notice
Moved to its own thread in hopes that someone will answer.

[MickiTee]

Originally Posted by PennyWise24

Series #10: Title 10

And the standalone to just be the Title.

This is what I currently have and it's not working:

{series}' '{series_index:0>2s| #:| }{title}

From your examples you want '#' to be used as a prefix and ':' as a suffix to the series number. Your code should read {series}' '{series_index:0>2s| #|: }{title}.

The Calibre manual explains this much better than I have done and has good examples that you can use as a starting point for your own needs.

Originally Posted by PennyWise24

I'm also trying to get the author's name to sort in my library list Last Name, First Name and show up that way in the Kindle Library. I'm hoping someone with more knowledge can help me. Thanks!

Can't help with this I'm afraid.

[isarl]

Originally Posted by PennyWise24

I'm also trying to get the author's name to sort in my library list Last Name, First Name and show up that way in the Kindle Library. I'm hoping someone with more knowledge can help me. Thanks!

1. Add custom column; “Column built from other columns”; Lookup name whatever you wish; Column heading likewise but perhaps “Authors”; for Template simply use {author_sort}
2. Hide the original Authors column, if you wish, and move your custom Authors column into place wherever you wish.

Originally Posted by PennyWise24

{series}' '{series_index:0>2s| #:| }{title}

As MickiTee wrote, you should have your series index like this instead: {series_index:0>2s| #|: } but furthermore I do not understand the purpose of the apotrophe-space-apostrophe between your series and series_index fields. That seems completely extraneous to me. So in full I think your correct template is:

{series}{series_index:0>2s| #|: }{title}

This seems to work on my library using the Template Tester:
Voyages Extraordinaires #03: Journey to the Center of the Earth
Fables
The Chrysalids
The 7 Habits of Highly Effective People
Sprawl #01: Neuromancer

Leaving the apostrophes and space in the template results instead in values like:
Voyages Extraordinaires' ' #03: Journey to the Center of the Earth
…which I don't think is what you're after.

[isarl]

PS: if you are interested in authors displaying as Lastname, Firstname in your library list, you may also be interested in the “Use author sort in Tag browser” tweak. (Preferences -> Tweaks)