I'm curious about option 1):
how does the file need to have the metadata info written in it?
My books come from html files, where should I write the metadata?
(Maybe I could do so -almost- automatically, because before calibre I used to index my books in an excel spreadsheet)
I already tried to write them like this
https://wiki.mobileread.com/wiki/Metadata#HTML_metadata, but when I add the book in calibre, it doesn't work.
My books are named as:
Harris, Charlaine - Aurora Teagarden 01 - 1990. Real Murders [9780425218716].htm
Harris, Charlaine - Sookie Stackhouse 04.1 - 2004. Fairy Dust [9780441011977].htm
As you can see, a lot of info in the filename.
So far, I've come up with this regular expression:
(?P<author>.+?) - ((?P<series>.+?) (?P<series_index>\d+) - )?(?P<title>.+)
but it recognizes metadata until the <title> (not included).
Can someone help me? Thank you.
--edit:
Maybe I got it:
(?P<author>.+?) - ((?P<series>.+?) (?P<series_index>\d+) - )(?P<pubdate>\d+\.)(?P<title>.+)\[(?P<isbn>\d+)\]