24.9 Importing Export Files

1. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
2. For Import:
   1. Import file - Navigate to the file.
   2. File Type - Select Application, Page, or Component Export.
   3. Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it.

3. To install the file, click Next.

   The Install Application wizard appears.

4. For the Install wizard:
   1. Parsing Schema - Select a schema.

      This is the schema against which all of the application's SQL and PL/SQL are parsed.

   2. Build Status - Select one of the following:

      • Run Application Only - Users can only run an application.

      • Run and Build Application - Users can run an application and developers can both run and edit an application.

      Selecting Run Application Only is an effective way to protect an application from modifications from other developers.

      Tip:

      If you select Run Application Only, the only way to change this setting after you import the application is to log in to Oracle Application Express Administration Services.

   3. Install As Application - Select one of the following:

      • Auto Assign New Application ID

      • Reuse Application ID From Export File

      • Change Application ID

      Use these options to avoid application ID conflicts. These options come in handy when you have two versions of the same application in the same instance. For example, you might be migrating an application to a production instance and still need to maintain the development version.

   4. Click Install Application.

Application groups are exported with an application, application exports include an group ID, name, and comments. When importing an application, the application import follows these rules:

• On import, an application uses an existing group if the ID matches.

• If no application group exists with the same ID on the target system, then application import looks for another group ID with the same name. If a name match is found, the application is imported with the ID corresponding to this application group name.

• If no ID or name matches existing application groups on the target system then a new application group is created. The new application group uses the application group ID if that ID is not used in that Oracle Application Express instance. If the group ID is being used, then a new ID is generated.

1. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
2. For Specify File:
   1. Import file - Navigate to the file.
   2. File Type - Select Websheet Application Export.
   3. Click Next.

      Once you import a file, you have the option to install it.

3. To install an imported file, click Next.

   The Install Application wizard appears.

4. For the Install Application wizard:
   1. Install As Application - Select one of the following:

      • Auto Assign New Application ID

      • Reuse Application ID From Export File

      • Change Application ID

      Use these options to avoid application ID conflicts. These options come in handy when you have two versions of the same application in the same instance. For example, you might be migrating an application to a production instance and still need to maintain the development version.

   2. Click Install.

1. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
2. For Specify File:
   1. Import file - Navigate to the file.
   2. File Type - Select Plug-in.
   3. Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it.

3. To install an imported file, click Next.
4. Click Install Plug-in.

1. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
2. On Import Definition, select the following:
   1. Import file - Navigate to the file.
   2. File Type - Select Theme Export.
   3. File Character Set - Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it.

3. To install an imported file, click Next.
4. Click Install Theme.

1. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
2. Select an application.
3. On Import Definition:
   1. Import file - Navigate to the file.
   2. File Type - Select User Interface Defaults.
   3. File Character Set - Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it.

4. To install an imported file, click Next.
5. Click Install User Interface Defaults.

1. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
2. Select Feedback.
3. For File Character Set, verify that File Character Set is correct and click Next.

   Once you import a file, you have the option to install it.

4. To install an imported file, click Next.
5. Click Install Feedback.