Reputation: 521
I have been following below link to save MS Project file as CSV
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
Dim g_projAppObj As MSProject.Application
g_projAppObj.MapEdit(Name:="Task Export Map", Create:=True, OverwriteExisting:=True,
DataCategory:=MSProject.PjDataCategories.pjMapTasks,
FieldName:="Task_UID", ExternalFieldName:="Task_UID",
CategoryEnabled:=True, TableName:="Task Export Map", ImportMethod:=0, HeaderRow:=True,
AssignmentData:=False, TextDelimiter:=",",
TextFileOrigin:=MSProject.PjTextFileOrigin.pjTextOriginUnicode,
UseHtmlTemplate:=False, IncludeImage:=False)
g_projAppObj.FileSaveAs(Name:=w_FileName, Format:=MSProject.PjFileFormat.pjCSV, Map:="Task Export Map")
getting same output as shown in screenshot
Note: I have MS Project 2019 Standard
Upvotes: 2
Views: 78