2 Replies Latest reply on Sep 22, 2009 1:39 PM by MartinBrändle

    Filling in web forms from records.



      Filling in web forms from records.


      I will start by stating this less about FileMaker and more about working with other applications from FileMaker.  I will also plead ingnorance about most things "web", as may be apparent after reading my question.  Soo...

      We are a nonprofit social service agency who maintains all of our data in FileMaker and has no real desire to change.  We will be participating in a project aimed at helping people maintain their existing housing or obtain new housing.  However, as part of that program they would like us to enter some basic client data (most of which we already collect in our current database) into a regional database system so it can be accessed by others.  We're O.K. with this, but their system has very limited capability to upload data remotely and we're looking at having to double-enter the data, once in our system (we have other clients and other funders to report to) and once in their system.  Their system is web-based and I've been around and around with them about creating a simple upload, but it ain't going to happen.

      So my question is, can anyone suggest a way we might be able to "auto-enter" the data to their system from ours?  I guess I'm looking for a way we could complete the record in our database, possibly export as xml or some other format, then create a record in their system and have the appropriate fields (about 15) populated with "the click of a button?"

      I realize much of this may be kind of vague so if you would like additional information please ask.  BTW, we're running FileMaker 10 server and Pro.  Thanks in advance for your input.

        • 1. Re: Filling in web forms from records.

          Sounds like it all depends on what their system can do rather than filemaker.


          You can export data from filemaker into a wide variety of file formats, excel, tab, commas separated text are three of the most common formats used for moving data between systems. Chances are extremely good that their software can import from some or all of these.


          If they are willing and able to import data from such a file, then you can simply export the data into a compatible format and send it to them. It they aren't/won't then good luck.

          • 2. Re: Filling in web forms from records.

            Does their system allow to submit data by HTTP GET or only by POST?


            If the former, you could construct an URL from their form parameters to submit your data by way of a web viewer or by using the Open URL script step.