Transcript Enriching Ellucian Recruiter Suspect and

Recruiter Enrichment
the New Age
Enrich Prospects or Suspects and
Eliminate Duplicates
Presented by: Steve Mason & David Morelli
Pacific University Oregon
April 9, 2013
Session ID 2699
Session ID 2699
1
About Pacific University Oregon
• Pacific University Oregon (Ory-gun)
– Founded in 1849 for Oregon Trail Orphans
– Small, private university with campuses in Forest
Grove, Hillsboro and Eugene, Oregon
– 5 Colleges; Arts & Sciences, Optometry, Education,
Health Professions and Business
– 3,700 FTE, Undergraduate & Professional, split 50/50
– Colleague since 1993, ODS 2008, Recruiter 2011.
– Mascot is Boxer, a Chinese qilin
Session ID 2699
2
2
Pacific University is located in the Tualatin Wine Country
Session ID 2699
3
3
Pacific University Oregon – More Information
http://www.pacificu.edu/multimedia/ for Pacific
University Year in Review, Boxer Tales, and
Campus Life
http://www.pacificu.edu/about/location/direction
s-forest-grove.cfm/ for directions
http://www.pacificu.edu/admissions/ for
Introduction to Pacific University
http://www.youtube.com/watch?v=WoXvH2aa_A for view of Forest Grove area
Session ID 2699
4
Session Rules of Etiquette
• Please turn off your cell phone/pager
• If you must leave the session early, please
do so as discreetly as possible
• Please avoid side conversation during the
session
Thank you for your cooperation!
Session ID 2699
5
Introduction
With the change from CRM 4 to CRM 2011 the enrichment process for
Recruiter has become easier for the majority of applications. This
presentation will provide an overview of the usual situation as an
introduction to the Enrichment process.
Then we will present the method used for a complex enrichment. In
this example, we compare Suspect records to Prospect records to
identify overlap, and then enrich the Suspect records with a flag that
will allow their deletion.
The complex example will presume a need to view the underlying SQL
tables, to write SQL queries against that data, and to return the query
data into Recruiter using the Enrichment process .
These steps may be used for any Recruiter/CRM installation and do not
rely upon Colleague.
Session ID 2699
6
Goal of Presentation & Prerequisites
We will present the process in a step by step
manner to facilitate duplicating the same
process when you return to your institution.
The process requires the Recruiter System
Administrator role, DB Reader rights to the
Recruiter database and an understanding of
T-SQL.
Session ID 2699
7
Basic Enrichment
Improvements in CRM 2011 has made
data enrichment easier in Recruiter.
Session ID 2699
8
Basic Enrichment Example
• This example details how to add an
extracurricular interest to a prospect.
• The source of the prospects can be a text
file. Excel spreadsheet or any other format
usable by Access.
• This technique can be used for any entity
related to the prospect
Session ID 2699
9
Import a prospect, then enrich extracurricular
activities using name and email as the link
Session ID 2699
10
10
Start with Imports
Session ID 2699
11
11
Create a new Import
Session ID 2699
12
12
Browse for the first import file - Contacts
Session ID 2699
13
13
Select your CSV of Contacts
Session ID 2699
14
14
Confirm Selected CSV File
Session ID 2699
15
15
Select Automatic Mapping – CSV Headings from Recruiter
Session ID 2699
16
16
Automatic Mapping Will Find The Headings
Session ID 2699
17
17
It is OK if not all fields are mapped
Session ID 2699
18
18
Confirm Mapping
Session ID 2699
19
19
Do Not Allow Duplicates for Simple Enrichment
Session ID 2699
20
20
Take a Break While the Import Runs
Session ID 2699
21
21
Start a new Import as before – Extracurricular Activity
Session ID 2699
22
22
Select Extracurricular Activity CSV
Session ID 2699
23
23
Confirm Upload
Session ID 2699
24
24
Select Automatic Mapping – CSV Headings from Recruiter
Session ID 2699
25
25
Map Email to Prospect
Session ID 2699
26
26
Also Map Contact – First with Full Name Default
Session ID 2699
27
27
Add Email to Connect to Contact
Session ID 2699
28
28
Confirm Lookup Reference
Session ID 2699
29
29
Confirm Mapping
Session ID 2699
30
30
Do Not Allow Duplicates for Simple Enrichment
Session ID 2699
31
31
Take a Break While the Import Runs
Session ID 2699
32
32
Check your Imports
Session ID 2699
33
33
Make sure it was successful
Session ID 2699
34
34
Check The Results
Session ID 2699
35
35
And there it is 
Session ID 2699
36
36
Basic Enrichment Summary
• You can start with new Contacts or enrich
existing contacts
• Export your existing Contacts to a CSV or
create a CSV with new contacts
• Use email address and Full Name to
attach interest to Contact
Session ID 2699
37
Complex Enrichment
There are situations where data
enrichment is more complex than can
be handled with the General process.
They can still be accomplished.
Session ID 2699
38
Complex Enrichment
• This example will identify duplicates by
matching suspects to prospects
• Then the duplicate suspects will be flagged
for deletion
• We use the SIC field since it is not used in
Recruiter. Any unused field will work
• An Advanced Find selects the suspects with
the SIC flag
• Then they are deleted
Session ID 2699
39
Start with and Advanced Find for Leads
Session ID 2699
40
40
Select Leads with no SIC and Related Contact (Origination Load)
Session ID 2699
41
41
Save Query for future use (Save As)
Session ID 2699
42
42
Edit Columns – Add and Remove
Session ID 2699
43
43
Initial Column Add/Remove Screen
Session ID 2699
44
44
Remove Name and Created On. Add First, Middle, Last,
Email and SIC
Session ID 2699
45
45
Click ! For Results
Session ID 2699
46
46
Then Click Export Leads
Session ID 2699
47
47
Export The Leads – Check Re-Import Option
Session ID 2699
48
48
Open the Export File
Session ID 2699
49
49
Save your Advanced Find Query
Session ID 2699
50
50
Open the XML File in Excel
Session ID 2699
51
51
Notice first column is D. A-C are Hidden
Session ID 2699
52
52
Unhide A-C but Do Not Modify
Session ID 2699
53
53
Unprotect the Sheet
Session ID 2699
54
54
Remove All Data Rows – Keep Headings
Session ID 2699
55
55
Save the XML Master File of Headings (once)
Session ID 2699
56
56
Save it again to use for Import
Session ID 2699
57
57
Save it again for a working copy
Session ID 2699
58
58
In the CRM DB using T-SQL Create this View
Session ID 2699
59
59
T-SQL View Continued (Part 2)
Session ID 2699
60
60
Results of the View
Session ID 2699
61
61
Copy the view results into working copy of XML file,
save and close it.
Session ID 2699
62
62
Start a new import
Session ID 2699
63
63
Browse for the working file
Session ID 2699
64
64
If you Do Not Allow Duplicates it Fails
Session ID 2699
65
65
Take a break while the import runs
Session ID 2699
66
66
Check the Import Status
Session ID 2699
67
67
Errors Caused by Not Allowing Duplicates
Session ID 2699
68
68
If you Do Not Allow Duplicates the Import Fails
Session ID 2699
69
69
Allow Duplicates will Permit Enrichment
Session ID 2699
70
70
Allow Duplicates and it Works
Session ID 2699
71
71
Final Process - Delete the Duplicate Suspects
• After enriching run an Advanced Find for
Leads with SIC = 1
• Select them all
• Click the Delete icon - X
• No more leads duplicating suspects
Session ID 2699
72
Questions & Answers
•
•
•
•
Feel free to contact us
Steve – [email protected]
David – [email protected]
We will post this on the Client Forums,
wherever they are in the future.
Session ID 2699
73
Thank You!
Presenter(s) Steve Mason & David Morelli
Email(s):
[email protected]
[email protected]
Please complete the online session evaluation form
Session ID 2699
.
Session ID 2699
© 2013 Ellucian. All rights reserved.
74