[Odb-help] Label Printing Issues, Excluding People from a list

[odb-help@lists.democracygroups.org]

Good afternoon:

  Three brief items today:

1) The Conference Call for ODB users is upon us... it will be
    tomorrow (tuesday) at 6pm EST. If you are not already
   signed up for this and you want to participate, just email
   us or call 617-426-0828 for the dial in number.

2) A union in Massachusetts found that when they tried to print Avery
  labels, the very first line of the labels on the top of the page was
  not printing properly. It was printing too high on the page.

  This seems to be a problem on more than one printer.  Our only
  fear is that if we set ODB to start printing any lower than it does,
  it might cause problems for other users.  Does anyone have
  experience tweaking their printer settings (not their ODB settings)
  to resolve this kind of problem?

3) Excluding People from a list

  You all might notice that it is difficult in ODB to exclude
  individuals from a list.   Of course you know how to exclude
  them if there is a database code you can select that will accomplish
  the trick.  By sometimes what you want to do is exclude a
  specific record, so you are sure not to exclude people from the
  list who you never intended to exclude.  Well, actually it is not as
  difficult as we once thought.

  Thanks to developer Steve Wishengrad, we have a solution for you:

Say you have a list of 100 donors but Beyonce Carnegie and Britney
Rockefeller shouldn't be included in your list.  The best way to
exclude them is to open Beyonce's and Britney's records and then
look for the ID number, which is in the title of the People Entry window.

Say Beyonce has ID #2101 and Britney has #2158...

All you do now is go into select records to pull up your donor list
(presumably a list that includes Britney and Beyonce), say it has
100 records.

Then, still in the same window, do the following:

a. Click on "View Custom Query"
b. Click on "Add SQL to further restrict your search"
c. Type into the Add SQL box:

people.id not in (2101, 2158)

Then click search again and your 100 records will be reduced to 98.
You can put as many items in the list as you want, as long as
all of the numbers are comma separated.

Then you can click OK and then view or print the records you are
looking for!