In order to access an app's data from Excel via a REST API, you need a corresponding HOMAG Connect license.
Examples:
App | License |
|---|---|
MMR Mobile | HOMAG Connect MMR Mobile |
intelliDivide | HOMAG Connect intelliDivide |
materialManager, materialAssist | HOMAG Connect materialManager |
productionManager, productionAssist | HOMAG Connect productionManager |
You can purchase the license in the tapio shop or add it to an existing license. It is already included in some apps. You can find more information about this on the license page of the respective app and under Subscribe to interfaces / options.
On the right side of the page and on GitHub , various Excel templates are available for download. These can be used as a basis for evaluating the data provided by the various applications in Excel.
The use of the templates is described below.
Download the template you want to use.
Confirm the security instructions in Excel by clicking the "Enable Editing" and "Enable Content" buttons.
A login dialog appears. Switch to the third option "Standard" and enter the SubscriptionId as the username and the authorization key as the password.
To connect Excel to the respective application, the SubscriptionId must be entered as the user name and the authorization key as the password.
For more information about how to obtain the SubscriptionId and permission key, see the Authentication page.
The Excel file created on the basis of the template can be saved locally.
When the application is reopened, the data must be updated. This is done by clicking the "Update All" button.
It is not necessary to re-enter the login data for this purpose. The connection data is stored in Excel.
If you use another template, the link is automatic.