Automic Continuous Delivery Automation

  • Private Community
 View Only

  • 1.  How do I write the ImportExportCLI -where clause?

    Posted Jan 22, 2018 02:09 PM
    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?


  • 2.  How do I write the ImportExportCLI -where clause?
    Best Answer

    Posted Jan 22, 2018 02:15 PM
    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


  • 3.  Re: How do I write the ImportExportCLI -where clause?

    Posted Oct 09, 2018 02:36 PM

    Hi, the export works perfectly, but the import doesn't work:

     

    C:\Automic\Release.Manager\Utilities\ImportExportCLI>Importexportcli.exe DeepImport -con http://172.26.28.22/webui -usr AUTOMIC/200/ADMIN200/CDA -pwd xxxxx -format xml -mt Application -where "system_name eq 'SAT BAN'" -fi exports/testapp.zip


    Reference property "system_owner.system_name" = "200/ADMIN100/CDA" not found
    Reference property "system_application.system_name" = "SAT BAN" not found
    Reference property "system_application.system_name" = "SAT BAN" not found
    Reference property "system_owner.system_name" = "200/ADMIN100/CDA" not found
    Workflow 'Deploy' of Application 'SAT BAN' not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found
    Reference property "system_on_entity" = "Backend" not found

    ................

     

    Thanks



  • 4.  Re: How do I write the ImportExportCLI -where clause?

    Posted Oct 09, 2018 02:44 PM

    I saw This link

     

    Requirements for Importing an ARA Application into - CA Knowledge 

     

    But, I'm trying to export User, folder, etc, with AdminCLi

     

    do anyone has an example? please.



  • 5.  How do I write the ImportExportCLI -where clause?

    Posted Jan 26, 2018 09:39 AM
    This worked perfectly to import and export an application between ARA systems.
    Thank you Martin!