This chapter describes how to upgrade your existing custom applications from previous to the current Smart Materials Web version.
-
Copy all files from <SMat_Web_Install_folder>\additional_scripts to your SQL working directory
or
Set your SQL working directory to <SMat_Web_Install_folder>\additional_scripts
-
Before you can upgrade your custom applications, you have to install the smat_apex_utils, performing this command:
Sqlplus /nolog @install_smat_apex_utils [DB_CONN] [SYS_PWD] [BIR_SPMAT_PWD]
for example:
sqlplus /nolog @install_smat_apex_utils myDB secret1 secret2
Output should be similar to this:
-
Upgrading a single Custom Application
The upgrade of the application will update all application processes, lists, settings, themes, templates, and page 0 in the target application. If you made any changes to any of these objects – these changes will be overwritten. With respect to templates/themes: In case you added your own templates in the theme, these will remain. But you need to check of screen/rendering issues.
-
To make a backup of your custom application before upgrading, run this command:
SQLPLUS /nolog @update_application [DB_CONN] [SYS_PWD] [BIR_SPMAT_PWD] [APPLICATION_ID]
For example:
SQPLUS /nolog @update_application myDB secret1 secret2 10000
The output will be 5 log files and 1 sql file, each file is postfixed with the application number:
-
UPDATE_APP_10000_application_lists.log
-
UPDATE_APP_10000_application_processes.log
-
UPDATE_APP_10000_application_settings.log
-
UPDATE_APP_10000application_templates.log
-
INSTALL_PAGE_0_FOR_10000.log
-
EXPORT_PAGE_0_FOR_10000.sql
-
-
Check the log files for any ORA-##### errors.
-
If you find any errors, please contact product support and provide the log files, the sql file and the application backup file.
-
-
How to handle customized Template/Theme which was overwritten by the upgrade:
-
In case you modified a template to fit your own need, you have to create a copy of modified template and give it a different (for example, a customer prefixed) name.
-
Now you need to switch every screen (or item) which is using the modified template to the newly created (customer prefixed) template, as follows:
-
In Apex Designer, select Shared Components -> Templates -> Replace Templates from the right menu.
-
Follow the dialog to replace the modified template (for example, page UX_Ingr_Standard) with your copied version of this (for example, page CUSTOM_Ingr_Standard).
-
-