topic Re: How to read and write CSV files from FTP server in Talend Studio

How to read and write CSV files from FTP server

Anonymous — Sat, 16 Nov 2024 10:53:19 GMT

Hi Team,
I am new to Talend open studio for ESB.
I need a help to create job desgin that i want to read csv file from FTP server and I want to write csv file into same FTP server.
Please help me that how to use FTP meta data/Could you please provide us the sample job designs.
I really appreciate for you help.
Thanks,
Jagan.

Re: How to read and write CSV files from FTP server

Anonymous — Wed, 30 Dec 2015 07:23:37 GMT

Hi Jagan,
So far, Talend don't support for transferring data by air which means you have to fetch data from FTP server firstly, save it locally and do further processing and then put it on FTP server.
There is no FTP metadata feature for now.
The workflow should be:tFTPConnection-->tFtpGet-->tFtpPut
Best regards
Sabrina

Re: How to read and write CSV files from FTP server

Anonymous — Tue, 05 Jan 2016 10:32:09 GMT

Hi Team,
Thanks for the reply.
I am facing below 2 issues.
1. Can we delete csv file in local by using tFTPDelete component?
2. unable to send csv file from local to FTP server,
I have placed csv file to C:/Users/Jagan/Desktop/nw/Talend/WDEmployees.csv directory and executed but getting error.
Error Message is:
Starting job PutFTP at 15:58 05/01/2016.
connecting to socket on port 3548
connected
No match file exist!
disconnected
Job PutFTP ended at 15:58 05/01/2016.

Re: How to read and write CSV files from FTP server

Anonymous — Tue, 05 Jan 2016 10:41:09 GMT

Hi,

1. Can we delete csv file in local by using tFTPDelete component?

As a matter of fact, you should use tFileDelete component instead of tFTPDelete component if you want to delete files on local.

2. unable to send csv file from local to FTP server,?

The exception "No match file exist!" means that no file in the local file system matches with the file filter.
Could you please show us the component setting screenshot of tFTPPut?
Best regards
Sabrina

Re: How to read and write CSV files from FTP server

Anonymous — Tue, 05 Jan 2016 11:35:58 GMT

Hi Team,
Reg 2. unable to send csv file from local to FTP server,?
FYI: I am able to get file from FTP server but unable to put file to same FTP server.
Please find the below screen shot.

Re: How to read and write CSV files from FTP server

Anonymous — Wed, 06 Jan 2016 02:27:32 GMT

Hi,
Local directory is the path to the local directory containing the files.
Please take a look at component reference TalendHelpCenter:tFTPPut with scenario.
Best regards
Sabrina

Re: How to read and write CSV files from FTP server

Anonymous — Thu, 18 Aug 2016 21:18:28 GMT

Hi,
I am very new to talend, I have got a work to export the data from a FTO connection and import data in salesforce using csv file. On FTP I have total 3 backup file with extension .bak(No CSV),
I am using same steps mentioned in a examole :
My job ran sucessfully but I did not get any csv file in folder, please help me.
Thanks,
Rahul

Re: How to read and write CSV files from FTP server

Anonymous — Fri, 19 Aug 2016 11:11:06 GMT

Hi,
Are you using tFTPget component to retrieve your csv file from FTP server?
Have you tried to check out "Die on error" option on tftpget component to see if there is any error message printed on console?
Best regards
Sabrina

Re: How to read and write CSV files from FTP server

Anonymous — Sun, 21 Aug 2016 20:14:03 GMT

Thank you , now I can get the files form FTP

Re: How to read and write CSV files from FTP server

Anonymous — Sun, 21 Aug 2016 20:17:43 GMT

Hi,
I also need your help on : I have to port data in salesforce from File Maker pro database, client provided me the jar file of ODBC File Maker pro, now I want to establish a connection in Talend Studio with FileMaker Pro database so I can fetch the data from FileMaker Pro and port in salesforce, but I do not see the db type as FileMaker pro in available list of db type, could you please let me know how to establish connection for FileMaker Pro Databse, your help would be much appreciated.

Thanks in advance,
Rahul

Re: How to read and write CSV files from FTP server

Anonymous — Mon, 22 Aug 2016 09:39:26 GMT

Hi,

<br>So far, there is no specific component for Filemaker Database.

Could you please take a look at document about:

https://help.talend.com/search/all?query=Supported+systems%2C+databases+and+business+applications+by+Talend+components&content-lang=en

Re: How to read and write CSV files from FTP server

Anonymous — Mon, 22 Aug 2016 10:58:33 GMT

Hi,
I did not tried with that could you please guide me how to do that.
Thanks much.

Re: How to read and write CSV files from FTP server

Talend_user123456787654 — Mon, 07 Jun 2021 11:59:59 GMT

Hi,

Do we have any update on this. Is there any way for transferring data without saving it locally

Thanks

Re: How to read and write CSV files from FTP server

Anonymous — Tue, 08 Jun 2021 04:01:50 GMT

Hello,

You have to fetch files from FTP server into local disk and then put them onto other servers.

Best regards

Sabrina

Re: How to read and write CSV files from FTP server

Anonymous — Tue, 08 Jun 2021 06:28:38 GMT

@Talend User, it is API limitation, no API available for transferring data on FTP server directly.

Re: How to read and write CSV files from FTP server

gjeremy1617088143 — Tue, 08 Jun 2021 09:27:20 GMT

HI, for the tftp put , it seems you specify a file instead of a directory in the local directory path:

: just use "C:/Users/Jagan/Desktop/nw/Talend"

if WDEmployees.csv is a directory :

check the arborescence of the ftp :

maybe you use move to the current directory in tftpget

so you have to be sure you use the good path for the remote directory

Send me Love and Kudos