Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11581 > unrolled thread

Quickbooks Integration

Started byKuno Egger <kuno.egger@gmail.com>
First post2018-05-08 09:31 -0700
Last post2018-05-24 10:08 +0100
Articles 16 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#11581 — Quickbooks Integration

FromKuno Egger <kuno.egger@gmail.com>
Date2018-05-08 09:31 -0700
SubjectQuickbooks 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]


#11584

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11653

FromKuno Egger <kuno.egger@gmail.com>
Date2018-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]


#11654

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11672

FromKuno Egger <kuno.egger@gmail.com>
Date2018-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]


#11673

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11674

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11676

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11677

FromKuno Egger <kuno.egger@gmail.com>
Date2018-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]


#11656

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11593

FromMartin <Martin@spam.spam>
Date2018-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]


#11594

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11631

FromMartin <Martin@spam.spam>
Date2018-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]


#11632

Fromdlzc <dlzc1@cox.net>
Date2018-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]


#11633

FromJames Martin <james@northwoodlumber.com>
Date2018-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]


#11662

FromMartin <Martin@spam.spam>
Date2018-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