Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Feb 23, 2023 1:54:12 AM
Apr 29, 2022 8:01:44 AM
This article explains how to import and export master items to and from a Qlik Sense app using the Microsoft Excel connector in Qlik Application Automation.
Content:
The first part of this article will explain how to export all of your master items configured in your Qlik Sense App to a Microsoft Excel sheet. The second part will explain how to import those master items from the Microsoft Excel sheet back to a Qlik Sense App.
For this, you will need a Qlik Sense app in your tenant that contains measures, dimensions, and variables you want to export. You'll also need an empty Microsoft Excel file. The image below contains a basic example on exporting master items.
The following steps will guide you through recreating the above automation:
An export of the above automation can be found at the end of this article as Export master items to a Microsoft Excel sheet.json
For this example, you'll first need a Microsoft Excel file with sheets configured for each master item type (dimensions, measures, and variables). Use the above example to generate this file. The image below contains a basic example on importing master items from Microsoft Excel to a Qlik Sense app.
An export of the above automation can be found at the end of this article as Import master items from a Microsoft Excel Sheet.json
Follow the same steps to build automations that import/export dimensions and variables.
Let's go over some edge cases when exporting information to Microsoft Excel:
Please check the following articles for more information about working with master items in Qlik Application Automation and also uploading data to Microsoft Excel.
Follow the steps provided in this article How to import & export automations to import the automation from the shared JSON file.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Has anyone ever succeeded with this, but with only some of your measures/dimensions/variables? I can't figure out why it's stopping part way through.
Hi, I'm receiving this error message. Could you now what's the issue?
Thanks!
{
"error": "Error calling endpoint \"Microsoft Excel - Create Workbook Session\"",
"endpoint": {
"name": "Create Workbook Session",
"datasource": "Microsoft Excel"
},
"request": {
"url": "https://graph.microsoft.com/v1.0/drives/367516f969ca0d8c/items/Master.xlsx/workbook/createSession",
"method": "POST"
},
"response": {
"status": 400,
"body": {
"code": "invalidRequest",
"message": "ObjectHandle is Invalid",
"innerError": {
"code": "invalidResourceId",
"date": "2024-05-08T23:53:13",
"request-id": "f56eewsx-bfb9-48f8-b62d-9d216e15586a",
"client-request-id": "f56eeaeb-bfc9-48f8-32d-9d216e15586a"
}
}
},
"external error": true
}
Hello @Rodlibar
Please post it in the Application Automation forum to give your question appropriate reach and attention,
All the best,
Sonja
Hello @Ionut_Dumitrascu,
I am having an issue with this Automation.
Indeed, I would like to export all my dimensions (including hierarchical and cyclic dimension), but it seems like it's only possible with the "classic" dimensions at the moment ?
Can you please confirm that ?
Thank you
Best Regards,
Antoine