View the progress and results of an import, and correct errors

Can I do this task?

You must wait for an import job to complete before you can repair failures. If you selected to receive e-mail notification in the Import Data Wizard, you will receive an e-mail message when the import completes.

1. In the Navigation Pane, click Workplace, and then under My Work, click Imports.

   Monitor the progress of the import.

   To monitor status for an import, watch the Status Reason column. The values will change from Submitted to Parsing to Transforming to Importing to Completed.

   These values correspond with the three stages of each import: parsing the file, transforming the data, and importing the data. For detailed information about the progress of the import job, double-click the import job record, and then under Details, click System Jobs. One system job is created for each import stage.

   Tip: To refresh the status, click the Refresh button .

2. After the import is complete, view the summary information, which shows the number of records created and the number of records that contain errors.
3. To open the import record to view the records that did not import, double-click the import record.
4. To view rows that were successfully imported, under Details, click <record types> Created.
5. To view rows that were not imported, under Details, click Failures.
6. To export rows that failed to import to a new comma-separated value (CSV) file A data file with a .csv file extension. Typically a CSV file consists of fields and records, stored as text, in which the fields are separated from one other by commas., click Export Error Rows. You can correct the errors in this file, and then import it.

© 2009 Microsoft Corporation. All rights reserved.