Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
CreoLabs
Contributor II
Contributor II

Import Master Item with Line Break in expression

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.

Labels (1)
  • SaaS

9 Replies
AfeefaTk
Support
Support

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

AfeefaTk
Support
Support

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

CreoLabs
Contributor II
Contributor II
Author

Hi, sure. Attached

AfeefaTk
Support
Support

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

CreoLabs
Contributor II
Contributor II
Author

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

AfeefaTk
Support
Support

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

CreoLabs
Contributor II
Contributor II
Author

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...
CreoLabs
Contributor II
Contributor II
Author

Hi. Any update?

AfeefaTk
Support
Support

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