Default number format and separators

Specify catalog types

In order to specify a catalog type for the selected catalog, proceed as follows:

1. From the menu in the “Catalog types” column, select the catalog type.
2. Click on the  button to save your selection or click on the  button to dismiss it.

By allocating catalog types to a particular catalog you can determine which global validation rules are applied to the imported item data during the transformation process. Catalog types can be defined in the Administration section. Click here to learn about his matter.

Specify the default number format

In order to specify the default number format, proceed as follows:

1. From the menu in the “Number format” column, select the number format (e.g. “German” for comma-separated decimal values, “English” for dot-separated decimal values or “automatic” for automatic recognition of the number format).
2. Click on the  button to save your selection or click on the  button to dismiss it.

Specify separators

Specify a single separator

In order to specify a separator for the separation of the individual values of list of values attributes, proceed as follows:

1. Enter the separator in the input field in the “Separator” column.
2. Click on the  button to save your input or click on the  button to dismiss it.

Specify additional separators

In order to specify an additional separator, proceed as follows:

1. Click on the  button. Following this, a new input field appears.
2. Enter the separator in the input field.
3. Click on the  button to save your input or click on the  button to dismiss it.

Move separators

In order to move a separator within the order of separators, proceed as follows:

1. Click on thebutton that is situated next to the input field and hold the mouse button down.
2. Move the separator to its new position and release the mouse button.
3. Click on the  button to save your changes or click on the  button to dismiss it.

Remove a separator

In order to remove a separator, proceed as follows:

1. Click on the button that is situated next to the input field of the separator. Following this, the input field vanishes.
2. Click on the  button to save your changes or click on the  button to dismiss it.

FAQ

Basics

What can be configured in the “Default number format and separators” section?

In this section of the transformation configuration, you can specify the catalog type, the default number format as well as the separator for separating the individual values of a list of values attributes. These settings affect how the imported item data is processed during the transformation.

Specify catalog types

What is the purpose of allocating catalog types?

By allocating catalog types to a particular catalog you can determine which global validation rules are applied to the imported item data during the transformation process. The catalog type therefore indirectly controls which checks take effect as part of the transformation.

Specify the default number format

Which options are available for the default number format?

The available options include “German” for comma-separated decimal values, “English” for dot-separated decimal values, as well as “automatic” for automatic recognition of the number format. The selected format determines how numeric values from the imported item data are interpreted.

What does the “automatic” setting do for the number format?

With the “automatic” setting, the number format of the imported values is recognized automatically instead of being fixed to “German” or “English”. This can be useful if the imported data is not consistently provided in the same number format.

Specify separators

What are the separators configured in this section used for?

The separators are used for separating the individual values of a list of values attribute. They specify at which points an imported value is split into the individual components of the list of values.