Hello,
I have an XML file in the form below.
<trace>
<LEVEL>FLOW</LEVEL>
<TIME>2003-05-06 09:57:59:9567238</TIME>
<TICKS>631878118799567238</TICKS>
<COMPONENT>NS</COMPONENT>
<SUBCOMPONENT>NS_SVC</SUBCOMPONENT>
<ENTRY type="ProcEntry">
<Datum name="Method">Init</Datum>
</ENTRY>
</trace>
<trace>
<LEVEL>FLOW</LEVEL>
<TIME>2003-05-06 09:58:00:2830701</TIME>
<TICKS>631878118802830701</TICKS>
<COMPONENT>NS</COMPONENT>
<SUBCOMPONENT>NS_SVC</SUBCOMPONENT>
<ENTRY type="ProcEntry">
<Datum name="Method">InitMgmt</Datum>
</ENTRY>
</trace>
<trace>
<LEVEL>FULL</LEVEL>
<TIME>2003-05-06 09:58:00:2830701</TIME>
<TICKS>631878118802830701</TICKS>
<COMPONENT>NS</COMPONENT>
<SUBCOMPONENT>NS_SVC</SUBCOMPONENT>
<ENTRY type="ProcEntry">
<Datum name="Adapter">SA</Datum>
<Datum name="Method">ServiceabilityAgent</Datum>
</ENTRY>
</trace>
I need to make an XSL file in
such a way so that resulted o/p will be in the
following given below.
<Query>
<Data> insert into
table(LEVEL,TIME,TICKS,COMPONENT,SUBCOMPONENT,Method)
values('FLOW',2003-05-06
09:58:00:2830701,631878118799567238,NS,SVC,Init)</Data>
<Data> insert into
table(LEVEL,TIME,TICKS,COMPONENTS,SUBCOMPONENTS,Adapter,Method)
values('FLOW',2003-05-06
09:58:00:2830701,631878118799567238,NS,SVC,SA,ServiceabilityAgent)</Data>
</Query>
Pls note --
1 - each <trace> tag will generate a SQL in the
corresponding <data> tag
2 - the value of columns of the SQL will come from
<LEVEL>, <TIME>, <TICKS>, <COMPONENT>, <SUBCOMPONENT>
and attribute values of <Datum> tag for e.g. Adapter
and Method. The table name is a constant.
3 - values of table columns will be corresponding
values of these tags
I'll appreciate a response to the above problem..
Regards,
Mukul
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list