I have something that hopefully someone can help me with.
I have a EG macros that generate an export from a google spreadsheet to a csv file every 15 minutes. After the csv is created EG runs a simple batch file that deletes the previous version and then copies the new csv file into the working folder. It works great but every once couple of weeks the google spreadsheet logs out and the export doesn't complete successfully. Because of the the way I am doing it right now this means that when this situation occurs the csv is deleted by the batch file and nothing gets copied to the working folder. At this point the automation is essentially broken until I manually go in and re-login to the spreadsheet.
What I would like to do is have EG send me an email when this condition occurs. Sending the email is easy and I am doing similar things already., My challenge is to find a way to check the working directory at the end of my EG macro and trigger a new EG event if my file is NOT there.
(its always the same file name)
Can anyone help with this?
Thanks,
Darren
Notice: This forum has been recovered from an old backup, so some content, links, and dates may be outdated. The forum is currently read-only while we restore sign-in and registration functionality. Details
If you find this forum valuable and would like to help keep it online, donations to help cover hosting and domain costs are greatly appreciated, but never expected. You can support the forum through Buy Me a Coffee or Ko-fi. Thank you for helping preserve the EventGhost community.
If you find this forum valuable and would like to help keep it online, donations to help cover hosting and domain costs are greatly appreciated, but never expected. You can support the forum through Buy Me a Coffee or Ko-fi. Thank you for helping preserve the EventGhost community.
Check to see if a file IS NOT there?
-
Pako
- Plugin Developer
- Posts: 2294
- Joined: Sat Nov 11, 2006 1:31 pm
- Location: Czech Republic
- Contact:
Re: Check to see if a file IS NOT there?
Pako