4 Replies Latest reply on Aug 30, 2009 3:03 AM by Teseo

    Filemaker integration with a corporate information services via XML

    Teseo

      Title

      Filemaker integration with a corporate information services via XML

      Your post

      Hello,

       

      We are doing some prospections in order to know if is there any possibility to integrate Filemaker server advanced (and some filemaker pro as a user clients) within a corporate information system that accepts xml as the only format to exchange information with third part applications.

       

      As far as we know filemaker can "get" information via XML from other applications by doing url "requests" and parsing the xml data received from that in different ways, but the main issue in that case is to write some FileMaker data into the corportate information software using XML. (to use odbc or jdb is not a possibility in that case, because they have some procedures before write data into their databases)

       

      We were thinking about the possibility to use a kind of php script who would act as as "calling-parser" receiving data from filemaker url request (extracting the values from $_request['var x'] and doing then the corporate information services call from whitin PHP), but we are not sure that it would work with text fields with large contents...

       

      Has anyone some experience in this kind of integration?.Any Idea about how we can plan this kind of issues?.

       

       

       

      Thanks a lot in advanced.

        • 1. Re: Filemaker integration with a corporate information services via XML
          FluffyBear
            

          I haven't done work with ultra large text fields.  But we basically uses a system similar to what you're describing where PHP make a querystring call to FM and parse the resulting XML output.  I've worked with some pretty big result set into the several thousand records per call, but our fields are just small size of under 64 chars.

           

          I don't see why it shouldn't work with text fields with large content since FM is just echoing the content out.  I've gotten 20MB pdf files out of filemaker container fields before,  the header is different, but it's basically just an echoing of a large data field just the same as if it were text.

          • 2. Re: Filemaker integration with a corporate information services via XML
            Teseo
              

            Thank you for you answer FluffyBear, in fact it could be a solution for us, because it suposes a paradigm change from what we have planned. 

             

            Our first thought was to use Web Viewer object to call php urls, parsing data as a variables inside url, but your method is much more effective, because as far as I understand, the solution for large field contents is to make php to get data from FileMaker and once PHP gets the contents from FileMaker, transfer it out using "whatever method" instead of passing this data as a url parameters as I was planning. Actually large field contents wouldn´t be a problem because PHP (and it´s FileMaker API), should do the "echo work" for us.

             

            I will make some trials with this point of view 

             

            Thank you for your help.

             

             

            • 3. Re: Filemaker integration with a corporate information services via XML
              jbarnum
                 Teseo, is this a SOAP XML Web Service that you're trying to call? If so, I recommend the fm:nexus Web Services Plugin (http://fmnexus.com/products/webservices/). If you're just trying to do an XML http POST that is not SOAP, you can use the XML POST module in our free ScriptMaster plugin (http://www.360works.com/scriptmaster). If you want to set up FileMaker Server so that it is actual a server for XML Web Services requests, I recommend using our Web Services Manager products (http://www.360works.com/wsm/). Hope that helps.
              • 4. Re: Filemaker integration with a corporate information services via XML
                Teseo
                  

                Jbarnum, thank´s for your suggestion, I will take a look to those pluggins and solutions that you have propossed. Whiout doubt It could be quite interesting.