Page 1 of 1

Date and Time adding to File name on FTP data

Posted: Tue Mar 02, 2010 7:20 am
by mrapkins
Hi all.
I have set up a File push (FTP) of records to a server and am trying to add the Date and Time to the beginning of the file name.
So added the %F_%R_ to the file name, but this is not being added.

The manual put the file name in "%F_%R_filename" with the quotes around it. When I try to do this on the Schedule FTP Upload page and hit Save, the file name disappears. The only way it stays there is if I leave the quotes off.

Has anyone got this working and what am I doing wrong.

Thanks.

Re:Date and Time adding to File name on FTP data

Posted: Tue Mar 02, 2010 11:39 am
by skyewright
mrapkins wrote:Has anyone got this working.
Yes. I leave the quotes off.

Also, I use %F_%H-%M instead of %F_%R.

The difference is that %F_%R includes a colon ( : ) in the filename.

e.g.

%F_%R => 2009-03-02_09:38

%F_%H-%M => 2009-03-02_09-38

A colon is not a valid filename character for Windows systems, so I found that though %F_%R worked fine for the upload to my server, I couldn't download the resulting file to my local system if I wanted to.

Re:Date and Time adding to File name on FTP data

Posted: Tue Mar 02, 2010 12:24 pm
by mrapkins
Thanks skyewright. That worked.