Transfer files based on filenames in CSV file

Discuss issues related to monitoring tasks

Transfer files based on filenames in CSV file

Postby Tech Support » Thu May 28, 2020 5:16 pm

User support request:
Is it possible to create a task that reads a .csv file for filenames? Then connect to an sFTP site and transfer the filenames listed in the .csv?
Tech Support
Site Admin
 
Posts: 1276
Joined: Thu May 25, 2006 11:12 am

Re: Transfer files based on filenames in CSV file

Postby Tech Support » Thu May 28, 2020 5:17 pm

You can try the CSV loop task.
This task can loop through rows or cells. For every filename the task finds, you can run a SFTP task. In the SFTP task filename field use the CSV variable.

Example:

CSV task title = csv
Task to Run = sftp_csv
Looping option = Loop by row
....

SFTP task title = sftp_csv
local directory = folder containing csv files
filename = $%csv::CurrentRowString%$ (or $%csv::CurrentCellValue%$)
Tech Support
Site Admin
 
Posts: 1276
Joined: Thu May 25, 2006 11:12 am

Re: Transfer files based on filenames in CSV file

Postby Tech Support » Thu May 28, 2020 5:19 pm

user reply:
Thank you! It works.
Appreciate it!
Tech Support
Site Admin
 
Posts: 1276
Joined: Thu May 25, 2006 11:12 am


Return to Monitoring Tasks

Who is online

Users browsing this forum: No registered users and 2 guests

cron