data load log

Anonymous — Thu, 28 Jun 2012 12:57:30 GMT

Dear all,

Can I get from a log file the step-by-step (as displayed) the data load (script execution)?

What I realy want is to setup alarms for problems in any specific load. example: 0 records loaded.

Thanks in advancce.

Re: data load log

erichshiino — Thu, 28 Jun 2012 13:08:50 GMT

Hi,

You can enable the log file on Settings- > Document Properties -> General Tab -> On the right, check 'Generate Log file'.

If you want to keep a log for each reload, you can also check the 'Timestamp in logfile name'. Otherwise, the log will be overwritten each time it runs.

The log file will be in the same folder of your qvw and the name will be the same of the .qvw but with the extension .log ( or the name can be name_timestamp.log if you enable the timestamp)

After that, you will need to create a script to interpret the results from the .log

Alternatively, you can use the approach we discussed in this thread:

http://community.qlik.com/message/230891#230891

There, we included a few more steps in the script to store the number of rows that were loaded in selected tables in qvds. Then, you can create an auxiliary qvw to analyse your results.

Hope it helps,

Erich

Re: data load log

Anonymous — Thu, 28 Jun 2012 13:31:03 GMT

Thanks Erich.

topic Re: data load log in QlikView

data load log

Re: data load log

Re: data load log