MobileRead Forums - View Single Post

ChrisMillward · 01-17-2020, 08:07 AM

To answer BetterRed, yes, I can type the text directly into the metadata. I was mistakenly assuming that the column definitions of Calibre were being used on initial import.

To answer davidfor, the character appears during the preview stage and it doesn't matter where in the import file the £ occurs. For example I inserted the character into the title column with the same results. Searching more generally for £ problems I found this.

https://www.thesitewizard.com/html-t...orrectly.shtml

It seems that the import list plugin is expecting UTF-8 encoding and it cannot be changed for CSV files. setting Calibre to UTF-8 doesn't help either.
Using notepad and saving with UTF-8 encoding however does work and gives the desired result right the way through (wherever the £ sign is). This involves an extra step using Notepad for each group of files imported, but it is a workaround.

I did consider stripping the £ sign with search and replace and importing a proper value using a Regex format but the above is a little quicker. Having the price in ASCII form is OK for me as it won't be used as a value anywhere else.

Is the Import List plugin still under development? Could the Author or anyone else modify the plugin to change the encoding for a CSV file?

01-17-2020, 08:07 AM	#394
ChrisMillward Enthusiast Posts: 34 Karma: 10 Join Date: Sep 2017 Device: PC	Update To answer BetterRed, yes, I can type the text directly into the metadata. I was mistakenly assuming that the column definitions of Calibre were being used on initial import. To answer davidfor, the character appears during the preview stage and it doesn't matter where in the import file the £ occurs. For example I inserted the character into the title column with the same results. Searching more generally for £ problems I found this. https://www.thesitewizard.com/html-t...orrectly.shtml It seems that the import list plugin is expecting UTF-8 encoding and it cannot be changed for CSV files. setting Calibre to UTF-8 doesn't help either. Using notepad and saving with UTF-8 encoding however does work and gives the desired result right the way through (wherever the £ sign is). This involves an extra step using Notepad for each group of files imported, but it is a workaround. I did consider stripping the £ sign with search and replace and importing a proper value using a Regex format but the above is a little quicker. Having the price in ASCII form is OK for me as it won't be used as a value anywhere else. Is the Import List plugin still under development? Could the Author or anyone else modify the plugin to change the encoding for a CSV file?