tFTPPut Remote Directory Path

One Star

tFTPPut Remote Directory Path

Hi guys,

I am trying to upload a file to a remote directory via SFTP and the name of the directory starts with an asterisk (*). I believe the * sign is currently causing me a problem, because whenever I run my job, I get the error:

Exception in component tFTPPut_1
4: <here my path will be shown>

Now, I run the same job using a "normal" folder name, without an asterisk.

I don't get any error messages this time and everything works perfectly.

So my questions is this: is there any way for me to circumvent this? Use an escape character of some sort, perhaps. Any ideas?

Thanks!

Cihan
One Star

Re: tFTPPut Remote Directory Path

NOTE: I cannot rename the folder. Unfortunately, that is not possible...
Four Stars

Re: tFTPPut Remote Directory Path

Hi,

Probably if you can work from command line ftp client using tSystem component, it would work.

Thanks
Vaibhav
One Star

Re: tFTPPut Remote Directory Path

I have never worked with that component before. Is there a link or an example that you could share?
This may be helpful for other people as well.
Thank you!
Moderator

Re: tFTPPut Remote Directory Path

Hi,

Here is online component reference TalendHelpCenter:tSystem with scenario. Could you please have a look at it?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tFTPPut Remote Directory Path

Check example of FTP session in below link.
http://www.cs.colostate.edu/helpdocs/ftp.html

You will have to use those ftp commands inside tSystem component.

thanks
Vaibhav
One Star

Re: tFTPPut Remote Directory Path

Thanks for the replies.

So I don't use any Tftp components anymore, is that correct? I just place a tsystem component and enter the commands, and do everything from there.
Seventeen Stars

Re: tFTPPut Remote Directory Path

hi all,
I'm not agree using tSystem in place off tFtpGet espacially as solution is nearly quite OK (except *).
running tSystem is out of the Talend box as you have any control&logs about what's happen ...
check 
https://help.talend.com/pages/viewpage.action?pageId=45221082#Raa64374
for default glob pattern :
http://docs.oracle.com/javase/tutorial/essential/io/fileOps.html#glob

it should normally work Smiley Wink
regards
laurent
One Star

Re: tFTPPut Remote Directory Path

I have just googled for a bit and found this: http://stackoverflow.com/questions/14205498/do-you-need-to-escape-character-in-java
So I have used "/DOLEXAIOUT/\\*BINDOLEIFTMIN" instead of "/DOLEXAIOUT/*BINDOLEIFTMIN"... and I think it worked.
At least I have a new error message now when I want to download a file (no more errors while uploading):
Exception in component tFTPFileList_1
3: Invalid user


The username I entered in the tFTPConnection component is correct, though. Any idea what this new error might be?
Seventeen Stars

Re: tFTPPut Remote Directory Path

can you show us parameters of your tFtp List component ?
your ftp connexion seems to be ok !

regards
laurent
One Star

Re: tFTPPut Remote Directory Path

Here is how my tFtpFileList looks like:




Pretty straightforward...

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog