Microsoft KB Archive/188649

= XADM: Error 291 with Exchange Bulk Import =

Article ID: 188649

Article Last Modified on 10/28/2006

-

APPLIES TO


 * Microsoft Exchange Server 4.0 Standard Edition
 * Microsoft Exchange Server 5.0 Standard Edition
 * Microsoft Exchange Server 5.5 Standard Edition

-



This article was previously published under Q188649





SYMPTOMS
After you edit an Exchange directory export .CSV file, some or all of the objects may fail re-import into Exchange with the following error message:

Event ID: 291

Source: MSExchangeDSImp

Type: Error

Category: None

Description: Unable to process object because the import

line must contain the same number of fields as the header line.

were expected. were found.

There will be one such error message for every object in the file that failed in this way.



CAUSE
The application in which the file was edited did not correctly preserve all fields in the original file. The most common cause of this problem is that the last column of the .CSV file contains blank values for some or all objects exported.

For example, an Exchange export file may look like this:   Obj-Class,First Name,Last name,Hide from AB   Mailbox,Angela,Barbariol,1 Mailbox,Kim,Yoshida, The second mailbox has no value defined for "Hide from AB."

After being imported to and then exported from an application for editing, the file may look like:   Obj-Class,First Name,Last name,Hide from AB   Mailbox,Angela,Barbariol,1 Mailbox,Kim,Yoshida Observe that the final comma delimiting the blank field for the second mailbox line has been removed from the edited file.

NOTE: The export header example shown here has had several required fields omitted for readability and is not actually a valid header.

Unusual characters can also cause an editor's export parser to incorrectly break fields into pieces or combine them incorrectly, thus corrupting the .CSV file.



WORKAROUND
In most cases where trailing blank fields have been dropped, the problem can be resolved by moving a field that has populated values for all objects to the end of the export header.

For example, you can make the "Directory Name" column the final one. Or you can populate the "Hide from AB" column with zeroes for all users.

NOTE: "Hide from AB" is the final field in a default Exchange mailbox export, and this field often has unpopulated values for most users. A zero value for "Hide from AB" leaves a mailbox visible in the Address Book; a 1 hides the mailbox.

If you are already experiencing this problem with a file, using the workaround described above usually corrects the problem without requiring creation of a fresh export file.

Another solution that often works is to add a comma to the end of each problem line.



MORE INFORMATION
To further troubleshoot .CSV files that fail in this way, choose an object line that failed and create a new file containing only this line and the header line. Use Notepad or a similar simple editor that reads and saves .CSV files without format conversion.

Export the object again from Exchange, and, using Notepad, create another file that contains only the header line and the object line.

Careful side-by-side comparison of the two files usually reveals where the problem lies.

Techniques such as the following examples can make it easier to see problems and differences in long export lines.

Numbering Fields
Each comma in a line designates a new field, with the exception of commas that come between double quotes (","). Therefore, you should place a number after each comma, and the highest number on each line should match.   1 Obj-Class,2 First Name,3 Last name,4 Display Name,5 Hide from AB   1 Mailbox,2 Angela,3 Barbariol,4 "Barbariol, Angela",5 1 1 Mailbox,2 Kim,3 Yoshida,4 "Yoshida, Kim"

Columnar Comparison
When comparing by columns, preserve all characters from each original line in each column, especially commas.   Obj-Class,        Mailbox,                 Mailbox, First Name,      Angela,                  Kim, Last name,       Barbariol,               Yoshida, Display Name,    "Barbariol, Angela",     "Yoshida, Kim" Hide from AB     1

Keywords: kbprb KB188649

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.