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? Quote 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 Quote 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. Quote 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 Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/20522-quickbooks-integration-help/#findComment-91751 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.