如何使用Web连接器连接QuickBooks Desktop? [英] How to connect QuickBooks Desktop using Web Connector?

问题描述

我正在尝试开发一个简单的Web窗体应用程序，以从.aspx页创建/编辑发票，并希望同步QB Desktop&使用Web连接器&的MS SQL数据库.ASMX Web服务( 2种方式同步:QBD-> Web应用程序和Web应用程序> QBD ).

I'm trying to develop a simple webform application to create/edit invoice from a .aspx page and want to sync QB Desktop & MS SQL database using web connector & .ASMX web service (2 way sync: QBD -> web app & web app > QBD).

这是我所做的:

1. 我已经设置了 QB Desktop美国版19(最新)和Web连接器
2. 通过添加.QWC文件添加了一个应用程序(我使用的是默认的.qwc文件，没有任何更改，甚至不知道该怎么做！)

第1步& 2，已完成但正在寻找适当的解决方案来从开发部分开始.我还提到了其他StackOverflow问题，并发现了此示例但不确定我必须从两者中选择哪个项目和版本.我找到了一些可以连接到QB Desktop& amp;的良好示例应用程序.使用Interop.QBFC13

Step 1 & 2, are done but looking for proper solution to start with the development part. I've referred some other StackOverflow questions and found this sample but not sure which project and version I've to choose from both of them. I'm finding some good sample applications which connects to QB Desktop & Web applications using Interop.QBFC13

我真的不知道Web连接器如何工作以及如何与我的Web应用同步.

I really don't have idea how web connector works and sync with my web app.

谢谢！

推荐答案

我使用的是默认的.qwc文件，没有任何更改，甚至不确定如何制作！

I'm using this default .qwc file without any changes, not sure even how can I make it!!

此^^^ 不起作用.曾经.没有默认" .QWC文件，它是您的应用程序专用的 ，如果您使用的是其他人的文件，则可以保证它不会起作用.

This ^^^ will not work. Ever. There is no "default" .QWC file -- it is specific to your application and if you're using someone else's it's guaranteed not to work.

创建您自己的.QWC文件.示例模板:

Create your own .QWC file. Example template:

<?xml version="1.0"?>
<QBWCXML>
    <AppName>QuickBooks Integrator</AppName>
    <AppID></AppID>
    <AppURL>https://example.com/quickbooks/server.php</AppURL>
    <AppDescription></AppDescription>
    <AppSupport>https://example.com/quickbooks/support.php</AppSupport>
    <UserName>username</UserName>
    <OwnerID>{90A44FB7-33D9-4815-AC85-AC86A7E7D1EB}</OwnerID>
    <FileID>{57F3B9B6-86F1-4FCC-B1FF-967DE1813D20}</FileID>
    <QBType>QBFS</QBType>
    <Scheduler>
        <RunEveryNMinutes>2</RunEveryNMinutes>
    </Scheduler>
    <IsReadOnly>false</IsReadOnly>
</QBWCXML>

字段:

• <AppName>这在Web连接器GUI中显示给用户
• <AppID></AppID>保留空白
• <AppSupport>...</AppSupport>必须包含指向有效页面的有效URL，该页面在被访问时将返回200 OK HTTP响应.有技术问题的用户将被定向到此处.
• <AppURL>...</AppURL>必须包含指向您的SOAP服务器的有效URL，https://...如果是远程的，http://localhost/...如果是本地的.
• <UserName>...</UserName>这将与您的SOAP服务器可用于身份验证的用户名相匹配
• <FileID>...</FileID>，只要遵循GUID格式(仅大写HE​​X字符！)，就可以进行弥补:{6904A826-7368-11DC-8317-F7AD55D89593}.它与DataExt元素有关；大多数简单的集成都可以弥补这一点.
• <OwnerID>...</OwnerID>与上述相同
• <QBType>...</QBType>指定要通过Web连接器连接的Quickbook的类型(即"QBFS"或"QBPOS")
• <Scheduler>...</Scheduler>这是一个可选元素，使用它来安排Web连接器自动如此频繁地运行
• <IsReadOnly>...</IsReadOnly>将此设置保留为false，将其设置为true将不起作用.

• <AppName> This is displayed to the user in the Web Connector GUI
• <AppID></AppID> Leave it blank
• <AppSupport>...</AppSupport> Must contain a valid URL to a valid page which returns a 200 OK HTTP response when visited. Users who have technical problems will be directed here.
• <AppURL>...</AppURL> Must contain a valid URL to your SOAP server, https://... if it's remote, http://localhost/... if it's local.
• <UserName>...</UserName> This will match the username your SOAP server understands for authentication
• <FileID>...</FileID> You can make this up as long as it follows the GUID format (uppercase HEX chars only!): {6904A826-7368-11DC-8317-F7AD55D89593}. It has something to do with DataExt elements; most simple integrations can just make this up.
• <OwnerID>...</OwnerID> Same as above
• <QBType>...</QBType> Specifies the type of Quickbooks you want to connect to with the web connector (ie "QBFS" or "QBPOS")
• <Scheduler>...</Scheduler> This is an optional element, use this to schedule the Web Connector to run every so often automatically
• <IsReadOnly>...</IsReadOnly> Leave this set to false, setting it to true will not work.

您是否阅读了100多页的PDF文件，其中准确记录了Web连接器的工作方式以及需要实现的内容?链接:

Did you read the 100+ page PDF that documents exactly how the Web Connector works and what you need to implement? Link:

• QuickBooks Web连接器程序员指南PDF

到目前为止，您尝试实施什么?

What have you tried to implement so far?

这篇关于如何使用Web连接器连接QuickBooks Desktop?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！