Upload data from FileMaker Server to FileMaker Server using Import XML

[The Software Man]

I have a need to upload data from one FileMaker Server to a second FileMaker Server.

I now know that this can NOT be done within a FileMaker scripting using "From FP7" method or using the "Set Field" method. FileMaker has put some kind of limitation crippling these methods. (Darn you FileMaker Inc )

So can I skirt the issue by using "Import from XML Data Source" and use a http request to the source server?

i.e. "http://192.168.1.101/fmi/xml/FMPXMLRESULT.xml?-db=details&-lay=xml&-findall"

I've tried this and get some kind of response, and an error of "XML Parsing Error!; Unterminated entity declaration 'ContentType'; Line number 81; column number 5"

I've tried accompanying the http request with an XSLT style sheet that was generated with the XML assistant. But still get the same response.

Am I an idiot?

Am I phrasing the http request wrong?

Am I not using XML correctly?

Am I all mixed up with the XSLT?

I looked into SynchDek. They want $6000+ to synch a couple of servers. And I have to buy another server that runs their software.

Crazy! I had this same kind of routine licked in FMP v6.0! One server could easily access another. Albeit not multi-tasked.

What's up with the limitations?

Thanks for the help.

Edited March 25, 2009 by Guest