[Calibre][Kobo] Ordered collections not following series order.

[MrSpock]

Problem:
I have a Kobo Sage.
With Calibre, when I copy books to the device, the series are created as collections but they are not ordered as wanted, they are only ordered by the title of each book, not its position in the series.
For example I have books from "G.J. Arnaud" (french) with a series of 64 books named "La compagnie des glaces". When I open the collection named "La compagnie des glaces", they are sorted by their title name and if I want to read them in their series order I have to consult a list somewhere to know which is the next one and choose it where it is in the collection.

Question:
I search the documentation and these forums (maybe with not accurate keys) and did not found anything about that.
Is there a way to define them properly, with some parameters in device section or with some naming conventions or special columns ?

Environment:
Calibre: 8.10.0
Kobo Sage: 4.38.23429

In Calibre I still have a user column named "completetitle" which is:
"{series}{series_index:number_in_series()| -|- }{title_sort}"

With the function "number_in_series" defined as:

program:
	if field('series') == "" then
	    ""
	else
		num = field('series_index') ;
		if fractional_part(num) == 0.0 then
		    format_number(num, "{0:03d}")
		else
		    format_number(num, "{0:05.1f}")
		fi
	fi

[Sirtel]

Why are you using collections for series? Kobo can take the series information directly from Calibre, and it can be sorted by series order. No need to create collections for this.

[MrSpock]

I don't create collections. This is Calibre which creates collections for series.

[MrSpock]

I had the checkbox "collections" checked in the device configuration. I tried to uncheck it and send some other series. Then it does not create collections... but does not create series too.

[PeterT]

Remember that for series to be synced on a Kobo you need:

Preferences | Sending Books to device | Metadata Management set to Automatic and to connect the device a second time after sending content; the series info is synced on the second connection. Also if any of the collection / series data is changted in calibre after the initial send, it will be updated on the next connection with no need to resend the content.

[MrSpock]

I found it... And then read your message. In the parameters of Calibre in "send books to device", the "metadata management" parameter was on "manual", I put it on "automatic" and then the series appears (as series, not collections) with he right order.
Sorry for the annoyance, I should have dig more in Calibre parameters.
I cleaned the reader when doing my tests, so I will resend the books (~100), this is not a problem.

Thanks a lot for your answers.

[DNSB]

Originally Posted by MrSpock

I don't create collections. This is Calibre which creates collections for series.

You have to tell calibre to create collections based on the series column. It is not something that calibre does out of the box.

As mentioned before, a Kobo ereader can display the series column natively in the My Books views. You can even select the Series tab and sort your series by recent, Series title and Number of books.