The non-profit I work at is working on our online donating. We are using CartThrob to handle the donations. All set there. However the issue now have is how to keep our ‘products’ (accounts people can donate to) updated.
We have a list of accounts that get updated in an internal database (FileMaker) used by our organization. Currently in our non-ee donate tool it pulls the list from an online version of this database. The local database pushes updates to the online FileMaker database to keep our online donate options updated.
How to do this now that we’ll be using an EE channel to update the data? PHP (via a plugin) can be used to generate an array. Could a sequel query be used in combination with this plug in to update the channel data? Anyone know how to get EE data to update from a FileMaker database (we can contract for this work if anyone knows how)?