XML Help

[shiftlocked]

Hi there,

anyone out there familiar with XML and stuff? I know I can import it into excel and do what i need from there but....

one of the feeds has xml inside XML that excel doesnt seem to want to play with. If anyone out there can help please let me know!

 

[JN]

Hi there,

anyone out there familiar with XML and stuff? I know I can import it into excel and do what i need from there but....

one of the feeds has xml inside XML that excel doesnt seem to want to play with. If anyone out there can help please let me know!

I've got some rough XML experience after setting up the OC3D feed. LMK what i can do to help.

 

[shiftlocked]

Its nested like the following

<Data>

<productDetails>

<SKU>111</SKU>

<manufacturer>Asus</manufacturer>

<techDataXML><product_tech_spec><Product_x0020_Group>Video Cards</Product_x0020_Group><Manufacturer>Asus</Manufacturer><SKU>8682</SKU><Product_x0020_Name>ASUS 512MB RADEON X1900XT 2xDVI PCI-E etc etcetc

</techDataXML>

</productDetails>

</Data>

The problem is that no matter what I read the file in, be it excel, dreamweaver etc it always seems to miss out the nested stuff and treat it as crap (non formatted crap that is)

Any ideas?

 

[clive r]

We use xml spy for editing xml files, you could see if it validates in that. I'm not much of an expert here though...