> > Carl, thanks for the rapid reply. I have been given four Excel > spread sheets > with membership information on them - current members, lifetime members, > expired members and non-member donors. Each name has a unique number - > unfortunately not totally sequential as the former data base had been > corrupted and redone at least once, maybe twice. It would please > me to be > starting all over again with totally sequentlial numbers. Do I understand > correctly that although I import the old ID numbers, ebase will > assign new > ones? If so, where are the old ones stored - are they visible or must a > search be made for them - ie will ebase display two id numbers?
If you go through the ebase import process you will wind up with new numbers. The old numbers are in a field called Legacy ID or some such. It is not on any of the normal layouts so if you need to look at it you will have to put it on a layout. > > We do not have a joining date but do have an expiration date. I see no > corresponding field in ebase - have I missed it? Ebase also has an expire date but it is computed from the last dues payment start date. This is usually easy to deal with unless you have multiyear memberships. It may be easiest to add a new field to your current database where you have subtracted off a year (or more for multiyear people) and import that into the dues payment start field. You will then also need to import the membership duration. In other words yearly is easy, multiyear messy. ------------------ 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 ---------------------------------------------------------------------
