Importing daily file with a variable name

Running SAGE 100 v2018 and trying to import a file on a daily basis that will contain a data stamp on it. What I'm trying to do is automate the process by creating a scheduled task in Windows that opens a batch file that runs the VI program. The only issue is that the file being imported has a date stamp as part of the name so each time the batch is run, an error occurs because the file cannot be found. One option is to rename the file once it is placed in the static directory but I was hoping there might be a way to import the file without modifying the name. Any suggestions would be much welcomed.

Parents
  • Script to copy the correct date-stamped file into the file name / path used in VI settings, then trigger the job, with Perform logic to rename the file after import.  You end up with two copies of the file, but I consider that a good thing.

Reply
  • Script to copy the correct date-stamped file into the file name / path used in VI settings, then trigger the job, with Perform logic to rename the file after import.  You end up with two copies of the file, but I consider that a good thing.

Children
  • in reply to Kevin M

    First, I appreciate the turbo speed response, Kevin...thank you.  Unfortunately my strengths are not within VI so most of what you said went over my head.  I'm not sure what you mean by "script to copy.."  On the flipside, I do know how to write a Perform logic to rename the file and place it in an "archive" folder.

  • in reply to Paul Smith - Bretthauer

    External VBScript or batch file commands. Google can tell you how.  There are lots of resources with examples of moving / copying text files.  For VI you just need the data in a specific file since you can't change that dynamically.

    For triggering a VI job from a batch file, the Sage KB has instructions for that.