First a question - do you need to do this with the XML interface...? you'd probably find far more resources to help if you used PHP (for example)....?
I agree and would prefer to use php
The prospective client has replied with '... the agency really need an XML feed'
Given that the data is calculated based on entered data, it is not possible (and I am not prepared to yet!) to export all the possible report data.
"an XML feed" typically means something else than the very targeted actions you describe in a through d. Try and get some clarity from them about that.
Are you going to be the one doing the coding on the external website or is someone else doing that? What web scripting technology is used on that remote site? PHP? .NET? Ruby?
Actions a through c can be done with any of these. "d" is probably where they want the result in XML format (the feed?). Ask them what XML grammar they expect because you may have to translate FM's grammar in what they expect.
'really need an XML feed' ... you'll want to know in what form?
Do they make a query to FM and get XML result from an URL? Can this be done from their application? (PULL)
Do they need a DOCUMENT (in xml format) that is FTP'd to a particular directory on their server? - (Export from FM) and transmission to wherever.
Do they need FM web publishing to PUSH the XML to their server?
Do they need it as a SOAP transmission (request w/ response - PULL & PUSH)?
In what schema/grammar do they need the XML formatted? Do you need to apply XSLT to one of the FMP grammars?
By the way, PHP can take care of all the above.
Otherwise, you need some manual manipulation, use of plug-in(s), or other means.
I do many "feeds" in many formats. You need the specifics!
taking your request:
a. having entered data on a external website field, copy this and
b. enter data in one field on my fmp database
c. initiate a script to build the report field
d. recall data from report field for display on the external webpage
b. is this additional data or just what in the "copy"
c. trigger a script - manually or automatically (you do know about the fmp::// protocol, right? it may require permissions, of course, but can trigger a script with parameters, even!)
d. PUSHING the results back to the external webpage, ok that's a post
and this all sounds a lot like a SOAP request/response. What can they do from their website? what web application is it running? What database is it running?
oops, Wim beat me to the reply. definitely get more clarity!
Steve, Wim & Beverley, thanks for the specifics. I have gone back and asked more questions...
Re my abcd .. maybe not the best description of the process.
To give you some idea of what I am trying to exchange between the existing filemaker files and the remote website, have a look at the test page
I think you get a better idea of what I am trying to achieve, just need to decide/convince them on the HOW!
This is a Web Direct interface (for display) of record(s). That doesn't tell me anything about what you need do with/for external website.
agree that it is web direct, seemed like the quickest way to display functionality required.
2 primary tasks
1. on external website, want to have users enter a country name in a field, this data is then copied and placed in eRTS::Countries.
2. then want the eRTS::CountryInfo data 'copied' for display on external website
At this time I am not really interested in what it looks like, just trying to get some help to build a sample url, configured to place data in Country and another to read the CountryInfo field.
I can then alter this to fit for the Vaccines, Diseases and Drugs.
1. enter country as in A
2. perform the script: Add Country to Itinerary
and likewise with A, I can reconfigure this url to prepare TravelReport and YF Report
Hope this helps make it a little clearer...
I see you have published a book on this subject. Is there anywhere where I can buy an eCopy?
No, but the web publishing is the one part that has changed and I don't think it would help for what you want. The IMPORT/EXPORT & usage with or without XSLT is all the same.
You need to give them XML results in a field still, this can also be calculated.
-- sent from my iPhone4 --