AnsweredAssumed Answered

How do I write the ImportExportCLI -where clause?

Question asked by VKeal on Jan 22, 2018
Latest reply on Oct 9, 2018 by zyxphreez
  • Comment • 4
I would like to use the ImportExportCLI deepExport to export one ARA application.  The goal is to export the application from one ARA system and then import it into another ARA system at a customer site.  We are on ARA 12.1.
What is the correct way to specify the name of the application in the where clause? 
Also, will this export enough for the client to be able to import the application with all components and workflows?
martin_polak_automic
martin_polak_automic Jan 22, 2018 7:14 PM
Correct Answer
Hi,

if you just want to export the application without any additional information (Components, Dynamic Properties, ...), you can do this:
ImportExportCLI.exe export -con https://araserver/ara -usr 100/USR/DEPTM -pwd **** -mt Application -format csv -where "system_name eq 'myApp'" -fi myApp.csv
(instead of csv, you might want to use xml).

If you want to export an application as a whole, including
  1. All components
  2. All component links
  3. All deployment target filters
  4. Dynamic properties of the application
  5. Dynamic properties of the components
  6. All workflows
  7. All workflow definitions
  8. Dynamic properties of the workflow
use the following syntax:
ImportExportCLI.exe deepexport -con https://araserver/ara -usr 100/USR/DEPTM -pwd **** -mt Application -format xml -where "system_name eq 'myApp'" -fi myApp.zip
and then import it with:
ImportExportCLI.exe deepimport -con https://araserver/ara -usr 100/USR/DEPTM -pwd **** -mt Application -format xml -where "system_name eq 'myApp'" -fi myApp.zip

HTH,
Martin
See the reply in context
No one else had this question

Outcomes