topic Re: Upper case file extension (.XLSX and .xlsx) in Talend Studio

Upper case file extension (.XLSX and .xlsx)

august1 — Fri, 15 Mar 2024 13:43:00 GMT

Hello everyone,

I am trying to connect to a FTP and download (tFTPGet) excel files after having them listed (tFTPFileList and iterate on them)

Those files can have the extension .XLSX or .xlsx (i.e. the extension in UPPERCASE or lowercase)

In the files section, "File Mask", if I only allow "*.xlsx", I won't get the .XLSX files and vice versa

If I set both "*.xlsx" and "*.XLSX", I have the afterwards treatment run twice.

I may also get the error in the tFileInputExcel afterwards : " The source File "/path/file.XLSX" does not exist or is not a file. " even if the file has been successfully downloaded.

Do you know how to properly open the two variations of the Excel files ?

I currently download everything (File Mask "*.*") and the add the .xlsx extension (I will then have a file.xlsx.xlsx) which is not a good solution.

Re: Upper case file extension (.XLSX and .xlsx)

Shicong_Hong — Mon, 18 Mar 2024 02:57:44 GMT

The filemask of tFTPFileList is case sensitive, you have to set both of the file extensions. After you download the files to local machine, use a tFileList to literate each Excel file in the specified directory, select 'no' option in the Case Sensitive list on tFileList, so you just need to set one filemask "*.xlsx" to iterate all Excel file. On tFileInputExcel, set the file name using global variable, eg:

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Regards

Shicong

Re: Upper case file extension (.XLSX and .xlsx)

august1 — Tue, 19 Mar 2024 10:22:59 GMT

Thanks for your answer !

This is a good workaround, however shouldn't we also have the "Case Sensitive" option in the tFTPFileList component ?

Regards,

Re: Upper case file extension (.XLSX and .xlsx)

Shicong_Hong — Tue, 19 Mar 2024 13:00:33 GMT

Totally agree with you. Please go to Ideation page and suggest a feature request. Thank you!

Regards

Shicong