Re: Filemaker and CakePHP
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 -~--~~~~--~~--~--~---
Re: Filemaker and CakePHP
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 -~--~~~~--~~--~--~---
Re: Filemaker and CakePHP
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 -~--~~~~--~~--~--~---
Filemaker and CakePHP
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 -~--~~~~--~~--~--~---
Re: Filemaker and CakePHP
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 -~--~~~~--~~--~--~---