topic tFTPPut error when file name have special characters in Talend Studio

tFTPPut error when file name have special characters

AlessandroCic — Wed, 18 Nov 2020 09:49:55 GMT

I found the error

No match file exist

where in the file name I have special characters

An example below

when i run the job I get this error

but the file exist in the folder

I also tried other special characters in different combinations such as ( ) [ ] and have the same error.

Whitout this characters the job it works.

Is there a workaround?

Thanks, regards.

Alessandro

Re: tFTPPut error when file name have special characters

vikramk — Wed, 18 Nov 2020 10:11:41 GMT

Hi @none none ,

In Filemask you are giving filename along with path, instead try with only filename with extension and in remote directory you could give complete file path of your ftp location and local directory you have to give path of your local disk where you would want to store.

Please go through below use case for tFtpput component.

https://help.talend.com/reader/1qpw94GLcI7eEqEyklTChA/2YQpwCBBypFX0o4~EqrFWg

Would you mind marking as solution if it helps.

Re: tFTPPut error when file name have special characters

AlessandroCic — Wed, 18 Nov 2020 10:23:40 GMT

There is no difference

Instead if i change the name of file without special characters it works

Re: tFTPPut error when file name have special characters

vikramk — Wed, 18 Nov 2020 11:04:28 GMT

Hi @none none ,

Would you mind trying it using tSystem component. It allows filenames with special characters as well. First test the code from command prompt as below. Once if it works you can implement the same using tSystem component in talend. Please go through below URL for cli code if you need.

#Code

ftp <ftpservername>

#listing files- ls

#then Put the file to ftp - put <filename.ext>

https://kb.globalscape.com/Knowledgebase/10407/Can-I-use-a-Windows-Command-Prompt-to-send-FTP-Commands-to-a-server

Please let me know if it helps.

Re: tFTPPut error when file name have special characters

AlessandroCic — Wed, 18 Nov 2020 14:42:16 GMT

Hi @Vikram Kumar

by command line it works

I tried to use the same command in tSystem component

but it is not easy to set up the connection parameters. Il the screen I have set

[server ip]

[port] (I have tried both with and without this parameter

)

[user]

but the connection is not activated

Re: tFTPPut error when file name have special characters

Anonymous — Thu, 19 Nov 2020 04:28:27 GMT

Hello,

tFTPPut/tFtpGet component support Regex Expression, it will try to compile the file mask, So the special characters in the file name will cause an exception during Regex compile.

If use this file mask then you will have to add an operation before the tFTPPut to escape special character and comply with the tFTPPut.

Could you please try to add special escape characters or untick Perl regex option and use a file mask with wild card character (*) that matches the filename pattern in tFTPPut.

Best regards

Sabrina

Re: tFTPPut error when file name have special characters

AlessandroCic — Thu, 19 Nov 2020 11:02:14 GMT

Hello

I assumed that the problem depended on the management of the Regex Expressions but the component is insensitive to the flag cheked/uncheked (in my examples it is always unchecked).

For example if the flag is unchecked and my filename is "A (+) B.txt" I get this error

The solution suggested from Sabrina, if I understood the method, it not works because the escape characters works only to a small set of characters.

I replaced my strig with:

"A\+B.txt"

and I have the error I also tried to compose the file name with unicode characters

And then in the tFTPPUT componentI also added the message display

However the job does not work and no error message it is generated

I think it is a bug of the tFTPPut component to be fixed.

Re: tFTPPut error when file name have special characters

Anonymous — Fri, 20 Nov 2020 08:20:42 GMT

Hello,

Could you please create a jira issue on talend bug tracker?

Best regards

Sabrina