FTP to FTP transfer

Answered

Sinclair Dental IT Admin

• May 10, 2022 17:01

Hi everyone, it appears that in an FTP to FTP transfer the destination filename must include a timestamp or guid. I want to transfer the file keeping the original name which I know to be unique. How can I accomplish this?

I want to use just {{{data.fileMeta.fileName}}} but the UI has an error and states 

Please append date and time stamp, such as {{timestamp "YYYY-MM-DD hh:mm:ss" "America/Los_Angeles"}}

The system I'm uploading to needs to have just the original name.

0

• 

  Pridhvi Product Manager

  • May 10, 2022 17:45
  • Edited

  

  

  Hi Sinclair Dental IT Admin

  This is required if you have the Advanced "Skip Aggregation" option in the import step set to true (checked). When Skipping aggregation, this means that multiple files will be uploaded to the FTP endpoint. The Timestamp option is then required because the timestamp (so long as it includes seconds or milliseconds) in the filename will be different for each file that gets created by the import. Otherwise, the files that are being created on the FTP server will be overwritten one after another until the last file is written, causing a loss of data.

  To remove this requirement, uncheck the "Skip Aggregation" option in the FTP import step.

  A workaround is suggested in this community post, I hope this is helpful for you. If you have any questions feel free to reach out to us, thank you.

  

  

  Regards,

  Pridhvi

  0
• 

  Sinclair Dental IT Admin

  • May 10, 2022 17:47

  

  I'm sorry but I don't see a Skip Aggregation option in either the source or destination configuration, I have included sources and destination screenshots below.

  
  I'm trying to configure a simple FTP to FTP transfer of multiple files 

  eg

  Source                Destination
  i88011.pdf           i88011.pdf
  i88012.pdf           i88012.pdf
  i88013.pdf           i88013.pdf
  
  Source Advanced Settings

  

   

  Destination advanced settings:

  

  0
• 

  viliandy leonardo Product Management Director

  • May 10, 2022 18:30

  

  

  Sinclair Dental IT Admin

  The skip aggregation field is available when you choose the option of generating files from record. 

  

  When you simply move files (download a file and then export a file), you do not have to provide timestamp or gui for the destination filename. This is what I put in the destination file field name:

  

  On the export step, I have added a presavepage script to get the filename (see this post for the script example)

  Thank you

  0
• 

  Ricko Borja Technical Support Representative

  • May 11, 2022 23:42

  

  

  Hi Dale,

  To clarify, please ensure the following settings on the FTP Import Step:

  1. Choose "CSV (or any delimited text file)" on the File type option (see 1st screenshot)
  2. Uncheck the "Skip aggregation" checkbox from Advanced and the timestamp for the File name will no longer be required (see 2nd screenshot)

  Thank you!

   

  

   

  

   

  0

Please sign in to leave a comment.