Mass Update for Auto Edit Variable

rahulsehgal · Post by **rahulsehgal** » 06 Jan 2010 10:09

Hi,

I have around 500 jobs for which I have to update Auto Edit Variable.

Do we have any mass update feature for Auto edit variables in Control-M/EM Desktop?

Regards,
Rahul Sehgal

Walty · Post by **Walty** » 06 Jan 2010 1:11

Hi,

In v6.3 the Mass Update feature is not possible for SET VAR values of Job Definitions.

Suggestion is to use <exportdeftable> or <exportdefjob>
This utilities first export the data from CONTROL-M/Enterprise Manager database to a flat file (xml format)
Then make the required changes from outside of CONTROL-Min in the flat file (by owner script or using text editor like UltraEdit)
The next step is to import the flat file back into the CONTROL-M/Enterprise Manager database using the <deftable> or <defjob> utility.
More information on these utilities is available in the CONTROL-M/EM Utility Guide.

Or use the <ctmexdef> utility
The ctmexdef utility exports job processing definitions from the CONTROL-M/Server database to a flat (ASCII) file.
Then make the required changes in this file.
This file can then be used as input for either the <ctmcreate> utility or the <ctmdefine> utility.
More information on this utility is available in the CONTROL-M/Server Admin Guide.

See also this interesting post

rahulsehgal · Post by **rahulsehgal** » 06 Jan 2010 2:26

HI Walty,

Thanks for your explanations walty. I am aware of exportdeftable and ctmexdef utility for Control-M EM and Control-M Server CLI, but these all jobs are available in drf files, I have to upload all these tables in Control-M/EM and then call them using exportdeftable utility, was just checking if we have anything for Control-M EM Desktop

Thanks for your help and thanks for such good post

Regards,
Rahul Sehgal

Samarth_Vyom · Post by **Samarth_Vyom** » 23 Jan 2010 10:44

is this option also works for Control-M 6.4?????

rahulsehgal · Post by **rahulsehgal** » 25 Jan 2010 2:41

Hi Samarth,

Yes this command line utulity is also available for Control-M 6.4

you can go through Control-M Enterprise Manager Utility guide for more info on this.

regards,
Rahul Sehgal

philmalmaison · Post by **philmalmaison** » 27 Jan 2010 11:42

hy
you can mass upload table in command, what ever is your number version from the em with ecs cli.
So you just have to make the list tables to upload and then run it.
you can make a script like :
DATACEHNTER=<dadacenter>
for ctl in `cat ${listetables}.dat`
do
ecs cli -U <userem> -P <passem> -H <GUI> -TABLE_UPLOAD <DATACENTER> ${ctl} -BY_FORCE
done

regards
philmalmaison

rahulsehgal · Post by **rahulsehgal** » 27 Jan 2010 1:18

Hi Philmalmaison,

Thanks for the response, but all the tables are in drf format, I think to upload the tables using Script given below, we should have the tables in XML format?

Regards,
Rahul Sehgal

philmalmaison · Post by **philmalmaison** » 27 Jan 2010 4:00

yes all that utilities are using xml format , but not draft one, i mean exportdeftable or ctmexdef ...

You can export all necessary jobs, change them , and import them, and finally upload them

regards
philmalmaison

master4usrcm · Post by **master4usrcm** » 10 May 2010 5:38

Hi,

In my case we have some 1000 jobs in Pre-Prod Server DALLAS for which I need to change Auto Edit var and my EM, GUI and Prod server are same(the name is EAST). So I login into Pre-Prod server i,e DALLAS and used ctmexdef to export the table and saved that in XML format and done all the necessary modifications.

Now how should I upload that to Control-M server and EM database.
Can anyone please help me in this??

Thanks & Regards

mauriziog · Post by **mauriziog** » 24 May 2010 6:26

but all the tables are in drf format

The desktop version 6.4, can open draft from 6.3 version.

So you can:
- use the 6.4 client for update the jobs with the new find and update
- save the new draft in xml file
- import with deftable the draft modified

Or you can save the draft in xml and after modify the xml file as suggested by Walty.

mauriziog · Post by **mauriziog** » 24 May 2010 6:29

Now how should I upload that to Control-M server and EM database.

rahulsehgal, use the deftable utility as well descrived in the "import XML files" posts.

[/quote]