[lug] perl mod for quickbooks

j davis davis_compz at hotmail.com
Tue Jun 4 16:56:52 MDT 2002


well,
  i cant find any docs on the quickbooks mod so i checked out the excel mods
for perl :)  So, you take any iif file from quickbooks drop it in excel, 
literllay
then  use Spreadsheet::WriteExcel and Spreadsheet::ParseExcel then just
resave the file as a iif. No problem,...right?

thanks
jd

>From: Evelyn Mitchell <efm at tummy.com>
>To: j davis <davis_compz at hotmail.com>
>Subject: Re: [lug] perl mod for quickbooks
>Date: Tue, 4 Jun 2002 14:59:17 -0600
>MIME-Version: 1.0
>Received: from tummy.com ([198.49.126.3]) by hotmail.com with Microsoft 
>SMTPSVC(5.0.2195.4905); Tue, 4 Jun 2002 13:58:16 -0700
>Received: (qmail 15030 invoked by uid 10); 4 Jun 2002 20:59:38 -0000
>Received: (qmail 27708 invoked by uid 500); 4 Jun 2002 20:59:17 -0000
>Message-ID: <20020604145917.A27699 at tummy.com>
>References: <F185QVXwR1IM9QX2CTp00014b25 at hotmail.com>
>User-Agent: Mutt/1.2.5.1i
>In-Reply-To: <F185QVXwR1IM9QX2CTp00014b25 at hotmail.com>; from 
>davis_compz at hotmail.com on Tue, Jun 04, 2002 at 02:30:08AM +0000
>Return-Path: efm at tummy.com
>X-OriginalArrivalTime: 04 Jun 2002 20:58:16.0778 (UTC) 
>FILETIME=[8C981AA0:01C20C0A]
>
>Well, I haven't actually done anything with it, but if I do, I'll be happy
>to discuss it on the list.
>
>Evelyn
>
>* On 2002-06-04 02:30 j davis <davis_compz at hotmail.com> wrote:
> > this is good to know, if you have personal exp. with manipulating 
>quickbooks
> > via perl i would love to talk to you a little in depth, and i would
> > in return gladly disclose anything i know or figure out. Could
> > you please email me directly ....davis_compz at hotmail.com. I look
> > forward in hearing your take on perl and quickbooks.
> >
> > thanks alot
> > jd
> >
> >
> > >From: Evelyn Mitchell <efm at tummy.com>
> > >Reply-To: lug at lug.boulder.co.us
> > >To: lug at lug.boulder.co.us
> > >Subject: Re: [lug] perl mod for quickbooks
> > >Date: Mon, 3 Jun 2002 15:38:43 -0600
> > >MIME-Version: 1.0
> > >Received: from [66.54.152.73] by hotmail.com (3.2) with ESMTP id
> > >MHotMailBEC52D4A0066400431DF4236984906850; Mon, 03 Jun 2002 14:40:26 
>-0700
> > >Received: (qmail 24566 invoked by uid 0); 3 Jun 2002 21:40:11 -0000
> > >Received: from localhost (HELO community.tummy.com)
> > >(?EBYJnNoa9Z6WyIIDFiHDMkNdjKDKqdRA?@127.0.0.1)  by localhost with SMTP; 
>3
> > >Jun 2002 21:40:03 -0000
> > >Received: (qmail 24388 invoked by alias); 3 Jun 2002 21:39:26 -0000
> > >Received: (qmail 24383 invoked by uid 0); 3 Jun 2002 21:39:23 -0000
> > >Received: from secure.tummy.com (HELO tummy.com)
> > >(?I2DMihgYe2lSVHPoA1rYwVmJGoPYp57u?@198.49.126.3)  by 
>community.tummy.com
> > >with SMTP; 3 Jun 2002 21:39:22 -0000
> > >Received: (qmail 23556 invoked by uid 10); 3 Jun 2002 21:39:24 -0000
> > >Received: (qmail 17454 invoked by uid 500); 3 Jun 2002 21:38:43 -0000
> > >>From lug-admin at lug.boulder.co.us Mon, 03 Jun 2002 14:41:57 -0700
> > >Return-Path: <alias-blug_dom-lug-owner at lug.boulder.co.us>
> > >Delivered-To: 
>mailman-lists.lug.boulder.co.us-lug at lists.lug.boulder.co.us
> > >Delivered-To: alias-blug_dom-lug at lug.boulder.co.us
> > >Message-ID: <20020603153843.B17182 at tummy.com>
> > >References: <F61KqTAc3PXpJaV9Uhk00014aab at hotmail.com>
> > >User-Agent: Mutt/1.2.5.1i
> > >In-Reply-To: <F61KqTAc3PXpJaV9Uhk00014aab at hotmail.com>; from
> > >davis_compz at hotmail.com on Mon, Jun 03, 2002 at 09:35:01PM +0000
> > >Sender: lug-admin at lug.boulder.co.us
> > >Errors-To: lug-admin at lug.boulder.co.us
> > >X-BeenThere: lug at lug.boulder.co.us
> > >X-Mailman-Version: 2.0.8
> > >Precedence: bulk
> > >List-Help: <mailto:lug-request at lug.boulder.co.us?subject=help>
> > >List-Post: <mailto:lug at lug.boulder.co.us>
> > >List-Subscribe:
> > 
> ><http://lists.lug.boulder.co.us/mailman/listinfo/lug>,<mailto:lug-request at lug.boulder.co.us?subject=subscribe>
> > >List-Id: Boulder (Colorado) Linux Users Group -- General Mailing List
> > ><lug.lug.boulder.co.us>
> > >List-Unsubscribe:
> > 
> ><http://lists.lug.boulder.co.us/mailman/listinfo/lug>,<mailto:lug-request at lug.boulder.co.us?subject=unsubscribe>
> > >List-Archive: <http://lists.lug.boulder.co.us/pipermail/lug/>
> > >
> > >Excel can export to csv, perl can read csv. Quickbooks can also export
> > >directly to csv. (Choose print to file, csv.)
> > >
> > >I've downloaded pm.asp, but haven't played with it.
> > >
> > >Please report back, I'd be very interested in hearing how it goes.
> > >
> > >* On 2002-06-03 21:35 j davis <davis_compz at hotmail.com> wrote:
> > > >
> > > >
> > > > Hi,
> > > > Im trying to have perl get data from quickbooks. There is a 
>quickbook
> > >mod
> > > > here
> > > >    http://developer.intuit.com/downloads/pm.asp
> > > > i was wondering if anybody used this , and ifso can point
> > > > me to some decent docs. Or maybe some one can tell me another way,
> > > > i guess you can export most data from qb to excell...maybe perl can
> > > > get it through excel?
> > > >
> > > > Please Help,
> > > > jd
> > > >
> > > > _________________________________________________________________
> > > > Chat with friends online, try MSN Messenger: 
>http://messenger.msn.com
> > > >
> > > > _______________________________________________
> > > > Web Page:  http://lug.boulder.co.us
> > > > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> > > > Join us on IRC: lug.boulder.co.us port=6667 channel=#colug
> > >
> > >--
> > >Regards,                    tummy.com, ltd
> > >Evelyn Mitchell             Linux Consulting since 1995
> > >efm at tummy.com               Senior System and Network Administrators
> > >                             http://www.tummy.com/
> > >_______________________________________________
> > >Web Page:  http://lug.boulder.co.us
> > >Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> > >Join us on IRC: lug.boulder.co.us port=6667 channel=#colug
> >
> >
> >
> >
> > _________________________________________________________________
> > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> >
> > _______________________________________________
> > Web Page:  http://lug.boulder.co.us
> > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> > Join us on IRC: lug.boulder.co.us port=6667 channel=#colug
>
>--
>Regards,                    tummy.com, ltd
>Evelyn Mitchell             Linux Consulting since 1995
>efm at tummy.com               Senior System and Network Administrators
>                             http://www.tummy.com/




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com




More information about the LUG mailing list