This chapter discusses:
PeopleSoft Infosync Client.
Data synchronization concepts.
PeopleSoft CRM integrates with PIM (Personal Information Manager) clients (for example, Microsoft Outlook) to provide data synchronization capabilities for end users, such as field service engineers and sales representatives, to manage contacts, calendar items, and tasks more effectively. When end users are connected to the company network, they can synchronize data between PeopleSoft CRM and their PIM clients with one click of a button.
Note. PeopleSoft Infosync Client synchronizes contacts between PeopleSoft CRM and the PIM client, which includes contacts, consumers, and workers. In PeopleSoft CRM, contacts, consumers, and workers are all instances of the person component. Whereas in the PIM client, they are all considered contacts in the address book. Consumers are contacts in the consumer category, and workers are contacts in the worker category. In this documentation, the term contacts refers to contacts, consumers, and workers as a whole unless stated otherwise.
Provides data synchronization capabilities between PeopleSoft 8.9 CRM and Lotus Notes (version 5.x, or 6.0) or Microsoft Outlook (version 98, 2000, 2002).
Provides administrative control on the synchronization process.
Administrators set up PIM preference to specify details on how the supported PeopleSoft CRM objects are handled when they are synchronized to PeopleSoft CRM (for example, does it allow new contacts to be added or does it synchronize private tasks, and so on). Every PIM end user is associated with PIM preference. Typically, you define a number of PIM preference settings that cover all PIM end users in a company based on roles or job functions. But if the company calls for a more granular definition of PIM preference for PIM end users, you can configure PIM preference settings on an individual user basis.
Provides full control on data flow.
Administrators can manipulate the type of data that gets exchanged in the synchronization process. You can limit the amount of data that gets downloaded to PIM end users by defining dataset rules that determine the most relevant set of data that end users receive (based on the dataset roles to which end users belong) within the shortest possible synchronization time.
Provides predefined rules to resolve data conflicts that occur during synchronization.
Provides synchronization status and error logs.
This section discusses:
Supported objects.
Configuration settings and PIM preference.
Categories and filtering.
Conflict resolution.
Datasets.
Field mapping.
PeopleSoft Infosync Client supports synchronization for these objects between PeopleSoft CRM and PIM clients:
Contacts.
Consumers.
Workers.
Tasks.
Calendar items.
Private.
Contacts, Consumers, and Workers
In PeopleSoft CRM, contact, consumer, and worker are instances of the person component and are referred to as roles. A person can have multiple roles; he or she can be a contact, a consumer, and a worker simultaneously. In the PIM client, consumers and workers are the same as contacts and they are stored in the address book. Category is used to distinguish which role the person has in a contact record. By default, contact records with a consumer role are in the consumer category; those with a worker role are in the worker category, and those with a contact role are in the contact category. You can modify the names of categories.
You can enable or disable consumer or worker synchronization. For each of the enabled objects, you can further select the operations that synchronization supports. Suppose that you enable consumer synchronization. You can later decide whether to allow actions, such as consumer creation, update, or deletion to be synchronized to PeopleSoft CRM if any of these occurs in the PIM client. For any unsuccessful synchronization of records that happens due to unauthorized operations, errors appear on screen immediately and are logged on the PIM Errors page.
Contacts (with the contact category) support multiple companies. End users can specify multiple companies in a contact record using a separator; when the record synchronizes, it establishes and maintains a one-to-many relationship between that contact and its companies. You can view the contact in the 360 Degree View in PeopleSoft CRM using the Contact Web Page URL field on the PIM Preference page. The contact must be associated with a company to locate the contact in the system.
Note. Consider defining Contact Web Page URLs a one-time implementation decision. If end users are currently using the Contact Web Page URL field, using this feature overwrites the existing values during synchronization.
PeopleSoft Infosync Client supports the synchronization of private contacts. There is a Private option in PeopleSoft that enables these contacts to be synchronized and that transfers the value of the Private option to the PIM client.
Tasks and calendar items are stored in the PIM client's to-do list and calendar, respectively. When they are synchronized to PeopleSoft CRM, they appear on the monthly or daily calendar of end users.
In PeopleSoft CRM, you can relate tasks to transactions (such as leads, opportunities, and service orders) or they can remain independent (not transaction-related). If a task that is created from a lead or opportunity is synchronized to the PIM client, the lead or opportunity name automatically appears on the subject line of the task in square brackets ([ and ]). PeopleSoft Infosync Client delivers dataset rules that determine the most relevant subset of data that is synchronized to the PIM client for end users. You can refine the data subset by adding more dataset rules to exclude insignificant data records from being synchronized for end users.
Note. If end users create a calendar item from the Task List in PeopleSoft CRM that spans multiple days, the synchronization process creates one corresponding record on the first day of the calendar item in the PIM client and sets the record's start date to equal its end date. If the calendar item is created from the PIM client, a warning message appears, stating that an appointment cannot span more than a day and that synchronization will ignore the appointment. PeopleSoft CRM currently supports the creation of recurring tasks or calendar items.
Private
PeopleSoft Infosync Client supports the synchronization of private contacts, tasks, and calendar items. There is a Private option in PeopleSoft that enables these objects to be synchronized; the value of this option transfers to the PIM client. When the Support Private feature is enabled, the synchronization process creates a record for every private calendar item on the monthly calendar. The record displays the duration of the private calendar item and has a subject line that indicates that it is a private record. Private tasks are handled similarly; the only difference is that no task duration appears on the private task records in PeopleSoft CRM.
Note. If you must reassign tasks that are transaction-related, do so directly from the transactions in PeopleSoft CRM.
Each object handles the deletion of records differently. This table summarizes what happens to the copy of a record, which was previously deleted in the PIM client, in PeopleSoft CRM if the delete operation is enabled for the record's object:
Object |
Result |
Contact (delete contact operation is enabled) |
Record is stored on the Deleted Objects page. You can reactivate it later for synchronization. |
Task or calendar item (delete calendar and delete task operations are enabled) |
Transaction-related: record status changes to the status that is defined for the deleted task or calendar item in PeopleSoft CRM. |
Independent: record is deleted if the delete independent task or calendar item feature is enabled. Otherwise, the record status changes to the status that is defined for the deleted task or calendar item in PeopleSoft CRM. |
PeopleSoft Infosync configuration settings, in conjunction PIM preference, identify end user synchronization profiles. When synchronization starts, PeopleSoft Infosync Client reads these values to determine what data gets exchanged and performs the update in both PeopleSoft CRM and the PIM client.
Configuration Settings
You define the configuration settings for each of these areas in PeopleSoft Infosync Client: address book, calendar, and to-do list. In the Advanced Settings window for each of these areas, you can view the field map, select a filter to exclude unnecessary data from synchronizing to PeopleSoft CRM, and select a conflict resolution rule to handle possible data conflicts during synchronization. PeopleSoft Infosync Client delivers predefined values for these settings; you can modify them to best suit your business needs.
PIM Preference
PIM preference specify details on how the supported PeopleSoft CRM objects are handled when they are synchronized to PeopleSoft CRM. PeopleSoft Infosync Client provides two sample PIM preferences, and they're highly configurable. You can modify them as needed or create new ones. Typically, you define multiple function-specific (for example, sales manager or field technician) PIM preferences to cover all end users across the enterprise. For end users with specific data synchronization requirements, you can customize PIM preference at the individual user level.
PeopleSoft Infosync Client uses categories in conjunction with filters to identify what records to pick from the PIM client and synchronize to PeopleSoft CRM. For every synchronization-enabled object, specify a category in PIM preference with which end users associate. End users must enter the correct category (case sensitive) for each record that they want synchronize to PeopleSoft CRM. To do so:
(Microsoft Outlook) Click the Categories button on the main page of the record, and select the category that is specified in PIM preference for the record's object.
(Lotus Notes) Select the Options page of the record, and in the Categorize drop-down list box, select the category that is specified in the PIM preference for the record's object.
For the address book, do so in the Categories drop-down list box on the Advanced page.
This table lists the system-delivered category values for each object:
Object |
System Delivered Category |
Contact |
Contact |
Worker |
Worker |
Consumer |
Consumer |
Task |
PeopleSoft |
Calendar |
PeopleSoft |
Categories are used with filters to determine what data is synchronized. For each of these objects, contacts (including contacts, consumers and workers), tasks, and calendar, set up a filter with one or multiple conditions. For filters with multiple conditions, specify the rule for combining conditions—whether or not all conditions must be met before a record can be transferred to the other system.
For example, if you want to support the synchronization of contacts, consumers, and workers in PeopleSoft CRM, specify conditions in the filter using the contains and oroperators like this:
Categories contains “Contact” OR
Categories contains “Consumer” OR
Categories contains “Worker”
PeopleSoft Infosync Client delivers preset filters for the address book, calendar, and to-do list:
Section |
Filter |
Address book |
Categories (condition: category equals “PeopleSoft”). |
Calendar |
|
To do |
|
Suppose that an end user marks a task as private and groups it under the PeopleSoft category in the PIM client. If the filter for the ToDo section is set to Categories and Private in PeopleSoft Infosync Client, the private task is not synchronized to PeopleSoft CRM. This task, however, is synchronized if the filter is set to Categories.
Note. Consider defining categories and filters a one-time setup process. It's highly recommended that you don't make changes after implementation, as that may cause unexpected results.
There is sample setup that you can use as guidelines; you should add or modify rules as necessary to meet your business needs. By default, no filter is selected.
Warning! If you specify multiple rules in a filter, you can use either the AND or OR operator to illustrate the relationship of the conditions (by selecting the rule for combining conditions), but not both.
To enable support for private tasks or calendar items, you:
Set the PrivateFlag Field parameter to 1 in the DCSSettings.cfg file for tasks or calendar items.
Make sure that the Private Flag field is mapped correctly.
Make sure that the filter being used doesn't exclude private data.
If you set to exclude private data, no time slots are reserved for private tasks or calendar items on the PeopleSoft CRM calendar, even when the Support Private feature is enabled because these records are not synchronized to PeopleSoft CRM.
To disable support for private tasks or calendar items, you:
Set the PrivateFlag Field parameter to 0 in the DCSSettings.cfg file for tasks or calendar items.
Do not map the Private Flag field.
No extra steps are required for contacts because the concept of “private” is not supported for contacts.
PeopleSoft CRM and PIM integration provides conflict resolution capability during synchronizations. When data conflict occurs (for example, end users have modified the same field or the same record in both systems with different values), PeopleSoft Infosync Client resolves the conflict based on the selected conflict resolution rule.
PeopleSoft Infosync Client delivers five predefined conflict resolution rules. You decide how the system handles data conflicts for the address book, calendar, and to-do list by selecting one of these rules:
Add all conflicting items.
Ignore all conflicting items.
Warning! It is recommended to not use this option. There is a potential for overwriting data.
Notify me when conflicts occur (default value).
PeopleSoft Infosync Client wins.
Lotus Notes or Microsoft Outlook wins.
See Also
Specifying Conflict Resolution Rules
To control the distribution of data only to end users who need it and help shorten the time needed for synchronization, datasets are used in the PeopleSoft CRM and PIM integration to filter and display data for end users based on their roles.
Datasets, PIM Dataset Roles, and Dataset Rules
Every end user is associated with a PIM dataset role through the PIM preference ID that is selected in their user preferences in PeopleSoft CRM. Every PIM dataset role is linked to three datasets (contact, task, and calendar), each of which contains its own dataset rules. A dataset rule defines the collection of data that is downloaded to the PIM client. Through the use of datasets, each user receives updates for data that pertains to them only. For example, Jane Smith, a sales user, gets updates for all the leads and tasks created by her, as well as calendar items that are created for her leads (governed by dataset rules). If another colleague changes a task that he created for his lead, it is not updated in Jane Smith's PIM application.
This table lists the predefined PIM dataset roles, datasets, and associated dataset rules that are delivered with the PeopleSoft CRM and PIM integration. Each dataset corresponds to a specific role and is associated with a number of dataset rules, which identify sets of data to be downloaded to the PIM client for end users associated to that role at synchronization.
Note. This set of dataset information is delivered in the system for demonstration; you can modify it. For example, administrators can create new dataset rules or modify existing ones as long as these rules carry the syncID for contacts, calendar items, and tasks to PeopleSoft CRM.
PIM Dataset Role |
Dataset |
Dataset Rule |
Set of Data That Gets Updated |
PIM Field Service Role |
PIM_FS_CALENDAR |
CALENDAR ASSIGNED TO ME |
Calendar items that are assigned to the user. |
CALENDAR FOR MY SERVICE ORDER |
Calendar items for the service orders that are owned by the user, including those calendar items (for the service orders) that belong to other users. |
||
CALENDAR OWNED BY ME |
Calendar items that are owned by the user. |
||
PIM Field Service Role |
PIM_FS_CONTACTS |
CONTACTS_CREATED_BY_ME |
Contacts that are created by the user. |
CONTACTS FOR MY SERVICE ORDER |
Contacts for the service orders that are owned by the user. |
||
CONTACTS_ACT_TM |
Contacts for the account team. |
||
MY_TASK_ASSIGNEE |
My task assignees. |
||
MY_TASK_CONTACT |
My task contacts. |
||
PIM Field Service Role |
PIM_FS_CONSUMER |
CONSUMER_CREATED_BY_ME |
Consumers that are created by the user. |
CONSUMERS_FOR_MY_SO |
Consumers for the service orders that are owned by the user. |
||
PIM Field Service Role |
PIM_FS_TASK |
TASKS ASSIGNED TO ME |
Tasks that are assigned to the user. |
TASKS FOR MY SERVICE ORDER |
Tasks that are associated with the user's service orders. |
||
TASKS OWNED BY ME |
Tasks that are owned by the user. |
||
PIM Sales Role |
PIM_SL_CALENDAR |
CALENDAR ON MY LEADS |
Calendar items for the leads that are owned by the user, including those calendar items (for the leads) that belong to other users. |
CALENDAR ON MY OPPORTUNITIES |
Calendar items for the opportunities that are owned by the user, including those calendar items (for the opportunities) that belong to other users. |
||
MY CALENDAR |
Calendar items that are created or owned by the user. |
||
CALENDAR ASSIGNED TO ME |
Calendar items that are assigned to the user. |
||
PIM Sales Role |
PIM_SL_CONTACTS |
CONTACTS_CREATED_BY_ME |
Contacts that are created by the user. |
CONTACTS_FOR_LEAD_TASK_ASSIGNEE |
Contacts for the leads in which lead tasks are assigned to the user. |
||
CONTACTS_FOR_OPP_TASK_ASSIGNEE |
Contacts for the opportunities in which opportunity tasks are assigned to the user. |
||
CONTACTS_FOR_LEAD_TEAM |
Contacts for the lead sales team of which the user is a member. |
||
CONTACTS_FOR_OPP_TEAM |
Contacts for the opportunity sales team of which the user is a member. |
||
CONTACTS_FOR_MY_LEAD |
Contacts for the leads that are owned by the user. |
||
CONTACTS_FOR_MY_OPP |
Contacts for the opportunities that are owned by the user. |
||
MY_TASK_ASSIGNEE |
My task assignees. |
||
MY_TASK_CONTACT |
My task contacts. |
||
CONTACTS_ACT_TM |
Contacts for the account team. |
||
PIM Sales Role |
PIM_SL_TASK |
MY TASKS |
Tasks that are created or owned by the user. |
TASKS ASSIGNED TO ME |
Tasks that are assigned to the user. |
||
TASKS ON MY LEADS |
Tasks for the leads that are owned by the user, including those tasks (for the leads) that are not assigned to the user. |
||
TASKS ON MY OPPORTUNITIES |
Tasks for the opportunities that are owned by the user, including those tasks (for the opportunities) that are not assigned to the user. |
||
PIM Sales Role |
PIM_SL_CONSUMER |
CONSUMER_CREATED_BY_ME |
Consumers that are created by the user. |
CONSUMER_FOR_MY_LEAD |
Consumers for the leads that are owned by the user. |
||
CONSUMER_FOR_MY_OPPY |
Consumers for the opportunities that are owned by the user. |
||
Both |
PIM_WORKER |
WORKERS FOR PIM USERS |
Workers in the same department as the user. |
See Also
PeopleSoft Enterprise Components PeopleBook
Field mapping dictates where data appears after it is transferred from one system to another. You can review the field map of the address book, calendar, and to-do list by clicking the Field Mapping button on the Advanced Settings window.
Note. PeopleSoft highly recommends that you leverage the field mapping as delivered and do not change it. If you must modify the field mapping, make sure it's well tested.
Field mapping for the integration can be found in these PeopleSoft database records:
BO_NAME
RD_PERSON
CM_ADDRESS
CM_EMAIL
CM_PHONE
CM_PAGER
PIM_CNTS_INFO
RB_TASK
PIM_TASK_INFO
Note. XML names are used internally in the program. They don't necessarily match the names that you see in the field map. The column heading # of Char (number of characters) denotes the maximum number of characters to be synchronized for each field.
BO_NAME Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
First Name |
firstName |
FIRST_NAME |
NA |
NA |
30 |
Last Name |
lastName |
LAST_NAME |
NA |
NA |
30 |
Middle Name |
middleName |
MIDDLE_NAME |
NA |
NA |
30 |
Suffix |
suffix |
NAME_SUFFIX |
NA |
NA |
2 |
Company Name |
companyName |
BO_NAME |
NA |
NA |
50 |
RD_PERSON Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Job Title |
jobTitle |
TITLE |
NA |
NA |
35 |
Title |
title |
SALUTATION_CD |
NA |
Codeset mapping supported |
30 |
CM_ADDRESS Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Office Street |
businessStreet |
ADDRESS1 |
Business type (32) |
NA |
55 |
Office City |
businessCity |
CITY |
Business type (32) |
NA |
30 |
Office State |
businessState |
STATE |
Business type (32) |
Codeset mapping supported |
32 |
Office Zip |
businessZip |
POSTAL |
Business type (32) |
NA |
12 |
Office Country |
businessCountry |
COUNTRY |
Business type (32) |
Codeset mapping supported |
32 |
Home Street |
homeStreet |
ADDRESS1 |
Home type (35) |
NA |
55 |
Home City |
homeCity |
CITY |
Home type (35) |
NA |
30 |
Home State |
homeState |
STATE |
Home type (35) |
Codeset mapping supported |
32 |
Home Zip |
homeZip |
POSTAL |
Home type (35) |
NA |
12 |
Home Country |
homeCountry |
COUNTRY |
Home type (35) |
Codeset mapping supported |
32 |
Other Street |
otherStreet |
ADDRESS1 |
Other type (38) |
Microsoft Outlook only |
55 |
Other City |
otherCity |
CITY |
Other type (38) |
Microsoft Outlook only |
30 |
Other State |
otherState |
STATE |
Other type (38) |
Codeset mapping supported; Microsoft Outlook only |
32 |
Other Zip |
otherZip |
POSTAL |
Other type (38) |
Microsoft Outlook only |
12 |
Other Country |
otherCountry |
COUNTRY |
Other type (38) |
Codeset mapping supported; Microsoft Outlook only |
32 |
CM_EMAIL Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Email1 Address |
|
EMAIL_ADDR |
Business type (27) |
NA |
70 |
Email2 Address |
email2 |
EMAIL_ADDR |
Home type (30) |
Microsoft Outlook only |
70 |
CM_PHONE Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Office Phone |
businessPhone |
PHONE |
Business type (11) |
NA |
24 |
Home Phone |
homePhone |
PHONE |
Home type (15) |
NA |
24 |
Other Phone |
otherPhone |
PHONE |
Other type (43) |
Microsoft Outlook only |
24 |
Mobile Phone |
mobile |
PHONE |
Cellular type (12) |
NA |
24 |
Fax |
fax |
PHONE |
Fax type (14) |
NA |
24 |
CM_PAGER Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Pager |
pager |
PHONE |
Pager 1 type (21) |
NA |
24 |
PIM_CNTS_INFO Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Categories |
category |
PIM_CATEGORY |
NA |
NA |
132 |
RB_TASK Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Start Date |
taskDate |
DATE_UNDER_RPT |
NA |
For calendar item and task |
9 |
Due Date |
taskDate |
NA |
NA |
Hard-coded to task date; task specific |
9 |
Status |
status |
STATUS |
NA |
Task specific |
26 |
Start Time |
startTime |
START_TIME |
NA |
Calendar item specific |
9 |
End Date |
dateClosed |
DATE_UNDER_RPT |
NA |
Calendar item specific |
9 |
End Time |
endTime |
END_TIME |
NA |
Calendar item specific |
7 |
Subject |
subject |
DESCR254 |
NA |
For calendar item and task |
254 |
Body |
notes |
ACTIVITY_NOTES |
NA |
For calendar item and task |
4095 |
PIM_TASK_INFO Record
PIM Field Label |
XML Name |
PeopleSoft Field Name |
Type |
Note |
# of Char |
Category |
category |
PIM_CATEGORY |
NA |
For calendar item and task; not applicable to Lotus Notes 4.6 |
132 |
Private |
private |
PIM_PRIVATE_FLG |
NA |
For calendar item and task |
1 |
Status Mapping for Tasks: Microsoft Outlook
This table shows the task status mapping between PeopleSoft CRM and Microsoft Outlook.
Note. In Lotus Notes, status is not available in individual task records, so there is no task status mapping between PeopleSoft CRM and Lotus Notes.
Task status in PeopleSoft CRM |
Task status in Microsoft Outlook |
In Progress |
In progress |
Completed |
Completed |
Cancelled |
Deferred |
Open |
Not started |
Open |
Waiting on someone else |
Assignee Mapping for Tasks: Microsoft Outlook
This table shows the task assignee mapping between PeopleSoft CRM and Microsoft Outlook:
Task Assignee Status |
Task Assignee Status in Microsoft Outlook |
Accepted |
In progress |
Completed |
Completed |
Assigned |
Assigned |
Declined |
Deferred |
Declined |
Waiting on someone else |
PeopleSoft Infosync Client is supported in two PeopleSoft CRM versions and two PIM clients (each of which has its own supported versions). In each of these environment combinations, the behavior of the system changes slightly. This section discusses general rules that govern the synchronization process and considerations that describe how the system works in different situations.
The section discusses:
General rules.
Rules that are specific to contacts.
Rules that are specific to calendar items and tasks.
Rules that are specific to task notes.
General Rules
Here is a list of rules or considerations that are applicable to the entire integration.
Rules That are Specific to Contacts
Here is a list of rules or considerations that are specific to contacts:
Rules That are Specific to Calendar Items and Tasks
Here is a list of rules or considerations that are specific to calendar items and tasks:
Rules That are Specific to Task Notes
Here is a list of rules or considerations that are specific to task notes:
Rule or Consideration |
|
If an entry with more than one note is synchronized with the PIM client from PeopleSoft CRM, the notes are either concatinated or only the most recent note appears. This is specified in the PIM Preference page. |
All |
From PIM, end users can only update the note that they are entering. Any previous note must be updated in PeopleSoft CRM and then synchronized. |
All |
Task note delimiters showing in PIM where the note begins and ends are specified on the PIM Preferences page. These are configurable, although PeopleSoft recommends that you use only characters, numbers, or dashes. |
All |
When task notes are created in PIM and synchronized, the subject line of the note reads Note Added from PIM. |
All |
If a user has previously selected the Most Recent option for synchronizing task notes then later changes the option to Concatenate, the existing notes that have been synced will not automatically become concatenated, they will remain showing the most recent note. |
All |
When a user adds a task note on the PIM Client and synchronizes, the note on the PIM Client will show the same as before the synchronization which includes the delimiters surrounding the note. The user must synchronize once more to see the note without the delimiters. |
All |
Only one set of note delimiters should be used when adding notes to a task. If a user needs to enter more than one note to a task, it is recommeded that they synchronize twice, then add the additional note. |
All |
Note. Attachments are not a supported object.