topic Re: In case data file cannot be uploaded in qlikview dashboard, an error should be raised and a log page should populate with data files details. in QlikView

In case data file cannot be uploaded in qlikview dashboard, an error should be raised and a log page should populate with data files details.

Anonymous — Thu, 23 Mar 2017 17:57:34 GMT

Hi Everyone,

I am having the excel source like Sample_03.22.2017AM and Sample_03.22.2017PM which will generated by daily basis.So I am pulling all the excel source by loading like Sample_*. xlsx.

In case any data file cannot be uploaded, an error should be raised and a log page should populate with the date and AM/PM missing data details.

How will achieve this? Can anyone assist me to get this done.

Thanks,

ShakilaD

Re: In case data file cannot be uploaded in qlikview dashboard, an error should be raised and a log page should populate with data files details.

maxgro — Thu, 23 Mar 2017 18:37:34 GMT

I think you have to loop on every file and check if the file exists, something like

vStart = Date(Today() - 10); // start date

vNumOfDates = 10; // num of dates

// date loop

FOR i=1 to $(vNumOfDates)

LET vDate = Date('$(vStart)' + $(i) - 1);

//TRACE $(vDate);

// AM PM loop

FOR each ampm in 'AM', 'PM'

LET vFile = 'Sample_' & Date('$(vDate)', 'MM.DD.YYYY') & '$(ampm)';

TRACE $(vFile);

IF FileSize('$(vFile)')>=0 THEN

Log: LOAD 'File $(vFile) exists' as Msg AutoGenerate 1;

ELSE

Log: LOAD 'File $(vFile) does not exist' as Msg AutoGenerate 1;

ENDIF

NEXT

Re: In case data file cannot be uploaded in qlikview dashboard, an error should be raised and a log page should populate with data files details.

Anonymous — Fri, 24 Mar 2017 17:52:28 GMT

Thanks maxgro

But the script execution should terminate when the specific file not found.

Then in the log file should show the specific file not found error message?

Can you help me to do this?

Re: In case data file cannot be uploaded in qlikview dashboard, an error should be raised and a log page should populate with data files details.

maxgro — Fri, 24 Mar 2017 19:14:51 GMT

add an exit script, bold

vStart = Date(Today() - 10); // start date

vNumOfDates = 10; // num of dates

// date loop

FOR i=1 to $(vNumOfDates)

LET vDate = Date('$(vStart)' + $(i) - 1);

//TRACE $(vDate);

// AM PM loop

FOR each ampm in 'AM', 'PM'

LET vFile = 'Sample_' & Date('$(vDate)', 'MM.DD.YYYY') & '$(ampm)';

TRACE $(vFile);

IF FileSize('$(vFile)')>=0 THEN

Log: LOAD 'File $(vFile) exists' as Msg AutoGenerate 1;

ELSE

Log: LOAD 'File $(vFile) does not exist' as Msg AutoGenerate 1;

// add a trace if you want

TRACE ..........................;

exit script;

ENDIF

NEXT

Re: In case data file cannot be uploaded in qlikview dashboard, an error should be raised and a log page should populate with data files details.

Anonymous — Mon, 27 Mar 2017 19:22:39 GMT

Thanks for the Update Massimo.

I have included the custom log instead of Trace.Its working fine.

Find the updated Script logic as below: