implementation:wms:install_toolsconfig
Differences
This shows you the differences between two versions of the page.
| 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}} | + | 2. Select an instance alias which will connect to the company database and click ''Run'' to start the Produmex Database Upgrade tool. |
| - | 2. Click the ''Run'' button to start the UpdateDatabase tool. | + | {{ :implementation:install:boyum:15._choosing_connection.png |Choosing Connection}} |
| - | This tool consists of 3 steps, which you can enable or disable by using the checkboxes on the top of the window: | + | 3. If necessary, change 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 window. The 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 SBO. Seeing 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 localizations. It 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 solution, enable the **Integration with Produmex Manufacturing** checkbox as well. For 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 procedure. If 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 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. | + | 5. Click ''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 procedure. If for some reason the stored procedure has to be re-installed, install 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 finished, close the screen. |
| - | 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.. | + | {{ :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
