dtdt0454 2014-04-13 23:46
浏览 30
已采纳

QuickBook PHP DevKit

I am currently in the process of integrating my php website with the desktop version of Quickbooks. The application resides on a remote computer and will need to remain in sync with the mysql db on my server. After a great deal of research it appears my two options are:

  1. Use the PHP Devkit and the web connector to accomplish this.
  2. Manually export csv files periodically from quickbooks and parse them and insert the data into my mysql db.

In regards to the first option, I can't seem to find any resources indicating that it's possible to query all items from the quickbooks db. This would be ideal as I could periodically query the remote quickbooks application for all items and insert ones which have been added/updated. It looks like the xml requests for querying require you to specify the item your querying. This will not work for what I have envisioned. As we are not making any orders from the website and only displaying current items/customers maybe the web connector is not what I need.

This brings me to my next option, manually parsing csv files from the application. I don't mind this as its more straight forward than setting up the php dev kit to talk to the web connector but requires manual intervention to export data files from quickbooks.

Does anyone have experience in accomplishing this task/automating the syncing of data between quickbooks desktop and a remote php website?

Any and all comments/suggestions are appreciated, Thanks.

  • 写回答

2条回答 默认 最新

  • dpsx99068 2014-04-14 15:02
    关注

    In regards to the first option, I can't seem to find any resources indicating that it's possible to query all items from the quickbooks db.

    This is definitely very do-able.

    Here's a full blown example of doing it:

    (that example can also import all invoices, all customers, etc. - but you could slim it down if you wanted to just do items)

    It looks like the xml requests for querying require you to specify the item your querying.

    No, they do not require that you specify an item. You can choose to filter things or not.

    See the full syntax reference here:

    If you look up ItemQuery, you can specify an item name if you want... or if you don't want to specify any criteria at all, that's fine too. If you specify a name to filter by, it filters items by that. If you don't specify any filters, you get back everything.

    This brings me to my next option, manually parsing csv files from the application.

    Yuck. :-)

    Does anyone have experience in accomplishing this task/automating the syncing of data between quickbooks desktop and a remote php website?

    Yes, lots. It's not terribly difficult.

    Follow the quick-start guide but substitute the _import.php script instead since you want to import data to MySQL instead of add/update stuff in QuickBooks:

    If you follow the quick-start you should be up and running within a half-hour. We have support forums too:

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 请问如何在matlab里使用raven工具?
  • ¥100 关于ios手游充值到一定金额,再点充值提示公众号的问题。
  • ¥15 求一个stm32串口控制程序
  • ¥20 Windows 驱动开发版本疑问相关
  • ¥15 MAC 未能打开磁盘映像
  • ¥15 fastcap使用,二维导体输入问题
  • ¥15 hosts修改后不能访问
  • ¥15 关于化学反应速率C++编译问题/FLUENT
  • ¥20 Yolov5训练报错
  • ¥15 Unity发布gzip压缩的webgl之后让浏览器可以正常显示画面