Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've been trying to use Automations (according to provided templates) to import Master Items.
The import fails for measures with Line Breaks in expression.
Please assist.
Hi @CreoLabs
We will look into the automation workspace.
Meanwhile could you please share the failed automation job file by clicking on the Export this run button in Automations Overview tab?
Please find instructions on how to extract those details in the below article:
https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-Application-Automation/...
Thanks
Hi @CreoLabs
Sorry, I spoke very soon
I just noticed that you have shared the job log file. Could you please share the automation json file?
I just wanted to check how the line breaks are added to the expression.
Also, let me know what changes have you made to the template.
Thanks
Hi, sure. Attached
Hi @CreoLabs
The automation workspace you have shared is the one for dimension.
But from the automation run log file, I see the create or update measure block failed.
{
"block": "CreateOrUpdateMeasure",
"index": 1,
"in_count": 15,
"timestamp_start": 1680006824114096,
"timestamp": 1680006824707633,
"memory_usage": 7985840,
"out_count": 1,
"out": [
{
"jsonrpc": "2.0",
"id": 1,
"error": {
"code": -32601,
"parameter": "GetLayout",
"message": "Method not found"
}
}
],
"in": {
"blendr_on_error": "stop",
"app_id": "3fd323f1-c099-49b8-93c0-ac52e6d6ebe1",
"measure_id": null,
"measure_name_for_search": "# FTDs Late - TBD",
"expression": "Sum\r\n(\n\t{$\n \t<$(vSelectionsPeriod), [Client Account FTD]={\">=$(=Date(Min(Date)))\"}>\n *\n <$(vSelectionsPeriod), [Client Account FTD]={\"<$(=Date(Max(Date)+1))\"}>\n *\n <$(vSelectionsPeriod), [Client Timestamp]={\"<$(=Timestamp(Min(Date)))\"}>\n\t} \n [Trans FTD Ind]\n)",
"name": "# FTDs Late - TBD",
"label_expression": "'# FTDs Late'",
"description": "",
"tags": null,
"create if not found": "yes",
"measure_color": null,
"Number_formatting": null,
"Segment_colors": null,
"blendr_snippet_guid": "ce9912c0-2c26-11ec-af83-ef26e389a542",
"blendr_connector_guid": "61a87510-c7a3-11ea-95da-0fb0c241e75c"
}
}
Is that the correct workspace?
Thanks
Hi.
The problem is with expression that contains line breaks.
It doesn't matter if it's a measure or dimension.
Attached log for dimension...
Hi @CreoLabs
Thanks for sharing the log file.
Could you please let me know how the line break is added to the field column value of dimension in google sheet?
Is it possible for you to share the google sheet so that we can test it out from our end?
Meanwhile please check if it works once you use the Excel file to import dimensions.
Thanks
Hi. Any update?
Hi @CreoLabs
Sorry for delay in response.
I am trying to reproduce the issue.
If it's not a production app do you mind sharing the app?
Thanks