About XML file Parseing

Shell Programming and Scripting
1

Hi ,

I have a question about unix shell scripting. I hope someone may help me to solve problem. I have an output file which is XML file. Also , I have a parser that parses files to format without XML tag. The problem is , this XML file contains such counter names and values sometimes this counter names and values are get out of order. So, when I integrate that file to a table in oracle, colon names and values are different because of disorder.
In the case , parser is not a permanent solution to me.
How I can load this file to my table in SQL without of disorder? Could you please share the solution suggestions with me?

Thanks
Catherine

2

then do something from your XML source. Get it in order..

3

Can you explain "get out of order" with an example (taking a part of your xml file as the example) ?

And an example of this as well ?

tyler_durden

4

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">Wireline Emergency Successful Push</mt>
<mt p="2">Wireline Emergency Routing Determination Request (Per Time
Unit)</mt>
.
.
.

the problem is ;
In one xlm file, first counter name is Wireline Emergency Successful Push from first server however first counter name is Wireline Emergency Routing Determination Request in second server. In order to integrate these fields to oracle table there is inconsistency with column names and values .
Is it more clear now ?