...

About people finders

People finders let you find individuals in Campus Cafe and produce reports about them. For example, you can search for all students from Rhode Island and generate a list of their names, addresses and majors.

There are six People Finders (filters) available for searching. These include Admissions Inquiry/Applicant, Student, Alumni/Development: Prospects, Students, Parents, Faculty, Parent, Alumni and All People. All display grids will show some common information such as first and last name to help identify the record. The other information on the display grid within each search page will vary and display information that is relevant to the group within each search. For example, on an admissions search, you would see When you use a finder, you’ll always see basic information like name. Additional information available depends on the population. For For example, when using the Prospect finder you’ll see admission progress code, entering semester, and inquiry date. On an alumni search, you might you’ll see class year, constituency, and solicitor.The query tool provided will allow you to search for groups of people using standard query logic

You can limit your results by selecting filters. For example, if you select State (is one of) and list three states, then the result set will include only people with that state in their address field within the databaseyou may wish to limit your student results to students from Rhode Island who also are majoring in Journalism and have a GPA greater than 3.5 to find students who qualify for a scholarship.

...

The various filters on the People Finder will allow you to segment and find various constituencies. For example, if you need an alumni gave last year but not this year report, you could use the last year and current year giving parameter to get the report. You could further limit the report to alumni in the last 10 class years.

Access Finders

...

Access finders

1. At the top of the screen click Filters.

2. Click the desired filter.

...

Define criteria

To return the desired narrow your results, the finder allows you to select criteria based on the desired data fields. Once on the finder, click Expand Filters to show the criteria options. Note that specific search criteria boxes may be shown or hidden by clicking the Hide/Show Fields in the upper right. 

Enter the desired criteria in each box. Some boxes contain a three-bar menu to the right that will allow the specific options for that criteria to be selected.

As an alternative to defining criteria, Campus Cafe accepts an imported list of Campus Cafe ID numbers. The source might be from an export of activity tracking items or any list of ID numbers gathered outside of the system. The ID numbers may appear more than once in the source spreadsheet, but they will be unduplicated when fed into the People Finder. The ID number input list may then be further filtered using the filter fields on the finder. 

1. Create a spreadsheet with ID numbers listed in the first column. The system will ignore data in other columns.

2. Save the spreadsheet as a .csv file
   Important: The file name cannot contain any periods. The only period should be prior to file extension csv

3. On the finder, click Add Ids to Filter

4. Click Browse and select your file

5. Click Add IDs to filer

Saving Criteria 

Criteria may be saved and the finder rerun in the future with the same criteria. A saved filter does not save the resulting population itself, it saves the criteria. The results will be dynamic.

To save the criteria, in the box to the right of the Save Filter As button, enter a name for the saved filter. To allow all users to use the saved filter, check Available For All Users? Click Save Filter As.

To run a saved filter, on the finder page, under All User's Filters or Your Filters choose the saved filter.

Using Date Variable Criteria

Finders allow the specification of specific dates. For example a saved finder could display all inquiries with an inquiry date specified between January 1, 2020 and June 30, 2020. Campus Cafe also permits saving a filter with a variable time frame. For example, all inquiries with an inquiry date of today. In this way, the results would constantly shift with each day.

For this function use the filters.

Use filters

1. Set your report format (formerly Saved Grid) to define the columns that will appear in the initial results, and either select a pre-defined set of search criteria from All Users (saved filters available to all users) or My Filters (saved filters you have created that others do not have access to):

...

The results will populate once you select one of the saved filters. After loading a saved filter, ONLY the fields used in the saved filters will populate in the “Filters” drawer, so, if the saved filter includes values for Last Name, GPA, and Credits Earned, only those fields will be selected in the Add Fields section, and only those fields will show in the Filters section. Alternatively, if the saved filters do not provide the accurate criteria, you can skip the saved filters step and build your own ad hoc filter.

2. Under Build Filters, click Add Fields to select the fields on which you’d like to filter your results. The search box below the “Add Fields” button will narrow the list of fields:

   Image Added

   The filters shown will update dynamically as each checkbox is toggled on or off. If you set a report format from step one, that will define the grid state when the results load.

3. Below the “Build Filters” section, click the Filters button to expand

   Image Added

