Import descriptor records

You can create an import descriptor record to define the rules for importing data from external files into HPE Service Manager. Each import descriptor record describes the following information:

• The external file source
• The internal destination table
• The format used to identify fields in the imported file
  • Fixed-width fields
  • Character-delimited fields
• The rules for handling duplicate records
  • Ignore duplicate records
  • Replace duplicate records
  • Update duplicate records
• The optional Format Control record to apply
• The names of destination fields for import records
• The date format to use
• The number of elements from an array to import

Note: You cannot import the database dictionary definition of fields from an external file. To import database dictionary field definitions, you must use the native HPE Service Manager unload format.

When you create an import descriptor record, Service Manager validates the records in the external file against the Service Manager database dictionary. If the validation is unsuccessful, Service Manager displays the message: Validation failed

You can click on the warning message to see the reasons why the data validation failed. Although Service Manager enables you to save an invalid import description record, you cannot use this record to import data. You must correct any validation errors before importing data. After Service Manager validates the file, it imports one record for each entry in the external file.