topic Re: tWaitForFile cannt find the CSV files in a folder in Talend Studio

tWaitForFile cannt find the CSV files in a folder

Anonymous — Sat, 16 Nov 2024 09:42:26 GMT

Hello

Please I have a Software send to me CSV files in a folder
With Talend Open Studio for Data Integration in Win7, how can I to do a list of orders to use the csv files one by one to use it in my project with tMap

I tried with tWaitForFile -> tFileInputDetimited

And I did the File name of tFileInputDetimited

((String)globalMap.get("tWaitForFile_1_CREATED_FILE")) -> Not work

And also I tried with tFileList

((String)globalMap.get("tFileList_1_CREATED_FILE")) -> Not work

Thanks

Re: tWaitForFile cannt find the CSV files in a folder

Anonymous — Thu, 01 Jun 2017 12:35:45 GMT

I did this for test and also no rows and Iam sure I have a csv file in my folder

Re: tWaitForFile cannt find the CSV files in a folder

Anonymous — Fri, 02 Jun 2017 05:20:33 GMT

Hi
((String)globalMap.get("tFileList_1_CREATED_FILE")) stores the current file name without file path, you should use this global variable ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")).

Regards
Shong

Re: tWaitForFile cannt find the CSV files in a folder

Anonymous — Fri, 02 Jun 2017 09:07:02 GMT

If you use tWaitForFile, check the 'Include present file' box to include existing files or create a new file, so tWaitForFile will be triggered.