Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Quick Books Pro Import
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows NT
Network:
Windows NT
Database:
Visual FoxPro
Divers
Thread ID:
00983035
Message ID:
00983225
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform