You are here: BLOG Web design Connecting Joomla to Filemaker for an integrated solution

Connecting Joomla to Filemaker for an integrated solution

Friday, 26 August 2011 07:56 Written by  John
Rate this item
(13 votes)

We're developing a solution for a local wholefoods shop that involves connecting their existing Filemaker Pro database to their new website. We've come up with a solution that can be applied to any company looking for unique database driven solutions for web design, Cambridge. Here's how to connect your Filemaker Pro database to Joomla:

First off let external sources access your MySQL server by going to your web host Cpanel and selecting the 'Remote MySQL' button and enter in the relevant domain you're connecting from or a % for a wildcard.

Now onto your PC. Download the MySQL ODBC plugin (MUST be version 3.51 and MUST be 32 bit: http://dev.mysql.com/downloads/connector/odbc/3.51.html ).

Install it on your PC (I would suggest using a 32 bit machine to save a lot of messing around).

Go to Windows Control Panel > Administrative Tools > Data Sources and click the tab for System DSN (very important - won't work unless it's System DSN) and click Add.

You'll see the MYSQL ODBC connector you installed listed.

Now add the following: Domain, DB name, DB user name, DB password.

Test the connection.

Now in Filemaker Pro select File > Sharing and switch on the ODBC/JDBC radio button and select for all (or limited) users.

Next File > Manage External Sources > New > and enter a name for the connection.

Click the ODBC radio button and specify the data source (this should pull up your MySQL ODBC connection. If it doesn't something's amiss). Add in the authentication details (User Name and Password). Click OK.

You now have a live connection between MySQL and Filemaker.

Next stage is adding fields.

Again in Filemaker:

File > Manage > Database > Relationships

You'll see any existing table(s) and the fields it contains there. Click the 'Add Table' button and from the Data Source drop down select your MySQL connection. You'll see all of the Joomla tables displayed. Now select the appropriate table (in my case I was connecting Virtuemart so used the 'jos_vm_product' table and the 'jos_vm_product_price').

You'll see your new table displayed with all its fields.

Next step is to make the relationships. Again using my Virtuemart example I made a new field in my existing database table (you can do this from the View > Layout Mode (although sure there's a better way - I'm a complete Filemaker novice) for Product ID.

Connect up the matching fields (these need to be unique so for example an email field, etc) between the Filemaker table and the Joomla table and click OK.

Now go into View > Layout and you can add in Joomla fields to your Filemaker layout. Simply add a new field and select the Joomla table and the field you want.

Now when you update either Filemaker or Joomla the data will synch in real time.

Best of luck and of course if you'd rather we did this for you just contact us.

Last modified on Friday, 26 August 2011 08:02
John

John

John is a co-founder of SWAYsearch.

3 comments

  • Comment Link windows hosting reviews Thursday, 22 September 2011 12:05 posted by windows hosting reviews

    Great review of this post about the 12-connecting-joomla-to-filemaker-for-an-integrated-solution

  • Comment Link Spencer Sunday, 19 February 2012 16:06 posted by Spencer

    Hi John,
    Thanks for posting the information above. I think this is exactly (well almost - she is Mac based) what I am looking for. A client is looking to install inbloom resale and consignment software (which I believe uses Filemaker Pro) (http://www.inbloomsoftware.com/) to manage their (brick) shop - they also want to sell the products online - which I am looking at Joomla/Virtuemart.
    We're trying to avoid the stock control problem of having 2 databases and double entry when a product sales both off and online. With what your saying above with the Filemaker Pro database syncing with the MySql database, would they update each other if a piece of clothing sells in the shop or onlin etc?
    Would be great if they did, I surprised that there isn't more software around for this as there must be 1000's of bricks and mortar shops selling products online??
    Cheers,
    Spence

  • Comment Link Louie Thursday, 14 February 2013 02:27 posted by Louie

    Hi John, how can I find "enter in the relevant domain you're connecting from or a % for a wildcard." correctly?

Leave a comment

Make sure you enter the (*) required information where indicated.
Basic HTML code is allowed.

Latest from our blog