topic Re: How do you use a context variable in tSystem component? in Talend Studio

How do you use a context variable in tSystem component?

talendtester — Fri, 12 Jul 2013 19:26:52 GMT

I have two context variables which are assigned values:
context.oldFileName
context.newFileName
I want DOS to rename the old file name with the new file name.
I think my tSystem component Command should look something like this:
"cmd /c echo "+ context.oldFileName+ context.newFileName+" "
or this:
cmd /c REN %oldFileName% %newFileName%
When I run the Command " cmd /c echo "+ context.oldFileName+ context.newFileName+" "
The result is "nullnull"
How do I get the tSystem to know the values of context.oldFileName and context.newFileName?

Re: How do you use a context variable in tSystem component?

alevy — Sat, 13 Jul 2013 13:09:20 GMT

I think the problem is not with tSystem itself (since that command works fine for me) but with some other aspect of your job design. How do you assign the context variable values? Can you print them with tJava or tContextDump? Screenshot your job...

Re: How do you use a context variable in tSystem component?

Anonymous — Sun, 14 Jul 2013 12:08:46 GMT

It does sound like a variable assignment issue.
Don't forget that Talend provides components to do this type of stuff tFile* which is preferable to dropping out to the OS

Re: How do you use a context variable in tSystem component?

Anonymous — Mon, 15 Jul 2013 06:01:05 GMT

Hi
Try this code for me it is working fine:
"cmd /c ren " +context.oldfile+ " "+context.newfile

thanks
Anil Kumar Burri
http://anilkumarburri.wordpress.com/

Re: How do you use a context variable in tSystem component?

talendtester — Mon, 15 Jul 2013 17:07:14 GMT

Here is my current tSystem code:
"cmd /c REN %oldFileName% %newFileName%"
The job runs without errors, but the files aren't being renamed, the file names stay the same:

Starting job FileRename at 11:02 15/07/2013.

connecting to socket on port 3659
connected
tContextLoad_1 set key "oldFileName" with value "test1.txt"
tContextLoad_2 set key "newFileName" with value "test1new.txt"
tContextLoad_1 set key "oldFileName" with value "test2.txt"
tContextLoad_2 set key "newFileName" with value "test2new.txt"
tContextLoad_1 set key "oldFileName" with value "test3.txt"
tContextLoad_2 set key "newFileName" with value "test3new.txt"
disconnected
Job FileRename ended at 11:02 15/07/2013.

Re: How do you use a context variable in tSystem component?

alevy — Mon, 15 Jul 2013 17:08:30 GMT

Screenshot your job

Re: How do you use a context variable in tSystem component?

talendtester — Mon, 15 Jul 2013 18:24:57 GMT

Here

Re: How do you use a context variable in tSystem component?

alevy — Mon, 15 Jul 2013 18:31:19 GMT

Can't see anything obvious wrong but it's certainly an unusual design. Would need more info on what you're trying to do in each component but have you tried using an Array Command in tSystem?

Re: How do you use a context variable in tSystem component?

talendtester — Mon, 15 Jul 2013 18:43:15 GMT

I am trying to clean out weird characters from the files names, such as these characters "!@#$%&()-_+" and I want to remove any periods except the file extension tag.
I am doing the filename clean up in the tMap. For example to get rid of the @ sign I use:
row3.fileName.replaceAll("@","").trim()

Re: How do you use a context variable in tSystem component?

Anonymous — Fri, 19 Jul 2013 11:02:10 GMT

Hi,
I simulate a simple one like
Fileinputdelimited-->contextload-->system
with code

"cmd /c ren "+context.oldfile+" "+context.newfile

it works fine. And name of file changed.
i think that you should try to put tsys in the end of this job.
like onsubjectok of tfilelist? or use tpostjob?
because in the screen shot i saw tcontextload for filepath ran faster than the others and you connected it to tsys. so...
Try it

Re: How do you use a context variable in tSystem component?

Anonymous — Fri, 19 Jul 2013 11:48:12 GMT

Why not just use tFileCopy?
It supports rename and keeps everything 'talend' and is cross platform.

Re: How do you use a context variable in tSystem component?

_AnonymousUser — Fri, 19 Jul 2013 14:56:07 GMT

Don't forget that Talend provides components to do this type of stuff tFile* which is preferable to dropping out to the OS

Re: How do you use a context variable in tSystem component?

talendtester — Fri, 19 Jul 2013 22:29:52 GMT

Re: How do you use a context variable in tSystem component?

alevy — Sat, 20 Jul 2013 01:22:54 GMT

So are the values getting to tSystem now? Have you tried just echoing them?
Is the path correct? Try just the "cd" command to check what path tSystem thinks it's in.

Re: How do you use a context variable in tSystem component?

talendtester — Mon, 22 Jul 2013 20:58:34 GMT

Not sure why it works, but it does!
I ended up putting Iterate from the tFileInputDelimited to the tSystem.
This is the tSystem command that worked for me:
"cmd /c ren \""+context.oldFileName+"\" \""+context.newFileName+"\""