Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quick Books Pro Import
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows NT
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00983035
Message ID:
00983225
Views:
20
>We have a VFP application that we wrote to work with QuickBooks Pro via its transaction import utility. Basically the A/P is generated by the VFP app and then the invoice data is emported to QB's IIF format for import.
>
>The problem is that alot of the fields that QB specifies in thier import format don't actully work. QB tech support simply states that they don't support the import function. Nice approach. They should either make it work or exclude it from the software.
>
>We use Quick Books Pro 2003. We really have no reason to upgrade to 2005 except of course if they have fixed the import which I doubt.
>
>Quick Books has a developers program that is used to integrate programs into thiers. Has anyone used it? Will my FoxPro knowledge be enough for me to use it or is it based in another language.
>

Yeah, I've got an app. that pulls info. from a sales website down nightly and pushes it into QB's via the COM interface that QuickBooks has. It's A LOT better than the IIF approach.

I found it pretty easy to use; if you've use COM before (eg. automating Word, or Excel, third party controls, etc) it should be pretty straightforward. Most of the samples are in VB, though (the syntax is close to VFP, so it's relatively easy to translate it). It has it's quirks, like anything. Depending on how complex the info you are importing is, you may or may not run into them.

I think there is some sample code in the downloads section here...
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Reply
Map
View

Click here to load this message in the networking platform