Overview

Do your plant personnel have long walking distances and search times due to manually and decentralized organized storage areas? Does the savings from changes in that area not justify a return on investment, so new storage hardware systems would be considered? Then follow the project of the Siemens Motion Control Factory: given the factory situation, a team of plant IT and plant experts began developing the Storage Management application with Mendix. They spent one week on ideation and another week on development – and it was ready!

Plant personnel can check out their needed assets, are guided to the correct storage location, and will be proactively alerted if there is an insufficient supply of assets. The Storage Manager can view defective assets and will be alerted when a minimum volume of an asset is reached, allowing them to start the repair process or the SAP asset order process.

Documentation

Demo data setup:

1. Log in as an administrator.
2. Select "Excel Template."
3. In MxReflector, select "ImportData" and click "Click to refresh."
4. Go to the "Templates" tab and click on "Import template."
5. Select "template_example" from the \resources\ImportData_Example folder of your application.
6. Now, you can switch to the storage manager user role.
7. Click on "New setup," then on "Upload excel file."
8. Select the newly added template and data_example file from \resources\ImportData_Example.
9. You should now be able to select a place in storage for each item, the storage amount, and the minimum required amount.
10. After clicking on "Confirm," the data should be visible on the Management dashboard page.

NOTE: This is an example of data import from a static, fixed Excel structure. To use your own structure, you need to modify attributes and microflows in the "ImportData" module of your application in StudioPro.