I haven't tried it, but there is software from this site:
http://www.peterssoftware.com/dfm.htm that appears to translate date into
Quickbooks format. I believe that the IIF format generates more than one
line of date for every record of a database, so creating the format,
oneself, isn't trivial.
If you go to that site, there is a trial version that can be downloaded. If
it works, let us all know.
As Walt pointed out, there may be some manipulations that have to occur
prior to creating the IIF format. DFM may be able to handle that, as well.
Good luck.
Jonathan Sibley
At 11:55 AM 8/30/01, you wrote:
>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
>---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
