mysql - XML - Filemaker

[benk]

I was wondering if anyone know how I go about solving parsing errors when importing XML data created from a mysql database.

I often get errors like "XML Parsing Error 'nbsp' was not found Line # 89 Column # 79"

Thanks

[cjaeger]

the entity " " is not known to XML by default. Create one!

[Joost Miltenburg]

  On 3/7/2005 at 2:59 PM, cjaeger said:

the entity " " is not known to XML by default. Create one!

Ok, that could make sense...

I try to import xml from an http request. That gets me the same error. However, when I copy and paste the xml from the browser into a empty xml file and save it. It imports without a hitch...

Any ideas ?

[comment]

Post the XML response as returned by the server.

[Joost Miltenburg]

  On 5/12/2011 at 3:24 PM, comment said:

Post the XML response as returned by the server.

Here it is...

I opened the url in Firefox and then copy/pasted the response data into a text file...

The tags and all are in Dutch, so if that hinders you please let me know...

FYI, importing this file works without a hitch... importing it directly from the response feed gives me this error message. I can influence the feed from the website so if work needs to be done there ; that's ok with me. It did work in the past however.

TIA

xml_response.xml.zip

import_order_inschrijvingen.xsl.zip

[comment]

  Quote

FYI, importing this file works without a hitch

Well, that's not getting us any further, then. Why don't you try opening the URL in Firefox, then do View > Page Source and File > Save Page As...

Even better: if you look at the error message you'll see where to find the response as downloaded by Filemaker.

[Joost Miltenburg]

  On 5/19/2011 at 2:28 PM, comment said:

Well, that's not getting us any further, then. Why don't you try opening the URL in Firefox, then do View > Page Source and File > Save Page As...

Even better: if you look at the error message you'll see where to find the response as downloaded by Filemaker.

Yes, I know. I was just hoping I would get this working again...

What I do now is let the user enter a product_code, which will be a part of an url and I import this directly.

Strange enough : it used to work...

I am already experimenting with the webviewer and export the contents of the webviewer to a file and import that... that will work, but is quite a work around.

[comment]

I am sorry, but I cannot help without seeing the problem. Have you tried either one of my suggestions?