senaia
8th August 2009, 09:43 AM
heya folks, i'm probably waaaay off course here, but i need a small favour from you kind people out there
i need to convert a .xml file to a .csv file... anyone up for it?
the basic layout of the xml is
<phone name="1100">
<repair name="Broken Screen" price="18.00" />
<repair name="Not Charging" price="21.00" />
<repair name="Microphone Replacement" price="16.00" />
<repair name="Earpiece Replacement" price="16.00" />
<repair name="Loudspeaker Replacement" price="16.00" />
<repair name="Software Faults" price="21.00" />
<repair name="Phone Not Turning On" price="Variable" />
<repair name="Other" price="Variable" />
<repair name="Unlock" price="10.00" />
<repair name="Unlock" price="10.00" />
</phone>
<phone name="1110">
<repair name="Broken Screen" price="18.00" />
<repair name="Not Charging" price="21.00" />
<repair name="Microphone Replacement" price="16.00" />
<repair name="Earpiece Replacement" price="16.00" />
<repair name="Loudspeaker Replacement" price="16.00" />
<repair name="Software Faults" price="21.00" />
<repair name="Phone Not Turning On" price="Variable" />
<repair name="Other" price="Variable" />
<repair name="Unlock" price="10.00" />
</phone>
is it possible to make it so (for example using MS excel) every new phone, is a new row?
sort of like this in notepad...
,Nokia,1100,broken screen - 18.00,not charging - 21.00,etc ,etc,etc,,,,,,,,,,,,,,,,,,,,,,,,
,nokia,1110,broken screen - 18.00,not charging - 21.00,etc ,etc,etc,,,,,,,,,,,,,,,,,,,,,,,,
the help would be reatly appreciated as i know nothing of programming:confused:
thanks in advance peeps
sorry if this is waaay off topic, but it is the off topic section lol
i need to convert a .xml file to a .csv file... anyone up for it?
the basic layout of the xml is
<phone name="1100">
<repair name="Broken Screen" price="18.00" />
<repair name="Not Charging" price="21.00" />
<repair name="Microphone Replacement" price="16.00" />
<repair name="Earpiece Replacement" price="16.00" />
<repair name="Loudspeaker Replacement" price="16.00" />
<repair name="Software Faults" price="21.00" />
<repair name="Phone Not Turning On" price="Variable" />
<repair name="Other" price="Variable" />
<repair name="Unlock" price="10.00" />
<repair name="Unlock" price="10.00" />
</phone>
<phone name="1110">
<repair name="Broken Screen" price="18.00" />
<repair name="Not Charging" price="21.00" />
<repair name="Microphone Replacement" price="16.00" />
<repair name="Earpiece Replacement" price="16.00" />
<repair name="Loudspeaker Replacement" price="16.00" />
<repair name="Software Faults" price="21.00" />
<repair name="Phone Not Turning On" price="Variable" />
<repair name="Other" price="Variable" />
<repair name="Unlock" price="10.00" />
</phone>
is it possible to make it so (for example using MS excel) every new phone, is a new row?
sort of like this in notepad...
,Nokia,1100,broken screen - 18.00,not charging - 21.00,etc ,etc,etc,,,,,,,,,,,,,,,,,,,,,,,,
,nokia,1110,broken screen - 18.00,not charging - 21.00,etc ,etc,etc,,,,,,,,,,,,,,,,,,,,,,,,
the help would be reatly appreciated as i know nothing of programming:confused:
thanks in advance peeps
sorry if this is waaay off topic, but it is the off topic section lol