topic Re: Loading multiple CSV files into MySQL database in Talend Studio

Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 16:20:33 GMT

Hello,

I'm trying to load multiple .csv files of the same format to MySQL DB.

I used tFileList for iteration of all the files. But I receive below error for the tFileList component :

Error in the component's properties:The method add(String) in the type List<String> is not applicable for the arguments ().

I'm attaching screenshots , please have a look at them and let me know what's the issue.

Thanks and regards,

Praneeth

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 18:55:48 GMT

Hi Praneeth,

Could you please go to the Code tab of the designer and see where exactly is the error? The error area will be highlighted in red.

Also could you please double check whether you need escape character for the csv options? When you take the tFileinputdelimited , by default, it will not use the escape character while using double quotes.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 19:21:06 GMT

Hello Nikhil,

Thanks for your reply. I don't have much expertise in Java coding....so I've attached the error that's been populated in the code section of my job designer. Also, I set escape char to 'empty' in tFileInputDelimited component.

Please let me know where am I missing. Looking forward to your reply.

Thanks and regards,

Praneeth

tfilelist_error.PNG

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 19:31:33 GMT

Hi Praneeth,

By default the values will be as shown below. Please try that way.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 19:50:47 GMT

Hey Nikhil,

I tried it...doesn't work. It still displays the same error:

Error in the component's properties:The method add(String) in the type List<String> is not applicable for the arguments ()

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 20:40:33 GMT

Hi,

I got the issue. You have added one additional dummy line as shown below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 20:49:45 GMT

Hey Nikhil,

You're awesome!..I Couldn't find the issue but when I removed the tfilelist component and added again in my job design it worked!...seems to be the issue that you've mentioned.

Thanks a lot man!

Re: Loading multiple CSV files into MySQL database

Anonymous — Wed, 24 Jul 2019 20:51:44 GMT

Happy to help!

If you want, you can recreate the issue by adding a new dummy line and try to run the job 😉

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