Matthew- Yup... I figured out that it was taking forever because it was trying to export calculated fields. I skipped them, and everything worked great.
best, jon > -----Original Message----- > From: Matthew Scholtz [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 26, 2002 4:45 PM > To: TechRocks Support > Subject: [support] Re: how long should it take to export a > contacts.100 file? > > > OK, I get it now. > 10,000 records should take a little while, but not 2 hours. > What file type are you exporting to? > Did you select all fields? If so, you might try selecting > only those fields that need to be imported into your target > file (i.e. only text, number, date, time fields, not > calculations.) If I remember right, there are some calcs in > that file that may be putting out very very long calc text > fields (in FMP text fields aren't limited to the usual 256 > chars. - they can be up to 64K chars.). > > BTW, why are you exporting to an intermediate file instead of > just importing directly from the .100 file to the .103 file? > > Matthew > > > At 03:16 PM 4/26/02 -0700, you wrote: > >Matthew- > > > >No, the names file (with about 1100 names) exported and imported in a > >flash, with no problems. > > > >The file that's taking forever is the "contact" file, which > stores the > >contact records for each person. That had about 10,000 records in it > >(~10 contact events per person), and is taking FOREVER. > > > >best, > >jon > > > >> -----Original Message----- > >> From: Matthew Scholtz [mailto:[EMAIL PROTECTED]] > >> Sent: Friday, April 26, 2002 3:25 PM > >> To: TechRocks Support > >> Subject: [support] Re: how long should it take to export a > >> contacts.100 file? > >> > >> > >> I assume you mean names.100? > >> No, it's not normal to take that long for 1100 recs, nor > >> should a database of 1100 recs be 100MB in size. I might try > >> doing a Save As <compressed> before exporting, or maybe even > >> try a Recover... (save a backup first). > >> FMP is slow for import/export, but not that slow. > >> > >> At 03:08 PM 4/26/02 -0700, you wrote: > >> >>>> > >> I'm in the midst of exporting my ebase files from 1.00 so I > >> can import them into 1.03 and thence into 2.0. > >> > >> The contacts.100 file was over 100MB, and has taken over 2 > >> hours (so far) to export, with no end in sight. Is this > >> normal for a database that has about 1100 names, and a max of > >> about 20 contact items per name? > >> > >> best, > >> jon > >> > >> --------------------------------------------------- > >> Jon Stahl, Program Manager > >> ONE/Northwest: Online Networking for the Environment > >> <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] > >> <http://www.onenw.org/>http://www.onenw.org > >> p: 206.286.1235 > >> f: 413.702.0213 > >> icq: 16742255 aim: jondstahl > >> > >> Subscribe to ONEList, our free monthly email newsletter about > >> using technology to protect the environment! > >> <http://www.onenw.org/onelist/>http://www.onenw.org/onelist/ > >> ------------------ 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 > >> > --------------------------------------------------------------------- > >> > >> > > > >------------------ > >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 > --------------------------------------------------------------------- > > ------------------ 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 ---------------------------------------------------------------------
