Good idea. I just did random spot checks. For example, after I pasted in the YTD amount, I scrolled over in the excel and checked the name, then checked in ebase and made sure that everything matched.
Dave Shaw wrote: > Good trick. I'll offer an additional piece. Although if the records > are exported from the same set in the same order you should have no > trouble, I am always afraid of getting the rows mixed up and getting > the wrong info on a person's record. To avoid that, you could export > a common field, record number for example, with each set of data. > When you paste them together it would be easy to compare these fields > and insure the data is consistent. > > >Yesterday I needed to export some data for a fundraising consultant we > >are working with. She wanted all kinds of info on our donors that > >doesn't seem to be covered by a single report, and wanted them all on > >one sheet (so not the individual giving history reports). I was trying > >to export to an Excel information such as YTD donations, activist > >issues, lifetime contributions, etc. along with contact info. ebase kept > >freezing up, although I don't know if this has more to do with the > >amount and type of things I was trying to export or just my computer in > >general. To get past this, I did a couple of exports and combined them. > >i.e. I exported the contact info for labels, then did a separate export > >of activist issues, another for lifetime contributions, etc then pasted > >those columns into the original excel. I thought this might be helpful > >if other folks ever have the same problem. :) > >-rrw > > > > > >------------------ > >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 > >--------------------------------------------------------------------- > > -- > -- > Dave Shaw H4 Consulting > tel: 206-954-7526 fax: 206-625-1338 > > ------------------ > 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 ---------------------------------------------------------------------
