I am trying to update a file once a month to change the date that is written in YYYYMMDD format. The file is on an FTP server, so I am downloading it on the first of the month, trying to write to it with the first day of the previous month, then I need to upload it back to the server.

I have successfully gotten the file to download, and I can write to it, but every time I try to add the custom variable, I am getting the error "Variable or function does not exist."

Not sure if it is even possible to write to a file using a variable, or it could be that I am using the incorrect syntax. I have included the code up to the point of trying to write to the file.


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="file_date" VALUE="" /> <AMTEXT ACTIVITY="format_datetime" RESULTVARIABLE="file_date" DATETIMEFORMAT="yyyyMMdd" ADJUSTMONTH="-1" /> <AMFTP SERVER="****" USERNAME=****** PASSWORD="*****" TYPE="sftp" PORT="22" SOURCE="****" DEST="E:\temp_archive\*.*" KEEPDATETIME="YES" /> <AMFILESYSTEM ACTIVITY="write_file" FILE="E:\temp_archive\tcntcn.opt" APPEND="no">%-p44-51ge%file_date% 1-11 44-51 1713-1742%</AMFILESYSTEM>

Edited: 06/25/2018 at 10:16 AM by GregPalios

-p44-51ge%file_date%
1-11 44-51 1713-1742

Hi Greg,

Stephen is correct that the issue is with extra percent signs in the Write to file step. The way you have it written automate is evaluating %-p44-51ge% as the first variable or function, file_date as text, and %
1-11 44-51 1713-1742% as the second variable or function.

If the only variable or function in the action is file_date, then it should be written as he suggests.

-p44-51ge%file_date%
1-11 44-51 1713-1742

-------------------------

Justin Aucoin | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665