Quickbooks PHP DevKit
我目前正在将我的 php 网站与桌面版 Quickbooks 集成.该应用程序驻留在远程计算机上，需要与我服务器上的 mysql 数据库保持同步.经过大量研究后，我的两个选择是:
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:
- 使用 PHP Devkit 和 Web 连接器来完成此操作.
- 定期从 quickbooks 中手动导出 csv 文件并解析它们并将数据插入到我的 mysql 数据库中.
关于第一个选项，我似乎找不到任何资源表明可以从 quickbooks 数据库中查询所有项目.这将是理想的，因为我可以定期查询远程 quickbooks 应用程序的所有项目并插入已添加/更新的项目.看起来查询的 xml 请求要求您指定查询的项目.这不适用于我的设想.由于我们没有从网站下订单，只显示当前项目/客户，因此网络连接器可能不是我需要的.
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.
这让我想到了下一个选项，从应用程序手动解析 csv 文件.我不介意这样做，因为它比设置 php 开发工具包与 Web 连接器通信更直接，但需要手动干预才能从 Quickbooks 导出数据文件.
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.
有没有人有完成此任务/自动在 quickbooks 桌面和远程 php 网站之间同步数据的经验?
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.
关于第一个选项，我似乎找不到任何资源表明可以从 quickbooks 数据库中查询所有项目.
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.
这绝对是非常可行的.
这是一个完整的例子:
(该示例还可以导入所有发票、所有客户等 - 但如果您只想做项目，您可以将其缩小)
(that example can also import all invoices, all customers, etc. - but you could slim it down if you wanted to just do items)
看起来查询的 xml 请求需要您指定要查询的项目.
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:
如果您查找 ItemQuery，您可以根据需要指定一个项目名称...或者如果您根本不想指定任何条件，也可以.如果您指定要过滤的名称，它将以此过滤项目.如果你不指定任何过滤器，你会得到一切.
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.
这让我想到了下一个选项，从应用程序手动解析 csv 文件.
This brings me to my next option, manually parsing csv files from the application.
呸.:-)
有没有人有完成此任务/自动在 quickbooks 桌面和远程 php 网站之间同步数据的经验?
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.
遵循快速入门指南，但替换为 _import.php 脚本，因为您想将数据导入 MySQL 而不是在 QuickBooks 中添加/更新内容:
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: