1. After clicking the Config button of the Produmex Tools, you will see the configuration screen of the Tools. Select an instance alias which will connect to a company database that will be updated to the most recent Produmex version.

2. Click the Run button to start the UpdateDatabase tool.

This tool consists of 3 steps, which you can enable or disable by using the checkboxes on the top of the window:

• Upgrade database
• Update localizations
• Update add-on files

You can also change the connection to use by using the drop-down list on the top of the window. The drop-down list is filled with all connection strings found in the configuration file of the UpdateDatabase tool.

In the first step, the tool will upgrade your database to the most recent Produmex version. This step will only be executed if the Upgrade database checkbox is activated.

During this step, UDF’s might need to be created in SBO. Seeing how this is an intensive action, this action is optional, but vital if you want to complete a full installation.

You can disable the creation of UDF’s by deactivating the Create User Defined Fields (slow on big DB’s) checkbox on the top of the window. In this case, you will have to create the UDF’s manually in SBO; the UpdateDatabase tool will prompt you to do so.

If you would like to use the integrated Produmex Manufacturing solution, enable the Integration with Produmex Manufacturing checkbox as well. For more information about the how to install the integrated solution please see: How to work with both Produmex Manufacturing and Produmex WMS.

During the database upgrade, stored procedures are installed or updated as well. The PMX_SP_TransactionNotification stored procedure is only added in case of a fresh installation or when upgrading from a version lower than 6.3. To update the PMX_SP_TranscationNotification during the upgrade, enable the Force to re-install PMX_SP_TransactionNotification checkbox.

Before starting the Tools Upgrade, backup the stored procedure. If for some reason the stored procedure has to be re-installed, install it manually from the backup.

Run the database upgrade by clicking on the Start button. Here the tool displays its actions. When starting from a new database without previous version of Produmex WMS installed, it will adjust the database by first adding UDT’s, UDO’s, adding UDF’s to SAP tables, creating PMX-tables, foreign keys, etc..

When this tool is running, and you have selected customer specific files in the previous steps you will see such messages as:

• “Found custom ‘AddUpdateData.cs’: updates the database with custom UDF’s/UDT’s, PMX-tables, etc..This cs-script executes custom database-adjustments specific for that customer.
• “Found custom ‘: If a custom script is found and inserted to the database, you can see the name of the script here. In this example a EnterPickingQuantityHookFlow is inserted into the database or updated if it already exists.

The second step performs an update for the localizations. This step will update any translations to the most recent version of the current Produmex WMS version.

This step will only be executed if the “Update localizations” checkbox is activated.

The final step you have the option to upload the Produmex suite add-on files necessary to run the Produmex suite add-on.

This step will only be executed if the “Update add-on files” checkbox is activated.

In this screen you can see the files required to upload. By default the Add-on Uploader will search in the build directory in which it is located.

Select the row(s) corresponding to the installation you are doing, and click ‘Upload’. After uploading, close the screen.

After all the selected steps have been executed, you can close the screen. To do so, press the ‘x’ cross in the top-right corner of the window.