Forum / Remote Desktop Manager - Bug Report

Powershell CSV-Import Problem with umlauts

  • Create an Issue
  • Cancel

Hi,

i had to import over 200 customers out of a csv file and used your example "PowerShell Samples - Creating Folder Structure from CSV file".

it appears that rdm can't handle umlauts i.e. ü,ä,ö,... when importing through powershell.

my entry "Österreich" get created as "�sterreich"


Best Regards
Markus

======================

Clock2 mths

Hi Markus,

This problem can occur when the csv file is encoded in ANSI format when using Import-Csv. Do you know the encoding format that your csv file is using?

Do you know if the umlauts are already missing when you are "printing" the variable $csv after importing the your file?
Ex:

$csv = Import-Csv "c:\YourFolder\GroupFolder.csv"
$csv

By encoding the CSV file in UFT-8 the umlauts should be there as expected when using Import-Csv.

Best regards,

Olivier Désalliers

signaturesignature

Clock2 mths

Hi Olivier,

yes, they are already missing/missformed in $csv

Best Regards
Markus

======================

Clock2 mths

Hi,

I did a convert-to-utf-8 with notepad++ and ran the script again, now it seems to work.

Best Regards
Markus

======================

Clock2 mths

Hi,

Good to know it is now working for you.

We will add a note about the encoding in the online help.

Best regards,

Olivier Désalliers

signaturesignature

Clock2 mths