AnsweredAssumed Answered

XML Import fails in FileMaker 10 on OS X Lion (10.7)

Question asked by Charlie Bailey on May 29, 2012
Latest reply on May 29, 2012 by james_quiggins

Summary

XML Import fails in FileMaker 10 on OS X Lion (10.7)

Product

FileMaker Pro

Version

10

Operating system version

OS X 10.7

Description of the issue

Import of XML data fails when XML data source is HTTP request or XSL stylesheet source is HTTP request. If both data source and stylesheet are local files, import proceeds as expected. Error generated:

XML parsing error:
An exception occured! Type: NetAccessorException,
Message: Could not connect to the socket for URL '{0}' . Error={1}

Line Number: 0
Column Number: 0

See this thread for more details:
https://fmdev.filemaker.com/message/83225

Steps to reproduce the problem

A little tricky to setup a test environment, since you need an XML and/or XSLT source hosted via http, but we have confirmed this with different data sources hosted on different servers.

1. Create a local filemaker file with a single table in it.
2. Create a script (or use the File/Import Records/XML Data Source... menu option)
3. Point to an HTTP hosted XML data source and XSL stylesheet source.
4. Execute the command and you'll get the error as specified here:

XML parsing error:
An exception occured! Type: NetAccessorException,
Message: Could not connect to the socket for URL '{0}' . Error={1}

Note that a successful import actually takes a second or two while the data is retrieved, in this failure case, the error is immediate. Sniffing network packets during this process confirms that the request for the remote files does not even leave the local machine (there are no network packets generated by this script step).

Expected result

Expect to retrieve the data via import.

Actual result

Error as above.

Exact text of any error message(s) that appear

Message: Could not connect to the socket for URL '{0}' . Error={1}

Line Number: 0
Column Number: 0

Workaround

Use FMP v11 to perform the import or run FMP v10 on OS X v10.6.

Outcomes