[AccessD] Quickbooks

2000? Time for an update.  So you cracked the Byzantine IIF formats? 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Barnes
Sent: Wednesday, February 25, 2009 8:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Quickbooks

Rocky,
We had a problem with our IP yesterday and all email was lost for the rest
of the day (go figure). If you tried to send the file(s) to me, it probably
got bounced back. We have the problem fixed for now. Version of Qb from what
the people tell me is 2000.

doug at starntech.com

thanks,
 Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Barnes
Sent: Tuesday, February 24, 2009 11:43 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Quickbooks


Thanks Rocky, I be more than happy if you could sent the info.

doug at starntech.com

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, February 24, 2009 11:34 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Quickbooks


Douglas:

What version of QB are they using?  The later versions allow import and
export via XL or CSV files.

I did write a couple interfaces to QB a few years back and it was a real
PITA. Like you I found the SDK to be impenetrable.

I took a while but I finally found the IIF file layouts and it turned out to
be one of the most Kafkaesque approaches to application interfaces I've ever
seen.  I've still got the formats in a folder but I don't think I can find
the link that described how they're used.  But I can send them to you
offline if you'd like.

But check out the version your client is using first and see if it will
import from XL or CSV.  It will save a lot of aggravation.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Barnes
Sent: Tuesday, February 24, 2009 8:20 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Quickbooks

Hi group,
I acquired an older database A2K. They want to export data into an iif file
and import that into their QB's. I'm at a loss on how to create the proper
formatting for the task at hand. I've looked at the SDK from Intuit and it
very overwhelming. Does anybody have a template or other ideas on getting
this 'bear' out the door?

thanks

Douglas Barnes

Starn Technical Services
P.O. Box 1172
1057 French Street
Meadville, PA  16335

P: 814.724.1045
F: 814.337.3460

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com Internal Virus Database is out of
date.
Checked by AVG - http://www.avg.com
Version: 8.0.233 / Virus Database: 270.10.17/1932 - Release Date: 2/3/2009
7:57 AM

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com Internal Virus Database is out of
date.
Checked by AVG - http://www.avg.com
Version: 8.0.233 / Virus Database: 270.10.17/1932 - Release Date: 2/3/2009
7:57 AM

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com