Solution ID: prim84363
"Error: "The process completed with errors"; NULL values in Microsoft Project file
Status: Reviewed
Version(s): 6.0, 6.1, 6.2, 6.2.1, 7.0

Problem: Error:  “The process completed with errors” when importing a file from Microsoft Project. 

Review of the import log file shows the following message followed by a list of resources:


*** ERROR ***: Reading Project Data – Could not convert variant of type (Null) into type (Double)
Problem: Errors on import from Microsoft Project to P6.

Review of the import log file shows the following:


*** ERROR ***: Reading Resource: [5] PM – Could not convert variant of type (Null) into type (String)


*** ERROR ***: Reading Resource: [6] PM – Could not convert variant of type (Null) into type (String)


Review of the Resource Sheet in MSProject shows blank Resource Names for 5 & 6:
Fix:

In order for project to be imported successfully, all blank (NULL) fields would have to be removed from the MSProject before it is re-imported into Project Management.


When an MSProject file is converted to XML the fields that contain null values are not included in the exported XML file.


1.  Save the MSProject file as an XML file. (All the NULL values will be removed from the project)


2.  Convert the XML file back into a MSProject file.


3.  Re-import the newly created MSProject file back into Project Management


Note:  The Activity IDs will be re-numbered when converting to XML to MSProject.