Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Ruan
  •  Ruan
  • No customer Topic Starter
2018-02-20T06:45:32Z
New task:

Every day VC should monitor the previous workday's log file on a mapped network drive, look for a string in the file, and if it matches, send an email.

Problem is configuring the correct syntax for VC to read the previous day's log file. Directory contains 600k files, and every day new files are added.

File format: F:\data\log\Chart_Import(FWPLCHAR)NNNN.log where NNNN is a random number.

Any help on how to configure such a task is appreciated.

Regards
Ruan
Sponsor
Forum information
bbusse
2018-02-22T16:25:06Z
I'm not sure i'll be able to help with this, but a screenshot showing the folder with the files in it would likely help to ensure we all understand what you're dealing with. Preferably sort the files by date showing most recent (so the newest file would be from yesterday, at the top). And is NNNN really a random number or is it based on the date in any way?

Brian
Ruan
  •  Ruan
  • No customer Topic Starter
2018-02-23T05:55:21Z
Thanks for the reply bbusse. I got it working with the help of VisualCron support and some minor tweaking. Configuration as follows:

Create a job and add an Email task. Configure the Email task as follows:
  1. Configure the Main settings, Recipients and Text as needed.
  2. In the Attachments tab, ADD a new attachment.
  3. In the Location tab, configure Folder path, and Include file mask
    Location
  4. Click the Content tab and specify the phrase you want to check for. In this case, the file should contain a phrase of INSERT ERROR.
    Content
  5. Click the Date tab and configure the Modified Date to be less than {DATEFORMAT(d/MM/yyyy h:mm tt)} - or whatever your locale setting is. To check your setting, click the red Variable button. Under Date variables, click Date format and use that variable key.
    Date
  6. Click the Result tab. Sort the results by Modified Date in Descending order. Limit the result to 1.
    Result


Great product, really impressed!
Users browsing this topic
Scroll to Top