将 TimeClock 数据从手机推送到 Quickbooks
我需要找到一种解决方案或开发一种解决方案，允许员工在一天结束时输入他们的“工作时间”，然后轻松快速地将这些数据“推送”到 Quickbooks Pro 2010。
我正在尝试在脑海中制定，如何构建此类解决方案。根据我对 QuickBooks 集成的理解，我认为它会如下所示：
Quickbooks Software on PC
|
|
Custom App "Linking" Online DataStore to QB (on same PC as above)
|
|
Online Data Store Such as MS SQL Server, MySQL, or CSV Files
|
|
Website or Web Service Used to Receive Data From Blackberry Phones
|
|
App on Blackberry Phone to Enter and "Push" Data To Data Store in the Cloud
您认为此设计有任何缺陷吗？有什么想法可以改进或简化它吗？
请记住，PC 上的应用程序可能位于甚至没有静态 IP 的消费者或小型企业网络上。
另外，据我所知，目前还没有任何东西可以满足我的要求。我看过的应用程序要求您将 iif 文件导入到手机中（特别是 ReportAway）。在应用程序的初始测试期间，导入未能导入任何内容，但没有产生任何错误消息。我不清楚数据如何从 BlackBerry 应用程序输入到 QuickBooks，但它似乎只是 CSV 文件。如果有人确实知道这方面的现有应用程序，我会很高兴了解它。然而，无论如何，我们仍然可以选择自己编程。
I need to find a solution or develop one for allowing employees to enter their "hours worked" at the end of the day and then easily and quickly "pushing" that data to Quickbooks Pro 2010.
I'm trying to formulate, in my mind, how to build this type of solution. With my understanding of QuickBooks integration I think it will look like the following:
Quickbooks Software on PC
|
|
Custom App "Linking" Online DataStore to QB (on same PC as above)
|
|
Online Data Store Such as MS SQL Server, MySQL, or CSV Files
|
|
Website or Web Service Used to Receive Data From Blackberry Phones
|
|
App on Blackberry Phone to Enter and "Push" Data To Data Store in the Cloud
Do you see any flaws in this design? Any ideas how to improve on it or simplify it?
Remember, the application on the PC will likely be on a consumer or small business network that doesn't even have static IP.
On a separate note, as near as I can tell nothing yet exists that will do what I'm looking for. The apps I have looked at require you to import iif files into your phone (specifically ReportAway). During an initial test of the app, the import failed to import anything but did not produce any error messages. It's unclear to me how the data gets input from the BlackBerry app to QuickBooks but it appears to simply be CSV files. If someone does know of an existing app for this I'd appreciate knowing about it. However, we may still opt to program our own anyway.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您的建议是正确的。我还有一些进一步的建议：
与其构建一个与 QuickBooks 一起使用的自定义应用程序，为什么不重复使用已经构建的内容呢？例如，QuickBooks Web Connector 或（如果您正在构建 SaaS 服务）同步管理器Intuit 合作伙伴平台？这两者都是专门为使 Web/远程应用程序能够与 QuickBooks 通信而设计的。 QuickBooks SDK 中包含几乎完全符合您所说的操作的 C# 示例，以及 开源QuickBooks 库 用于执行您要求的操作。
您为什么想要使用 CSV 文件来存储数据？帮自己一个忙，使用数据库。
您可以通过多个界面轻松地使手机端可用 - 为 iPhone/Web 浏览器构建一个 Web 界面，如果需要，还可以为 Blackberry 构建一个应用程序。一旦有了基础设施，实际的界面/视图的实现就应该很简单。
您是否查看过可用的用于时间跟踪的 Workplace.Intuit.com 应用 ？
You're on the right track with what you proposed. I have a few further suggestions:
Instead of building a custom app that sits alongside QuickBooks, why not re-use something that's already built? For instance, the QuickBooks Web Connector or (if you're building a SaaS service) the Sync Manager via the Intuit Partner Platform? Both of those are specifically designed to enable web/remote applications to communicate with QuickBooks. There are C# examples of doing almost exactly what you're talking about included in the QuickBooks SDK, and open source QuickBooks libraries for doing what you're asking.
Why would you ever want to use CSV files for storing data? Do yourself a favor, and use a database.
You could easily make the phone end of things available via more than once interface- build a web interface for iPhones/web browsers, and an app for Blackberry if you want. Once you have the infrastructure, the actual interface/view should be trivial to implement.
Have you looked at the available Workplace.Intuit.com apps for time tracking yet?
您想构建自己的应用程序吗？您最好的选择是构建您的手机应用程序，该应用程序调用托管 QB 的网络上某处托管的 Web 服务，该服务可以使用 QB API 将数据放在您需要的地方。或者简单地创建一个他们可以浏览的网站，该网站将调用 API，那么您甚至不需要费心使用手机应用程序。
电话/网站>>网络服务> QB/SQL
are you wanting to build your own app? Your best option is the build your phone app that makes a call to a web service hosted somewhere on the network where QB is hosted, the service can use the QB API to put the data where you need it. Or simply create a website that they can browse to that will make the call to the API, then you dont even need to bother with a phone app.
Phone/Website > Web Service > QB/SQL
我过去已经解决了这个问题，其方式与达斯汀戴维斯所描述的非常相似。就我而言，我只需将智能手机客户端应用程序连接到 php 应用程序服务器。应用服务器立即存储数据。在单独的计划过程中，应用程序服务器根据配置每 15 分钟或每 30 分钟刷新一次数据并将数据推送到 QuickBooks 服务器。如果您有兴趣，我可以提供更多详细信息。
I have solved exactly this problem in the past, in a manner very similar to as described by DustinDavis. In my case, I simply connect the smartphone client app to the php app server. App server stores the data immediately. In a separate scheduled process, app server refreshes and pushes data to QuickBooks server every 15 minutes or every 30 minutes as configured. I can provide more details if you are interested.