I would also be interested in further development of this idea. We use QuickBooks in
our FrontEnd and manage simlar data in ebse (so like MAtthew, we are entering a lot
of data twice). It would obviously save much time!
-otis
Walt Daniels wrote:
> We have looked at the problem but have not actually tackled it yet. An IIF
> file is just a text file with a particular content so it should not be hard
> to constuct it line by line and write it to a text file. The hard part is
> writing a generic one rather than one tied to your particular chart of
> accounts. The problem is roughly: If you enter a sale in QB by hand it
> adjusts the approriate accounts and changes the inventory. To do this via
> IIF you need to create each of the individual pieces adjusting each account
> of what a manual user thinks of as a single transaction. Income accounts are
> easier because there is no inventory involved. One of our volunteers did
> write a program to generate IIF from the database of our previous accounting
> system so we could import the data.
>
> > -----Original Message-----
> > From: Marshall Mayer [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 29, 2001 10:16 PM
> > To: TechRocks Support
> > Subject: [support] Re: Ebase and QuickBooks
> >
> >
> > Matthew,
> >
> > Ebase, based on FileMaker Pro, will not export to an .IIF file
> > format. Will
> > QuickBooks import a .txt or an .xls file? If so, it should be
> > easy to match
> > fields.
> >
> > Marshall
> >
> > On 8/29/01 8:19 PM, "Matthew Scholtz" <[EMAIL PROTECTED]> wrote:
> >
> > > Hello All,
> > >
> > > Has anyone on the list tried to create an interface between Ebase and
> > > QuickBooks? Specifically, a client of mine wants to have a way
> > to export
> > > transactions (i.e. donations) that were entered in Ebase over
> > to QuickBooks
> > > format (.IIF) so that data entry doesn't need to happen twice.
> > Just wondering
> > > if any of you have tackled this problem, so that I don't need
> > to reinvent the
> > > wheel.
> > >
> > > TIA,
> > > Matt
> > > Matthew Scholtz
> > > Database and Non-Profit Technology Consultant
> > > Bellingham, WA
> > >
> > > Also associated with NPower, Seattle
> > > www.npower.org
> > >
> > > ------------------
> > > Reminder to each recipient: To change your list account
> > preferences, go to
> > > http://email.sparklist.com/scripts/lyris.pl?enter=support and
> > enter the email
> > > address you used to subscribe to the ebase support list::
> > > [EMAIL PROTECTED]
> > >
> > > To unsubscribe send a blank email to
> > [EMAIL PROTECTED]
> > > ---------------------------------------------------------------------
> > > ebase - Relationship Management for Nonprofits, http://www.ebase.org
> > > ---------------------------------------------------------------------
> > >
> >
> >
> > ----------------------------------------------------------------------
> > ebase - Relationship Management for Nonprofits, http://www.ebase.org
> > ----------------------------------------------------------------------
> > Marshall Mayer mailto:[EMAIL PROTECTED]
> > CEO, TechRocks http://www.techrocks.org
> > 633 Battery Street - Suite 110 phone: 415.722.7171
> > San Francisco, CA 94111-1812 USA eFax: 208.361.0149
> > ----------------------------------------------------------------------
> > Please note my new address and phone number in TechRock�s SF office.
> > ----------------------------------------------------------------------
> >
> >
> > ------------------
> > Reminder to each recipient: To change your list account preferences, go to
> > http://email.sparklist.com/scripts/lyris.pl?enter=support and
> > enter the email address you used to subscribe to the ebase
> > support list:: [EMAIL PROTECTED]
> >
> > To unsubscribe send a blank email to [EMAIL PROTECTED]
> > ---------------------------------------------------------------------
> > ebase - Relationship Management for Nonprofits, http://www.ebase.org
> > ---------------------------------------------------------------------
> >
> >
>
> ------------------
> Reminder to each recipient: To change your list account preferences, go to
> http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email
>address you used to subscribe to the ebase support list:: [EMAIL PROTECTED]
>
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
> ---------------------------------------------------------------------
--
________________________
Michael "Otis" Lavitschke
Member Services Manager
River Alliance of Wisconsin
306 E. Wilson St., Suite 2W
Madison, WI 53703
608-441-8414
[EMAIL PROTECTED]
www.wisconsinrivers.org
________________________
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
