I have a problem with Calibre. I have imported many ebooks and the metadata were taken from the file name. In most cases the file name was author - title.epub. All went well, the metadata were imported correctly to Calibre.
The problem is: For books which are part of a series, Calibre added the title of the book to the series column whereas the name of the series is in the title column. (Therefore searching for metadata e.g. comments on the net is not working because Calibre does not know that the title is found in the series column.)
Example: Author: Agatha Christie - Series: Hercule Poirot Mystery - Title: Death on the Nile. "Death on the Nile" would be in the series column, "Hercule Poirot Mystery" in the title column.
Is there a one-click solution to switch the title and series columns for several books? Or is there a specific setting that has to be used during the metadata downloading process that tells Calibre that the book title is in the series column?
P.S.: Reimporting the books is not an option for me for I don't have the files anymore.