将 QBSDK 中的全部关联到 IPP? [英] Relating Entires from QBSDK to IPP?

问题描述

我们目前正在使用 Windows QBSDK 与 QuickBooks 进行交互.我们正在评估 IPP.但是，QBSDK 使用 ListID's/TransactionID's 来标识对象，而 IPP 使用不同的方案.有没有办法确定两者之间的映射关系?

We're currently using the Windows QBSDK to interact with QuickBooks. We're evaluating IPP going forward. However, the QBSDK uses ListID's / TransactionID's to identify objects and IPP uses a different scheme. Is there a way to determine the mapping between the two?

推荐答案

在 IDN 提出了同样的问题，并被告知无法执行此翻译.但是，在合作伙伴的帮助下，仔细观察 IPP 和 QuickBooks 之间的结果，我得到了相当不错的答案.

Asked the same question at IDN and was told there is not away to perform this translation. However, a little bit of assistance from a partner, some careful watching of results between IPP and QuickBooks and I have a fairly decent answer.

QuickBooks 中的典型 ID 如下所示:

A typical ID in QuickBooks looks like this:

80000001-1296949588

第一部分是标识符，第二部分是某种形式的时间戳.

The first portion is the identifier and the second portion is some form of timestamp.

将第一部分视为 32 位十六进制数并关闭高位.在这种情况下，您将获得 1.

Treat the first portion as a 32-bit hexadecimal number and turn off the high bit. In this case, you will get 1.

如果您先在 QB 中创建记录，然后同步到 IPP，您将找到以这种方式标识的记录:

If you create the record first in QB then sync to IPP, you will find a record identified in this manner:

<Id idDomain="QB">1</Id>

如果您首先在 IPP 中创建记录，您将找到以这种方式标识的记录:

If you create the record first in IPP, you will find a record identified in this manner:

<Id idDomain="NG">1</Id>

同步后，您会发现一个外部记录引用，例如:

Once you sync, you will find an external record reference for example:

<ExternalKey idDomain="QB">3</ExternalKey>

这将与 QuickBooks 中的交易 ID 匹配:

This would match to a transaction id in QuickBooks:

80000003-1299163737

不幸的是，由于 QuickBooks 中标识符末尾附加了时间戳，因此此转换不是同构的.因此，从 QuickBooks ID 转换为基于 IPP 的 ID 很容易执行.以另一种方式翻译需要枚举 QuickBooks 中的记录并匹配 ID.

Unfortunately, this transform is not isomorphic because of the time stamp appended at the end of the identifier in QuickBooks. Therefore, translating from a QuickBooks ID to a IPP based ID is trivial to perform. Translating the other way will require an enumeration of records in QuickBooks and matching up of the ID's.

这篇关于将 QBSDK 中的全部关联到 IPP?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！