How to properly import a page from "another" application? (Apex 19.2)

John like many others

Hello

I have developed an Apex Application in 19.2. Now we want it to bring to Production. I was able to export the whole application from DEV to PROD. In the nature of changes I have to do enhancements in between of single pages. Now when I want to import a single page in PROD that I have exported DEV it stops on the install step:

This page was exported from a different application or from an application in different workspace. Page cannot be installed in this application.

Per se it's the same application on another DB, in a different Workspace. The only one obvious difference is:

DEV application ID: 107

PROD application ID: 100 (I can't change this in Application Properties, nor its alias)

I've found nothing about this in documentation: https://docs.oracle.com/en/database/oracle/application-express/19.2/htmdb/importing-export-files.html#GUID-930EE242-A0A7-4CEF-A588-8B435704449E

I've found this scary link https://community.oracle.com/tech/developers/discussion/710565/how-to-import-page-from-another-instance-workspace where there are some manual changes which I want to avoid.

Target: Export single pages from DEV environment, import to PROD environment WITHOUT any manual changes and no Apex complaints/errors.

Question: What do I have to do to to achieve this goal? In what way the application have to be the "same"?

Thank you

John like many others

Thank you for the clear answer! I try this out and will let you know how it worked.

peter_raganitsch

To make this work easily you should have the same workspace-id and the same application-id on both systems, DEV and PROD.

John like many others

Thank you for the clear answer! I try this out and will let you know how it worked.

John like many others

It worked with same Workspace-ID and same Application-ID BUT some other parts have to be considered as well, else same blocking message:

On export the whole application:

• Export Preferences -> Export with Original IDs must be set to active

On import the whole application:

• "Install" step: Reuse Application ID <nnn> From Exported File

Then you will be able to export/import pages without blocking messages.

AndyH

You can import the entire application into your workspace allowing APEX to assign a random APP_ID.

From your existing application you can then use the "create page" "page as copy" to copy the page from the imported application.

peter_raganitsch

John,

you are right about the "Reuse Application Id", but you shouldn't use "Export with Original IDs".

"Export with Original IDs" doesn't have any effect on an application developed from scratch, but it changes the IDs to some old values if your application is a result of an import or copy of another application.