makeshift_theory Posted September 12, 2006 Share Posted September 12, 2006 My manager has just asked me to look up some info on integrating a mysql/php driven database structure and connect it to a Quickbooks platform. My original thought was to convert the mysql data into iff(quickbooks) or csv(Excel) however I do not think they will want to go that route? Does this sound like a xml model application? Link to comment https://forums.phpfreaks.com/topic/20522-quickbooks-integration-help/ Share on other sites More sharing options...
HuggieBear Posted September 12, 2006 Share Posted September 12, 2006 Do they want it to be a 'real-time' site?RegardsRich Link to comment https://forums.phpfreaks.com/topic/20522-quickbooks-integration-help/#findComment-90508 Share on other sites More sharing options...
makeshift_theory Posted September 13, 2006 Author Share Posted September 13, 2006 That's what I was talking to my manager today about basically here's what he told me in a nutshell. Basically when a customer makes a purchase on this client's website, the order get's logged in the mysql database. They also want it to log that order into the client's Quickbooks Suite, I have not used Quickbooks that much so I don't know exactly all there is to know about it. I know that it handles CSV and IFF files which I can convert the database into however they do not want to have to import or export anything they want it to be fully automatic. With that said I think the best thing to do is on every purchase dump the DB into Quickbooks somehow and have it update in ASC order. So to answer your question, yes I believe it's real time. Link to comment https://forums.phpfreaks.com/topic/20522-quickbooks-integration-help/#findComment-91171 Share on other sites More sharing options...
HuggieBear Posted September 13, 2006 Share Posted September 13, 2006 I think this link will be useful to you ;)[url=http://developer.intuit.com/QuickBooksSDK/Resources/Default.asp?id=97]Intuit Development[/url]I also just "Googled" [url=http://www.google.co.uk/search?q=quickbooks+%2Bwebsite+%2Bintegrate]quickbooks +website +integrate[/url] and got some good results.RegardsRich Link to comment https://forums.phpfreaks.com/topic/20522-quickbooks-integration-help/#findComment-91223 Share on other sites More sharing options...
makeshift_theory Posted September 14, 2006 Author Share Posted September 14, 2006 Well actually I think I'm saved, I can indeed go straight from the database to a iff file. Now my question with this information, I opened the iff file in Excel and it seems to just be formatted like a CSV so is it possible to just do a fopen() and write directly to this file or do I need to add something to my headers? Link to comment https://forums.phpfreaks.com/topic/20522-quickbooks-integration-help/#findComment-91751 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.