Skip to main content
Question

Reading csv files from FTP


Forum|alt.badge.img

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

david_r
Celebrity
  • July 13, 2022

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.


Forum|alt.badge.img
  • Author
  • July 14, 2022
david_r wrote:

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!


david_r
Celebrity
  • July 14, 2022
lyon wrote:

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.

 


Forum|alt.badge.img
  • Author
  • July 21, 2022
lyon wrote:

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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings