Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #11581 > unrolled thread
| Started by | Kuno Egger <kuno.egger@gmail.com> |
|---|---|
| First post | 2018-05-08 09:31 -0700 |
| Last post | 2018-05-24 10:08 +0100 |
| Articles | 16 — 4 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Quickbooks Integration Kuno Egger <kuno.egger@gmail.com> - 2018-05-08 09:31 -0700
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-09 11:07 -0400
Re: Quickbooks Integration Kuno Egger <kuno.egger@gmail.com> - 2018-05-15 17:42 -0700
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-16 08:47 -0400
Re: Quickbooks Integration Kuno Egger <kuno.egger@gmail.com> - 2018-05-28 16:32 -0700
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-29 08:08 -0400
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-29 08:49 -0400
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-29 14:42 -0400
Re: Quickbooks Integration Kuno Egger <kuno.egger@gmail.com> - 2018-05-29 14:39 -0700
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-16 10:23 -0400
Re: Quickbooks Integration Martin <Martin@spam.spam> - 2018-05-10 12:51 +0100
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-10 10:50 -0400
Re: Quickbooks Integration Martin <Martin@spam.spam> - 2018-05-14 16:20 +0100
Re: Quickbooks Integration dlzc <dlzc1@cox.net> - 2018-05-14 09:20 -0700
Re: Quickbooks Integration James Martin <james@northwoodlumber.com> - 2018-05-14 14:32 -0400
Re: Quickbooks Integration Martin <Martin@spam.spam> - 2018-05-24 10:08 +0100
| From | Kuno Egger <kuno.egger@gmail.com> |
|---|---|
| Date | 2018-05-08 09:31 -0700 |
| Subject | Quickbooks Integration |
| Message-ID | <7cc9f54b-e6df-4b38-9a24-e17543c96ef9@googlegroups.com> |
Hello from British Columbia, Does anyone know of a Quickbooks plug-in that works with VO28 / Windows 10? I have tried the /nSoftware product but I just could not get my VO app to load the Active-X control. No matter what I tried the message kept coming back: Function: OLEOBJECT:CREATEFROMAPPDOCSTORAGE Description: Object creation failed I used to use Scribble Software's SBO Bridge but something about VO28 SP4 or Windows 10 that broke it. Any advice would be greatly appreciated. Kuno
[toc] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-09 11:07 -0400 |
| Message-ID | <pcv2r2$ueb$1@dont-email.me> |
| In reply to | #11581 |
Some time ago I used it and it works fine. I had to make some modifications of the later Quickbooks releases. It's been some time but I could try to answer some questions. James On 2018-05-08 12:31 PM, Kuno Egger wrote: > Hello from British Columbia, > > Does anyone know of a Quickbooks plug-in that works with VO28 / Windows 10? > > I have tried the /nSoftware product but I just could not get my VO app to load the Active-X control. No matter what I tried the message kept coming back: > > Function: OLEOBJECT:CREATEFROMAPPDOCSTORAGE > Description: Object creation failed > > I used to use Scribble Software's SBO Bridge but something about VO28 SP4 or Windows 10 that broke it. > > Any advice would be greatly appreciated. > > Kuno >
[toc] | [prev] | [next] | [standalone]
| From | Kuno Egger <kuno.egger@gmail.com> |
|---|---|
| Date | 2018-05-15 17:42 -0700 |
| Message-ID | <7c3b2a7c-6cfe-4f60-bf2f-82dd459727b3@googlegroups.com> |
| In reply to | #11584 |
Hello James, Thanks for your offer to answer some questions about your experience with QB integration. Did you use SBO Bridge or some other product? Was it with VO28 SP4 and Windows 10? Thanks, Kuno
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-16 08:47 -0400 |
| Message-ID | <pdh99t$dok$1@dont-email.me> |
| In reply to | #11653 |
I did use SBO bridge, but had to modify it for some of the new versions of QB. The QB SDK was very helpful as you could make files manually, check them out, get the error messages, and then when it worked, write the program to make files like that. I used the SBO routines to make the xml files, and also used SBO to connect to the QB API. We used it in XP, Vista, Windows 7, and maybe Windows 10. I don't think the cersion of Windows matters as you are using the QB API and a program you write. I am using VO28 SP3. James On 2018-05-15 08:42 PM, Kuno Egger wrote: > Hello James, > > Thanks for your offer to answer some questions about your experience with QB integration. Did you use SBO Bridge or some other product? Was it with VO28 SP4 and Windows 10? > > Thanks, > > Kuno >
[toc] | [prev] | [next] | [standalone]
| From | Kuno Egger <kuno.egger@gmail.com> |
|---|---|
| Date | 2018-05-28 16:32 -0700 |
| Message-ID | <522dcf15-f070-4710-bd76-56bdb991cbf8@googlegroups.com> |
| In reply to | #11654 |
Hello James, Thanks for the advice. I had it working fine as well on VO28 SP3. When I upgraded to SP4 it broke. Now when I try to get SBO Bridge and QB to shake hands my program crashes. Any idea where I should look? Regards Kuno
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-29 08:08 -0400 |
| Message-ID | <pejfrd$kbm$1@dont-email.me> |
| In reply to | #11672 |
Do you have the debug on full when compiling? Are there no compiling errors? Since I didn't use SP4 I don't know what changed. What is the error when it crashes? James On 05/28/2018 07:32 PM, Kuno Egger wrote: > Hello James, > > Thanks for the advice. I had it working fine as well on VO28 SP3. When I upgraded to SP4 it broke. Now when I try to get SBO Bridge and QB to shake hands my program crashes. Any idea where I should look? > > Regards > > Kuno >
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-29 08:49 -0400 |
| Message-ID | <peji8n$53k$1@dont-email.me> |
| In reply to | #11672 |
Here is the init() of the QuickbooksSDK. It does not seem like rocket
science. The rest of the interface is making the xml files which you
could likely write yourself. I included only the lines that do something
and the note before it.
Method Init() CLASS QuickbooksSDK
// NOTE: Tricky, Tricky, we do not exactly instantiate an
IRrequestProcessor object,
// instead we simply "cast" the COM object pointer into a VO object.
This works
// because we have ensured that our class definition has a VTable
exactly the same
// shape as the COM object's.
SELF:oIRequestProcessor := IRequestProcessor3{}
Maybe someone else knows if this is the problem. Other than that it is
quite straightforward VO code.IRequestProcessor3 is the com interface
with QBXMLRP2.
James
On 05/28/2018 07:32 PM, Kuno Egger wrote:
> Hello James,
>
> Thanks for the advice. I had it working fine as well on VO28 SP3. When I upgraded to SP4 it broke. Now when I try to get SBO Bridge and QB to shake hands my program crashes. Any idea where I should look?
>
> Regards
>
> Kuno
>
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-29 14:42 -0400 |
| Message-ID | <pek6um$lso$1@dont-email.me> |
| In reply to | #11672 |
I looked at your first post again. Did you try to run the program in administrator mode? I had to do that with VO at one point after a Windows 10 update. James On 05/28/2018 07:32 PM, Kuno Egger wrote: > Hello James, > > Thanks for the advice. I had it working fine as well on VO28 SP3. When I upgraded to SP4 it broke. Now when I try to get SBO Bridge and QB to shake hands my program crashes. Any idea where I should look? > > Regards > > Kuno >
[toc] | [prev] | [next] | [standalone]
| From | Kuno Egger <kuno.egger@gmail.com> |
|---|---|
| Date | 2018-05-29 14:39 -0700 |
| Message-ID | <9cbc2bec-42d7-4e2d-9cb9-e76bcc41216a@googlegroups.com> |
| In reply to | #11676 |
Hello James, Thanks - I appreciate the tips - gives me some angles I hadn't thought of. Kuno
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-16 10:23 -0400 |
| Message-ID | <pdhesq$k94$1@dont-email.me> |
| In reply to | #11653 |
I'm thinking you need to make sure you have the latest quickbooks SDK,
and you may need to use a different Request Processor. It was some time
ago, but I remember I needed to add another IRequestProcessor. SBO came
with IRequestProcessor. I copied every file and called it
IRequestProcessor3. Then in QuickBooksSDK:Init I pointed it to
IRequestProcessor3{}. Whether I changed anything I don't remember, but
it wasn't much. I could add info windows to show what was going on.
But I would check that you can use the tool that comes with the SDK and
talk to Quickbooks. Then make a small program of your own where you can
talk to QB. Then go from there.
James
On 2018-05-15 08:42 PM, Kuno Egger wrote:
> Hello James,
>
> Thanks for your offer to answer some questions about your experience with QB integration. Did you use SBO Bridge or some other product? Was it with VO28 SP4 and Windows 10?
>
> Thanks,
>
> Kuno
>
[toc] | [prev] | [next] | [standalone]
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2018-05-10 12:51 +0100 |
| Message-ID | <pd1bp0$m1p$1@dont-email.me> |
| In reply to | #11581 |
A customer bought Quackbooks. They wanted us to export invoices for QB to import. We found the whole project was too difficult (no import option and absolutely no help from the suppliers) so we took the decision to not support the product as Quickbooks would prefer you to go elsewhere, here it is Sage Line 50. I would recommend a better product and to let people know why. There are plenty of packages out there with a CSV import. On 08/05/2018 17:31, Kuno Egger wrote: > Hello from British Columbia, > > Does anyone know of a Quickbooks plug-in that works with VO28 / Windows 10? > > I have tried the /nSoftware product but I just could not get my VO app to load the Active-X control. No matter what I tried the message kept coming back: > > Function: OLEOBJECT:CREATEFROMAPPDOCSTORAGE > Description: Object creation failed > > I used to use Scribble Software's SBO Bridge but something about VO28 SP4 or Windows 10 that broke it. > > Any advice would be greatly appreciated. > > Kuno >
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-10 10:50 -0400 |
| Message-ID | <pd1m7v$q6p$1@dont-email.me> |
| In reply to | #11593 |
I would say that Quickbooks integration is actually very good. Once you get it going it works very well. We real time created invoices in a VO program and put them into QB as we made them. That way the complex invoicing could be done in VO, yet the AR, AP, Payroll, etc. could be done in QB itself. Only payroll cannot be integrated very well (basically not at all for transactions). We also did not do inventory control in QB. James On 2018-05-10 07:51 AM, Martin wrote: > A customer bought Quackbooks. They wanted us to export invoices for QB > to import. > > We found the whole project was too difficult (no import option and > absolutely no help from the suppliers) so we took the decision to not > support the product as Quickbooks would prefer you to go elsewhere, here > it is Sage Line 50. > > I would recommend a better product and to let people know why. > > There are plenty of packages out there with a CSV import. > > On 08/05/2018 17:31, Kuno Egger wrote: >> Hello from British Columbia, >> >> Does anyone know of a Quickbooks plug-in that works with VO28 / >> Windows 10? >> >> I have tried the /nSoftware product but I just could not get my VO app >> to load the Active-X control. No matter what I tried the message kept >> coming back: >> >> Function: OLEOBJECT:CREATEFROMAPPDOCSTORAGE >> Description: Object creation failed >> >> I used to use Scribble Software's SBO Bridge but something about VO28 >> SP4 or Windows 10 that broke it. >> >> Any advice would be greatly appreciated. >> >> Kuno >> >
[toc] | [prev] | [next] | [standalone]
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2018-05-14 16:20 +0100 |
| Message-ID | <pdc9fd$qak$1@dont-email.me> |
| In reply to | #11594 |
I am very surprised as the writers of QB were pretty evasive and would not say any more than contact your supplier. Our customer just gave up and went Sage On 10/05/2018 15:50, James Martin wrote: > I would say that Quickbooks integration is actually very good. Once you > get it going it works very well. We real time created invoices in a VO > program and put them into QB as we made them. That way the complex > invoicing could be done in VO, yet the AR, AP, Payroll, etc. could be > done in QB itself. Only payroll cannot be integrated very well > (basically not at all for transactions). We also did not do inventory > control in QB. > > James > > On 2018-05-10 07:51 AM, Martin wrote: >> A customer bought Quackbooks. They wanted us to export invoices for QB >> to import. >> >> We found the whole project was too difficult (no import option and >> absolutely no help from the suppliers) so we took the decision to not >> support the product as Quickbooks would prefer you to go elsewhere, >> here it is Sage Line 50. >> >> I would recommend a better product and to let people know why. >> >> There are plenty of packages out there with a CSV import. >> >> On 08/05/2018 17:31, Kuno Egger wrote: >>> Hello from British Columbia, >>> >>> Does anyone know of a Quickbooks plug-in that works with VO28 / >>> Windows 10? >>> >>> I have tried the /nSoftware product but I just could not get my VO >>> app to load the Active-X control. No matter what I tried the message >>> kept coming back: >>> >>> Function: OLEOBJECT:CREATEFROMAPPDOCSTORAGE >>> Description: Object creation failed >>> >>> I used to use Scribble Software's SBO Bridge but something about VO28 >>> SP4 or Windows 10 that broke it. >>> >>> Any advice would be greatly appreciated. >>> >>> Kuno >>> >>
[toc] | [prev] | [next] | [standalone]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2018-05-14 09:20 -0700 |
| Message-ID | <b101c725-952c-42c7-b564-931205de7e0e@googlegroups.com> |
| In reply to | #11631 |
Dear Martin: On Monday, May 14, 2018 at 8:20:14 AM UTC-7, Martin wrote: > I am very surprised as the writers of QB were pretty > evasive and would not say any more than contact your > supplier. They have an extensive API, and support their registered developers. And frankly I find their API as clear as mud. I suspect they are afraid of exposing vulnerabilities, ones they'd have to fix, as the root of the evasiveness. David A. Smith
[toc] | [prev] | [next] | [standalone]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2018-05-14 14:32 -0400 |
| Message-ID | <pdckof$u5k$1@dont-email.me> |
| In reply to | #11632 |
It is simply a matter of creating xml files and telling QB to import them. Other than payroll, you can do many things with it. I even set up a system to share one QB installation among many users by creating one program to talk to QB, and the other terminals talked to my interface program. You have to install the QB SDK and then you can send xml files to QB and it sends answers back in xml. They give the format of the files. James On 2018-05-14 12:20 PM, dlzc wrote: > Dear Martin: > > On Monday, May 14, 2018 at 8:20:14 AM UTC-7, Martin wrote: >> I am very surprised as the writers of QB were pretty >> evasive and would not say any more than contact your >> supplier. > > They have an extensive API, and support their registered developers. And frankly I find their API as clear as mud. I suspect they are afraid of exposing vulnerabilities, ones they'd have to fix, as the root of the evasiveness. > > David A. Smith >
[toc] | [prev] | [next] | [standalone]
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2018-05-24 10:08 +0100 |
| Message-ID | <pe5vej$vqu$1@dont-email.me> |
| In reply to | #11632 |
Still no problem for us as only one UK customer ever had it, most just get one of the Sage products. On 14/05/2018 17:20, dlzc wrote: > Dear Martin: > > On Monday, May 14, 2018 at 8:20:14 AM UTC-7, Martin wrote: >> I am very surprised as the writers of QB were pretty >> evasive and would not say any more than contact your >> supplier. > > They have an extensive API, and support their registered developers. And frankly I find their API as clear as mud. I suspect they are afraid of exposing vulnerabilities, ones they'd have to fix, as the root of the evasiveness. > > David A. Smith >
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web