How To: Check import logs for contacts

Step 1: Open import logs

1. In Oniva, go to Contacts.
2. Select Import logs.
   Here you will see a list of all previous imports.

In this overview, you can quickly see:

• How many contacts were created, updated, deleted, or skipped.
• Which actions were performed during the import: Create, Update, or Delete.

💡 Note: ‘Add new contacts’ creates new contacts if the identifier does not yet exist, ‘Update existing contacts’ updates existing contacts based on the identifier, and ‘Delete no longer existing, open contacts’ removes all contacts that are not included in the Excel file and have the status ‘open’.

Identifier

An identifier must be selected during the import. This is used to recognise existing contacts and avoid duplicates.

• If a contact with the chosen identifier already exists:
  • It will be updated if Update is enabled.
  • It will be skipped if Update is not enabled.
• New contacts that do not match the identifier will be created if Create is enabled.

Step 2: Review the detailed log

A detailed log is available for each import:

1. Click the actions menu (three dots) next to the desired import.
2. Select Open Log.

The log displays a table with the following columns:

• Field: Indicates which row from the Excel file it relates to.
• Status: Successful, skipped, or failed actions.
• Action: The action performed: create, update, delete.
• Description: Detailed information about the outcome of the action.

You can use the filters at the top right to directly filter by skipped or failed entries.

Step 3: Status message descriptions

Successful actions

• Successfully created: The row from the Excel file was created as a new contact.
• Successfully deleted: The contact was deleted because no corresponding row was found in the Excel file.
• Successfully updated: The contact was recognised by the identifier and updated.

Skipped actions

• Create disabled: The Excel row was skipped because the Create action was not enabled.
• Update disabled: The Excel row was skipped because Update was not enabled and the identifier already exists.
• Validation for create failed: The contact could not be created, usually due to invalid values (e.g., special characters or spaces in the identifiers).

💡 Note: If only create is enabled and a contact already exists, it will appear as skipped: Update disabled, meaning the duplicate was skipped.

Summary

• The import log provides a clear overview of all imported contacts.
• Reviewing the log allows you to quickly identify errors or skipped entries.
• The identifier is essential for recognising duplicates and updating or skipping existing contacts.
• Use caution with the delete function, as it cannot be undone.
• Skipped or failed contacts indicate adjustments needed in the Excel file.