Correcting Errors with Creating, Updating, or Deleting Objects by Using the Failed Objects File

When you run Bulk Administration Manager to create, update, or delete users or contacts, it copies each record that it cannot process to a failed objects report file, along with the reason that the record was not processed correctly.

For example, in the following CSV file, the first record includes an invalid entry for the Country field, and the second record specifies a template that is not a voice mail user template:

Alias, City, PostalCode, State, Country, TemplateAlias
Jsmith, Beverly Hills, 90210, Ca., United States, VoiceMailUserTemplate
BRobertson, Seattle, 98121, WA, US, AdminUserTemplate

 

Using this file to create users with voice mail produces the following failed objects file:

FailureReason, alias, city, postalcode, state, country, templatealias
United States is invalid for column Country|, Jsmith, Beverly Hills, 90210, Ca., United States, VoiceMailUserTemplate
Object not found or is not a template: Parameter = [@TemplateObjectId], Table = [vw_SubscriberTemplate], Column = [Alias,ObjectId]|, BRobertson, Seattle, 98121, WA, US, AdminUserTemplate

 

The FailureReason column-which provides information about the invalid data-is added before the first column.

To correct errors, do the following procedure to modify the failed objects file, rename it, and use it as the input file when you re-run Bulk Administration Manager.

Note that depending on the type of problem with the data in the CSV file, for each problem record, Bulk Administration Manager may report multiple errors or only the first error encountered. Therefore, after you correct errors, Bulk Administration Manager may detect additional errors in the same record when the data is processed again. Thus, you may need to repeat the correction process-running the tool and correcting an error-several times to find and correct all errors.

To Correct Errors with Creating, Updating, or Deleting Users or Contacts by Using the Failed Objects File
  1. Go to the directory location of the failed objects file that you specified when you ran Bulk Administration Manager.
  2. Open the file and correct all problems with the data, as indicated by the information in the FailureReason column for each record.
  3. Remove the FailureReason column or change the heading to "junk."
  4. When you have finished modifying the data, save the file as a CSV file with a new name.
  5. Run Bulk Administration Manager again with the CSV file that you saved in Step 4 as the input file.
    6. Note that each time that you run Bulk Administration Manager, the failed objects file is overwritten (unless you specify a new name for the file each time you run the tool).
  6. Repeat this procedure until all records are processed without error.