About XML file Integrating to a table

UNIX for Advanced & Expert Users
1

Hi ,
I have a question about unix shell scripting. I hope someone may help me to solve problem. In our system , there are two server that generate two different log file which are XML format in UNIX system. The problem is ,
this XML files contain such counter names and values sometimes this counter names and values are get out of order. We don't have any permission to change counter names order.
So, when I integrate that file into a table in oracle, column names and values are different because of disorder.
How I can load this file to my table without of disorder?
Could you please share the solution suggestions with me?

the example of XML file ;
There are two server and we get this xml files from two servers .
these are the names of the counter names;
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
.
.
.
the problem is ;
In one xlm file, first counter name is Attempts from first server however first counter name is Successful Attempts in second server. In order to integrate these fields to oracle table there is inconsistency with column names and values .
Thanks a lot
catherine

2

To ensure that the "Attempts" line counter is always "1" and the "Successful Attempts" line counter is always "2" you could run each xml file through the following script before importing it into Oracle:

 sed -e '/Attempts/s/mt p="2"/mt p="1"/' -e '/Successful Attempts/s/mt p="1"/mt p="2"/'   inputfile.xml > outputfile.xml

Example run thorugh:

$ cat inputfile.xml
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="2">Attempts</mt>
<mt p="1">Successful Attempts</mt>
<mt p="2">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="1">Successful Attempts</mt>
$ sed -e '/Attempts/s/mt p="2"/mt p="1"/' -e '/Successful Attempts/s/mt p="1"/mt p="2"/' inputfile.xml > outpufile.xml
$ cat outpufile.xml
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
<mt p="1">Attempts</mt>
<mt p="2">Successful Attempts</mt>
$