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

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 <parasane@gmail.com> 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
service@jiffyslides.com
leonardburton@gmail.com

"The prolonged evacuation would have dramatically affected the
survivability of the occupants."

On 7/5/07, Leonard Burton <leonardburton@gmail.com> 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 <parasane@gmail.com> 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
> service@jiffyslides.com
> leonardburton@gmail.com
>
> "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

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:parasane@gmail.com]
> 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

On 7/5/07, Bob Covell <bcovell@rolet.com> 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:parasane@gmail.com]
> > 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