topic Re: Qlik Tabular Reporting failure upload Receiver template in Reporting Service & Alerting

Qlik Tabular Reporting failure upload Receiver template

Loes — Fri, 15 Dec 2023 15:07:21 GMT

Totally excited, I started testing this new reporting excel add-in option in Qlik Saas. When setting up recipients, it is possible to download an example template file. You can fill this with your own data, so it can then be uploaded again in the correct format. However, I get an error while uploading, it the same file as the template file. Only I filled in my own email recipients. Does anyone experience the same issue? Or where can this be caused?

Re: Qlik Tabular Reporting failure upload Receiver template

MichaelR1 — Mon, 18 Dec 2023 13:27:35 GMT

The recipients import seems to add a section to your load script to import the file. Check your script for 'exit script' statements before the end of the section, when I was having this issue it was because the script exited before reaching that section.

Re: Qlik Tabular Reporting failure upload Receiver template

Loes — Mon, 18 Dec 2023 14:57:00 GMT

That Worked Indeed!! Thanks so much

Re: Qlik Tabular Reporting failure upload Receiver template

JonnyPoole — Wed, 20 Dec 2023 19:26:42 GMT

It may be easier to just go straight to the script and use an INLINE table to load your users. This can be done in a new section of script at the end with the necessary tags and optional hideprefix.

Set HidePrefix = '%';

Users:
LOAD * INLINE [
%Recipient,%Email,%Filters
Jonathan Poole,jonathan.poole@test.com,Northeast
Jonathan Poole+1,jonathan.poole+1@test.com,Midwest
Jonathan Poole+2,jonathan.poole+2@test.com,Southeast
Jonathan Poole+3,jonathan.poole+3@test.com,Southwest
Jonathan Poole+4,jonathan.poole+4@test.com,South Central
Jonathan Poole+5,jonathan.poole+5@test.com,West
];

tag field %Recipient with 'DL_DISTRIBUTION_SVC__recipientName';
tag field %Email with 'DL_DISTRIBUTION_SVC__recipientEmail';
tag field %Filters with 'DL_DISTRIBUTION_SVC__recipientFilters';

Re: Qlik Tabular Reporting failure upload Receiver template

Loes — Wed, 27 Dec 2023 08:37:08 GMT

That's even a better idea. Thanks!

Re: Qlik Tabular Reporting failure upload Receiver template

andre_bento — Wed, 20 Mar 2024 15:10:30 GMT

Hello Jonny,

I tried your suggestion, I am able to load my data however there are no users being created on my reporting Tab. Why is that?

I created a new section like you mentioned and used the exact same code you provided:

tag field %Recipient with 'DL_DISTRIBUTION_SVC__recipientName';
tag field %Email with 'DL_DISTRIBUTION_SVC__recipientEmail';
tag field %Filters with 'DL_DISTRIBUTION_SVC__recipientFilters';

Re: Qlik Tabular Reporting failure upload Receiver template

JonnyPoole — Wed, 20 Mar 2024 15:47:08 GMT

If you have an “exit script” statement before or if the script exits beforehand for other reasons, with recipients won’t be created.

Also try removing line 14 as you likely don’t have these filters created in your app.

Lastly, why are you adding my email to your example? lol

Re: Qlik Tabular Reporting failure upload Receiver template

andre_bento — Wed, 20 Mar 2024 16:00:02 GMT

Thank you for the fast reply Jonny, I have no exit script statement, and I even moved the Distribution list section further up on my flow. I copy pasted your example.. I have already updated it. I am using this code:

Users:
LOAD * INLINE [
%Recipient,%Email,%Filters
André Bento,andre.bento@xxxxx.com,Northeast
Tomás Pádua,tomas.padua@xxxx.com,Midwest
];

tag field %Recipient with 'DL_DISTRIBUTION_SVC__recipientName';
tag field %Email with 'DL_DISTRIBUTION_SVC__recipientEmail';

It is running without issues however the users and group still are not being created

Re: Qlik Tabular Reporting failure upload Receiver template

JonnyPoole — Wed, 20 Mar 2024 16:04:43 GMT

Is the app in a shared or personal space? If yes, I would just try it in a brand new app you own. Also try logging out/in as the behaviour seems strange to me.

Re: Qlik Tabular Reporting failure upload Receiver template

andre_bento — Wed, 20 Mar 2024 16:34:45 GMT

