Need Help - Filenames to Calibre for a Series

[daishan9]

I can't seem to grasp this one. I have 132 Star Wars books. They are currently organized by file names in chronological order....

001 Star Wars Crosscurrent
002 Star Wars Lost Tribe of the Sith 01 Precipice

When I import them into Calibre, just the title field is filled in as I have it set to read metadata from the file names.

How do I change the file name so Calibre will also populate the Series field via the file name?

If I can get a clean title, and lets say a Series of "Star Wars [1]", then my import will automatically be in chronological order based on the Series field....and I can mass download covers and real metadata without the Series field being affected.

Therefore easily giving me full metadata for all the books and the ability to organize them via chronological order.

Hopefully that makes sense and thanks in advance for taking the time to read and try and help.

[Manichean]

You'll need to create a regular expression to match the titles to metadata fields. There's a tutorial available should you need it, specifically, you'll need to create named backreferences to the metadata fields. The supported field names are available as tooltips on the test fields in the preferences->adding books dialog.

[daishan9]

Originally Posted by Manichean

....you'll need to create named backreferences to the metadata fields. The supported field names are available as tooltips on the test fields in the preferences->adding books dialog.

I took a look at the tutorial and the string values in the tooltips popups, but I think I missed something somewhere as what I did is not working in the Test area of Preferences > Adding Books.

I'm using:
(?P<series_index>) - (?P<series>) - (?P<title>)

to parse out this example file:
001 - Star Wars - Title.epub

When I click Test, everything gets dumped into the Title field.

Hell, when I leave the field as just (?P<series_index>) and the file name 001.epub, the Title field is still the only one used.

[Manichean]

That's because the named groups are empty. You'll need to actually fit an expression in there describing what you want to match. Try

(?P<series_index>\d+) - (?P<series>.*?) - (?P<title>.*?)

or something similar.

[daishan9]

Originally Posted by Manichean

That's because the named groups are empty. You'll need to actually fit an expression in there describing what you want to match. Try

(?P<series_index>\d+) - (?P<series>.*?) - (?P<title>.*?)

or something similar.

Thank you very much. This worked great!