Question

Reading csv files from FTP


Badge

hello,

i'm interested to know the usual process in reading/getting files from FTP caller.

I did make FTP caller run, however, I don't know the next transformers to use to read the csv (not in a zip file) from the FTP server.

I tried attribute splitter and list exploder, but didn't work.

 

Can you share a sample workbench for the same case, please?

Thanks!


4 replies

Userlevel 4

My preferred way of doing it would be

  • TempPathnameCreator to create a temporary directory
  • FTPCaller do download the file into the temporary directory
  • FeatureReader to read the CSV file from the temporary directory

The temporary directory with its contents will be automatically deleted once the workspace terminates.

Badge

My preferred way of doing it would be

  • TempPathnameCreator to create a temporary directory
  • FTPCaller do download the file into the temporary directory
  • FeatureReader to read the CSV file from the temporary directory

The temporary directory with its contents will be automatically deleted once the workspace terminates.

Hi @david_r​ , thank you so much for your feedback. However, I am super newbie here and I'm not sure how to work with those transformers. Do you have any sample workbench? thank you again!

Userlevel 4

Hi @david_r​ , thank you so much for your feedback. However, I am super newbie here and I'm not sure how to work with those transformers. Do you have any sample workbench? thank you again!

Try something like the pattern in the attached workspace template.

 

Badge

Hi @david_r​ , thank you so much for your feedback. However, I am super newbie here and I'm not sure how to work with those transformers. Do you have any sample workbench? thank you again!

thank you @david_r​ ! it works for me!

Reply