How to move files to different ftp folders under the same root on the same server
Q: Conditional destination request. We are looking for an easy way (one channel) to move files to different ftp folders (more than 100 folders) under the same root on the same server, where filename prefix (3 char) is the key to which folder. Prefix and folder name are different.
A few examples:
- BBL > folder1
- ABB > folder2
- BYR > folder4
- BYP > folder5
- DAT > folder6
I have been looking at your blog post without finding anything like it. The list of prefixes and folders could be a text table in the script or in a csv file. Do you have a script for this?
A: Yes this is possible, please have a look at the following screenshots. This setup can be used with other Sources and Destinations too.
– We used a Windows folder as Source:
– Open our Pascal Script option
Please enable and add the following ‘On Destination’ Pascal Script:
- Please add the following script: link
- The script strips the first 3 characters from the filename by using ‘copy(psFilename, 1, 3)’
- The stripped part is compared with ‘BBL’, ‘ABB’ .. ‘DAT’
- Depending on the result of the compare, a folder name is added to our variable psVSA ( pascal script Var String A )
- This psVSA variable will be used in the Destination setup as parameter (%VSA, which contains data from psVSA)
- You’ll need to adjust the folder names and add more prefixes if needed
– In the FTP as Destination Setup, please adjust the ‘Create Subdir’ option to: %VSA\%SFS
- Here we used the %VSA parameter, set in the Pascal Script, which contains the desired subdirectory name
– Feedback customer:
That looks easy. Thank you very much.
If you need any help with this new option, please let us know.
Best Regards,
Limagito Team
#ftp #sftp #managedfiletransfer #filetransfer #filemanagement
