[resolved] Insert multiple files into mysql

Anonymous — Tue, 19 Apr 2016 06:55:51 GMT

Hi,
I try to upload in a mysql table, a lot of files.

So I try like this:
tFileList_2 ------> tIterateToFlow_2 -- What to put here ----> tFileInputDelimited_1 ------> tMap_1 ------> tMysqlOutput_1

1) tFileList_2 I use a context where I define the path (listedesfichiers for the name) and a filter on the extention file (*.I18)
2) tIterateFlow_2 I use the mapping name Fichiers and this value : ((String)globalMap.get("tFileList_2_CURRENT_FILEPATH"))
3) tFileInputDelimited_1 Is metadata on one file, all the file have the same layout : int, int, date, int, int.
4) tMap_1 I do the matchin gbetween the column of the files and the field on the Mysql databse
5) tMysqlOutput_1 where i give the parameters for the connection.

I can upload only one file, but I would like to upload all the file present in tFileLIst_2 in my database, but I don't know to send all the value to the component and witch component to use!

Regards
Burnside.

Re: [resolved] Insert multiple files into mysql

Anonymous — Tue, 19 Apr 2016 07:40:38 GMT

It should be something like
tFileList-->tFileInputDelimited-->tMap-->tMySqlOutput
You do not need tIterateToFlow
You can iterate to tFileInputDelimited and then refer to the file path directly

Re: [resolved] Insert multiple files into mysql

Anonymous — Tue, 19 Apr 2016 13:34:10 GMT

Hi,
Thank's for your idea, I have resolved the problem.
Thank's a lot.
Burnside.

topic Re: [resolved] Insert multiple files into mysql in Talend Studio

[resolved] Insert multiple files into mysql

Re: [resolved] Insert multiple files into mysql

Re: [resolved] Insert multiple files into mysql