topic Re: Can't open the specified file from tFileList in Talend Studio

Can't open the specified file from tFileList

Anonymous — Sat, 16 Nov 2024 07:40:54 GMT

Hello,

I want to read the content of file in the list of file in tFileList and i try to read it with tFileInputExcel.

But i get the following message:

Exception in component tFileInputExcel_1 (User_management)
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file input stream from file.

and i have admin role to read this excel file which is located under this folder

any ideas for this?

Thanks

ledoan

Re: Can't open the specified file from tFileList

TRF — Tue, 11 Sep 2018 10:30:32 GMT

Use "tFileList_1_CURRENT_FILEPATH" instead of "tFileList_1_CURRENT_FILE".

Re: Can't open the specified file from tFileList

Anonymous — Wed, 12 Sep 2018 13:11:16 GMT

Hello,

thanks for your answer. i want to read the content of the specified field and when i used tFileList_1_CURRENT_FILEPATH, i see that it read only the first row in first file.

Have you any ideas.

Thanks

ledoan

Re: Can't open the specified file from tFileList

TRF — Wed, 12 Sep 2018 13:20:46 GMT

Not exactly the same question!

Anyway, to be sure create a job with the following design: tFileList-->tFileInputExcel-->tLogRow

This should print all the records from the Excel file.

Else, share the complete tFileInputExcel setting (both Basics and Advanced).

Re: Can't open the specified file from tFileList

Anonymous — Wed, 12 Sep 2018 13:45:57 GMT

Here is the code in my tjavaRow
int seq=Numeric.sequence("s1",1,1);

if (seq ==13) {
context.b13 = input_row.Name;
context.c13 = input_row.Email;
context.d13 = input_row.Se_ID;
context.e13 = input_row.Windown_Login;
context.f13 = input_row.Country;
}

this code allows me to read the content of row 13 in the file.

But it read in the first row of file 1 and not read other file.

ledoan

Re: Can't open the specified file from tFileList

TRF — Wed, 12 Sep 2018 13:59:37 GMT

Can you clearly explained what you expect to do.

Re: Can't open the specified file from tFileList

Jesperrekuh — Wed, 12 Sep 2018 14:25:42 GMT

int seq=Numeric.sequence("s1",1,1);

its a global var... so the next file continues with "s1" value (which after the first file will be say 801 if it has this amount of records) I suggest use it like this:

// a cntr for each file
int seq=Numeric.sequence( ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) ,1,1);

Re: Can't open the specified file from tFileList

Anonymous — Wed, 12 Sep 2018 15:57:17 GMT

i want read all the content of file with the specified field.

Example:

i read the content from the row = 14 of each file.

ledoan

Re: Can't open the specified file from tFileList

Anonymous — Wed, 12 Sep 2018 16:01:24 GMT

Thanks for your answer.

ledoan

Re: Can't open the specified file from tFileList

TRF — Wed, 12 Sep 2018 16:08:30 GMT

Is your output file an Excel file?

If so, set the "First cell X" field to 0.

Remark: as your 1rst question has been answered, thank's to mark the topic as solved and open a new one to continue the discussion.

Re: Can't open the specified file from tFileList

Jesperrekuh — Wed, 12 Sep 2018 16:08:52 GMT

First of all, show us what you do... help us out a little more by making a couple of screenshot and mark your 'issues' .

And I suggest using a tMap to map columns from input to your output.

Within tMap you do what you want and need to do to transform your data.