Skip to content

Filemaker & XML


Introduction

We can exchange information and messages between two computers,which uses XML data sent over the web via Http.But why xml? The reason is xml is faster,is a standard and well documented.

REQUESTING XML DATA FROM FILEMAKER PRO

Syntax:

xyz.com:591/FMPro?-db=myDB.fp5&-format=-fmp_xml&-max=all&-find

The above syntax specifies the protocol that is needed to communicate with the server. When we need to use FileMaker Pro over the Web, the protocol has to be http, the hypertext transfer protocol.

Let us now discuss the parts in detail:

the host: xyz.com

This describes the name or IP address of the server on which FileMaker Pro is running on.

the port: 591

Normally HTTP servers run on port 80. However if FileMaker Pro is sharing a machine with another web server say Apache or WebStar, then in that case you have to choose a different port.

the file path: /FMPro

This tells the server which file to serve.When using the FileMaker Web Companion as your server to serve XML,this is always /FMPro.

the query string: -db=myDB.fp5&-format=-fmp_xml&-max=all&-find

CHOOSING A FILEMAKER PRO XML GRAMMAR

So there are three different XML vocabularies.

These are:

o The FMPDSORESULT grammar

o The FMPXMLRESULT grammar

o The FMPXMLLAYOUT grammar

From the main menu file you can choose file-> export records->choose xml grammar-> export choose file-> import records->select file->import

XML export does not support exporting container field data.

FileMaker Pro can export XML in two grammars: FMPXMLRESULT and FMPDSORESULT.

The following is an example of XML in the FMPDSORESULT grammar.

The FMPDSORESULT grammar

This grammer is obsolete and hence not used. The better term is deprecated means the designer of the grammar is discouraging you to use xml grammar.

FMPXMLRESULT grammar

The FMPXMLRESULT grammar contains additional information about the database that is not in the
FMPDSORESULT grammar, such as the number of records, field types, and field formats.

FMPXMLLAYOUT – A GRAMMAR FOR LAYOUTS

FMPXMLLAYOUT is the third and final XML grammar that FileMaker Pro supports.

While both FMPDSORESULT and FMPXMLRESULT focus on the data in the database, FMPXMLLAYOUT describes the layout of the fields.

Conclusion

This article provides a better insight into the integration of xml in Filemaker.

I am working with Mindfire Solutions(http://www.mindfiresolutions.com), which is an offshore software development company and provides customized software solution to its global clients. My expertise includes PHP 4.0,PHP5 and Filemaker pro 8 advance,Filemaker pro 9 advanceetc. You can reach me at manjushreed@mindfiresolutions.com

Author: Manjushree Das
Article Source: EzineArticles.com
Provided by: Digital TV, HDTV, Satellite TV

15 Comments

  1. male model wrote:

    Howdy! Great article, thank you for that. Filemaker & XML | Learn XML is cool! Might I question the webmaster where he or she acquired his design and style? Or does it come normal at this web log? Keep it up and bless you once more for your time and efforts.

    Thursday, November 3, 2011 at 9:09 pm | Permalink
  2. Roger Bamber wrote:

    “Wow, great article. Fantastic.”

    Monday, November 21, 2011 at 2:54 pm | Permalink
  3. I think this is among the most significant information for me. And i am glad reading your article. But should remark on some general things, The website style is wonderful, the articles is really excellent : D. Good job, cheers

    Tuesday, November 22, 2011 at 12:38 am | Permalink
  4. I’m often to blogging and i really admire your content. The article has actually peaks my interest. I’m going to bookmark your web site and hold checking for brand spanking new information.

    Tuesday, November 22, 2011 at 5:28 am | Permalink
  5. Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a little bit, but other than that, this is magnificent blog. A great read. I’ll definitely be back.

    Tuesday, November 22, 2011 at 10:39 pm | Permalink
  6. Ela Orlander wrote:

    I’m still learning from you, but I’m trying to reach my goals. I definitely liked reading everything that is written on your blog.Keep the aarticles coming. I liked it!

    Monday, December 5, 2011 at 9:18 am | Permalink
  7. I think other website proprietors should take this site as an model, very clean and fantastic user genial style and design, let alone the content. You’re an expert in this topic!

    Monday, December 5, 2011 at 2:09 pm | Permalink
  8. Normally I do not read article on blogs, but I would like to say that this write-up very forced me to try and do so! Your writing style has been amazed me. Thanks, very nice article.

    Monday, December 5, 2011 at 5:38 pm | Permalink
  9. Spot on with this write-up, I actually think this website needs much more consideration. I’ll probably be again to read way more, thanks for that info.

    Tuesday, December 6, 2011 at 3:50 pm | Permalink
  10. I don’t even know how I ended up here, but I thought this post was good. I don’t know who you are but definitely you are going to a famous blogger if you aren’t already ;) Cheers!

    Tuesday, December 6, 2011 at 10:56 pm | Permalink
  11. After I initially commented I clicked the -Notify me when new comments are added- checkbox and now every time a remark is added I get 4 emails with the same comment. Is there any means you’ll be able to take away me from that service? Thanks!

    Thursday, December 8, 2011 at 1:42 am | Permalink
  12. Mike Raskey wrote:

    I’ve been absent for some time, but now I remember why I used to love this website. Thanks , I will try and check back more frequently. How frequently you update your website?

    Friday, December 9, 2011 at 7:58 am | Permalink
  13. Willa Swimm wrote:

    Wow, amazing blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is wonderful, as well as the content!

    Friday, December 9, 2011 at 9:28 pm | Permalink
  14. I think this is among the most vital information for me. And i am glad reading your article. But wanna remark on some general things, The site style is wonderful, the articles is really nice : D. Good job, cheers

    Saturday, December 10, 2011 at 2:59 am | Permalink
  15. Hi, i think that i saw you visited my web site so i came to “return the favor”.I’m attempting to find things to enhance my web site!I suppose its ok to use some of your ideas!!

    Wednesday, December 14, 2011 at 12:52 am | Permalink

Post a Comment

Your email is never published nor shared.