Support Questions
Find answers, ask questions, and share your expertise

how to read csv file data and make them as group variables and pass one by one record to ListSFTP processor ?

Highlighted

how to read csv file data and make them as group variables and pass one by one record to ListSFTP processor ?

Explorer

Hi Folks,

How to read csv file data and make them as group variables and pass one by one record to ListSFTP processor ?

Lets assume my csv file has data Hostname, port , username, password, remotepath information like below.

Hostname|port|username|password|remotepath|

172.16.2.99|22|abcd1|abcd1|partner1/outbox|

172.16.2.98|22|abcd2|abcd2|partner2/outbox|

172.16.2.97|22|abcd3|abcd3|partner3/outbox|

172.16.2.96|22|abcd4|abcd4|partner4/outbox|

172.16.2.95|22|abcd5|abcd5|partner5/outbox|

172.16.2.94|22|abcd6|abcd6|partner6/outbox|

172.16.2.93|22|abcd7|abcd7|partner7/outbox|

172.16.2.92|22|abcd8|abcd8|partner8/outbox|

172.16.2.91|22|abcd9|abcd9|partner9/outbox|

172.16.2.90|22|abcd10|abcd10|partner10/outbox|

-----------------------------------------------------------------------------------

i want to read the csv file and make all the columns into group attributes and pass row by row to listSFTP processor.

In listSFTP processor, i will define HOSTNAME as ${hostname}, PORT as ${port}, USERNAME as ${username}, and REMOTEPATH as ${remotepath}....

How to pass group attribute values from csv file to listSFTP processor..

in listSFTP processor we declare attribute variables instead of static values. whenever listSFTP processor gets the data, it will list the files from that connection and stops based on schedule..after listSFTP stop, again we need to pass the next record from csv file list.

Please help me how to do it.

which processor helps me to read the csv and send one by one record to listSFTP processor based on listSFTP processor acknowledgment / time schedule.

Thanks in advance.

Thanks,

Rangareddy Y