Copying Project parameters

PhilHibbs · Post by **PhilHibbs** » Tue Feb 15, 2005 4:07 am

I have been merrily copying job parameters around by doing an XML export, but how do I do the same for user-defined project variables?

roy · Post by **roy** » Tue Feb 15, 2005 5:59 am

Hi,
I think you'll need to update/insert data in the repository for that one.
I believe a search here should get results with some relevant code, or as already siad in this forum a unsupported/advised hack via trace to get the commands performed when manually performing the task.

I wonder if Kim's (AKA kduke in this forum) products can do this? (parameter manager and dwnav)

IHTH,

kduke · Post by **kduke** » Tue Feb 15, 2005 7:32 am

I have never used those. I have no idea where they are stored. If someone knows then post it. Maybe we can hack a solution.

chulett · Post by **chulett** » Tue Feb 15, 2005 7:37 am

I have a very strong sense of Deja Vu working right now. Didn't you post this very same question only a few days ago, Phil?

sudharsanan · Post by **sudharsanan** » Tue Feb 15, 2005 7:54 am

Job parameters are always Project specific i.e is Environment Specific.. parameters will be different for development Env compare to Production Env.. one of the way to reslove this is using some tool(I am not sure which tool.. probalby some expert can help you in that).. or we can use the option what we use in our project...we use a hash file where we have key and value.. the values are the environment specific values (for eg.Database connection details..directory details)..this hashfiles will have all the job parameters..this need to be loaded before you start executing the jobs... also this is specific to env.. so you just have to modify the file based on the environment...you need to write a routine to the get the values from this hash file...i hope this information may be useful for you..

PhilHibbs · Post by **PhilHibbs** » Tue Feb 15, 2005 7:54 am

chulett wrote:I have a very strong sense of Deja Vu working right now. Didn't you post this very same question only a few days ago, Phil?

I did, but the post contained two questions, and I only got answers to the second. I thought it was worth trying again.

sudharsanan wrote:Job parameters are always Project specific i.e is Environment Specific.. parameters will be different for development Env compare to Production Env..

Yes, but the parameter names will be the same in the production environment as in development, and many of the values will be similar. Having to re-type everything when we create a new project environment is very tedious, even if it only has to be done two or three times.

PhilHibbs · Post by **PhilHibbs** » Wed Mar 02, 2005 4:19 am

I have now answered my own queston. The settings are stored in DSParams in the project directory. There are two parts: one in the [EnvVarDefns] section, which stores the properties of the parameter such as data type and prompt, and one in the [EnvVarValues] section that stores the values.