Attempting to Bulk Add migration line items to a MigrationWiz project using a .csv throws the error "Your import contains at least one error, beginning on row x", where x is the row number of the item causing the error.
After clicking Bulk Add in a MigrationWiz object, selecting a .csv file, and all of the fields are populated, clicking the green "Save" button throws the following error in a flyout window in the bottom right corner of the page, where x is the row number of the item causing the error:
"Your import contains at least one error, beginning on row x."
This issue can be caused by a leading or trailing white space for one or more entries in the .csv file. Here are a few quick ways to resolve this issue without having to manually inspect and edit each entry:
Run the TRIM function in Excel
If you are using Excel you can run the built-in TRIM function. The TRIM function is located in Excel by:
Clicking the Formulas tab
Clicking the Text button
Selecting TRIM from the drop-down menu
Using Replace in Notepad
The following can be done in Notepad to remove leading and trailing white spaces:
Right-click the .csv file in Windows Explorer, click Open With from the drop-down menu, and select Notepad:
Click Edit on the tools bar
Click Replace from the drop-down menu
Put a single space in the "Find what" field, leaving the "Replace with" field empty
Click Replace All
Close the Replace window
Click File on the tools bar and select Save from the drop-down menu
After saving the file start the Bulk Add process from the beginning and select the updated .csv file to import migration line items from.
If you are in the Bulk Add Items page and the fields have already been populated after selecting the original .csv file the entries need to be cleared and the updated .csv file needs to be selected. The quickest way to do this is to click the up arrow button between the MigrationWiz logo and Bulk Add Items at the top left of the page to get back to the project level, then re-start the Bulk Add process.