Append Date and Time to VI export using Perform function?

Question

Running SAGE 100 v2018 and exporting a file using VI that requires the current date and time be appended to the file. Is there a way to accomplish this using the Perform option within the VI Export job or do I need to create a separate batch process once the file has been created? I'm not well versed in the Perform function and if it can be done in Perform, it would be helpful to see an example. Thank you.

David Speck · Accepted Answer

The following should work for you. There is a ProvideX RENAME directive but I haven't gotten a chance to test it on Advanced installs but the code below does work on Standard and Advanced installs. This code does not rename the file but rather copies it using the current file name as the source and the resulting file name in the NEWFILENAME$ variable as the destination. 
 LET MAS90_PATH$=%SYS_SS'PATHROOT$
 IF %SYS_SS'CS=1 THEN { LET MAS90_PATH$=%SYS_SS'PATHCSROOT$ }
 LET WDX_OPTION$=COSESSION'WDX$
 IF IMPORTFILEONHOST$="Y" THEN { LET WDX_OPTION$="" }
 IF IMPORTFILENAME$<>"" THEN {
 LET NEWIMPORTFILENAME$=MID(IMPORTFILENAME$,1,POS("."=IMPORTFILENAME$,-1)-1)+"_"+DTE(0:"%Y-%Mz-%Dz %hz%mz%sz %P")+MID(IMPORTFILENAME$,POS("."=IMPORTFILENAME$,-1))
 ! LET NEWIMPORTFILENAME$=MAS90_PATH$+"Home\TextOut\"+MID(NEWIMPORTFILENAME$,POS("\"=NEWIMPORTFILENAME$,-1)+1)
 ! LET NEWIMPORTFILENAME$="C:\"+MID(NEWIMPORTFILENAME$,POS("\"=NEWIMPORTFILENAME$,-1)+1)
 LET S_CMD$=WDX_OPTION$+"CMD /E:ON /V:ON /S /Q /C COPY /Y """+IMPORTFILENAME$+""" """+NEWIMPORTFILENAME$+""""
 INVOKE HIDE WAIT S_CMD$
 } 
 Exclamation points comment out lines, I have commented out two lines in the above code to show how they can be used to change the directory. 
 The first line commented out copies the new file name to the MAS90\Home\TextOut folder. 
 The second line commented out copies the new file name to the C:\ folder. 
 If you leave both lines commented out, the file is simply copied into the original folder with the new file name. 
 Put the code in a text file somewhere accessible by users that run Sage 100, I recommend the MAS90\CM\Script folder on the Sage 100 server. You can optionally change the extension to something like ".pl" instead of ".txt". Then in your VI job, click the Perform button, set the perform type to "On Completion", set the sequence to something that isn't in use already, hit the flashlight button to see if there is other perform logic in use, then enter the relative path to the file containing the code. 
 
 EDIT: Added 2 lines at the beginning of the code to handle getting correct root path to the MAS90 directory for the Sage 100 server.

Paul Smith - Bretthauer · Answer

That worked perfectly...thank you, David.

Sage 100

Append Date and Time to VI export using Perform function?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING