3 Replies Latest reply on Jan 7, 2019 1:59 PM by partlycloudy

    APEX - Export parameters

    partlycloudy

      Good to see native support in sqlcl for exporting APEX applications with the apex export command. But I don't see a way to specify parameters to fine-tune the behavior that the old APEXExport.class Java class or the new APEX_EXPORT database API offers.

       

      Specifically, I would like to include developer comments as part of the export file simiilar to APEXExport.class/-expComments  and apex_export.get_application p_with_comments

       

      Any ideas? Thanks

        • 2. Re: APEX - Export parameters
          Franco Soldera

          SQL>

          SQL> apex export 100 nonsense_string

              -applicationid:    ID for application to be exported

              -workspaceid:      Workspace ID for which all applications to be exported or the workspace to be exported

              -instance:         Export all applications

              -expWorkspace:     Export workspace identified by -workspaceid or all workspaces if -workspaceid not specified

              -expMinimal:       Only export workspace definition, users, and groups

              -expFiles:         Export all workspace files identified by -workspaceid

              -skipExportDate:   Exclude export date from application export files

              -expPubReports:    Export all user saved public interactive reports

              -expSavedReports:  Export all user saved interactive reports

              -expIRNotif:       Export all interactive report notifications

              -expTranslations:  Export the translation mappings and all text from the translation repository

              -expFeedback:      Export team development feedback for all workspaces or identified by -workspaceid to development or deployment

              -expTeamdevdata:   Export team development data for all workspaces or identified by -workspaceid

              -deploymentSystem: Deployment system for exported feedback

              -expFeedbackSince: Export team development feedback since date in the format YYYYMMDD

              -expOriginalIds:   If specified, the application export will emit ids as they were when the application was imported

              -split:            Split the exported file

              -splitFlat:        Split with no directory strucure

              -splitUpdate:      Generate update.sql file while splitting

              -splitNoCheckSum:  Overwrite all files

           

           

          Application Example:            apex export -applicationid 31500

          Workspace Example:              apex export -workspaceid 9999

            Instance Example:               apex export -instance

          Export All Workspaces Example:  apex export -expWorkspace

          Export Feedback to development environment:

                   apex export -workspaceid 9999 -expFeedback

          Export Feedback to deployment environment EA2 since 20100308:

                   apex export -workspaceid 9999 -expFeedback -deploymentSystem EA2 -expFeedbackSince 20100308

          SQL>

           

           

          Could  -expFeedback and -expFeedbackSince be the options you are looking for?

          • 3. Re: APEX - Export parameters
            partlycloudy

            No. Feedback refers to comments captured when using the team development feature or at run-time using the Feedback application feature. I am referring to developer comments entered by developers when designing the application in the Application Builder.

             

            Seems like Kris Rice-Oracle missed this one :-)

             

            Usage java oracle.apex.APEXExport [option]...

            Available options:

                -db:                  Database connect url in JDBC format

                -user:                Database username

                -password:            Database password

                -applicationid:        ID for application to be exported

                -workspaceid:          Workspace ID for which all applications to be exported or the workspace to be exported

                -instance:            Export all applications

                -expWorkspace:        Export workspace identified by -workspaceid or all workspaces if -workspaceid not specified

                -expMinimal:          Only export workspace definition, users, and groups

                -expFiles:            Export all workspace files identified by -workspaceid

                -skipExportDate:      Exclude export date from application export files

                -expPubReports:        Export all user saved public interactive reports

                -expSavedReports:      Export all user saved interactive reports

                -expIRNotif:          Export all interactive report notifications

                -expTranslations:      Export the translation mappings and all text from the translation repository

                -expFeedback:          Export team development feedback for all workspaces or identified by -workspaceid to development or deployment

                -expTeamdevdata:      Export team development data for all workspaces or identified by -workspaceid

                -deploymentSystem:    Deployment system for exported feedback

                -expFeedbackSince:    Export team development feedback since date in the format YYYYMMDD

                -expOriginalIds:      If specified, the application export will emit ids as they were when the application was imported

                -expNoSubscriptions:  Do not export references to subscribed components

                -expComments:          Export developer comments

                -expSupportingObjects: Pass (Y)es, (N)o or (I)nstall to override the default

                -expACLAssignments:    Export ACL User Role Assignments.

                -debug:                Print debug output

                -nochecksum:          Overwrite existing files even if the contents have not changed

                -split:                Split applications into multiple files