topic Re: FileName have contains special characters, in Talend Studio

FileName have contains special characters,

_AnonymousUser — Tue, 15 Apr 2014 08:12:45 GMT

File name contains special characters,such as % () [] ... and Cannot modify.For example: new.txt
I use fFTPGet_1 , input new.txt to FileMask ,but can not Download.
How to solve the problem

Re: FileName have contains special characters,

Anonymous — Tue, 15 Apr 2014 08:28:31 GMT

Hi,
Is it working with you that renaming the file by TalendHelpCenter:tFTPRename then get them from FTP to local?
Or fetch them by TalendHelpCenter:tFTPFileList with fuzzy mask(new*.txt...).
Best regards
Sabrina

Re: FileName have contains special characters,

_AnonymousUser — Tue, 15 Apr 2014 08:46:32 GMT

Hi,
Is it working with you that renaming the file by TalendHelpCenter:tFTPRename then get them from FTP to local?
Or fetch them by TalendHelpCenter:tFTPFileList with fuzzy mask(new*.txt...).
Best regards
Sabrina

I Get The file Form Ftp Server.
so,i can not rename the remote filename.
for example:
ftp://10.0.0.0:21/test/nnew.txt
ftp://10.0.0.0:21/test/nne(w.txt
ftp://10.0.0.0:21/test/n%w.txt
ftp://10.0.0.0:21/test/ndf w.txt
I tried to use tFTPGet to download these files,but failed !
How can I resolve this issue?

Re: FileName have contains special characters,

Anonymous — Tue, 15 Apr 2014 08:56:05 GMT

Hi,

I Get The file Form Ftp Server.
so,i can not rename the remote filename.

Could you please share your current job design screenshots with us? Have you already checked the scenario in tFTPFileList? What's the error info on console?
Best regards
Sabrina

Re: FileName have contains special characters,

_AnonymousUser — Tue, 15 Apr 2014 09:09:01 GMT

Hi,

I Get The file Form Ftp Server.
so,i can not rename the remote filename.

Could you please share your current job design screenshots with us? Have you already checked the scenario in tFTPFileList? What's the error info on console?
Best regards
Sabrina

current job design: tFTPConnection_1 --> tFTPGet_1 --> tFTPPut_1
tFTPGet_1 FileMask:"tes+t.doc"
tFTPPut_1 FileMask:"tes+t.doc"
tFTPFileList_1 can list the files,but I need to download the file specified,
the file specified have special characters.

Re: FileName have contains special characters,

_AnonymousUser — Tue, 15 Apr 2014 09:11:11 GMT

the error info on console:
connecting to socket on port 4021
connected
No match file exist!
0 FILES HAVE BEEN UPLOADED.
0 FILES HAVE BEEN DOWNLOADED.
disconnected

Re: FileName have contains special characters,

Anonymous — Tue, 15 Apr 2014 09:42:45 GMT

Hi,
TalendHelpCenter:tFTPGet retrieves selected files from a defined remote FTP directory and cop them to a local directory.
TalendHelpCenter:tFTPPut copies selected files from a defined local directory to a destination remote FTP directory.
Why did you get files from FTP to local then Put them back to FTP again? Did you make change on it or have specific needs.
Using tFTPFileList list the files then down these the file specified
tFTPConnection-->tFTPFileList-->tFtpGet and setting fuzzy mask(n*.txt...) in tFTPFileList.
Best regards
Sabrina

Re: FileName have contains special characters,

_AnonymousUser — Tue, 15 Apr 2014 10:25:38 GMT

I get the file from A server, upload to B server.
when i use tFTPFileList_1,the filename have 't.doc
^
at java.util.regex.Pattern.error(Unknown Source)
at java.util.regex.Pattern.clazz(Unknown Source)
at java.util.regex.Pattern.sequence(Unknown Source)
at java.util.regex.Pattern.expr(Unknown Source)
at java.util.regex.Pattern.compile(Unknown Source)
at java.util.regex.Pattern.<init>(Unknown Source)
at java.util.regex.Pattern.compile(Unknown Source)
at java.util.regex.Pattern.matches(Unknown Source)
at java.lang.String.matches(Unknown Source)
at etl.downloadstest_0_1.DownloadsTest$1FTPGetter_tFTPGet_1.getFiles(DownloadsTest.java:711)
at etl.downloadstest_0_1.DownloadsTest.tFTPFileList_1Process(DownloadsTest.java:836)
at etl.downloadstest_0_1.DownloadsTest.tFTPConnection_1Process(DownloadsTest.java:462)
at etl.downloadstest_0_1.DownloadsTest.runJobInTOS(DownloadsTest.java:1537)
at etl.downloadstest_0_1.DownloadsTest.main(DownloadsTest.java:1396)

current job design: tFTPConnection_1 --> tFTPFileList_1 --> tFTPGet_1 --> tFTPPut_1
The filename use (String)globalMap.get("tFTPFileList_1_CURRENT_FILE"))

Re: FileName have contains special characters,

Anonymous — Tue, 15 Apr 2014 11:08:54 GMT

Hi Neal,
We can download such files using commandline ftp. It seems that there is a problem with the ftp component in talend. Check the screenshot, this works.
You can use a tSystem component for getting files from ftp server. Use appropriate variables for getting the file list, storing and iterating on those.
Thanks
Vaibhav