My workgroup also uses filemaker for some existing projects so I've had interest in this as well.
I'm new to filemaker, but recently started using the Filemaker API (not FX) and while it seems kind of clunky, it worked. I have not used the API inside the cakephp framework, but I imagine if you drop Filemaker API into the vendors folder and load it appropriately, you can just use the API as you would in 'normal' php code that utilized the API. In the worst case, you will be back to a non-cake existence when asking the model to provide data as the nice 'automagic' functions obviously won't work. Potentially, you can roll up your sleeves and extend(?) the existing find() function and others to go through filemaker. Unfortunately, you'll likely run into trouble with existing filemaker apps because they were probably created in the 'usual' way - in large flat denormalized tables. This will wreck a lot of the automagic so you'll need to evaluate the existing data first and assess whether or not normalizing it will mess up existing apps. Good luck On Jul 17, 10:49 am, Eric <[EMAIL PROTECTED]> wrote: > The database is going to be updated primarily from an existing > Filemaker application. However, there will be some changes from the > web site that will need to be added to the database, ie. new user > registration, new "posts" from the users. I would expect there to be > daily modifications of existing data from the filemaker client, and a > large influx of new data from the FileMaker client about once a month. > > The database is relational and is being run on the latest version of > Filemaker. There is not a huge amount of data currently, but the site > is expected to grow. > > Thanks. > > On Jul 16, 9:44 pm, GravyFace <[EMAIL PROTECTED]> wrote: > > > Is the data on the website going to be read-only? How often is the > > data going to change? How much data? Is the data relational? What > > version if Filemaker? Can't really expect us to give you advice > > without knowing what it is you're trying to do. > > > On Wed, Jul 16, 2008 at 8:19 PM, Grant Cox <[EMAIL PROTECTED]> wrote: > > > > A few years ago I had to work with Cake and Filemaker - but thankfully > > > I convinced them that the website could use it's own database, and > > > their internal Filemaker database would just synchronise from this > > > live site with a Filemaker script (one way synch only). There was > > > just a cake action that output appropriate data as an XML file > > > suitable for Filemaker, and the Filemaker script updated from this > > > (with a recorded macro, as I recall). > > > > But the final solution is quite limited (one way, not automatic), and > > > it was a pain to work with - I really didn't like FileMaker after > > > that. > > > > Admittedly, this was back when Filemaker was not relational either (FM > > > 6 or 7 as I recall), so maybe things have improved. But if it still > > > doesn't support SQL, maybe not. > > > > On Jul 17, 5:24 am, Eric <[EMAIL PROTECTED]> wrote: > > >> Hi, > > > >> Has anyone had success using Filemaker as a repository for Cake? There > > >> have been a few posts here on the issue, but nothing for quite some > > >> time. > > > >> I realize it is quite a task since Filemaker does not really handle > > >> SQL. Filemaker does have a PHP API and there is something called > > >> FX.php which is another way of accessing the data. > > > >> The problem that I am facing is that a customer has an internal > > >> Filemaker database which they would like users of their website to > > >> have access to some of the data. They are moving their site's hosting > > >> internally to facilitate this change. If anyone has any other ideas of > > >> how to get the filemaker data into Cake, I am all ears. I was thinking > > >> some sort of database synchronization, but I think that will be more > > >> trouble then it is worth, if it is even possible. > > > >> Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
