Whether you're updating contact data via FTP or uploading a CSV file, it's helpful to be able to look back at past imports. Delivra’s Import History feature allows you to do just that. It's a useful tool for reviewing what was added or updated, troubleshooting failed imports, and keeping track of who made changes.

What Is Import History?

Located in the Contacts dashboard, the Import History section displays a list of all your data imports from the past year. It includes key details like the number of records imported, successful updates, and more. To find it, simply navigate to Import History from the side menu in your account.

Viewing Import Details

Each import entry has a Details page that provides a deeper breakdown of the import process. To access it, hover over the import record and click View Details. You'll find:

• Importer: Name of the administrator who uploaded the file.
• Upload/End Times: Time stamps showing when the import started and finished.
• Total Rows: Total number of records (rows) in the uploaded file.
• Added Rows: Number of new contacts successfully created in your account.
• Updated Rows: Number of existing contacts that were updated with new data.
• Failed Rows: Rows that could not be processed, often due to formatting or validation errors.
• Warning Rows: Records skipped because the contact was in a Held or Unsubscribed status.
• Contact Status: Indicates the action selected for the import—such as add, update, or status change.
• Download Links: You can download both your original import file and a corresponding Error file, if any issues occurred.
  

Understanding the Error File

If any part of your import fails, the Error file provides insight into what went wrong. You’ll find a reason listed in the first column for each failed row:

• Warning: These records were skipped because the contacts are in Held or Unsubscribed status. Only contacts in Normal status can be updated through bulk import.
• Error: These records didn’t meet import requirements. Common issues include missing email addresses, incorrect formatting, or mismatched data types.

Tips to Prevent Common Failures

Here are a few helpful checks to run before importing your CSV file:

• Only one email per row: Ensure that each contact record contains a single email address.
• Proper email formatting: Every email address must include an "@" symbol.
• No trailing spaces: Extra spaces at the end of email addresses can cause issues.
• Watch out for special characters in file names: If you're using a hyphen in the file name and encountering problems, try replacing it with an underscore. Some applications may interpret certain hyphen characters as special symbols, which can interfere with processing.
  

Additional Notes

• FTP Imports: Error logs for FTP imports are stored in the “Error” folder of your FTP program.
• CSV Imports: Import history is retained in Delivra for 90 days.
• Filtering: Use the toggle in the Import History screen to filter and view either Email or SMS imports specifically.

Best Practices

• Always review the Details page after importing to confirm the data was processed correctly.
• Use the Error file to quickly troubleshoot and correct any failed rows before re-importing.
• Limit imports to contacts in Normal status to avoid unnecessary warnings.
• For accountability, track which team member performed each import using the Importer field.

For any questions or help with import issues, reach out to our Support team at support@delivra.com