import xml data

[Simon K]

Hi guys

I am trying to do an import of xml data using an http request (after great help from Fenton with the xslt).

However when i try and run the import (manual or scripted all i get is the following message:

"XML Parsing error

An exception occured

Type: NetAccessorException

Message: Could not open file {0}

Line no 0

columnn no 0"

No matter what I try to do to solve the problem (including stopping and restarting server, closing databases etc) I cannot get past this message now

Does anybody have an idea what to do about this?

Many thanks

Simon

PS apologies if anybody thinks this is a double post - the previous thread was all about the xslt - which has been successfully resolved - thanks to Fenton.

Edited November 23, 2007 by Guest

[Fenton]

Look carefully at the path to the xsl file. Is it correct? If so, you should be able to open that path with your web browser (or a FileMaker Web Viewer object). Or are you trying to use a local xsl file and a web request for the xml?

[Simon K]

Hi Fenton,

The XSL file is local (the one you last posted) - in fact placed on the root of my machine for ease ie c: - the xml file was the result of an http request from a remote server...

thanks for continuing to help

Simon

[Mikhail Edoshin]

Try to check that you really get a XML file using the URL. (I'd use a tool like ‘curl’ for this, not a browser.)

[Simon K]

Hi Mikhail,

Thanks for the suggestion - I have checked now and it is indeed an XML file. The HTTP request works fine from a browser (both IE and Firefox)

but if I put the exact same request in the import (menu command or script) as either an HTTP request or the calc for an HTTP request I get the message referred to in my previous post?

Any other pointers/ideas gratefully received

Simon

[Mikhail Edoshin]

A few more ideas:

If that XML is formed dynamically it may produce different results depending on what the user agent is. E.g. if you try to import MapQuest XML, it sends XML to known browsers, but plain text to any other user agent (including FileMaker) explaining that this agent is not supported. (At least this is how it was when I tested it.)

Try to view that XML in FM web viewer.

Try to import without referring to a XSLT to see if the error is same or different.

Do you use HTTP or HTTPS protocol?

[Simon K]

Hi,

Good ideas - heres the answers:

1) If I put it into the web viewer it returns the IE version of the xml data - so the correct return data is viewable in FM web viewer

2) If you try the import without the xslt file it brings up the exact same message (ie its pretty immediate failure)

3) HTTP - the HTTPS services costs more to use so we would prefer to use the HTTP service

Anything in these points?

Simon

[Mikhail Edoshin]

Is it a publicly available URL or internal one? If it's public, could you please tell us what it is, so we can test it?

[Fenton]

Can you open the XSL file in the web browser with its path? In other words, are you sure you've got the path right to the xsl file?

[Simon K]

Hi Fenton

the xsl is in the root of my local hard drive - ie if i opened in a browser it had the following in the url

file:///C:/PCML_3.xsl

[Simon K]

Fenton, Mikhail,

Have suggested PT to continue - hope you dont mind but I need to send URL

I really do appreciate your time

Thanks

[rantanplan41]

Hi Guys!

I´ve got the same problem here: when I use the HTPP request, I get the XML Parsing error, but if I save the resulting file that I get from the HTTP (save as xml from Safari), everything works just fine.

Any new ideas?

Thanks,

Daniel

[Mikhail Edoshin]

Try to access the same URL using some other tool, e.g. curl. Some servers check the "user agent" header and return different content to different agents.

Also: is this a HTTPS resource, perhaps? Safari would access it just fine, but FileMaker won't, as far as I know.

[dataclip]

I am dealing with the same problem and I am wondering if there is any additonal information.

To recap: I have a FM application that succesfully imports XML data. One of my customers installed this application on a new computer and this computer gives me a XML parsing error. An exeption occurred. Type: NetAccessorExecption. Message: Could not open file {0}. line number: 0 column number: 0

Manual download and import into FM works fine. Other computers in the same network give no problems. Firewall and anti-virus software is not a problem.

[Bonnerbl]

Did any of the three of you reach a resolution to the problem? I'm trying to import xml from the USPS site using http. Getting the same NetAccessorException.