Dave, I followed your instructions on entering a range in the post date of the payment entry screen and did come up with a list that I was able to export. Thanks for your (always wonderful) help.
Vicki Sola Development Coordinator Inland Northwest Land Trust phone: 509-462-1239 fax: 509-328-4733 -----Original Message----- From: TechRocks Support digest [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:00 PM To: support digest recipients Subject: support digest: November 29, 2001 TechRocks ebase Support list digest ----------------------------------- SUPPORT Digest for Thursday, November 29, 2001. 1. FMP 5.5 Trial Version 2. RE: FMP 5.5 Trial Version 3. exporting lists of donors 4. Re: exporting lists of donors 5. Re: exporting lists of donors 6. Re: exporting lists of donors 7. Re: update list enhancement data 8. Re: update list enhancement data 9. Re: exporting lists of donors 10. Mailing label Problems 11. Year 2000 bug? 12. question 13. Re: Mailing label Problems 14. Re: Year 2000 bug? 15. Re: Mailing label Problems ---------------------------------------------------------------------- Subject: FMP 5.5 Trial Version From: "Garry Bulllard" <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 07:43:23 -0600 X-Message-Number: 1 Not able to use the master password, only admin or user. Why?? pls.. ---------------------------------------------------------------------- Subject: RE: FMP 5.5 Trial Version From: "Walt Daniels" <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 09:38:36 -0500 X-Message-Number: 2 The trial version has many more restrictions than they advertise. I have not tried it personally but previous reports on this list and other FileMaker lists confirm that it is not useful for real work. > -----Original Message----- > From: Garry Bulllard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 8:43 AM > To: TechRocks Support > Subject: [support] FMP 5.5 Trial Version > > > Not able to use the master password, only admin or user. Why?? pls.. > > ------------------ > 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 > --------------------------------------------------------------------- > > ---------------------------------------------------------------------- Subject: exporting lists of donors From: "Vicki Sola" <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 12:16:44 -0800 X-Message-Number: 3 I am trying to export the names of donors who have given in a certain period so they can be acknowledged in our newsletter. I'm having trouble getting the ranges to work -- and what I want are people who have contributed no matter the reason (membership, regular contribution, etc.) I can't build a query from the payment screen that searches all donor records rather than the records of a particular donor. Finally, when I think I have a list by using the payment report option in reports -- I can only print it, I can't export the data to be imported into a newsletter list. What am I missing? It seems that this is a pretty standard need. Thanks to all of you who helped answer my many other questions. Vicki Sola Development Coordinator Inland Northwest Land Trust phone: 509-462-1239 fax: 509-328-4733 ---------------------------------------------------------------------- Subject: Re: exporting lists of donors From: Rachel Walden <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 15:29:25 -0800 X-Message-Number: 4 <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Searching for >0 in the $YTD field on the Home screen would be a good solution if you just want to thank the folks who have given this year so far... <p>Vicki Sola wrote: <blockquote TYPE=CITE>I am trying to export the names of donors who have given in a certain period <br>so they can be acknowledged in our newsletter. <p>I'm having trouble getting the ranges to work -- and what I want are people <br>who have contributed no matter the reason (membership, regular contribution, <br>etc.) <p>I can't build a query from the payment screen that searches all donor <br>records rather than the records of a particular donor. <p>Finally, when I think I have a list by using the payment report option in <br>reports -- I can only print it, I can't export the data to be imported into <br>a newsletter list. <p>What am I missing? It seems that this is a pretty standard need. <p>Thanks to all of you who helped answer my many other questions. <p>Vicki Sola <br>Development Coordinator <br>Inland Northwest Land Trust <br>phone: 509-462-1239 <br>fax: 509-328-4733 <p>------------------ <br>Reminder to each recipient: To change your list account preferences, go to <br><a href="http://email.sparklist.com/scripts/lyris.pl?enter=support";>http://emai l.sparklist.com/scripts/lyris.pl?enter=support</a> and enter the email address you used to subscribe to the ebase support list:: [EMAIL PROTECTED] <p>To unsubscribe send a blank email to [EMAIL PROTECTED] <br>--------------------------------------------------------------------- <br> ebase - Relationship Management for Nonprofits, <a href="http://www.ebase.org";>http://www.ebase.org</a> <br>---------------------------------------------------------------------</b lockquote> <p><br>-- <br><font face="arial"><font color="#6699CC"><font size=+0>Rachel Walden</font></font></font> <br><font face="arial"><font color="#6699CC"><font size=+0>Communications Coordinator</font></font></font> <br><font face="arial"><font color="#6699CC"><font size=+0>Southern Alliance for Clean Energy</font></font></font> <br><font face="arial"><font color="#6699CC"><font size=+0>PO Box 1842 Knoxville, TN 37901</font></font></font> <br><font face="arial"><font color="#6699CC"><font size=+0>Phone: 865-637-6055 or 1-866-522-SACE (toll-free)</font></font></font> <br><font face="arial"><font color="#6699CC"><font size=+0>Fax: 865-524-4479</font></font></font> <br><font face="arial"><font color="#6699CC"><font size=+0>Web: www.cleanenergy.org</font></font></font></html> ---------------------------------------------------------------------- Subject: Re: exporting lists of donors From: Michael Agosta <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 15:32:27 -0500 X-Message-Number: 5 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C17914.F5BA7930 Content-Type: text/plain; charset="iso-8859-1" Hi: A quick question from a group in Florida. They have just received their new list enhancement data from this year's projects. I beleive they have legacy list enhancement data on the system from last year. I think they're using a Mac, but I'm not 100% certain (I'm working off a pretty unclear voice mail message). When they import, they get a prompt: There are records in the current enhanced voter file. Do you wish to delete? With Yes/No/Cancel. If they choose to delete, does this merely update those records with the new enhancements? THANKS in advance. Michael -----Original Message----- From: Rachel Walden [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:29 PM To: TechRocks Support Subject: [support] Re: exporting lists of donors Searching for >0 in the $YTD field on the Home screen would be a good solution if you just want to thank the folks who have given this year so far... Vicki Sola wrote: I am trying to export the names of donors who have given in a certain period so they can be acknowledged in our newsletter. I'm having trouble getting the ranges to work -- and what I want are people who have contributed no matter the reason (membership, regular contribution, etc.) I can't build a query from the payment screen that searches all donor records rather than the records of a particular donor. Finally, when I think I have a list by using the payment report option in reports -- I can only print it, I can't export the data to be imported into a newsletter list. What am I missing? It seems that this is a pretty standard need. Thanks to all of you who helped answer my many other questions. Vicki Sola Development Coordinator Inland Northwest Land Trust phone: 509-462-1239 fax: 509-328-4733 ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support <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 <http://www.ebase.org> --------------------------------------------------------------------- -- Rachel Walden Communications Coordinator Southern Alliance for Clean Energy PO Box 1842 Knoxville, TN 37901 Phone: 865-637-6055 or 1-866-522-SACE (toll-free) Fax: 865-524-4479 Web: www.cleanenergy.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 --------------------------------------------------------------------- ------_=_NextPart_001_01C17914.F5BA7930 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD> <BODY> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>Hi:</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>A quick question from a group in Florida.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>They have just received their new list enhancement data from this year's projects. I beleive they have legacy list enhancement data on the system from last year. I think they're using a Mac, but I'm not 100% certain (I'm working off a pretty unclear voice mail message).</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>When they import, they get a prompt: There are records in the current enhanced voter file. Do you wish to delete?</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001> With Yes/No/Cancel.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>If they choose to delete, does this merely update those records with the new enhancements?</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>THANKS in advance.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001>Michael</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=340512620-29112001> </SPAN></FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px"> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Rachel Walden [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Thursday, November 29, 2001 6:29 PM<BR><B>To:</B> TechRocks Support<BR><B>Subject:</B> [support] Re: exporting lists of donors<BR><BR></DIV></FONT>Searching for >0 in the $YTD field on the Home screen would be a good solution if you just want to thank the folks who have given this year so far... <P>Vicki Sola wrote: <BLOCKQUOTE TYPE="CITE">I am trying to export the names of donors who have given in a certain period <BR>so they can be acknowledged in our newsletter. <P>I'm having trouble getting the ranges to work -- and what I want are people <BR>who have contributed no matter the reason (membership, regular contribution, <BR>etc.) <P>I can't build a query from the payment screen that searches all donor <BR>records rather than the records of a particular donor. <P>Finally, when I think I have a list by using the payment report option in <BR>reports -- I can only print it, I can't export the data to be imported into <BR>a newsletter list. <P>What am I missing? It seems that this is a pretty standard need. <P>Thanks to all of you who helped answer my many other questions. <P>Vicki Sola <BR>Development Coordinator <BR>Inland Northwest Land Trust <BR>phone: 509-462-1239 <BR>fax: 509-328-4733 <P>------------------ <BR>Reminder to each recipient: To change your list account preferences, go to <BR><A href="http://email.sparklist.com/scripts/lyris.pl?enter=support";>http://emai l.sparklist.com/scripts/lyris.pl?enter=support</A> and enter the email address you used to subscribe to the ebase support list:: [EMAIL PROTECTED] <P>To unsubscribe send a blank email to [EMAIL PROTECTED] <BR>--------------------------------------------------------------------- <BR> ebase - Relationship Management for Nonprofits, <A href="http://www.ebase.org";>http://www.ebase.org</A> <BR>---------------------------------------------------------------------</P ></BLOCKQUOTE> <P><BR>-- <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>Rachel Walden</FONT></FONT></FONT> <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>Communications Coordinator</FONT></FONT></FONT> <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>Southern Alliance for Clean Energy</FONT></FONT></FONT> <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>PO Box 1842 Knoxville, TN 37901</FONT></FONT></FONT> <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>Phone: 865-637-6055 or 1-866-522-SACE (toll-free)</FONT></FONT></FONT> <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>Fax: 865-524-4479</FONT></FONT></FONT> <BR><FONT face=arial><FONT color=#6699cc><FONT size=+0>Web: www.cleanenergy.org</FONT></FONT></FONT> ------------------ 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 --------------------------------------------------------------------- </P></BLOCKQUOTE> ------------------ 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 --------------------------------------------------------------------- </BODY></HTML> ------_=_NextPart_001_01C17914.F5BA7930-- ---------------------------------------------------------------------- Subject: Re: exporting lists of donors From: Dave Shaw <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 12:41:28 -0800 X-Message-Number: 6 >I am trying to export the names of donors who have given in a certain period >so they can be acknowledged in our newsletter. > >I'm having trouble getting the ranges to work -- and what I want are people >who have contributed no matter the reason (membership, regular contribution, >etc.) > >I can't build a query from the payment screen that searches all donor >records rather than the records of a particular donor. Not sure what the problem is. At the payment entry or view payments screen, in find mode, enter a range of dates, e.g., 1.1.2001...11.1.2001, in the Post Date field and hit the enter key. That gives you a list of payments within that period. Of course, a single person might be responsible for several payments. To get the list of people responsible for those payments, go to the payment entry screen and hit the Transfer to Names button. That will jump you to the names file with the set of people related to the payments in your list. If that doesn't do what you're expecting, describe in great detail what you do, what you get, and how that's different from what you expect. >Finally, when I think I have a list by using the payment report option in >reports -- I can only print it, I can't export the data to be imported into >a newsletter list. If you are using FileMaker, you can export directly from any file by selecting the menu item File>Export Records. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ---------------------------------------------------------------------- Subject: Re: update list enhancement data From: Dave Shaw <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 12:46:03 -0800 X-Message-Number: 7 --============_-1205055731==_ma============ Content-Type: text/plain; charset="us-ascii" ; format="flowed" >A quick question from a group in Florida. > >They have just received their new list enhancement data from this >year's projects. I beleive they have legacy list enhancement data on >the system from last year. I think they're using a Mac, but I'm not >100% certain (I'm working off a pretty unclear voice mail message). > >When they import, they get a prompt: There are records in the >current enhanced voter file. Do you wish to delete? > With Yes/No/Cancel. > >If they choose to delete, does this merely update those records with >the new enhancements? They _do_ wish to delete. Presumably many (most) of the records in this year's file will be the same people as last year's. The process isn't as complex as updating - they delete all the records in the file impenh_.10x, then import the new data. Same file, same relationship to the names file, just new data. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 --============_-1205055731==_ma============ Content-Type: text/html; charset="us-ascii" <!doctype html public "-//W3C//DTD W3 HTML//EN"> <html><head><style type="text/css"><!-- blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 } --></style><title>[support] Re: update list enhancement data</title></head><body> <blockquote type="cite" cite><font face="Arial" size="-1" color="#0000FF">A quick question from a group in Florida.</font></blockquote> <blockquote type="cite" cite> </blockquote> <blockquote type="cite" cite><font face="Arial" size="-1" color="#0000FF">They have just received their new list enhancement data from this year's projects. I beleive they have legacy list enhancement data on the system from last year. I think they're using a Mac, but I'm not 100% certain (I'm working off a pretty unclear voice mail message).</font></blockquote> <blockquote type="cite" cite> </blockquote> <blockquote type="cite" cite><font face="Arial" size="-1" color="#0000FF">When they import, they get a prompt: There are records in the current enhanced voter file. Do you wish to delete?</font></blockquote> <blockquote type="cite" cite><font face="Arial" size="-1" color="#0000FF"> With Yes/No/Cancel.</font></blockquote> <blockquote type="cite" cite> </blockquote> <blockquote type="cite" cite><font face="Arial" size="-1" color="#0000FF">If they choose to delete, does this merely update those records with the new enhancements?</font></blockquote> <div><br></div> <div>They _do_ wish to delete. Presumably many (most) of the records in this year's file will be the same people as last year's. The process isn't as complex as updating - they delete all the records in the file impenh_.10x, then import the new data. Same file, same relationship to the names file, just new data.</div> <div>-- <br> --<br> Dave Shaw H4 Consulting<br> tel: 206-954-7526 fax: 206-625-1338</div> ------------------ 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 --------------------------------------------------------------------- </BODY> </html> --============_-1205055731==_ma============-- ---------------------------------------------------------------------- Subject: Re: update list enhancement data From: Michael Agosta <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 15:51:18 -0500 X-Message-Number: 8 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C17917.9841EAB0 Content-Type: text/plain; charset="iso-8859-1" That's what I thought, but I figured I'd check first. -----Original Message----- From: Dave Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 3:46 PM To: TechRocks Support Subject: [support] Re: update list enhancement data A quick question from a group in Florida. They have just received their new list enhancement data from this year's projects. I beleive they have legacy list enhancement data on the system from last year. I think they're using a Mac, but I'm not 100% certain (I'm working off a pretty unclear voice mail message). When they import, they get a prompt: There are records in the current enhanced voter file. Do you wish to delete? With Yes/No/Cancel. If they choose to delete, does this merely update those records with the new enhancements? They _do_ wish to delete. Presumably many (most) of the records in this year's file will be the same people as last year's. The process isn't as complex as updating - they delete all the records in the file impenh_.10x, then import the new data. Same file, same relationship to the names file, just new data. -- -- 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 --------------------------------------------------------------------- ------_=_NextPart_001_01C17917.9841EAB0 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>[support] Re: update list enhancement data</TITLE> <STYLE type=text/css>BLOCKQUOTE { MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px } DL { MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px } UL { MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px } OL { MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px } LI { MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px } </STYLE> <META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD> <BODY> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=130535320-29112001>That's what I thought, but I figured I'd check first.</SPAN></FONT></DIV> <BLOCKQUOTE> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Dave Shaw [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Thursday, November 29, 2001 3:46 PM<BR><B>To:</B> TechRocks Support<BR><B>Subject:</B> [support] Re: update list enhancement data<BR><BR></DIV></FONT> <BLOCKQUOTE cite type="cite"><FONT color=#0000ff face=Arial size=-1>A quick question from a group in Florida.</FONT></BLOCKQUOTE> <BLOCKQUOTE cite type="cite"> </BLOCKQUOTE> <BLOCKQUOTE cite type="cite"><FONT color=#0000ff face=Arial size=-1>They have just received their new list enhancement data from this year's projects. I beleive they have legacy list enhancement data on the system from last year. I think they're using a Mac, but I'm not 100% certain (I'm working off a pretty unclear voice mail message).</FONT></BLOCKQUOTE> <BLOCKQUOTE cite type="cite"> </BLOCKQUOTE> <BLOCKQUOTE cite type="cite"><FONT color=#0000ff face=Arial size=-1>When they import, they get a prompt: There are records in the current enhanced voter file. Do you wish to delete?</FONT></BLOCKQUOTE> <BLOCKQUOTE cite type="cite"><FONT color=#0000ff face=Arial size=-1> With Yes/No/Cancel.</FONT></BLOCKQUOTE> <BLOCKQUOTE cite type="cite"> </BLOCKQUOTE> <BLOCKQUOTE cite type="cite"><FONT color=#0000ff face=Arial size=-1>If they choose to delete, does this merely update those records with the new enhancements?</FONT></BLOCKQUOTE> <DIV><BR></DIV> <DIV>They _do_ wish to delete. Presumably many (most) of the records in this year's file will be the same people as last year's. The process isn't as complex as updating - they delete all the records in the file impenh_.10x, then import the new data. Same file, same relationship to the names file, just new data.</DIV> <DIV>-- <BR>--<BR>Dave Shaw H4 Consulting<BR>tel: 206-954-7526 fax: 206-625-1338</DIV>------------------ 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 --------------------------------------------------------------------- </BLOCKQUOTE> ------------------ 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 --------------------------------------------------------------------- </BODY></HTML> ------_=_NextPart_001_01C17917.9841EAB0-- ---------------------------------------------------------------------- Subject: Re: exporting lists of donors From: Marshall Mayer <[EMAIL PROTECTED]> Date: Fri, 01 Jan 1904 00:39:25 -0700 X-Message-Number: 9 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_2365_132215 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Michael, The answer to your question is yes. They should answer YES to the prompt, t= o delete the old enhanced data. In essence, the process does a complete replace of the enhanced data, throwing out the old and importing the new. That way, what appears in ebase is only the current data. Marshall On 11/29/01 1:32 PM, "Michael Agosta" <[EMAIL PROTECTED]> wrote: > Hi: > =20 > A quick question from a group in Florida. > =20 > They have just received their new list enhancement data from this year's > projects. I beleive they have legacy list enhancement data on the system = from > last year. I think they're using a Mac, but I'm not 100% certain (I'm wor= king > off a pretty unclear voice mail message). > =20 > When they import, they get a prompt: There are records in the current > enhanced voter file. Do you wish to delete? > With Yes/No/Cancel. > =20 > If they choose to delete, does this merely update those records with the = new > enhancements? > =20 > THANKS in advance. > =20 > Michael > =20 >> -----Original Message----- >> From: Rachel Walden [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, November 29, 2001 6:29 PM >> To: TechRocks Support >> Subject: [support] Re: exporting lists of donors >>=20 >> Searching for >0 in the $YTD field on the Home screen would be a good >> solution if you just want to thank the folks who have given this year so >> far...=20 >>=20 >> Vicki Sola wrote: >> I am trying to export the names of donors who have given in a certain pe= riod >> so they can be acknowledged in our newsletter. >>=20 >> I'm having trouble getting the ranges to work -- and what I want are peo= ple >> who have contributed no matter the reason (membership, regular contribut= ion, >> etc.)=20 >>=20 >> I can't build a query from the payment screen that searches all donor >> records rather than the records of a particular donor. >>=20 >> Finally, when I think I have a list by using the payment report option i= n >> reports -- I can only print it, I can't export the data to be imported i= nto >> a newsletter list. >>=20 >> What am I missing? It seems that this is a pretty standard need. >>=20 >> Thanks to all of you who helped answer my many other questions. >>=20 >> Vicki Sola=20 >> Development Coordinator >> Inland Northwest Land Trust >> phone: 509-462-1239 >> fax: 509-328-4733 >>=20 >> ------------------ >> Reminder to each recipient: To change your list account preferences, go = to >> http://email.sparklist.com/scripts/lyris.pl?enter=3Dsupport and enter the >> email address you used to subscribe to the ebase support list:: >> [EMAIL PROTECTED] >>=20 >> To unsubscribe send a blank email to [EMAIL PROTECTED]= g >> --------------------------------------------------------------------- >> ebase - Relationship Management for Nonprofits, http://www.ebase.org >> --------------------------------------------------------------------- >>=20 >>=20 >>=20 ---------------------------------------------------------------------- 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: 212.202.4400 ---------------------------------------------------------------------- Please note my new address and phone number in TechRock=B9s SF office. ----------------------------------------------------------------------=20 --B_2365_132215 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable <HTML> <HEAD> <TITLE>Re: [support] Re: exporting lists of donors</TITLE> </HEAD> <BODY> <FONT FACE=3D"Geneva">Michael,<BR> <BR> The answer to your question is yes. They should answer YES to the prompt, t= o delete the old enhanced data.<BR> <BR> In essence, the process does a complete replace of the enhanced data, throw= ing out the old and importing the new. That way, what appears in ebase is on= ly the current data.<BR> <BR> Marshall<BR> <BR> On 11/29/01 1:32 PM, "Michael Agosta" <[EMAIL PROTECTED]&= gt; wrote:<BR> <BR> </FONT><BLOCKQUOTE><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">= Hi:<BR> </FONT></FONT></FONT><FONT FACE=3D"Geneva"> <BR> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">A quick ques= tion from a group in Florida.<BR> </FONT></FONT></FONT><FONT FACE=3D"Geneva"> <BR> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">They have ju= st received their new list enhancement data from this year's projects. I bel= eive they have legacy list enhancement data on the system from last year. I = think they're using a Mac, but I'm not 100% certain (I'm working off a prett= y unclear voice mail message).<BR> </FONT></FONT></FONT><FONT FACE=3D"Geneva"> <BR> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">When they im= port, they get a prompt: There are records in the current enhanced vot= er file. Do you wish to delete?<BR> With Yes/No/Cancel.<BR> </FONT></FONT></FONT><FONT FACE=3D"Geneva"> <BR> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">If they choo= se to delete, does this merely update those records with the new enhancement= s?<BR> </FONT></FONT></FONT><FONT FACE=3D"Geneva"> <BR> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">THANKS in ad= vance.<BR> </FONT></FONT></FONT><FONT FACE=3D"Geneva"> <BR> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">Michael<BR> <BR> </FONT></FONT></FONT><BLOCKQUOTE><FONT SIZE=3D"2"><FONT FACE=3D"Tahoma">-----Or= iginal Message-----<BR> <B>From:</B> Rachel Walden [mailto:[EMAIL PROTECTED]]<BR> <B>Sent:</B> Thursday, November 29, 2001 6:29 PM<BR> <B>To:</B> TechRocks Support<BR> <B>Subject:</B> [support] Re: exporting lists of donors<BR> <BR> </FONT></FONT><FONT FACE=3D"Geneva">Searching for >0 in the $YTD field on = the Home screen would be a good solution if you just want to thank the folks= who have given this year so far... <BR> <BR> Vicki Sola wrote: <BR> I am trying to export the names of donors who have given in a certain perio= d <BR> so they can be acknowledged in our newsletter. <BR> <BR> I'm having trouble getting the ranges to work -- and what I want are people= <BR> who have contributed no matter the reason (membership, regular contribution= , <BR> etc.) <BR> <BR> I can't build a query from the payment screen that searches all donor <BR> records rather than the records of a particular donor. <BR> <BR> Finally, when I think I have a list by using the payment report option in <= BR> reports -- I can only print it, I can't export the data to be imported into= <BR> a newsletter list. <BR> <BR> What am I missing? It seems that this is a pretty standard need. <BR> <BR> Thanks to all of you who helped answer my many other questions. <BR> <BR> Vicki Sola <BR> Development Coordinator <BR> Inland Northwest Land Trust <BR> phone: 509-462-1239 <BR> fax: 509-328-4733 <BR> <BR> ------------------ <BR> Reminder to each recipient: To change your list account preferences, go to = <BR> http://email.sparklist.com/scripts/lyris.pl?enter=3Dsupport and enter t= he email address you used to subscribe to the ebase support list:: rachel@cl= eanenergy.org <BR> <BR> To unsubscribe send a blank email to [EMAIL PROTECTED] <= BR> --------------------------------------------------------------------- <BR> ebase - Relationship Management for Nonprofits, http://www.ebase.org = <BR> ---------------------------------------------------------------------<BR> <BR> </FONT></BLOCKQUOTE></BLOCKQUOTE><FONT FACE=3D"Geneva"><BR> <BR> <BR> ----------------------------------------------------------------------<BR> ebase - Relationship Management for Nonprofits, <FONT COLOR=3D"#0000FF"= ><U>http://www.ebase.org<BR> </U></FONT>----------------------------------------------------------------= ------<BR> Marshall Mayer = &nbs = p;<FONT COLOR=3D"#0000FF"><U>mailto:[EMAIL PROTECTED]<BR> </U></FONT> CEO, TechRocks = &nbs = p; <FONT COLOR=3D"#0000FF"><U>http://www.te= chrocks.org<BR> </U></FONT> 633 Battery Street - Suite 110 &n= bsp; phone: 415.7= 22.7171<BR> San Francisco, CA 94111-1812 USA = eFax: 212.202.4400<BR> ----------------------------------------------------------------------<BR> Please note my new address and phone number in TechRock’s SF of= fice.<BR> ---------------------------------------------------------------------- <BR> </FONT> ------------------ 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 --------------------------------------------------------------------- </BODY> </HTML> --B_2365_132215-- ---------------------------------------------------------------------- Subject: Mailing label Problems From: "Global Renaissance Alliance" <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 16:56:35 -0500 X-Message-Number: 10 This is a multi-part message in MIME format. ------=_NextPart_000_007F_01C178F6.CDFD44E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am using a Laser printer to print my mailing labels, on Avery 5160 (30 = per page count). They are printing slightly above and out of the = labels- on the lines. I can't find anyhting in either manual to help me = figure out how to re-configure. We are using Filemaker 5 with ebase. = Please help! =20 Many thanks, MAtthew ________________________________ Global Renaissance Alliance P.O. Box 3259 Center Line, MI 48015 (810)754-8105 www.renaissancealliance.org [EMAIL PROTECTED] _______________________________ "Forgiveness is the answer to the child's dream of a miracle by which = what=20 is broken is made whole again, what is soiled is made clean again."=20 -Dag Hammarskj=F6ld=20 ------=_NextPart_000_007F_01C178F6.CDFD44E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am using a Laser printer to print my = mailing=20 labels, on Avery 5160 (30 per page count). They are printing = slightly=20 above and out of the labels- on the lines. I can't find anyhting in = either=20 manual to help me figure out how to re-configure. We are using = Filemaker 5=20 with ebase. Please help! </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>MAtthew</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>________________________________</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Global Renaissance Alliance<BR>P.O. Box = 3259<BR>Center Line, MI 48015</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>(810)754-8105<BR><A=20 href=3D"http://www.renaissancealliance.org";>www.renaissancealliance.org</= A><BR><A=20 href=3D"mailto:[EMAIL PROTECTED]";>office@renaissancealliance= .org</A><BR>_______________________________</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>"Forgiveness is the answer to the = child's dream of=20 a miracle by which what <BR>is broken is made whole again, what is = soiled is=20 made clean again." <BR>-Dag Hammarskj=F6ld </FONT></DIV> ------------------ 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 --------------------------------------------------------------------- </BODY></HTML> ------=_NextPart_000_007F_01C178F6.CDFD44E0-- ---------------------------------------------------------------------- Subject: Year 2000 bug? From: Melanie Phoenix <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 14:14:33 -0800 X-Message-Number: 11 This is a multi-part message in MIME format. --------------1909565290D0C050F765FB3C Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit We successfully imported our payment records but ebase/Filemaker replaced 2000 with 1900 even though it was in a four-digit format in our original database (Panorama). Is there any way to fix this in ebase/Filemaker now or how can we re-export to correct this problem? --------------1909565290D0C050F765FB3C Content-Type: text/x-vcard; charset=us-ascii; name="melanie.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Melanie Phoenix Content-Disposition: attachment; filename="melanie.vcf" begin:vcard n:Phoenix;Melanie tel;work:510.655.6169 x-mozilla-html:FALSE org:Buddhist Peace Fellowship adr:;;;Berkeley;CA;; version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;3 fn:Melanie Phoenix end:vcard --------------1909565290D0C050F765FB3C-- ---------------------------------------------------------------------- Subject: question From: Melanie Phoenix <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 14:17:54 -0800 X-Message-Number: 12 This is a multi-part message in MIME format. --------------72CCF5948B86DFB0389E0DE0 Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit Is there a way to get mailing labels for all of the people in one deposit report? --------------72CCF5948B86DFB0389E0DE0 Content-Type: text/x-vcard; charset=us-ascii; name="melanie.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Melanie Phoenix Content-Disposition: attachment; filename="melanie.vcf" begin:vcard n:Phoenix;Melanie tel;work:510.655.6169 x-mozilla-html:FALSE org:Buddhist Peace Fellowship adr:;;;Berkeley;CA;; version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;3 fn:Melanie Phoenix end:vcard --------------72CCF5948B86DFB0389E0DE0-- ---------------------------------------------------------------------- Subject: Re: Mailing label Problems From: Dave Shaw <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 15:58:02 -0800 X-Message-Number: 13 --============_-1205044211==_ma============ Content-Type: text/plain; charset="us-ascii" ; format="flowed" >I am using a Laser printer to print my mailing labels, on Avery 5160 >(30 per page count). They are printing slightly above and out of >the labels- on the lines. I can't find anyhting in either manual to >help me figure out how to re-configure. We are using Filemaker 5 >with ebase. Please help! > Working with layouts can be a bit frustrating because of the way all the layout parts - header, footer, margins, body, etc., interact. Easiest way I have found to sort out labels is to open up the lable layouts one at a time and make sure that: - margins are set to .5 inch top and bottom, .25 left and right (menu item Layouts>Layout Setup) - header and footer parts are deleted (grab the dotted line at the bottom of each part and drag it up till it disappears.) - adjust the horizontal position to suit - Filemaker doesn't have a way to allow for the 3/16 inch gutter between the label columns. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 --============_-1205044211==_ma============ Content-Type: text/html; charset="us-ascii" <!doctype html public "-//W3C//DTD W3 HTML//EN"> <html><head><style type="text/css"><!-- blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 } --></style><title>Re: [support] Mailing label Problems</title></head><body> <blockquote type="cite" cite><font face="Arial" size="-1">I am using a Laser printer to print my mailing labels, on Avery 5160 (30 per page count). They are printing slightly above and out of the labels- on the lines. I can't find anyhting in either manual to help me figure out how to re-configure. We are using Filemaker 5 with ebase. Please help! </font></blockquote> <blockquote type="cite" cite> </blockquote> <div><font face="Arial" size="-1"><br></font></div> <div><font face="Arial" size="-1"> Working with layouts can be a bit frustrating because of the way all the layout parts - header, footer, margins, body, etc., interact.</font></div> <div><font face="Arial" size="-1"><br></font></div> <div><font face="Arial" size="-1">Easiest way I have found to sort out labels is to open up the lable layouts one at a time and make sure that:</font></div> <div><font face="Arial" size="-1">- margins are set to .5 inch top and bottom, .25 left and right (menu item Layouts>Layout Setup)</font></div> <div><font face="Arial" size="-1">- header and footer parts are deleted (grab the dotted line at the bottom of each part and drag it up till it disappears.)</font></div> <div><font face="Arial" size="-1">- adjust the horizontal position to suit - Filemaker doesn't have a way to allow for the 3/16 inch gutter between the label columns.</font></div> <div><font face="Arial" size="-1"><br></font></div> <div>-- <br> --<br> Dave Shaw H4 Consulting<br> tel: 206-954-7526 fax: 206-625-1338</div> ------------------ 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 --------------------------------------------------------------------- </BODY> </html> --============_-1205044211==_ma============-- ---------------------------------------------------------------------- Subject: Re: Year 2000 bug? From: Dave Shaw <[EMAIL PROTECTED]> Date: Thu, 29 Nov 2001 16:03:57 -0800 X-Message-Number: 14 >We successfully imported our payment records but ebase/Filemaker >replaced 2000 with 1900 even though it was in a four-digit format in our >original database (Panorama). Is the date correctly formatted with 4 digits in the export file? Or did Panorama export a short date format? >Is there any way to fix this in >ebase/Filemaker now or how can we re-export to correct this problem? > Assuming you can isolate the incorrect records (by searching for all payments with a post date in 1900, for example)... Find the set of records to change Put a cursor in the post date (this is the field with the incorrect date, right?) Select the FileMaker Replace Command from the Scripts Menu Click the button to do a calculated replace Replace with this formula... Date (Month(Post Date), Day(Post Date), 2000) -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ---------------------------------------------------------------------- Subject: Re: Mailing label Problems From: [EMAIL PROTECTED] Date: Thu, 29 Nov 2001 21:57:01 EST X-Message-Number: 15 --part1_37.1ec17292.29384f7d_boundary Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit I have the same problem and I have been told it is a function of Filemaker, not ebase that causes this problem. As a really quick fix, I print the labels on plain paper, then place them in the copy machine slightly offset and print to the labels - perfect! Not the best long range fix, but if you're like me, when you need labels, you don't have all day to work on configuring the fix. --part1_37.1ec17292.29384f7d_boundary Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: 7bit <HTML><FONT FACE=arial,helvetica><FONT SIZE=2 FAMILY="SERIF" FACE="Times New Roman" LANG="0">I have the same problem and I have been told it is a function of Filemaker, not ebase that causes this problem. As a really quick fix, I print the labels on plain paper, then place them in the copy machine slightly offset and print to the labels - perfect! Not the best long range fix, but if you're like me, when you need labels, you don't have all day to work on configuring the fix.</FONT></HTML> --part1_37.1ec17292.29384f7d_boundary-- --- END OF DIGEST --- You are currently subscribed to support as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