I was using a shared app but I am getting the same outcome for my personal space. Script runs fine but no groups or recipients are being created.. I also tried uploading a csv in the same format of the example csv, and the following section is being created automatically:

Replace LOAD
"Name" AS [DL_DISTRIBUTION_RECIPIENT_NAME],
"Email" AS [DL_DISTRIBUTION_EMAIL],
SubField([Filters],',') AS [DL_DISTRIBUTION_FILTERS],
SubField([Groups],',') AS [DL_DISTRIBUTION_GROUP_NAMES]
FROM "lib://Tracer DEV:DataFiles/reporting_source_b4d79158-af56-40c6-afe3-d2e815c69da3.xlsx"
(ooxml, embedded labels, table is DL_DISTRIBUTION_SVC_USERS_QCS);

TempGroups:
REPLACE LOAD
*
FROM "lib://Tracer DEV:DataFiles/reporting_source_b4d79158-af56-40c6-afe3-d2e815c69da3.xlsx"
(ooxml, embedded labels, table is DL_DISTRIBUTION_SVC_GROUPS_QCS);

let vEnabledFieldNo = FieldNumber('Enabled', 'TempGroups');

if (vEnabledFieldNo > 0) then
DL_DISTRIBUTION_SVC_GROUPS_QCS:
REPLACE LOAD
"Name" AS [DL_DISTRIBUTION_GROUP_NAMES],
"Description" AS [DL_DISTRIBUTION_GROUP_DESCRIPTION],
"Enabled" AS [DL_DISTRIBUTION_GROUP_ENABLED]
Resident TempGroups;
else

DL_DISTRIBUTION_SVC_GROUPS_QCS:
REPLACE LOAD
"Name" AS [DL_DISTRIBUTION_GROUP_NAMES],
"Description" AS [DL_DISTRIBUTION_GROUP_DESCRIPTION],
1 AS [DL_DISTRIBUTION_GROUP_ENABLED]
Resident TempGroups;
end if

Drop Table TempGroups;

tag field DL_DISTRIBUTION_RECIPIENT_NAME with 'DL_DISTRIBUTION_SVC__recipientName';
tag field DL_DISTRIBUTION_EMAIL with 'DL_DISTRIBUTION_SVC__recipientEmail';
tag field DL_DISTRIBUTION_FILTERS with 'DL_DISTRIBUTION_SVC__recipientFilters';
tag field DL_DISTRIBUTION_GROUP_NAMES with 'DL_DISTRIBUTION_SVC__groupsName';
tag field DL_DISTRIBUTION_GROUP_DESCRIPTION with 'DL_DISTRIBUTION_SVC__groupDescription';
tag field DL_DISTRIBUTION_GROUP_ENABLED with 'DL_DISTRIBUTION_SVC__groupEnabled';.

However I get the error that the csv was not uploaded due to not having the same format has the example csv.

Re: Qlik Tabular Reporting failure upload Receiver template

RIchard_Brown — Mon, 25 Mar 2024 12:18:50 GMT

I am getting the same problem as Andre. I have got it too work against a copy of my app but it wont do it on the main app. They are both in shared spaces. I have moved the distribution list section up the code. I have tried adding the recipients in the code directly as described. Nothing seems to work. This seem pretty flakey tech.

Re: Qlik Tabular Reporting failure upload Receiver template

JonnyPoole — Mon, 25 Mar 2024 20:28:15 GMT

Try it without filters:

Users:
LOAD * INLINE [
%Recipient,%Email
André Bento,andre.bento@xxxxx.com
Tomás Pádua,tomas.padua@xxxx.com
];

tag field %Recipient with 'DL_DISTRIBUTION_SVC__recipientName';
tag field %Email with 'DL_DISTRIBUTION_SVC__recipientEmail';

/////

ALSO try it without special characters:

Users:
LOAD * INLINE [
%Recipient,%Email
Andre Bento,andre.bento@xxxxx.com
Tomas Padua,tomas.padua@xxxx.com
];

tag field %Recipient with 'DL_DISTRIBUTION_SVC__recipientName';
tag field %Email with 'DL_DISTRIBUTION_SVC__recipientEmail';

Re: Qlik Tabular Reporting failure upload Receiver template

TheLazyDevelopr — Wed, 27 Mar 2024 16:31:14 GMT

Random question but do we have a keyboard shortcut to insert the tag fields script portion? Right now I just copy and paste so I don't have to go through the recipients route in reporting.