Keeping books in correct series order

[Maverick1962]

I have a lot of books & many are part of a series of 10 or more books
I have tried to number the books from,say 1-28 in the title column and also in the series column,in these columns the books appear in the correct numerical order.
When I try to send the books to my Amazon fire HD10 the series numbers are out of sequence (eg 1,10,13,15,instead of 1,2,3,4,5 & so on.

I have even put the book covers on to paint,added a text box at the bottom of the book cover & tried to send the books to my device in the correct numerical order,but it still jumbles them up.
I have tried every way that I can think of to make the books appear in the correct order & now am completely stuck.

Has anybody solved this really annoying problem? if you have,please enlighten me & tell me how you did it.
Thanks in advance

[dwig]

Originally Posted by Maverick1962

...
I have tried to number the books from,say 1-28...

That's the source of your problem.

Different systems use differing rules for handling alphanumeric sorting. Calibre tends to use a system that evaluates the numeric characters as a number whereas most systems use a strict alphanumeric sorting. Hence, "aaa 2 aa" comes after "aaa 10 aa" since "1" comes before "2".

These solution would be to use leading zeros, numbering from "01" to "28".

Personally, I prefer not to alter the title in calibre. Instead, I use a Plugboard (in Prefs) to prefix the title with the series info during the Save to Disk action.

[theducks]

I second that.
Use Calibre fields (columns) as they were intended, then use the Template Language tools to pass them to your device.

There are 2 general systems, and they are different:

File Name based: Send to Device, Save to disk use the Template to build a file-folder name

Metadata based: (changing the filename has no effect) For these, you use the Plugboard to JAMB in the extra fields. Kindles use this. OR the device drives settings like Kobo Utilities does

One field = 1 sort at a time possible. Some sort routines (and methods) allow bias (FROM PRIOR SORT) Eg 4 books with the exact title, sort first by Author, then by Title. The books show in Author order (the bias)
Others use a faster sort, but that doesn't leave a bias (these sort types are not really needed for our DB scale due to modern processors and storage)

Back to your original title method: Those are governed by the 1 sort rule because the now have been reduced to 1 type: ASCII (character weight).
Grab a ASCII chart. That is how each position in the string will weigh against others in the same POSITION. That is why we pad with leading spaces or numbers (0). Spaces can be problematic, as some systems strip any after the first. So go for the (ugly?) leading 0 to make All numbers have the exact same PLACES BTW I use a 2place before and 2 after template because I use fractional values in series_index

{series_index:0>5.2f}-{title}

Also note that you can NOT put anything different in front at the same folder level ({series}/{series_index:0>5.2f}-{title} Is valid, because series is a folder and you are sorting by file in the CURRENT folder)

[Maverick1962]

Thank you dwig & theducks.
I have to admit to not trying the 01,02 & so on way to number my books.
I am going to follow your advice & suggestions.
Thank you again.