Can't open the specified file from tFileList

[Anonymous]

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

[TRF · Accepted solution]

Use "tFileList_1_CURRENT_FILEPATH" instead of "tFileList_1_CURRENT_FILE".

[Anonymous]

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

[TRF]

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

[Anonymous]

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.

Br

ledoan

[TRF]

Can you clearly explained what you expect to do.

[Jesperrekuh]

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

[Anonymous]

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

[Anonymous]

Thanks for your answer.

ledoan

[TRF]

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.