DataImporter - Import Change Status Transitions



This article presents the method to import the status transition used in the Change module. 

It is possible to control the possible status transitions depending on the Change category or the permissions associated with your roles. The transitions and permission must be imported via DataImporter. 



What you need to know:

The reference template files (.xlsx et .xml) to prepare imports are included in the Status file.

Required Fields

  • Category- Text (100)
    • Represents the Change category.  

    • The category will be created if it does not exist.

    • Status transitions associated to the category do not get added from one import to the other, they get replaced. Hence it is important to add every possible status transition to the categories being imported. 

  • ​​SourceState- Text (1000)
    • Starting status.

    • The New status must be present for each category as the starting status. 

    • The status will be created if it does not exist.

  • DestinationState - Text (1000)
    • The status that represents the new possible step.
    • The status will be created if it does not exist.
What you kneed to know

It is possible to import the status transitions for only one category, but all possible status transitions must be included in the import as each import overwrites the previous statuses. 

If a transition is forgotten during an import, add it to the Excel file and proceed to another import to correct.  

Optional Fields

  • RequiredPermission- Text (1000)
    • Permission required to change to the target status. 

    • The permission will be created in the Change category if it does not exist. 

    • If a permission exists with the same name but in another category, an error appears and the import will not be done. 

Configuration File (XML)

The declaration of the source is done by indicating ChangeStateTransition in the <Content> tag.

NOTE: The XML file used as this example is for an import done from Excel 2007 or 2010. 
<?xml version="1.0" encoding="utf-8" ?>
   <Source Name="Status Transition">
     <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Import\Status Transition.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString>
     <ViewName>[Import Basic Transisitons$]</ViewName>

To explain the tags used in all types and to find out more about the types of files, please refer to the XML Configuration File article


Help us improve our articles

Help us improve our articles