Sage 100

VI import perform logic Need to run an executable at the end of import to move the import source file to another folder. Per KB: __To execute an external file to be executed by the Windows operating system, enter * (asterisk) followed by the ""exe"" command To execute an external file and wait until the external program is complete, enter ~ (tilde) followed by the ""exe"" command__ Okay I need to do both, do I use *~ or ~* or does it matter?

I have been running this file as part of the VI perform logic for over eight years now. Still working like a champ. It moves the import file (glxfer.dat, the name never changes), to an archive folder and renames it by appending the date and time (glxfer20130103102255.dat). Perhaps it will work in your case. !1. created a folder ""pl"" in the MAS90/VI folder !2. copied the text above into a notepad file, saved with the name ""rename.pl"" in the VI\pl folder (didn't make any changes to the text) !3. created a simple job, tested to be sure it works without the pl !4. on the configuration tab, selected perform !5. selected perform type ""completion"" and changed the command to ..\VI\pl\rename.pl !and assistance from PVXlanguage.pdf file !6. Modified 2/14/09 to move imported file to archive folder and rename by appending system date and time to file name. rename ""..\MAS_BLS\TGBLS\glxfer.dat"" to ""..\MAS_BLS\TGBLS\ARCHIVE\glxfer""+DTE(0:""%Ys%Mz%Dz%Hz%mz%sz"")+"".dat

Thank you @JeffSchwenk - when you entered the command line for the perform logic, you don't need to use a tilde or an asterisk, because its not an '.exe.' file?

Not really sure. Big Louie or Slade Hornick helped me with the original back in the day. In essence, it is a simple bat file. The command line is just PVX syntax. The only line inside the rename.pl file is the last line. Line #'s 4 & 5 are for the VI job. Very simple yet very effective.

@JeffSchwenk the link doesn't lead anywhere. I've tried 'save as' to 'bat' and doesn't seem to open for review.

Also, the 3rd party software vendor wrote (whose file I import) the 'rename' files and saved as 'exe' type so I can't see if theirs will work (std open with notepad didn't work). I'll test with a ~ and then * in front of the command, but would really like to see yours in case theirs fails. Thanks @JeffSchwenk

Let's start over. See attached file. Follow the notes inside it to create the file that you want. Call me if you have questions.

Got it now thanks. The exe that had been provided to me by the 3rd party ran last night when I inserted an ""*"" at the front of the command line on the perform logic. I like your file its simple and can be used with any source file. Nice job @JeffSchwenk