topic Re: Import Master Item with Line Break in expression in Qlik Automate

Import Master Item with Line Break in expression

CreoLabs — Tue, 28 Mar 2023 13:23:00 GMT

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.

Re: Import Master Item with Line Break in expression

AfeefaTk — Thu, 30 Mar 2023 04:01:31 GMT

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/ta-p/2016531

Thanks

Re: Import Master Item with Line Break in expression

AfeefaTk — Thu, 30 Mar 2023 06:04:31 GMT

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

Re: Import Master Item with Line Break in expression

CreoLabs — Thu, 30 Mar 2023 12:10:34 GMT

Hi, sure. Attached

Re: Import Master Item with Line Break in expression

AfeefaTk — Thu, 30 Mar 2023 13:07:05 GMT

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

Re: Import Master Item with Line Break in expression

CreoLabs — Sun, 02 Apr 2023 06:46:07 GMT

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...

Re: Import Master Item with Line Break in expression

AfeefaTk — Mon, 03 Apr 2023 04:59:39 GMT

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

Re: Import Master Item with Line Break in expression

CreoLabs — Wed, 05 Apr 2023 21:14:41 GMT

Hi,
The Google Sheet was exported from application as is.
It doesn't work even when you import from another application and then
export to a new one.
There is template in automations that should do this but it fails due
the same reason - multiline expression.
Just try to create a measure or dimension with multiline expression and
then to use the automation...

Re: Import Master Item with Line Break in expression

CreoLabs — Sun, 16 Apr 2023 06:17:57 GMT

Hi. Any update?

Re: Import Master Item with Line Break in expression

AfeefaTk — Mon, 17 Apr 2023 09:52:10 GMT

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