User Tools

Site Tools


implementation:wms:install_toolsconfig

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
implementation:wms:install_toolsconfig [2019/02/08 12:06]
vise
implementation:wms:install_toolsconfig [2020/01/17 14:16] (current)
vise
Line 1: Line 1:
-==== 3.2.1. Produmex Tools configuration ​====+==== 3.3.1. Configure the Produmex Tools ====
  
-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.+1. Click the ''​Config'' ​button ​of the Produmex Tools.
  
-{{ :​implementation:​Installer_ToolsConfig.png?nolink|Produmex ​Tools}} ​+2Select an instance alias which will connect to the company database and click ''​Run''​ to start the Produmex ​Database Upgrade tool.
  
-2Click the ''​Run''​ button to start the UpdateDatabase tool.+{{ :​implementation:​install:​boyum:​15._choosing_connection.png |Choosing Connection}}
  
-This tool consists of stepswhich you can enable or disable ​by using the checkboxes ​on the top of the window: +3. If necessarychange the connection ​by using the //​Connection//​ drop-down list on the top of the screen. The drop-down list is filled with all the connection strings found in the configuration file of the Produmex Database Upgrade tool. 
-  * [[internal:​wms:​install_toolsconfig#​upgrade_database|Upgrade database]] +
-  * [[internal:​wms:​install_toolsconfig#​update_localizations|Update localizations]] +
-  * [[internal:​wms:​install_toolsconfig#​update_add_on_files|Update add-on files]]+
  
-You can also change the connection to use by using the drop-down list on the top of the windowThe drop-down list is filled with all connection strings found in the configuration file of the UpdateDatabase tool.+{{ :​implementation:​install:​boyum:​16._database_upgrade_tool.png |Database Upgrade Tool}}
  
-{{ :implementation:​install:​database_upgrade.png?​ |Produmex Database ​Upgrade}}+4. The tool has three options, which are checked by default: 
 +  * (1) Upgrade ​database 
 +  * (2) Update localizations 
 +  * (3) Update add-on files (Create User Defined Fields)
  
-=== 3.2.1.1. Upgrade ​database === +(1) **Upgrade ​Database**: \\ The tool upgrades ​your database to the required ​Produmex version.  
-In the first step, the tool will upgrade ​your database to the most recent ​Produmex version. +  * **Create User Defined Fields**: \\ The tool creates the necessary User Defined Tables. If the checkbox is not selected, the necessary UDFs need to be created manually in SBO. 
-This step will only be executed ​if the **Upgrade database** checkbox is activated.+  * **Integration with Produmex Manufacturing**:​ \\ Select the checkbox ​if you want to use the integrated Produmex Manufacturing solution (see section: [[implementation:​manufacturing:​wms_integration|Working with Produmex Manufacturing and Produmex WMS]]).  
 +  ​* **Force to re-install PMX_SP_TransactionNotification**: The checkbox is relevant in case of future version upgrades:  
 +         ​*During a database upgrade, stored procedures are installed or updated as well, but 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 a version upgrade, select the Force to re-install PMX_SP_TransactionNotification checkbox.  
 +         * Select the checkbox to add the stored procedure if it is missing.  
 +         * If this stored procedure has been customized, these customizations will be lost in case of a version upgrade
  
-During this step, UDF’s might need to be created in SBOSeeing how this is an intensive action, this action is optional, but vital if you want to complete a full installation.+(2) **Update Localizations**:​ \\ This step updates localizationsIt updates any translations ​to the required Produmex WMS version
  
-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.+(3) **Update Add-on Files**: \\ This step uploads the Produmex suite add-on files necessary ​to run Produmex WMS
  
-If you would like to use the integrated Produmex Manufacturing solutionenable ​the **Integration with Produmex Manufacturing** checkbox as wellFor more information about the how to install the integrated solution please see: [[internal:​manufacturing:​wms_integration#​recommended_installation_steps|How to work with both Produmex Manufacturing and Produmex WMS]].+Note: Before clicking ''​Start''​backup ​the stored procedureIf for some reason ​the stored procedure has to be re-installed, ​install ​it manually from the backup.
  
-During the database upgrade, stored procedures are installed or updated as wellThe 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+5Click ''​Start''​ and the tool displays ​the process.
  
-<WRAP round important>​Only use this checkbox to add the SP when it is missing, but keep in mind that this is a clean install, so if this SP was customized, these customizations will be lost.</​WRAP>​+{{ :​implementation:​install:boyum:17._database_upgrade_tool_displaying_actions.png |Database Upgrade Tool}}
  
-Before starting ​the Tools Upgrade, backup ​the stored procedureIf for some reason ​the stored procedure has to be re-installedinstall it manually from the backup.+6. On the Add-on Loader Form select ​the all row(s) corresponding to the installation and click ''​Upload''​When the upload is finishedclose the screen
  
-Run the database upgrade by clicking on the ''​Start''​ buttonHere the tool displays its actionsWhen 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..+{{ :​implementation:​install:​boyum:​18._addon_uploader_form.png |Add-On Loader Form}}
  
-{{:​implementation:​dbupgrade_custom.png?​nolink|}}+7. When the upgrade process is finished, close the Produmex Database Upgrade and the Produmex Tools screens by clicking x in the top-right corner
  
-When this tool is running, and you have selected customer specific files in the previous steps you will see such messages as: +{{ :​implementation:​install:boyum:19._database_upgrade_completed.png |Upgrade Completed}}
-  * “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. +
- +
-=== 3.2.1.2. Update localizations === +
- +
-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. +
- +
-{{:​implementation:​dbupgrade_localizations.png?​nolink|}} +
- +
-=== 3.2.1.3. Update add-on files === +
- +
-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. +
- +
-{{ :implementation:Installer_ToolsConfig_7.png?nolink |}}   +
- +
-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. +
- +
-{{:​implementation:​AddOnUploadForm_Completed.jpg?​nolink|}} ​  +
- +
-=== 3.2.1.4. Closing the tool === +
- +
-{{:​implementation:​dbupgrade_close.png?nolink|}}   +
- +
-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.+
implementation/wms/install_toolsconfig.1549627579.txt.gz · Last modified: 2019/02/08 12:06 by vise