Skip to main content
Matrix42 Self-Service Help Center

Importing Material Groups

Overview

Material Groups are managed in Contracts application → Financial AccountingMaterial Groups page:

material_groups_overview.png

In Contracts Management there is an option to import Material Groups using a standard template.

Material records import

To import Material Groups:

  1. Go to Matrix42 Software Asset and Service Management → Contracts application.
  2. In the navigation area, click  Financial AccountingMaterial Groups.
  3. On the toolbar, click Import Material Groups. The Quick Import wizard opens.
  4. Follow the instructions.

Quick import definition includes the same steps and data processing sequence as any other standard import definition. The main difference consists in the pre-defined source file structure and pre-configured mapping rules for the Quick Import definition.

Common rules to consider when editing the Import Template file:

  • Culture context of the data: when entering the text, consider the language specified in the quick import settings.
  • Not specified or ambiguous values: if no or more than one matching values are found, the value that is specified in the data source file is not saved to the system database.
  • Import processing details: a detailed report of the import processing stages is available in the Import Log Files section of the Administration application.

Explanation of the Import Template 

All imported data can be modified manually in the user interface.

Field Name Explanation Maximum Character Length

Key

Required: alphanumeric string for logical identification of a material group. This information is a key field, which means that it is used by the import process to determine whether to create a data set or whether to update the existing, matching data set.

50

Name

Required: alphanumeric string that is used for the name of a material group.

200

Description

Alphanumeric string that is used to describe a material group.

1000

Material Groups Import Example 

The given example is a filled out template imported for the English (United States) [es_US] culture context of the data:

material_groups_template.png

Successfully completed Material Groups Import results in the following records in the Contracts Financial Accounting section:

material_groups_imported.png

  • Was this article helpful?