4 Replies Latest reply on Jun 16, 2014 1:39 PM by sectoral

    How to use dates in filenames

    sectoral

      Hello all,

      We've been long time owners/users of FTP Voyager v16.1 and need to start uploading files that contain a date in the filename, as well as adding the date to files after they are uploaded. I'm having a very hard time getting this to work, even after reading through the Knowledgebase. I want to accomplish the following:

      upload 2104-06-13_file1.txt --> /uploads/2104-06-13_file1.txt
      Note the date shown in the filename above will change day to day.

      upload file2.txt --> /uploads/2104-06-13_file2.txt
      Note the source file does not have a date, but the destination does. The date shown in the filename above will change day to day.


      I have my Scheduler Profile set up as follows:



       

      Note:

      • scheduler profiles don't have the ability to specify a Local folder... so I have to specify the full path in the Scheduled Job Actions.
      • Only one rename is specified since I'm not renaming file1

       

       

       

      And my Scheduled Job Actions (with full path for local files) are:

       

       

       



       


      The logs of the job show thi

      [13] Mon 16Jun14 10:41:09 - (Action: "D:\%Y-%m-%d_file1.txt" to "/uploads/%Y-%m-%d_file1.txt") - Uploading from "D:\2014-06-16_file1.txt" to "/uploads/2014-06-16_file1.txt"

      [05] Mon 16Jun14 10:41:09 - CWD /uploads/2014-06-16_file1.txt

      [06] Mon 16Jun14 10:41:09 - 550 Can't change directory to /uploads/2014-06-16_file1.txt: No such file or directory

      [04] Mon 16Jun14 10:41:09 - Unable to change to folder "/uploads/2014-06-16_file1.txt".

      [05] Mon 16Jun14 10:41:09 - CWD /uploads

      [06] Mon 16Jun14 10:41:09 - 250 OK. Current directory is /uploads

      [05] Mon 16Jun14 10:41:09 - MKD /uploads/2014-06-16_file1.txt

      [06] Mon 16Jun14 10:41:09 - 257 "/uploads/2014-06-16_file1.txt" : The directory was successfully created

      [05] Mon 16Jun14 10:41:09 - CWD /uploads/2014-06-16_file1.txt

      [06] Mon 16Jun14 10:41:10 - 250 OK. Current directory is /uploads/2014-06-16_file1.txt

      [05] Mon 16Jun14 10:41:10 - MLST /uploads/2014-06-16_file1.txt/2014-06-16_file1.txt

      [06] Mon 16Jun14 10:41:10 - 550 Can't check for file existence

      [03] Mon 16Jun14 10:41:10 - Sending: D:\2014-06-16_file1.txt -> /uploads/2014-06-16_file1.txt/2014-06-16_file1.txt

      [05] Mon 16Jun14 10:41:10 - TYPE I

      [06] Mon 16Jun14 10:41:10 - 200 TYPE is now 8-bit binary

      [05] Mon 16Jun14 10:41:10 - PASV

      [06] Mon 16Jun14 10:41:10 - 227 Entering Passive Mode (67,210,123,189,131,40)

      [03] Mon 16Jun14 10:41:10 - Opening passive mode data connection to 67.210.123.189, port 33576.

      [03] Mon 16Jun14 10:41:10 - Negotiating SSL connection with server...

      [05] Mon 16Jun14 10:41:10 - STOR 2014-06-16_file1.txt

      [06] Mon 16Jun14 10:41:10 - 150 Accepted data connection

      [03] Mon 16Jun14 10:41:10 - SSL connection established. All transactions are now secure.

      [03] Mon 16Jun14 10:41:10 - Encryption cipher: 128 bit RC4; Version: TLSv1/SSLv3.

      [06] Mon 16Jun14 10:41:11 - 226-File successfully transferred

      [06] Mon 16Jun14 10:41:11 - 226 0.758 seconds (measured here), 46.32 Kbytes per second

      [03] Mon 16Jun14 10:41:11 - Transferred 35,959 bytes. 41.66 KB/sec.

      [05] Mon 16Jun14 10:41:11 - XCRC "/uploads/2014-06-16_file1.txt/2014-06-16_file1.txt"

      [06] Mon 16Jun14 10:41:11 - 500 Unknown command

      [04] Mon 16Jun14 10:41:11 - XCRC command failed. The command may not be supported by this server.

      [03] Mon 16Jun14 10:41:11 - XCRC command checking has been disabled for future transfers using this session.

      [05] Mon 16Jun14 10:41:11 - MFMT 20140616070159 /uploads/2014-06-16_file1.txt/2014-06-16_file1.txt

      [06] Mon 16Jun14 10:41:11 - 213 UTIME OK

      [03] Mon 16Jun14 10:41:11 - Sent 35,959 bytes.

      [03] Mon 16Jun14 10:41:11 - Transfer time: 00:00:00.843.s

      [13] Mon 16Jun14 10:41:11 - (Action: "D:\%Y-%m-%d_file1.txt" to "/uploads/%Y-%m-%d_file1.txt") - Action successfully completed.

       

      and

       

      [13] Mon 16Jun14 10:41:11 - (Action: "D:\file2.txt" to "/uploads/%Y-%m-%d_file2.txt") - Uploading from "D:\file2.txt" to "/uploads/2014-06-16_file2.txt"

      [05] Mon 16Jun14 10:41:11 - CWD /uploads/2014-06-16_file2.txt

      [06] Mon 16Jun14 10:41:11 - 550 Can't change directory to /uploads/2014-06-16_file2.txt: No such file or directory

      [04] Mon 16Jun14 10:41:11 - Unable to change to folder "/uploads/2014-06-16_file2.txt".

      [05] Mon 16Jun14 10:41:11 - CWD /uploads

      [06] Mon 16Jun14 10:41:11 - 250 OK. Current directory is /uploads

      [05] Mon 16Jun14 10:41:11 - MKD /uploads/2014-06-16_file2.txt

      [06] Mon 16Jun14 10:41:12 - 257 "/uploads/2014-06-16_file2.txt" : The directory was successfully created

      [05] Mon 16Jun14 10:41:12 - CWD /uploads/2014-06-16_file2.txt

      [06] Mon 16Jun14 10:41:12 - 250 OK. Current directory is /uploads/2014-06-16_file2.txt

      [05] Mon 16Jun14 10:41:12 - MLST /uploads/2014-06-16_file2.txt/file2.txt

      [06] Mon 16Jun14 10:41:12 - 550 Can't check for file existence

      [03] Mon 16Jun14 10:41:12 - Sending: D:\file2.txt -> /uploads/2014-06-16_file2.txt/file2.txt

      [05] Mon 16Jun14 10:41:12 - PASV

      [06] Mon 16Jun14 10:41:12 - 227 Entering Passive Mode (67,210,123,189,154,238)

      [03] Mon 16Jun14 10:41:12 - Opening passive mode data connection to 67.210.123.189, port 39662.

      [03] Mon 16Jun14 10:41:12 - Negotiating SSL connection with server...

      [05] Mon 16Jun14 10:41:12 - STOR file2.txt

      [06] Mon 16Jun14 10:41:12 - 150 Accepted data connection

      [03] Mon 16Jun14 10:41:12 - SSL connection established. All transactions are now secure.

      [03] Mon 16Jun14 10:41:12 - Encryption cipher: 128 bit RC4; Version: TLSv1/SSLv3.

      [06] Mon 16Jun14 10:41:12 - 226-File successfully transferred

      [06] Mon 16Jun14 10:41:12 - 226 0.136 seconds (measured here), 59.89 Kbytes per second

      [03] Mon 16Jun14 10:41:12 - Transferred 8,367 bytes. 27.60 KB/sec.

      [05] Mon 16Jun14 10:41:12 - MFMT 20140616131743 /uploads/2014-06-16_file2.txt/file2.txt

      [06] Mon 16Jun14 10:41:12 - 213 UTIME OK

      [03] Mon 16Jun14 10:41:12 - Sent 8,367 bytes.

      [03] Mon 16Jun14 10:41:12 - Transfer time: 00:00:00.296.

      [13] Mon 16Jun14 10:41:12 - (Action: "D:\file2.txt" to "/uploads/%Y-%m-%d_file2.txt") - Action successfully completed.

       

       


      In both cases, Voyager thinks the destination filename is a folder... and of course those folders don't exist. For some reason, Voyager creates those folders and then deposits the files in them. In the case of File2, the date does not even get appended to the filename.


       

       

      Can anyone explain to me where I've gone wrong? Thanks.


      Al

        • Re: How to use dates in filenames
          dbladorn

          Try this for the "file2.txt" upload configuration:

           

          FVS-Config.png

          1 of 1 people found this helpful
            • Re: How to use dates in filenames
              sectoral

              dbladorn,

               

                 I think you're on to something there... I tried your suggestion, and the folders were not created, so that takes care of issue #1. --- Thank you

               

              File2, however, still does not get the date appended to it's filename. Any ideas on that one?

               

              [13] Mon 16Jun14 12:07:50 - (Action: "D:\file2.txt" to "/uploads") - Uploading from "D:\file2.txt" to "/uploads"

              [05] Mon 16Jun14 12:07:50 - MLST /uploads/file2.txt

              [06] Mon 16Jun14 12:07:50 - 550 Can't check for file existence

              [03] Mon 16Jun14 12:07:50 - Sending: D:\file2.txt -> /uploads/file2.txt

              [05] Mon 16Jun14 12:07:50 - PASV

              [06] Mon 16Jun14 12:07:50 - 227 Entering Passive Mode (67,210,123,189,154,79)

              [03] Mon 16Jun14 12:07:50 - Opening passive mode data connection to 67.210.123.189, port 39503.

              [03] Mon 16Jun14 12:07:50 - Negotiating SSL connection with server...

              [05] Mon 16Jun14 12:07:50 - STOR file2.txt

              [03] Mon 16Jun14 12:07:50 - SSL connection established. All transactions are now secure.

              [03] Mon 16Jun14 12:07:50 - Encryption cipher: 128 bit RC4; Version: TLSv1/SSLv3.

              [06] Mon 16Jun14 12:07:50 - 150 Accepted data connection

              [06] Mon 16Jun14 12:07:50 - 226-File successfully transferred

              [06] Mon 16Jun14 12:07:50 - 226 0.135 seconds (measured here), 60.57 Kbytes per second

              [03] Mon 16Jun14 12:07:50 - Transferred 8,367 bytes. 27.60 KB/sec.

              [05] Mon 16Jun14 12:07:50 - MFMT 20140616131743 /uploads/file2.txt

              [06] Mon 16Jun14 12:07:50 - 213 UTIME OK

              [03] Mon 16Jun14 12:07:50 - Sent 8,367 bytes.

              [03] Mon 16Jun14 12:07:50 - Transfer time: 00:00:00.296.

              [13] Mon 16Jun14 12:07:50 - (Action: "D:\file2.txt" to "/uploads") - Action successfully completed.

               

              Al