Hello,
Chris Velevitch wrote:
On 12/21/06, Simon Haddon <[EMAIL PROTECTED]> wrote:
On the bright side, however, there is an MYOB API to their MS Access
database. It could be feasable to let let MYOB to what it does and the
lacking bits could be written in CF or somethng else.
The last time I checked, MYOB doesn't have a true API, only an ODBC
interface, which means you can't update the database without knowing
the business rules to ensure the integrity of the database. To be
truely useful, you need to be able automate the updating MYOB.
We have been down this path, using MYOB with our own system and you are
correct Chris, it is an ODBC connection but it does go directly into
their database so you can read things directly just like any other sort
of database read. To expand in what you said what is different is that
you cannot write to the database, and thinking about it that is very
sensible, MYOB protects its data quite strongly, the last thing you need
is a corrupted set of books. What you do is write to a temporary table
and then go into MYOB and ask it verify the data, if it sees no
disparity in field naming, data structure, etc then it imports the data.
So it is a fairly painless exercise
Kym K
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
