WebTools-NG icon indicating copy to clipboard operation
WebTools-NG copied to clipboard

[BUG] Extra character added before special character in title

Open Andrew-RH opened this issue 2 years ago • 1 comments

Describe the bug The movie title 8½ is exported to a csv as 8½ Similarly, the movie Alien³ is exported as Alien³

To Reproduce Steps to reproduce the behavior:

  1. Go to ExportTools and Create a custom level that exports just Title
  2. Go to ExportTools and select export type movie, subtype movie and the media library
  3. Select the custom level setting from step 1
  4. Click Export Media
  5. Open the csv file that was created
  6. See the issue reported above

Expected behavior The movie title appears without extra characters added before some special characters like half, cube, etc.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: Windows 11

Additional context Add any other context about the problem here.

Logs WebTools-NG 2024-02-01 AndrewRH.zip

Andrew-RH avatar Feb 01 '24 23:02 Andrew-RH

The issue is caused by the Unicode characters in the file names and titles used by Plex.

The ¡Three Amigos! (1986) causes a similar issue to those already listed.

If you are using Microsoft Excel to open the .csv file, then make sure you select Unicode (UTF-8) when you import the .csv file into your work sheet.

image

See this link for more details on importing the .csv into Microsoft Excel: https://github.com/WebTools-NG/WebTools-NG/wiki/Help-%28Hints%2C-Tips-and-Videos%29#to-import-a-csv-file-so-that-the-columns-are-presented-correctly-in-microsoft-excel

If you use Libre Office Calc make sure the Character Set is set to Unicode (UTF-8) in the Text Import wizard that opens when you first open the .csv file in Libre Office Calc.

trumpy81 avatar Feb 02 '24 00:02 trumpy81