Creating Export XML

Adeptia provides a intuitive interface to create the Export XML file that contains the reference to the objects you want to migrate from one environment of Adeptia Connect to another. 

Prerequisite

• Make sure that you have the required permissions to view and use the Solution Promotion option on the Account menu. To have this permission, the role that you have been assigned must have Allow Solution Promotion to migrate objects checkbox selected in it. To know more about this permissions, refer to this document.

You can create an Export XML file by following the steps given below. 

1. Click Account > Solution Promotion

2. In the Select Export Criteria field, select the criteria based on which you would like to export the objects.
   

   Project	Allows you to export all the selected projects and the activities associated with them.
   Service Type	Allows you to export all the activities of selected services.
   Individual Activities	Allows you to pick and export the activities of a selected Service Type.

3. Select the Add Filter Condition checkbox to further filter the activities to be exported, based on their last modified date.

4. Click Next.
   
5. Select the Export Files/Folders checkbox if you want to export additional files/folders.
   

   1. Select Folder to export folders or sub folders within them.

      Base Folder	Base folder is the mounted folder in the PVC.
      Folder	Enter the name of the folder to be exported.
      Include Subfolder	Enter the comma-separated list of subfolders of the folders you want to export.
      Exclude Subfolder	Enter the comma-separated list of subfolders of the folders you want to exclude during export.
      Include Files	Enter the comma-separated list of files you want to export from the folders/subfolders.
      Exclude Files	Enter the comma-separated list of files you want to exclude from the folders/subfolders during export.

   2. Select File to export the files.
      

      Base Folder	Base folder is the mounted folder in the PVC.
      File	Enter the name of the file to be exported.

6. Click NEXT.

7. Select the checkbox Export Solution if you want to export the data from the tables that you may have created on the database server.

   1. In the Database Info section, provide the following details of the database containing the tables that you want to export.

      Type	Enter the type of database. For example MySQL, SQL, etc.
      Server	Enter the hostname of the database server.
      Port	Enter the port number of the database server.
      Name	Enter the name of the database.
      Username	Enter the username to access the database.
      Password	Enter the password to access the database.

   2. In the Solution Tables section, you can further apply the conditions for exporting database tables.

      Table Name	Enter the name of the tables you want to export.
      Where Clause	Write a conditional query to export selective data or leave it blank to export all the data from the table.

8. Click NEXT.

9. In the Target Zip Location field, if you wish, you can change the name and location for the exported ZIP file which is created during migration.

   This field contains a predefined name and the location for the exported ZIP file.

   
   

10. Click Export Metadata to download the Export XML file.