Skip to main content
  • EN

Hello, new FME user here. I am modifying an existing script to download a CSV from an FTP site. I want this to trigger at the beginning of the process as shown in the diagram below. I want the newly downloaded CSV to feed into the CSV reader. How can I trigger the FTPCaller at the beginning of the script and how can I feed the new CSV file into the CSV reader? Any assistance would be appreciated. Thank you!

 

image

Hi @jkin​,

You can use the following process to download the CSV file to a temp folder, then read it with the FeatureReader transformer:

Screen Shot 2023-03-02 at 11.58.48 AMScreen Shot 2023-03-02 at 11.59.03 AMScreen Shot 2023-03-02 at 11.59.22 AMThe folder created by the TempPathnameCreator is deleted when the workspace finishes, cleaning up the downloaded CSV file automatically.

 

Hi @jkin​,

You can use the following process to download the CSV file to a temp folder, then read it with the FeatureReader transformer:

Screen Shot 2023-03-02 at 11.58.48 AMScreen Shot 2023-03-02 at 11.59.03 AMScreen Shot 2023-03-02 at 11.59.22 AMThe folder created by the TempPathnameCreator is deleted when the workspace finishes, cleaning up the downloaded CSV file automatically.

 

Is there a way to do it without having to create a temp folder? I'd really like the file to a permanent location.

Is there a way to do it without having to create a temp folder? I'd really like the file to a permanent location.

To use a permanent location, please remove the TempPathNameCreator, then use the permanent location instead for the Target File in the FTPCaller and the Dataset in the FeatureReader.

Reply


Community Stats

30,160
Posts
114,491
Replies
37,810
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.