Re: [PHP] PHP -> QuickBooks
On 7/5/07, Bob Covell <[EMAIL PROTECTED]> wrote: Daniel, We have found that changing data (correctly) in QB quite a task. Once we saw how we could really mess up data integrity we opted for a read only solution by pulling out the exact tables we needed. We used AccessBooks RT from synergration. http://www.synergration.com/ http://www.synergration.com/accessBooksRT/ This solution allowed us to store the information in MySql. Once in here you can do just about anything you want, minus putting it back into QB. -Bob > -Original Message- > From: Daniel Brown [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 05, 2007 9:48 AM > To: PHP List > Subject: [PHP] PHP -> QuickBooks > > I usually don't post a question to the list, since Google is my > friend, but this is somewhat of an urgent question that I don't feel > qualified to answer 100% affirmatively. So as I research the Internet > for some quality information, I'm hoping one (or more) of you have had > some experience in this area > > Is there a simple way to interface QuickBooks using PHP, or will I > need to convert my data to a common format (such as CSV) and import it > into QB that way? > > -- > Daniel P. Brown > [office] (570-) 587-7080 Ext. 272 > [mobile] (570-) 766-8107 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php Right, but unfortunately, my purposes require the ability to successfully and reliably write back to the QuickBooks database. Here's the actual scenario: Selling products online via a LAMP site. Need to synchronize the orders to QB to interface with the shipping department, who absolutely, 100% will not be moved from their QB/UPS system (I tried). All I need to do is dump in the new data, once per day, from one MySQL table to the appropriate QB table(s). -- Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP -> QuickBooks
On 7/5/07, Leonard Burton <[EMAIL PROTECTED]> wrote: Hi Daniel, There is a QB format. What you will have to do AFAIK is have PHP create the file then have QB import it. As far as Live changes, the only thing I have even glanced at is: http://www.devx.com/xml/Article/30482 Take care, Leonard On 7/5/07, Daniel Brown <[EMAIL PROTECTED]> wrote: > I usually don't post a question to the list, since Google is my > friend, but this is somewhat of an urgent question that I don't feel > qualified to answer 100% affirmatively. So as I research the Internet > for some quality information, I'm hoping one (or more) of you have had > some experience in this area > > Is there a simple way to interface QuickBooks using PHP, or will I > need to convert my data to a common format (such as CSV) and import it > into QB that way? > > -- > Daniel P. Brown > [office] (570-) 587-7080 Ext. 272 > [mobile] (570-) 766-8107 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Leonard Burton, N9URK http://www.jiffyslides.com [EMAIL PROTECTED] [EMAIL PROTECTED] "The prolonged evacuation would have dramatically affected the survivability of the occupants." Excellent, Leonard, that was EXACTLY the information I was looking for. Thanks! -- Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP -> QuickBooks
Hi Daniel, There is a QB format. What you will have to do AFAIK is have PHP create the file then have QB import it. As far as Live changes, the only thing I have even glanced at is: http://www.devx.com/xml/Article/30482 Take care, Leonard On 7/5/07, Daniel Brown <[EMAIL PROTECTED]> wrote: I usually don't post a question to the list, since Google is my friend, but this is somewhat of an urgent question that I don't feel qualified to answer 100% affirmatively. So as I research the Internet for some quality information, I'm hoping one (or more) of you have had some experience in this area Is there a simple way to interface QuickBooks using PHP, or will I need to convert my data to a common format (such as CSV) and import it into QB that way? -- Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Leonard Burton, N9URK http://www.jiffyslides.com [EMAIL PROTECTED] [EMAIL PROTECTED] "The prolonged evacuation would have dramatically affected the survivability of the occupants." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP -> QuickBooks
I usually don't post a question to the list, since Google is my friend, but this is somewhat of an urgent question that I don't feel qualified to answer 100% affirmatively. So as I research the Internet for some quality information, I'm hoping one (or more) of you have had some experience in this area Is there a simple way to interface QuickBooks using PHP, or will I need to convert my data to a common format (such as CSV) and import it into QB that way? -- Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP & QuickBooks Integration
On Tue, 2004-01-20 at 04:30, Galen wrote: > I am looking into the possibilities of exporting data from QuickBooks > into PHP for use with a SQL database. Getting data back into QuickBooks > would be even better, some kind of integration. Anybody ever done this? > Anyone even got any experience working with QuickBooks data, back and > fourth? > > All suggestions are welcome, I hear this can be a tough topic. Last I looked QB would export csv. -- BrianGnuPG -> KeyID: 0x04A4F0DC | URL: www.gfx-design.com/keys Key Server: pgp.mit.edu == gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC GnuPG: http://gnupg.org http://www.biglumber.com/x/web?qs=0x2C35011004A4F0DC Linux Registered User #339825 at http://counter.li.org signature.asc Description: This is a digitally signed message part
[PHP] PHP & QuickBooks Integration
I am looking into the possibilities of exporting data from QuickBooks into PHP for use with a SQL database. Getting data back into QuickBooks would be even better, some kind of integration. Anybody ever done this? Anyone even got any experience working with QuickBooks data, back and fourth? All suggestions are welcome, I hear this can be a tough topic. -Galen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
