Changes in the External Data

The external data may change between imports.

This can happen in three ways:

  • Data was added: A row that was not in the file at the previous import has been added; for example, a new employee has joined the company.

  • Data was deleted: A row that was in the file at the previous import has been removed; for example, an employee has left the company.

  • Data was updated: A row that was in the file at the previous import is still there, but has been changed in some way since the previous import; for example, an employee has changed their name.

Data was Added

In this case, People Planner simply adds the new data the next time that you run the import.

This is the default behavior, but you can change it by selecting the Only update existing objects (import fails if objects don't exist in People Planner) checkbox. You select/deselect this checkbox as part of defining the custom import mapping.

If this checkbox is selected, and you run the import after new external data has been added, People Planner reports this as an error.

Data was Deleted

By default, existing data is not deleted as part of an import mapping. Any data that has been imported into People Planner once remains, even if it is not in the external source anymore.

You can change this behavior by selecting the Delete previously imported objects in PeoplePlanner that no longer exist in external data checkbox. You select/deselect this checkbox as part of defining the Import Mapping.

Note: Only data that was previously imported though the Import Mapping is deleted. People Planner does not delete data with a different Origin.

Data was Updated

People Planner identifies the external data from the External ID. As long as the External ID does not change, the rest of the data is allowed to change. When you run the import the next time, People Planner updates the data from the previous import.