You create an import file using a text editor (such as WordPad) or Excel. We recommend using comma-delimited (.CSV) files which can be created with Excel spreadsheet files.

Information to include in the import file

Each row (in a text file) or each column (in an Excel file) corresponds to a field within Service Management. You need to know the individual field definitions and storage type definitions for each field in Service Management files related to service calls. See Service call master file for information on these fields.

Import file guidelines

See Import file guidelines for information on import file guidelines.

Sample import file

Below is a sample import file that was created as a spreadsheet. The first row of the import file is reserved for header information and is not imported.