In the previous lesson, we saw how to import customer data from an existing spreadsheet. But how does the system know how to map the fields on the inbound file? In this lesson, we’ll give an overview of the components of an import format and show how to configure a basic import format from a spreadsheet.
An Import Format is a wizard-like process that takes you through the steps to configure data imports. There are two types of import formats: user defined and standard. User defined import formats allow you to define a custom format for data from inbound files. These files can be a number of formats, including:
- Plain text files, including delimited or fixed-length file formats
- Excel spreadsheet files
- Database queries
Standard import formats allow you to use one of the standard prepackaged XML formats or preprocessors.
The image below shows the creation of a user defined import format from an Excel spreadsheet.
Select the link 'Introducing Data Import Formats in SAP Agent Performance Management' to get more information.
To configure a user defined import format:
- Create the new import format and select User Defined.
- Configure the import field list.
- Customize the field mappings, if needed.
- Activate the import format.