Logging script execution

[Anonymous]

Hi Experts,

I have a scheduled daily QlikView batch that executes to extract a series of data from Customer A to Z. I would like to log the execution to a log file so that I know the batch has executed for Customer A to Z successful. Example of the log content

DateTime                 Message                                                            ErrorMsg

10/12/2013 05:00     Data Extraction Started on 10/12/2013

10/12/2013 05:00     Data successfully extracted for Customer A

10/12/2013 05:00     Data successfully extracted for Customer B

10/12/2013 05:01     Data extraction failed for Customer!!                  Some error message

I am quite a loss on how I can do this in QlikView. Can someone advise? Thx.

[Gysbert_Wassenaar · Accepted solution]

I don't understand your question. You can enable the Generate Logfile option in the document properties of .qvw documents so a log is generated when the file is reloaded. You can use the TRACE keyword  in the script to output custom logging lines. See the help file for more details.

[Anonymous]

Nickson

How about you:

• Create a log.qvd if it does not exist
• Early in your load script load it into resident
• Concatenate your log information to it with an Inline
• At the end of your script store the log.qvd

Best Regards,     Bill

[Anonymous]

Thx for your suggestion! I just tried switching on the log and placing a few trace statement in my scripts and then reload my file.

Urmm... I am not able to find the any log file generated. Can advise where are the logs generated to?

[Anonymous]

Thx gwassenaar! I got it.