Error importing MS Project file

[kscottengstrom]

Not sure if this is an MS Project version issue (we are using MS Project 2016) or a ServiceNow settings issue (we use Isanbul Patch 6a) or somewhere in between (since docs.servicenow.com indicates support up to MS Project 2013 and makes no mention of MS Project 2016).   When we atttempt to import a Microsoft Project file (MPP extension) we get a processing error and an information code.   This same error occurs whether we import the file in 2016 format or save it down to 2007 format first.

Information Did not find content in CDN for sys_ms_project_import-normal Embedded Help Trigger

Error java.lang.NullPointerException: java.lang.NullPointerException: net.sf.mpxj.mpp.GraphicalIndicatorReader.processOperandValue(GraphicalIndicatorReader.java:211)
net.sf.mpxj.mpp.GraphicalIndicatorReader.processCriteria(GraphicalIndicatorReader.java:175)
net.sf.mpxj.mpp.GraphicalIndicatorReader.processColumns(GraphicalIndicatorReader.java:137)
net.sf.mpxj.mpp.GraphicalIndicatorReader.process(GraphicalIndicatorReader.java:64)
net.sf.mpxj.mpp.MPP14Reader.processGraphicalIndicators(MPP14Reader.java:238)
net.sf.mpxj.mpp.MPP14Reader.process(MPP14Reader.java:98)
net.sf.mpxj.mpp.MPPReader.read(MPPReader.java:136)
net.sf.mpxj.mpp.MPPReader.read(MPPReader.java:79)
com.glide.processors.MSProjectImportProcessor.importProjectFromInputStream(MSProjectImportProcessor.java:100)
com.glide.processors.MSProjectImportProcessor.parseForm(MSProjectImportProcessor.java:75)
com.glide.processors.MSProjectImportProcessor.process(MSProjectImportProcessor.java:41)
com.glide.processors.AProcessor.runProcessor(AProcessor.java:415)
com.glide.processors.AProcessor.processTransaction(AProcessor.java:186)
com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:178)
com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:167)
com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:49)
com.glide.sys.Transaction.run(Transaction.java:1976)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:748)
 com.glide.ui.ServletErrorListener

[sachin_namjoshi]

Hi,

• Microsoft Project 2016 is not supported even in Jakarta.

Project import and export

We also faced similar issue for MPP project import and created HI incident for this.

This is product defect which will be fixed in future releases.

Regards,

Sachin

[kscottengstrom]

Sachin,

Thanks for the quick reply...it is helpful to know 2016 is not supported, I guess my real question is: does anyone have a workaround?   We tried to "save as 2007 format" from 2016 and it gave the same error.   We tried "export to XML" and it refused to import it (because it was not MPP, even though the SN export uses XML format).   Maybe the only logical conclusion is to "buy" a copy of MS Project 2013 (or 2007) and import the export from 2016...then save it in 2013 (or 2007) and use that MPP file instead...?

[sachin_namjoshi · Accepted solution]

Hi,

Please use below workaround

Please create Simple 2007/2013 MPP (with no tasks) file and save the same and later copy over the changes from existing MPP file to the same. So basically copy all your tasks from the above you're trying to import and pasted them into this new file created above. Save the file and try to import.This should work

Regards,

Sachin

[kscottengstrom]

I created a 2007 file from the 2016 program (with no tasks as recommended) but still get the error when trying to import into ServiceNow.   Are you saying I have to actually install the older version of MS Project (2013 o lower) to create the sample file?     If so, that is not a workaround so much as a requirement to buy more software for the sole purpose of uploading to ServiceNow.   Please clarify your recommended workaround.