Jump to content

mysql - XML - Filemaker


benk

This topic is 4320 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

  • 6 years later...

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 ?

Link to comment
Share on other sites

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

fmError.png

xml_response.xml.zip

import_order_inschrijvingen.xsl.zip

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4320 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.