Errors in the import process are common. Typically, it is because a row did not include a valid email address or because columns were not mapped to the correct eManager field during Step 2 of the import.
After your import has finished processing, you can click on the red number of errors under the "Errors Count" column to get a better idea of what happened. You can go back to your original data file, make any corrections and re-upload the entire file. Or, if you wish only to retry importing the rows that caused errors, you can save the errors display page as a .CSV file and make the corrections there. To do this recommended alternative, right-click anywhere on the Errors Count page and select “Save As.” On the Save As screen, give your file a name and then change the Save as type to “All Files.” Once this is done, delete everything after the period in the File name (ex. .aspx or .txt) and replace it with the “.csv” file type ending. Then hit save. Before reimporting the document, you will need to go into this newly saved spreadsheet and fix all of the reported errors displayed in the Error column of your spreadsheet. Make sure that you do not import the Error column when attempting to upload the data. Below are some common errors.
Email Address (or other errors): The data ends with a question mark ? or is incomplete. Add another column in the CSV spreadsheet and call it "trimmed Emails." In each of the cells in that column, add the formula =TRIM(A2) where A2 is the cell reference for the email for the current row. Then use that column as the "email" column when you do the import.
Birthdate Errors: "Birthdate Date Time argument was in wrong format: 19570524"
Dates must be in MMDDYYYY format to be imported into our system. You can convert it to an excel recognized date with the formula where A1 is the cell with the yyyyMMdd date (replace “A1” with the cell that needs editing):
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
To edit multiple cells in your spreadsheet with this formula, simply enter it in the first cell, and hit tab so that you know it’s working properly. Then click on that cell once again, and using the little box in the lower-right corner, drag the formula down so that all cells needing the change are filled. In the event that an individual never had a birthday in the spreadsheet to start, entering that formula will result in “VALUE!” being entered in the cell. Should this occur, please make sure to delete that out prior to importing, as this will also result in an error.
Zip Errors: Excel will often convert Zips to numbers (FYI: no need to correct or even import Zip+4s) which may or may not have the right number of digits. You can pad extra zeros onto the beginning with the following formula (replace “A1” with the cell number that needs editing):
=REPT(0,5-LEN(A1))&A1
Comments
Article is closed for comments.