KB‎ > ‎

Index is not a valid value when importing properties from Excel

Ref: PEV201108301753
Last edited: August 31st 2012
Dev Ref: 89
 
Description:
When importing and exporting maps from/to Excel the following error can be encountered:
 
An error has occurred processing actions in the Map C:\Documents and Settings\Steve Jones\Desktop\bad\Support\Offer assistance.vdx
=== 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.
Argument 'Index' is not a valid value.
An error has occurred processing actions in the Map C:\Documents and Settings\Steve Jones\Desktop\bad\Support\Offer assistance.vdx
System.ArgumentException: Argument 'Index' is not a valid value.
   at Microsoft.VisualBasic.Collection.get_Item(String Key)
   at Triaster.ProcessNavigator.Common.ProcessObjects.Map.ProcessUpdateCustomPropertyLoadTimeAction(XmlNode objUpdateCustomProperty)
   at Triaster.ProcessNavigator.Common.ProcessObjects.Map.ProcessActions(MELoadTimeProcessing oVDXInterfaceLoadTimeProcessing)
=== Finish For Triaster Support===
 
The steps to create this error are:
  1. Create a map.
  2. Export to a single Excel file.
  3. Save the Excel file.
  4. Import the map from Excel (so the file is redrawn).
  5. Import properties only from Excel.
 
Cause:
This happens when the shape GUIDs (unique IDs) in the VDX and Excel files become out of sync. Whenever you re-draw a map the new shapes will have different GUIDs. If you perform a shape replace on your maps you will encounter this behaviour.
 
Workaround:
If the map is recreated, you must generate a new Excel file to be able to import properties successfully.
 
Fix:
If this occurs, a message will be shown in the progress window rather than displaying an exception message. This fix is applied in PN 11.1.10.

*** Update versions from 11.2 onwards do not use a GUID **** 
 
Applies to:
  • Process Navigator 11.1.0