Scripted XML Import into FileMaker 6

[OffTheDeepEnd.com]

Does anyone know if there is a way to script an XML import using and HTTP request into FileMaker 6? Our shopping cart support XML requests and it would be a great way to import recent orders. The only thing is that it would need to be scripted so our customer service department could perform the function easily.

[Wim Decorte]

Sure. Check out the "Import Records" script step. In the "specify file", scroll down to the bottom where it says "XML source".

In the top half of the "specify xml / xsl" dialog you enter an HTTP request.

It's very unlikely that the source produces XML in the FileMaker FMPXMLRESULT grammar so you'll also need an XSLT to do the transformation from your source's grammar to FMPXMLRESULT. You then specify the location for that XSLT in the bottom half of the dialog.