Drupal 6 和 Quickbooks 库存导出是否顺利
查看 Quickbooks API，我只看到同步用户的选项。我可能只需要直接从数据库导出我需要的字段？只是希望有人已经有了一些脚本/模板来处理这个问题。我不太担心同步，只要客户端可以在一天开始时手动导入网络交易
Looking at the Quickbooks API I only see options to sync users. I may just need to export the fields I need directly from the database? Just hoping someone had some scripts/templates to work with this already. I am not too worried about sync as long as the client could manually import web transactions at the beginning of the day
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
QuickBooks SDK 能够导入和导出库存项目，包括现有数量和成本信息。需要澄清的是，我在这里谈论的是经典 SDK，而不是合作伙伴平台。使用该 SDK，可以使用 XML over SSL 连接到 QuickBooks 在线公司，或者使用 XML 或与 .NET 兼容的 Intuit 的 QBFC 框架连接到桌面公司文件（仍然是大多数用户最流行的选择）。
无法直接访问 QuickBooks“数据库”。 QODBC 使您能够通过 ODBC 对 QuickBooks 公司文件数据运行 SQL，但它是使用 SDK 实现的。 QODBC 是快速启动和运行 QuickBooks 的最佳方式，而且它也非常适合自定义报告。但对于大多数同步应用程序来说，实际的数据访问只是整个范围的一小部分，并且通过直接访问 SDK 并绕过 QODBC 获得的控制权是值得的。
大多数具有 QuickBooks 经验的开发人员都有一个库来帮助完成常见的 SDK 任务。 code.intuit.com 上也提供了一些产品。除了库代码之外，它还有助于理解 QuickBooks 和 SDK 的行为。 SDK 有详细记录，如果您还没有访问过Intuit 开发者网站的 SDK 部分 我强烈推荐它。
The QuickBooks SDK has the ability to import and export inventory items, including quantity on hand and cost information. Just to be clear, I speaking here about the classic SDK and not the Partner Platform. Using the SDK it is possible to connect to a QuickBooks online company using XML over SSL, or to a desktop company file (still the most popular option for most users) using XML or Intuit's QBFC framework, which is compatible with .NET.
There is no way to access the QuickBooks "database" directly. QODBC give you the ability to run SQL against QuickBooks company file data via ODBC, but it is implemented using the SDK. QODBC is the best way to get up and running fast with QuickBooks, and it's also great for custom reporting. But for most sync applications, the actual data access is a minor part of the overall scope, and the control that you get from going directly to the SDK and bypassing QODBC is worth it.
Most developers who have experience with QuickBooks have a library to help with common SDK tasks. There are also some offerings at code.intuit.com. In addition to library code, it also helps to understand the behavior of both QuickBooks and the SDK. The SDK is well documented and if you haven't visited the SDK section of the Intuit Developer site I would highly recommend it.