Total Newbie to XML needs advice!

[utterlystumped]

Hi Guys,

I am a total noobie to xml but I am digging my heals in deep.

The scenario is this:- I have created an xml feed which is pulled from a zencart database, I also have an importer script to import the data into an oscommerce dbase.

The problem is that I am pretty sure that the xml is fine because no errors show up in firefox but when I run the importer script it returns this error:

not well-formed (invalid token) on line 8

These are the first couple of products from the xml file which look ok to me (maybe I am now blind to it after too many hours staring urgh)

<?xml version="1.0" encoding="ISO-8859-1" ?>
- <catalogue>
<productset>7</productset>
- <product>
- <product_id>
- <![CDATA[ 267
]]>
</product_id>
- <name>
- <![CDATA[ DermaMed Anti Fungal Balm 60ml
]]>
</name>
- <category>
- <![CDATA[ DermaMed
]]>
</category>
<categoryparent />
<image>

http://www.****.com/images/formulaAx180.png</image>

- <price>
- <![CDATA[ 9.95
]]>
</price>
- <quantity>
- <![CDATA[ 3
]]>
</quantity>
- <description>
- <![CDATA[ Anti Fungal Balm DermaMed Formula A Anti-Fungal Balm contains clinically proven herbal extracts and natural therapeutic ingredients that provide effective treatment for fungal infections including Athlete's Foot, Jock Itch, and ringworm. Also effective for warts. Works quickly to relieve and soothe red, itchy and flaking skin caused by infection, dryness and exposure to chemical or physical irritants. Helps regenerate healthy tissue and strengthen skin integrity to prevent secondary and re-infections. <br /><br />
]]>
</description>
</product>
- <product>
- <product_id>
- <![CDATA[ 267
]]>
</product_id>
- <name>
- <![CDATA[ DermaMed Anti Fungal Balm 60ml
]]>
</name>
- <category>
- <![CDATA[ DermaMed
]]>
</category>
<categoryparent />
<image>

http://www.****.com/images/formulaAx180.png</image>

- <price>
- <![CDATA[ 9.95
]]>
</price>
- <quantity>
- <![CDATA[ 3
]]>
</quantity>
- <description>
- <![CDATA[ Anti Fungal Balm DermaMed Formula A Anti-Fungal Balm contains clinically proven herbal extracts and natural therapeutic ingredients that provide effective treatment for fungal infections including Athlete's Foot, Jock Itch, and ringworm. Also effective for warts. Works quickly to relieve and soothe red, itchy and flaking skin caused by infection, dryness and exposure to chemical or physical irritants. Helps regenerate healthy tissue and strengthen skin integrity to prevent secondary and re-infections. <br /><br />
]]>
</description>
</product>

Please offer some advice please as I am totally stuck now.

Thanks

Mark

 

[tsuji]

It would certainly be the character encoding issue pop-up in "import" script to oscommerce. Ask them or their support forum so that people there know what import script is.