KB‎ > ‎

Exporting a map to Excel that was created in PN 4.50

 This article is suitable for a Process Mapper

Ref: 201205290900 SS
Defect ID: 2609348
Last Edited: May 29th, 2012
Applies to: Process Navigator 4.60 onwards

Description

When an map created in PN 4.50.0.0 or earlier is exported to Excel, the following exception occurs.
 
03/11/2011 17:24:04
   
Legacy SolutionXML data detected in the map 'C:\Documents and Settings\Samyak Shah\Desktop\Import from excel and properties\Dealing with FOI Enquiries.vdx'
 
While this file has been exported to Excel XML, the position & size of elements, routing of connections and some Feedback E-mails & Hyperlink Circles will not have been included. Please open and save this map in Visio to update the SolutionXML.
   
03/11/2011 17:24:05
   
The map C:\Documents and Settings\Samyak Shah\Desktop\Import from excel and properties\Dealing with FOI Enquiries.vdx could not be exported to Excel. Process Navigator will attempt to export the remaining maps and ignore this one.
   
=== Begin For Triaster Support ===
 The following content may be useful to the Triaster support team.
 Please copy and paste it into an e-mail to support@triaster.co.uk
 and attach any referenced files if you would like help understanding
 how to avoid this issue reoccurring.
 Object reference not set to an instance of an object.
 The map C:\Documents and Settings\Samyak Shah\Desktop\Import from excel and properties\Dealing with FOI Enquiries.vdx could not be exported to Excel. Process Navigator will attempt to export the remaining maps and ignore this one.
   
System.NullReferenceException: Object reference not set to an instance of an object.
   
at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.OutputSwimlaneAttributes(XmlElement objXMLElementTableSwimlaneAttributes, Flexilane objFlexilane) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 645
   
at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.OutputMap(Map objMap, Boolean blnIncludeFilenames) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 316
 
at Triaster.ProcessNavigator.Common.ProcessObjects.ExcelExportHelper.PopulateXML(Maps objMaps) in Q:\working\Samyak Shah\Process Navigator 5.x Public Working\Source Code\Common\ProcessObjects\clsExcelExportHelper.vb:line 105
   
=== Finish For Triaster Support === 

Cause

The process map was created in an older version of Process Navigator and needs to be upgraded to be compatible with the Export to Excel feature.

Workaround

Ensure you are using the most recent version of Process Navigator, open the map in Microsoft Visio Process, save the map, close the map and then Export again.
 

Need further help? Contact the Triaster Support team by e-mailing support@triaster.co.uk or by calling us on +44 (0)870 402 1234.
 
Do you have any feedback or suggestions that you would like to share with Triaster? We would love to hear from you! Please e-mail feedback@triaster.co.uk