4. For each criteria, first select the operator. Common operators include:

   • Starts With means the results must start with the text you enter. For example, you could find all people with a last name that start with Barr.

   • Equal to means the results must match the text you enter exactly. For example, to find all people with the last name of Smith you’d select equal to and enter Smith.

   • Is One Of lets you select multiple options. For example, you could use Is One Of to find all students from Rhode Island or Connecticut.

5. Enter the variable. You can use the three bars to the right of the box to select your options.
   

   Image AddedImage Added

6. Set the # of Results and # Per Page. This controls the total number of results return and how many show on each page without having to click to the next page.

7. Click Submit.

Example

...

Video tutorial

Use variable date criteria

You might want to run a finder on a regular basis and show only results that occurred in a recent time frame. For example, you might want to see all inquires that occurred within the last week. Rather than set these specific dates each time you run a a finder, you can enter a variable that automatically adjusts depending on today’s date.

For this to work, the filters must be saved and then run from the All Users' Filters or Your Filters drop downs.

1. In a date filter box enter any of the below

2. In the Save Filter As box enter a filter name.

3. Click Submit.

4. Next time the filter is run, the date with the variable will automatically fill in with the correct date.

...

2. .

Save criteria 

Each time you run the finder, it returns the results that match the criteria as of that moment. For example, if you configure the finder to return all students from Alabama on Monday you may return 10 students. On Friday, you run the finder with the same criteria and return only 9 students. This is because during the week one individual’s address was changed and they now don’t live in Alabama.

If you often search for the students meeting a particular criteria, you can save your criteria. This way you don’t need to set the criteria every time you need to identify a certain population of students. For example, you may need to run a weekly report of students from Alabama for an outside reporting requirement. Once you set the criteria, which may be just state or state and additional criteria, you can save it.

Save a filter

1. Configure your filters as desired and click Submit.

2. In Save Filter As enter a name to identify the criteria. For example, Alabama Students.
   

   Image Added

3. Optionally, to allow others to use this same criteria when they run the Student Finder, select (check) Available For All Users?

4. Click Save Filter As.

Use a saved filter

Once you’ve saved a filter, you can use it later, even if you’ve logged out of Campus Cafe and returned the next day. If someone else has saved a filter and allowed others to use it, you can use their filter, too. This can help ensure that different people across your organization use the same criteria when answering a common question like how many students do we have from Alabama?

1. Go to the Filters.

2. At the top select a filter either from All Users or My Filters.

3. Once a filter is selected, the finder shows the resulting students who match the criteria. You can adjust the criteria by clicking Filters.

Show results based on list of IDs

As an alternative to defining criteria, you can upload a list of Campus Cafe ID numbers. You might gather the IDs from an export of activity tracking items or any list of ID numbers gathered outside of Campus Cafe. The ID numbers may appear more than once in your spreadsheet, but they will be unduplicated when fed into the People Finder. The ID number input list may then be further filtered using the filter fields on the finder. 

1. Create a spreadsheet with ID numbers listed in the first column. Campus Cafe ignores data in other columns.

2. Save the spreadsheet as a .csv file
   Important: The file name cannot contain any periods. The only period should be prior to file extension csv

3. On the finder, click Add Ids to Filter.

4. Click Browse and select your file.

5. Click Add IDs to filer. The numbers show in the ID filter.

Result limit

To ensure quality system performance, Campus Cafe by default limits results to 100 total people and 100 people per page. This limit may be increased You can increase this limit by changing the numbers in the # of Results and # Per Page boxes.Number of Results boxes

...

Add/

...

hide columns to

...

This function allows the user to view additional information in the results by adding or hiding columns. This can be used to better organize data and isolate columns needed for the current task. An export will only contain columns that included on the grid.

...

Click the Column Visibility button

...

results

When you return results, you may wish to see more information about each person. For example, you may return students from Connecticut and Rhode Island and you want to see their full addresses.

If you export results, only visible columns appear in the exported file.

1. Click Column Visibility.
   

   Image Added

2. Click a column name to show or hide the column.

3. Rearrange columns by clicking and dragging the column to

...

1. a new location.

2. Sort by column by clicking the column header.

Save

...

column arrangement

The results grid, including the visible columns and the column order, may be saved. 

1. With the results loaded and the columns visible and arranged as desired, click the disk icon.

   

2. In the Name of Table Configuration box enter a name for the column arrangement.
   Tip: To make this the default arrangement, save it as *MY DEFAULT

3. Optionally check the box  Make select Make Available For All Users to make arrangement visible to all usersothers.

4. Click Save.

