Powershell CSV-Import Problem with umlauts
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"
Kind Regards
Markus
======================
All Comments (4)
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"$csvBy encoding the CSV file in UFT-8 the umlauts should be there as expected when using Import-Csv.
Best regards,
Olivier Désalliers
Hi Olivier,
yes, they are already missing/missformed in $csv
Kind Regards
Markus
======================
Hi,
I did a convert-to-utf-8 with notepad++ and ran the script again, now it seems to work.
Kind Regards
Markus
======================
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