QuickBooks connectivity

[JCrou82]

I'm trying to create a web application for my company here. Basically I need a support ticket control app. I've tried downloading some and for some reason I wasn't able to get them to run so then I decided to create my own app. Since I'm creating my own app, I might as well link into our quickbooks data for customer look up. I heard that there are "drivers" to access the QuickBooks database? The thing is I need to access the database from a PHP application using MySQL. I'm not exactly sure where to start or even if it's possible. Basically I'm going to create a data base for the trouble ticket system and use the connection to either look up the customer information or make an export of the data into the MySQL database.

Thanks

 

[sleipnir214]

If you are running PHP on Win32, there is probably an ODBC driver for QuickBooks databases. You can use that driver and PHP's odbc_* family of functions to access the data.

You could, as you said, export the data from QuickBooks and import that data into MySQL. Whether this is applicable depends on how dependent your application is on having fresh data to work with. The more your QuickBooks customer database is updated, the quicker the data in your imported MySQL database will be out-of-date.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bradzy88]

is thier a way to send access data to quickbooks without buying the $200.00 ODBC Driver?