I have a xml file(template) and a csv file what next?

[scottiptel]

As you will notice this is the FIRST time I've worked with xml. I've done some research but have not found the answer to my question. Please help with my issues..thanks in advance.

I have and xml file that looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<!-- CDR descriptions v0.1 -->
<CDR>
<field no="1" name="start-time" fmt="string"/>
<field no="2" name="start-time" fmt="uint32"/>
<field no="3" name="call-duration" fmt="HH:MM:SS"/>
<field no="4" name="call-source" fmt="A.B.C.D"/>
<field no="5" name="call-source-q931sig-port" fmt="uint32"/>
<field no="6" name="call-dest" fmt="A.B.C.D"/>
<field no="7"/>

then I have my .csv file

How do I get the data from the csv file into this format/template (the csv file is HUGE) where it looks cool and I get a big old raise?

Thanks

 

[harebrain]

Repeated applications of XSLT's substring_before and substring_after functions will accomplish this, provided none of the data contains commas.

 

[k5tm]

Or you could go to

http://www.stylusstudio.com

and download the prodcut there, which claims to do exactly this...

Tom Morrison

http://www.liant.com

 

[harebrain]

Or you could import it into Excel (which you might already have) and save it as XML. Then you wouldn't get that fat raised dinged by the cost of the software.