Customize the Mapping of Fields
If automatic mapping is not possible, such as when fields are named differently, you can map the external field by selecting the field from the dropdown list for the Source Field Name field.
| Type | Description |
|---|---|
|
Whenever a field in the Create Entity Mapping view is displayed with a red cross icon, it means that this field is mandatory and must be mapped before you can import the data. |
|
The External ID column is mandatory in all imports. This is the unique key that is used in the People Planner database. |
|
Fields shown with the silver key icon are foreign keys in People Planner. Whenever you import data to a foreign key you must make sure that the value that you set in your import actually exists in People Planner in the field. For example, if you import to Popup 1 on the resource you must make sure that the value that you set for a resource in the Popup 1 field is also created in the resource popup 1 field. |
|
If you import data to a field that has this icon-known as the List icon-it means that the field contains a list of values. The list of values is determined in the People Planner code, and you cannot change the number of values in the list or rename the existing values. When importing to these kinds of fields you must make sure that the value that you import also exists in the list of values for this system field. |