topic Re: send Environment variable from context in Talend Studio

send Environment variable from context

Anonymous — Tue, 22 Jul 2014 10:57:37 GMT

Hi,
I am reading csv files from different locations for my etl job,those files are having some common filepath. So common path is stored in an environment variable.Here i consider 'SOURCE_FOLDER' as a environment variable.
i am sending a context parameter to my job as
Folder_location=System.getenv("SOURCE_FOLDER")/filepath/
But i am unable to get the full file path while reading this variable.I am getting System.getenv("SOURCE_FOLDER")/filepath/ while reading context variable . How can i get environment variable value from context variable. Thanks in advance.

Re: send Environment variable from context

Anonymous — Tue, 22 Jul 2014 12:25:44 GMT

Hi Mani,
context.Folder_location=System.getenv("SOURCE_FOLDER")/filepath/
Whether this is not returning you the value to context variable? What is the value of SOURCE_FOLDER in environment variable?
Thanks
Vaibhav

Re: send Environment variable from context

Anonymous — Tue, 22 Jul 2014 12:46:07 GMT

SOURCE_FOLDER is a environment variable which having my file path like '/home/mani/Documents'.

While i am reading from my job i want to get the value in the environment variable like '/home/mani/Documents/filepath'. But i am getting only System.getenv("SOURCE_FOLDER")/filepath/.

Re: send Environment variable from context

Anonymous — Tue, 22 Jul 2014 12:58:21 GMT

Can you pl show how you are calling... Actually it is a string concatenation operation, it should be written like
context.Folder_location=System.getenv("SOURCE_FOLDER")+"/filepath/"
Try printing the value using System.out.println(System.getenv("SOURCE_FOLDER"));
and see what value is printed on console... else there is a trouble in calling the environment variables.
Thanks
vaibhav

Re: send Environment variable from context

Anonymous — Tue, 22 Jul 2014 13:14:39 GMT

Try printing the value using System.out.println(System.getenv("SOURCE_FOLDER")); -- gives the correct results.

But i am reading all the context values from external file,By Prompting on context variable, So that the context value i am reading in the job in like context.Folder_location only
System.out.println(context.Folder_location);
I am getting result as System.getenv("SOURCE_FOLDER")+"/filepath/"
But how to recognize System.getenv("SOURCE_FOLDER") -- value as a environment variable while sending from context. Because i think it is taking hole as a Object.

Re: send Environment variable from context

Anonymous — Tue, 22 Jul 2014 14:20:07 GMT

I got you....
You are trying to send System.getenv("SOURCE_FOLDER") from property file / variable value...
Context can't recognize it, it will read it as a string... you have to use it in tJava or within the job component, you can get that value directly from environment variable, you need not set it in job level context variables.
Vaibhav

Re: send Environment variable from context

willm1 — Tue, 22 Jul 2014 14:47:02 GMT

mani - could you please print the results of you context variable and your env variable - so we can separate out what each part is doing?