问题描述
我正在尝试构建一个节点服务以从 Quickbooks Desktop 中提取信息.最合乎逻辑的路线似乎是 Quickbooks 桌面网络连接器.
I'm trying to build a node service to pull information from Quickbooks Desktop. The most logical route seems to be the Quickbooks Desktop Web Connector.
我已经尝试过使用 quickbooks-js 和从 wsdl 创建一个 node-soap 类,虽然服务器运行良好,但我没有看到任何关于连接的日志.
I have tried with both quickbooks-js and creating a node-soap class from the wsdl and while the server runs fine, I don't see any logs about connections.
从客户端,我一直在尝试连接到这个 nodejs 服务,但 QBWC 几乎立即停止响应.这是尝试添加我的连接的完整日志:
From the client side, I have been trying to connect to this nodejs service, but QBWC almost immediately stops responding. This is the full log for attempting to add my connection:
日志文件在 2021 年 1 月 11 日星期一 - UTC 上午 7:44 初始化
使用的时间戳格式:YYYYMMDD.HH:MM:SS UTC QBWebConnector 2.2 有已将其日志记录状态初始化为 level = DEBUG.请重新启动 QBWebConnector 以使日志级别的任何更改生效.用文件菜单清除日志.
20210111.07:44:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock 已被设置为假20210111.07:44:08 UTC:QBWebConnector.RegistryManager.setUpdateLock():************************ 更新会话解锁*********************20210111.07:44:09 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock 已被设置为假20210111.07:44:09 UTC:QBWebConnector.RegistryManager.setUpdateLock():************************ 更新会话解锁*********************20210111.07:44:09 UTC:QBWebConnector_Load():QuickBooks Web Connector 2.3.0.198 已经启动.2021 年 1 月 11 日星期一 7:44:09是20210111.07:44:09 UTC:QBWebConnector_Load():QBWC 表单加载20210111.07:44:20 UTC:QWCReader.ParseQWC():QWC 文件的内容:-通过 QuickBooks 进行访问疑难解答
IDNTS_FS1
https://8001-XXX.ws-eu03.gitpod.io
帮助对 QBWebConnector 进行故障排除快书
https://8001-XXX.ws-eu03.gitpod.io
测试
{A9A83089-7DA7-4d27-A08C-7E1626E9395A}
{AE931E67-4AA5-4374-A32D-8EA4BEC91981}
QBFS文件
0xF20210111.07:44:20 UTC:QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC):解析应用程序配置 xml 文件将其内容加载到变量中
20210111.07:44:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has beenset to False20210111.07:44:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************20210111.07:44:09 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has beenset to False20210111.07:44:09 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************20210111.07:44:09 UTC : QBWebConnector_Load() : QuickBooks Web Connector 2.3.0.198 has started. Monday, January 11, 2021 at 7:44:09AM20210111.07:44:09 UTC : QBWebConnector_Load() : QBWC Form Loaded20210111.07:44:20 UTC : QWCReader.ParseQWC() : Contents of QWC file: - Troubleshoot access via QuickBooks
IDNTS_FS1
https://8001-XXX.ws-eu03.gitpod.io
Helps troubleshoot QBWebConnector forQuickBooks
https://8001-XXX.ws-eu03.gitpod.io
test
{A9A83089-7DA7-4d27-A08C-7E1626E9395A}
{AE931E67-4AA5-4374-A32D-8EA4BEC91981}
QBFS Document
0xF20210111.07:44:20 UTC : QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC) : Parsingapplication configuration xml file to load its content to variables
从客户端,我尝试了 Quickbooks 测试连接,并收到以下日志文件(看起来有效):
From the client side, I have tried the Quickbooks testing connection, and received the following logfile (looks like it worked):
日志文件在 2021 年 1 月 8 日星期五 - UTC 下午 12:25 初始化
使用的时间戳格式:YYYYMMDD.HH:MM:SS UTC QBWebConnector 2.2 有已将其日志记录状态初始化为 level = DEBUG.请重新启动 QBWebConnector 以使日志级别的任何更改生效.用文件菜单清除日志.
20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock 已经设置为假20210108.12:25:31 UTC:QBWebConnector.RegistryManager.setUpdateLock():************************ 更新会话解锁*********************20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock 已被设置为假20210108.12:25:31 UTC:QBWebConnector.RegistryManager.setUpdateLock():************************ 更新会话解锁*********************20210108.12:25:31 UTC:QBWebConnector_Load():QuickBooks Web Connector 2.3.0.198 已经启动.2021 年 1 月 8 日星期五 12:25:31下午20210108.12:25:31 UTC : QBWebConnector_Load() : QBWC 表单加载20210108.12:26:19 UTC:QWCReader.ParseQWC():QWC 文件的内容:-通过 QuickBooks 进行访问疑难解答
IDNTS_FS1
https://test.developer.intuit.com/QBWC/TroubleshootWebServiceFS/Service.asmx帮助对 QBWebConnector 进行故障排除快书
http://developer.intuit.com/QBWebConnector/
测试
{A9A83089-7DA7-4d27-A08C-7E1626E9395A}
{AE931E67-4AA5-4374-A32D-8EA4BEC91981}
QBFS文件
0xF20210108.12:26:19 UTC:QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC):解析应用程序配置 xml 文件以将其内容加载到变量20210108.12:26:30 UTC:QBWebConnector.RegistryManager.createRegKey():为 appName = <> 创建注册表项时出错20210108.12:26:30 UTC:QBWebConnector.RegistryManager.createRegKey():原因:值不能为空.参数名称:名称20210108.12:26:30 UTC:QBWebConnector.SOAPWebService.SerializeToRegistry():保存错误通过 QuickBooks 访问注册表故障排除:对象引用不设置为对象的实例.20210108.12:26:30 UTC:QBWebConnector.SOAPWebService.ConnectToQB():连接到 QuickBooks...20210108.12:26:52 UTC:QBWebConnector.SOAPWebService.ConnectToQB():连接.,会话开始20210108.12:26:52 UTC:QBWebConnector.SOAPWebService.AddToQuickBooks():应用程序名称=通过 QuickBooks 进行访问疑难解答20210108.12:26:52 UTC:QBWebConnector.SOAPWebService.AddToQuickBooks():查询公司文件以查找所有者/文件 ID 是否存在.20210108.12:26:52 UTC:QBWebConnector.SOAPWebService.findFileIDinQB():支持的最新 QBXML 版本 = v14.020210108.12:26:52 UTC:QBWebConnector.SOAPWebService.findFileIDinQB():查询 QuickBooks 是否存在所有者/文件 ID20210108.12:26:52 UTC:QBWebConnector.SOAPWebService.findFileIDinQB():XML 转储如下:-
20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has beenset to False20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has beenset to False20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************20210108.12:25:31 UTC : QBWebConnector_Load() : QuickBooks Web Connector 2.3.0.198 has started. Friday, January 8, 2021 at 12:25:31PM20210108.12:25:31 UTC : QBWebConnector_Load() : QBWC Form Loaded20210108.12:26:19 UTC : QWCReader.ParseQWC() : Contents of QWC file: - Troubleshoot access via QuickBooks
IDNTS_FS1
https://test.developer.intuit.com/QBWC/TroubleshootWebServiceFS/Service.asmxHelps troubleshoot QBWebConnector forQuickBooks
http://developer.intuit.com/QBWebConnector/
test
{A9A83089-7DA7-4d27-A08C-7E1626E9395A}
{AE931E67-4AA5-4374-A32D-8EA4BEC91981}
QBFS Document
0xF20210108.12:26:19 UTC : QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC) : Parsingapplication configuration xml file to load its content to variables20210108.12:26:30 UTC : QBWebConnector.RegistryManager.createRegKey() : Error creating registry key for appName = <>20210108.12:26:30 UTC : QBWebConnector.RegistryManager.createRegKey() : Reason: Value cannot be null. Parameter name: name20210108.12:26:30 UTC : QBWebConnector.SOAPWebService.SerializeToRegistry() : Error savingTroubleshoot access via QuickBooks to Registry: Object reference notset to an instance of an object.20210108.12:26:30 UTC : QBWebConnector.SOAPWebService.ConnectToQB() : Connecting to QuickBooks...20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.ConnectToQB() : Connected., Session started20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Application name =Troubleshoot access via QuickBooks20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Querying companyfile to find if owner/file id exists.20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : Latest QBXML version supported = v14.020210108.12:26:52 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : Querying QuickBooks for existance of owner/file id20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : XML dump follows: -
20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.findFileIDinQB():XML 转储如下:-
20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : XML dump follows: -
20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.findFileIDinQB():状态消息:查询请求在快书20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.AddToQuickBooks():FileID 没有存在.在公司文件中创建新的 FileID20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():创建DataExtDef 名为 FileID 分配给 Company 对象的 ownerID ={A9A83089-7DA7-4d27-A08C-7E1626E9395A}20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():XML 转储如下:-
20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : Status message: A query request did not find a matching object inQuickBooks20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : FileID did notexist. Creating new FileID in company file20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : CreatingDataExtDef named FileID assigned to Company object for the ownerID ={A9A83089-7DA7-4d27-A08C-7E1626E9395A}20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dumpfollows: -
20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():XML 转储如下:-
20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dumpfollows: -
20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():数据扩展已在 QuickBooks 中为所有者 ID 创建了定义.20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.AddToQuickBooks():注册文件ID到公司备案成功.20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.enterDataExtValueInQB():XML 转储如下:-
20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : Data extensiondefinition has been created in QuickBooks for owner id.20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Registered FileID tocompany file successfully.20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.enterDataExtValueInQB() : XML dumpfollows: -
20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.enterDataExtValueInQB():XML 转储如下:-
20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.enterDataExtValueInQB() : XML dumpfollows: -
20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.enterDataExtValueInQB():数据扩展已在 QuickBooks 中为 FileID 创建值20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.AddToQuickBooks():输入的 FileID 值到公司备案成功.20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():创建DataExtDef 名为 AppLock 分配给 Company 对象的 ownerID ={A9A83089-7DA7-4d27-A08C-7E1626E9395A}20210108.12:26:53 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():XML 转储如下:-
20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.enterDataExtValueInQB() : Data extensionvalue has been created in QuickBooks for FileID20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Entered FileID valueto company file successfully.20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : CreatingDataExtDef named AppLock assigned to Company object for the ownerID ={A9A83089-7DA7-4d27-A08C-7E1626E9395A}20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dumpfollows: -
20210108.12:26:54 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():XML 转储如下:-
20210108.12:26:54 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dumpfollows: -
20210108.12:26:54 UTC:QBWebConnector.SOAPWebService.registerDataExtInQB():数据扩展已在 QuickBooks 中为所有者 ID 创建了定义.20210108.12:26:54 UTC:QBWebConnector.SOAPWebService.AddToQuickBooks():注册AppLock 到公司文件成功.20210108.12:26:54 UTC:QBWebConnector.CompanyFileLock.Send_DataExtDefAddRqXML():XML 转储如下:-
20210108.12:26:54 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : Data extensiondefinition has been created in QuickBooks for owner id.20210108.12:26:54 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Registered theAppLock to company file successfully.20210108.12:26:54 UTC : QBWebConnector.CompanyFileLock.Send_DataExtDefAddRqXML() : XML dumpfollows: -
20210108.12:26:54 UTC:QBWebConnector.CompanyFileLock.Send_DataExtDefAddRqXML():XML 转储如下:-
20210108.12:26:54 UTC : QBWebConnector.CompanyFileLock.Send_DataExtDefAddRqXML() : XML dumpfollows: -
我尝试根据规范滚动我自己的 XML 连接文件,但我最终复制了规范并只是换掉了 URL.在变量行之后我可以得到任何日志的唯一文件是 Quickbooks 测试.
I tried rolling my own XML connection file based on the spec but I eventually copy-pasta'd the spec and just swapped out the URLs. The only file I can get any log after the variable line for is the Quickbooks test one.
我觉得如果我可以修复日志记录,我至少可以看到问题所在,所以我有一些事情可以处理.如果有帮助,我正在使用 Quickbooks Pro 2021.
I feel like if I can fix logging, I can at least see what the problem is so I have something to work with. I'm using Quickbooks Pro 2021 if that helps.
感谢阅读.
推荐答案
所以似乎对域长度有一些隐含的限制.GitPod 的域很长,这似乎导致了崩溃.据我所知,它没有记录.
So there seems to be some implied limit on the domain length. GitPod's domains are quite long and that seems to have caused the crash. It is undocumented to the best of my knowledge.
这篇关于如何让 Quickbooks Desktop Web Connector 启动连接?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!