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: actions- Add new contacts: Creates new contacts if the identifier does not already exist.
- Update existing contacts: Updates existing contacts based on the identifier.
- Delete contacts not present: Removes all contacts not included in the Excel file.

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: Creation
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.