Cannot find exported excel file after automation run complete - Toad Data Point Forum - Toad Data Point - Toad World

Cannot find exported excel file after automation run complete

Follow / 7 Jun 2017 at 5:36pm

Why cannot I find the excel file in the locations that I have set up when the log shows the automation run complete and file name generated?

Replies

  • Follow / 9 Jun 2017 at 12:48pm

    Hi sssxxx,

    Whats your Toad Data Point version? Enable verbose logging in automation (in the settings activity > logging level dropdown > verbose), rerun the script and send the log file.

    Petr

  • Follow / 13 Jun 2017 at 8:52pm

    Toad Data Point 3.2. I have changed from Basic to Verbose. Seems it works for some reports. Sandy

  • Follow / 14 Jun 2017 at 2:49am

    On the ones that are not being found does the log file have a "Done" at the end? Perhaps there is an error occuring that you are not aware of. 

    Do you have the "Send email on Error" option set up. This can be found in the settings activity. Check the option and set up the email. This will attach the log file of the error only when there is a problem.

  • Follow / 16 Jun 2017 at 5:55pm

    If you are exporting into an existing Excel worksheet, where is the existing worksheet?  Does it get deleted or just have no new data in it?

     - Greg

  • Follow / 16 Jun 2017 at 6:47pm

    The Export Finished dialog lists the File Name including the directory path, which is of the format C:\Users\<username>\Downloads.

  • Follow / 17 Jun 2017 at 3:17am

    Can you open a support case so I can debug this? i need the files you are using and see what is occurring. I'm sure it is easy to resolve.