Loading multiple CSV files into MySQL database

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

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 ()

[Anonymous · Accepted solution]

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 🙂

[Anonymous]

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!

[Anonymous]

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 🙂