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 (···) 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).
• The email address does not follow common conventions: The email address does not comply with technical formatting standards and is therefore invalid.
• The email address uses a local or reserved domain: The domain is local or system-reserved and is not suitable for public email communication.
• The email address appears to be spoofed: The address contains suspicious character combinations that may indicate manipulation or identity spoofing.
• Role-based email addresses are not allowed (e.g. noreply@, admin@): Generic functional addresses are not permitted as they often lead to delivery issues or spam complaints.
• Disposable email addresses are not allowed: Temporary or anonymous email addresses are rejected because they are not permanently accessible.
• The email domain is currently unreachable: The domain could not be technically reached and its ability to receive emails cannot be confirmed at this time.
• The email domain does not exist: The specified domain is not registered in the DNS system and therefore cannot receive emails.
• This domain cannot receive emails: The domain does not have valid mail server records and is therefore not configured to receive emails.

💡 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.