Forum Discussion

vishalvd's avatar
vishalvd
Copper Contributor
Aug 23, 2024

MS Project Export as CSV not generating non english language data

i have been following below link to save MS Project file as CSV

https://support.microsoft.com/en-us/office/export-or-import-data-to-another-file-format-6e6e581f-a580-4f04-aa87-9b6552143d9c#:~:text=Choose%20File%20%3E%20Save%20As.%20Choose%20Browse.%20In,a%20name%20for%20the%20exported%20file.%20Choose%20Save

using Existing Task Export Map to save as CSV

Issue i am facing is after generating CSV, non English data is getting corrupted, showing as "????????" in the CSV

CSV File generated is getting saved as ANSI encoding, there is no way to change it to UTF 8 in Export Wizard

these are all steps can be done Mannully on MS Project
i also have MSPPlugin written in DotNet which does same exact steps programmatically
have used below APIs to perform the same

https://learn.microsoft.com/en-us/office/vba/api/project.application.mapedit
https://learn.microsoft.com/en-us/office/vba/api/project.application.filesaveas 

getting same output as shown in screenshot

Note: I have MS Project Standard 2019 installed on windows

No RepliesBe the first to reply

Resources