My CSV import error report shows "EmailAddress: Value cannot be empty". What does this mean?
My CSV import error report shows "EmailAddress: Value cannot be empty". What does this mean?
The error means that the system has identified cells in the file, in the Email Address column, that are empty. The system is detecting that the cells contain formatting but it is not an email address nor is it visible to the user. This error does not indicate that the file is wholly bad or the import as a whole failed, there are simply empty cells contained in it.
If you want to avoid this error you can do one of the following:
1. Locate the last cell that contains data in the worksheet, and then reset that last cell by clearing all of the formatting that may be applied in empty rows or columns between the data and the last cell.
2. You can copy the rows & columns that actually contain data and paste it into a new Excel worksheet. Save the new worksheet as a .CSV file type, and import it.
Preparing your file Before we cover the process, let's talk about file preparation. The following are a few tips for a smooth import experience. Utilize a spreadsheet application to easily view and edit your data file. Organize each point of data ...
Sometimes you may need to revisit previous imports, whether completed via FTP or CSV, to review your data updates or troubleshoot any issues. Delivra offers an Import History feature that provides a detailed summary of each upload Import History ...
Occasionally you may have some row failures when importing new contacts (or updating existing contacts) through CSV import. To determine the cause of those failures and make adjustments to clear those failures, follow the process below. How-To ...
Importing contacts into Delivra is a straightforward process, but a little prep work goes a long way. By organizing your data ahead of time, you’ll ensure a smooth experience and help your campaigns take flight faster. File Preparation Tips Before ...
If you have previously used an email service provider like Delivra, we recommend that you migrate any email subscribers that opted-out of campaigns you sent through that system. This way, you're ensuring that you don't all of a sudden start emailing ...