To launch this column arrangement in the future, after loading results, select it from the drop down.

...

Launch

...

person from

...

result

Clicking the Launch Person link (assuming this column is visible) will bring the user you to the person’s Contact Information screen profile that shows information about the individual and allows navigation to additional information and functions related to that individual dependent on the user’s security.

Export

...

results

You can export the results to an Excel spreadsheet or PDF. Only rows and columns that are selected on the grid will be exported.

1. Click the Excel or PDF button.
   

   Image Added

2. Depending on the user’s computer your browser settings the file will either open, download or prompt the user you for guidance on whether to open or save the file.

Download

...

results

The download option allows downloading the results with additional data elements not shown in the results grid.

1. Click the Download icon.

   

2. Check Select the data elements to download

3. Click Apply.

4. Click the Download button > For All.

   

5. Choose For All to download all results or For Page to download the results on the shown page

...

1. The file downloads as a .tab file.

...

Open a .tab file in Excel:

1. Open Excel.

2. Navigate Go to File > Open.

3. Click Browse.

4. To the right of the File name box, select All Files (*.*) from the drop down
   

   

5. Select your file.

6. Under Original data type, select Delimited.

7. Click Next.

8. Under Delimiters, check select only Tab.

9. Click Next.

10. Click Finish.

Send

...

text message

To use this feature you must have a third-party contract with Message Media. Once enabled and configured a user with appropriate security may send a text message from the finder. Refer to the separate text messaging documentation for setup and detailed directions. It is recommended that the text We recommended your text message include the name of the your institution and/or sender to help the recipient identify the source of the text.

1. Click Text.

2. User will be You’re brought to the texting screen. In the Member: Template Name, select an activity tracking template.

3. Optionally set additional criteria.

4. In the message box Message, compose the text message.

5. Click Submit.

6. Wait until the system Campus Cafe completes sending the message. Only users with valid mobile (MBL) phone numbers can receive a text message.

Send

...

email

You can email selected results on the People Finder either by feeding the emails into a local email software client (e.g. Outlook) or by using the Campus Café Cafe email client. The client relies on the customer configuring an email relay. In both cases, the system will return and email the email set as preferredCampus Cafe emails preferred emails.

Emailing using local client (email software on your computer)

1. Select by checking the Selected checkbox the results individuals you wish to email.

2. Click the Email buttonClick For Page Default or For > For All Default.

3. Your locally installed email client will open and the emails will appear in the BCC line.

4. Compose and send the email as normal.

Emailing using Campus Café Cafe 

Ensure pop ups are allowed for Campus CaféCafe.

1. Select by checking the Selected checkbox the results individuals you wish to email.

2. Click the Email buttonClick For Page Client or Email > For All Client.

3. A pop up will appear

4. Compose the email.

5. Click send Send.

Add tracking items-sending personalized emails/letters

This function allows the user to You can add a batch of items to the activity tracking system based on the people selected in the grid. For example, the user you may wish to add a phone reminder to call the 10 people on list in 10 days.

...

Follow these directions if the activity does not involve sending an email or if the activity is pre-configured with an associated workflow that sends an email.

1. Select by checking the Selected checkbox the results individuals you wish to add the activity to.

2. Click Add ActivityChoose Add for All or Add for Page > For All.

3. In the Member: Template Name, select an activity tracking template.

4. Optionally tie the activity to a specific semester. This might be is useful if the activity relates to a specific class in a specific semester or financial aid for a specific semester.

5. In the Add Only For These People box you can choose whether to send the message to everyone selected, only those that do not have the activity tracking item or only those that do not have the item for the set semester.

6. Optionally add a comment Comment.

7. Optionally assign a user User.

8. Optionally add a long comment Long Comment.

9. Click Submit.

Find

...

related people

You can use the finders to find people related to the individuals returned as results. For example, you may wish to find all parents of a group of students. 

1. Navigate Go to the desired filter finder.

2. Click Expand Filters.

3. In the Relationship Type filter choose select one or more types of relationships.
   Tip: If the Relationship Type box does not appear, in the upper left click Hide/Show Fields.

4. Click Submit.

5. Click Column Visibility; fields that start with "Relationship" provide additional information. The below are frequently used columns.

   • Relationship Type

   • Relationship Person

   • Relationship Email

   • Relationship Phone

   • Relationship Mobile Phone

Download Related People

To download related people, click Download > Relationships for Page or Relationships for All.