|
I don't know anything about ELM, or what their
goals, aims, and objectives are.
Clue me
David
----- Original Message -----
Sent: Monday, August 27, 2001 2:16
PM
Subject: [support] Re: Ebase
Hi there,
One of our ebase users, the
Environmental League of Massachussetts, is having trouble conducting finds in
the database along specific criteria. They are listed below.
Can ebase
users on this list lend a hand to suggest ways that ELM can conduct these
searches? Answer one or all. In your answer, be sure to include any
assumptions about how data is stored in order for it to be found
again.
Whey you reply, please include Jessica Champness and Jeremy
Martin at ELM in your distribution. Their emails are included here. Thanks in
advance.
Marshall
On 8/27/01 1:59 PM, "Jeremy Marin"
<[EMAIL PROTECTED]> wrote:
Marshall,
That's great!!
Here are some queries we run (or at least try to) on a regular
basis:
1. Everyone who has donated more
than or equal to $200 to us within the last 3 years, minus those who have
died, moved, or have been flagged as "do not solicit," organizations,
businesses.
2. Everyone who has donated
less than $200 to us within the last 3 years, minus those who have
died, moved, or have been flagged as "do not solicit," organizations,
businesses.
3. Everyone who has given to us
in the past, but not since 11/30/2000, minus deceased, moved, do not
solicit, organizations, businesses.
4.
Everyone who is "event responsive."
5.
Everyone who has given more than $200 more than
once.
6. Everyone who has donated
within the last three years, all marked as "free," all businesses,
organizations, and foundations.
-----Original
Message-----
From: Marshall Mayer
[mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001
9:05 AM
To: Jeremy Marin
Subject: Re:
Ebase
Jeremy,
Send me your
sample queries, and I will post them to the listserv, and then send you
responses.
Marshall
on 8/27/01 6:55 AM, Jeremy Marin at
[EMAIL PROTECTED] wrote:
As a small
non-profit we have no IT, MIS department (other than me, and my training
is in managing political campaigns, not databases of this nature.)
We have a TREMENDOUS amount of difficulty culling the names we
want for our mailings. Even simple queries give us a lot of
trouble. I have in the past suggested that a few sample queries be
put up on the web site. To the best of my knowledge this has not
occurred. I would be happy to provide you with sample queries we
think might be useful.
----------------------------------------------------------------------
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
---------------------------------------------------------------------
|
