exportdeftable error !!

catchtony · Post by **catchtony** » 03 Feb 2011 11:43

Hi,

I have been trying to use exportdeftable utility to export one table into xml fromat for modification.

I had gone thru Control-EM Utility guide aswell as many posts here on this utility, but unfortunately I am getting an error in my attempt :

exportdeftable -U <User> -P <Pass> -ARG_FILE $HOME/Testing1 -OUT_FILE TESTA

Error: Missing command Arguments! Please follow the Usage instructions.

For this I created a file with the name of Testing1.xml on the path $HOME on EM server calling the table MOHIT having the following contents :-

%ems620> cat Testing1
<TERMS>
<TERM>
<PARAM>
</TERM>
</TERMS>

Please let me know where I am going wrong ??

philmalmaison · Post by **philmalmaison** » 03 Feb 2011 4:18

Hi,
Add this first
<DOCTYPE>

Regards,
Philmalmaison

mmetti · Post by **mmetti** » 04 Feb 2011 10:34

exportdeftable -username XXX -password YYY -host ZZZ -arg_file ARGFILE -out FILE_OUT

where ZZZ is "GUI Server Name" on your Intranet

ARGFILE must be like:

<TERMS>
<TERM>
<PARAM>
</TERM>
</TERMS>

or

<TERMS>
<TERM>
<PARAM>
<PARAM>
</TERM>
</TERMS>

and so on. See utility guide, for help ''exportdeftable'' and arg_file format.

matom · Post by **matom** » 04 Feb 2011 5:51

Hi catchtony,

try with an argfile like this :

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE TERMS SYSTEM "terms.dtd">
<TERMS>
<TERM>
<PARAM NAME="DATACENTER" OP="EQ" VALUE="DataCentre" />
<PARAM NAME="TABLE_NAME" OP="EQ" VALUE="TABLE_XXXXX" />
</TERM>
</TERMS>

Regards
matom

catchtony · Post by **catchtony** » 05 Feb 2011 2:06

Thanks, the incorrect ARG file was the culprit, now it ran fine.

I guess v6.4 offers more flexibilty on this !

philmalmaison · Post by **philmalmaison** » 07 Feb 2011 3:15

yes you can export from the desktop directly in XML form

Regards,
Philmalmaison