Qlik Tabular Reporting failure upload Receiver template

[Loes]

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?

[MichaelR1 · Accepted solution]

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.

[Loes]

That Worked Indeed!! Thanks so much

[JonnyPoole · Accepted solution]

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';

[Loes]

That's even a better idea. Thanks!

[andre_bento]

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:

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';

[JonnyPoole]

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 

[andre_bento]

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

[JonnyPoole]

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. 

[andre_bento]

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.