Forum Stats

  • 3,734,169 Users
  • 2,246,900 Discussions
  • 7,857,146 Comments

Discussions

APEX - Export parameters

partlycloudy
partlycloudy Member Posts: 8,024 Silver Trophy
edited Jan 7, 2019 8:59AM in SQLcl

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

Justin WarwickFranco Soldera

Answers

  • partlycloudy
    partlycloudy Member Posts: 8,024 Silver Trophy
    edited Nov 6, 2018 11:07PM
  • Franco Soldera
    Franco Soldera Member Posts: 50 Red Ribbon
    edited Jan 7, 2019 8:21AM

    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?

    Justin Warwick
  • partlycloudy
    partlycloudy Member Posts: 8,024 Silver Trophy
    edited Jan 7, 2019 8:59AM

    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

    Franco SolderaJustin Warwick
Sign In or Register to comment.