PeopleImport Stage 2 - Compare

Stage 2 is where the user decides if the input file should be compared to all records in Salesforce or just a subset of Leads, Contacts, or Accounts.

Capabilities & Features

• Ability to compare the incoming spreadsheet to all Leads, Contacts and Accounts or just a subset of records
  • For strategic reasons, e.g. only compare to records with a particular record type
  • For volume reasons, e.g. only compare to records in a particular state or country
• Multi-Table join capability
  • Only compare to "Customer" Contacts (where the Account.Type = Customer)
• Defaults to "Use All" - compare input data to ALL Leads, ALL Contacts and ALL Accounts
• If NO limiting conditions need to be specified, click Next in the bottom right to move directly to Stage 3 - Matching
• A particular section may be greyed out based on whether the input data is being compared to just Leads, just Contacts or Leads and Contacts
• Account matching only used when specifying New Contact - Existing Account matching steps in Stage 3

Step 1. Select the Field to Base a Condition On

• All fields from the particular object and related objects, including custom fields, are available for selection
• To access fields in a related table select the "+" to the left of the table name
  • This will display the fields from the related table
  • Multi-table join is available for Parent tables only, based on foreign key relationships between tables
  • For example, the Account table can be accessed from within the Contact table, because the Account ID is physically stored on the Contact table, but the Contact table is NOT accessible from the Account table.

Step 2. Select the Operator

• Available operators will change based on the type of field selected
• "!=" represents "not equal to"
• When using dates, operators will include "Today", "Yesterday", etc.
• For date and number fields, additional operators are included for specifying blank values (see below for specifying blanks for text fields or empty values for picklist fields)
  • Dates: "Empty Date" & "Not Empty Date"
  • Numbers: "Equals Null" & "Not Null"

Step 3. Specify a Value(s)

• Text Fields: Type in the value
  • Multiple values for the same field can be separated by commas. DO NOT PUT A SPACE AFTER THE COMMA. 
    • e.g. State = ma,nh,me will be translated to State = ma or State = nh or State = me
    • Values entered are not case sensitive
    • To specify a blank value, leave the value box empty
• Picklists: Select the value from the specified list
  • Multiple values can be selected and will be translated as "or"
  • Only valid picklist values are shown (as defined in Salesforce)
  • Right click the list of values to bring up additional selection options:                                                                                                                                                                                                     
    • Add Value To List - Allows for the addition of a value for selection purposes only
    • This will not add a value as an active option to the picklist in Salesforce
    • Filter List - Allows for easy searching a long picklist based on a character string to quickly find a value(s)
    • Reset - Will strip all filters and added values and reset to the values in your Salesforce instance
• Dates: The current date will default in the value window. Click the arrow on the right to access a calendar and select a specific date.                                                                                                                                                                                                                                                                                                                 
  • To isolate a specific day, regardless of time for a date/time field (e.g. created date), specify 2 conditions to isolate the 24 hour period
    • e.g. Created Date >= Jun 01 2010 00:00 AM, Created Date <= Jun 01 2010 11:59 PM
    • The value is ignored when using an operator such as "Today" or "Yesterday"

Step 4. Add Condition(s)

• Select Add Condition to add the condition to the list of current conditions
• By default all conditions are "AND'd" together. To create "OR" groups see Step 5
• To delete one condition from the list, click the box to the left to highlight the condition and press the delete key on the keyboard

Step 5. Creating "OR Groups"

• To create "OR" groups, check Expert Mode
• Change the "OR Group" number for specific conditions (click on the number on the right and adjust up or down). All conditions WITHIN a group (e.g. have the same group number) are AND'd and BETWEEN groups are OR'd. For example:                                                                                                                                                                                                                                                               

Reads as:

(MailingState=ma AND LeadSource=External Referral) OR (MailingState=ny AND LeadSource= Trade Show)

• Unchecking Expert Mode will cause all conditions to be and'd once again

Click HERE to go to Stage 3 - Matching