Structure of Import XML

Following screenshot displays the structure of import xml:

Structure of Import XML

Following is the description of the tags used in import XML file:

<Configuration operation="import">
This is the root tag of the XML. It also specifies the type of operation. For example: Export or Import. You need not to change anything within this tag.

<SourceZipLoc>/opt/export/export.zip</SourceZipLoc>
Enter the path along with the file name, of the exported zip. This is the zip that you have created during export step. You may also specify this value as parameter through the command prompt at run-time.

<AdeptiaInstallFolder>/AdeptiaServer
Enter the installation path of the Adeptia Suite of target environment where you want to deploy the exported zip. You may also specify this value as parameter through the command prompt at the run-time.

<RetainXmlLocation>/opt/retain.xml</RetainXmlLocation>
Enter the path along with file name of the retain xml. Retain XML file is used to specify the activities that you want to retain while importing the objects.

<OverrideGroup >IndigoGroup:127000000001107055548721600002</OverrideGroup>
Enter the id of the group, which will be the owner group of the deployed objects in the target environment.

<OverrideUser>IndigoUser:127000000001107055536473900001</OverrideUser>
Enter the id of the user, which will be the owner of the deployed objects in the target environment.

<OverrideModifiedByUser></OverrideModifiedByUser>
Enter the User Id which will be reflected in the modified by field of every activity after deployment.

<OverridePermission>rwx,r-x,r--</OverridePermission>
Enter the permission/s which will be reflected in the permission field of every activity after deployment. By default no values are defined, so the default permissions will be applicable unless you override them during deployment.

In addition, read permission is automatically granted. For example, if you give only write or execute permission to owner then he will get the read permission as well.
<Solution>
<DatabaseType><![CDATA[sql]]></DatabaseType>
<Server><![CDATA[192.168.1.17]]></Server>
<Port><![CDATA[1433]]></Port>
<DatabaseName><![CDATA[SqlDatabase]]></DatabaseName>
<UserName><![CDATA[sa]]></UserName>
<Password><![CDATA[p@ssw0rd]]></Password>
</Solution>

Enter values for all the parameters. You need to define these parameters as to export table(s) from the respective database.
Here: