“Datafeed” tab (up to version 5.6.3) – novomind iPIM Documentation

In the first step you create a new datafeed and make the basic settings. To do so, proceed as follows:

Go to the “Datafeed” tab and click on the button. Then a new dataset with empty input fields is created. Just the input field “Datafeed ID” contains a datafeed identifier that was assigned by the system.

Possibly change the datafeed identifier in the “Datafeed ID” field.
Enter names for the different locales.
1. Click on the button in the “Name” field. Following this appears a dialogbox that features individual input fields for the different locales.
2. Enter the multilingual names in the respective input fields.
3. Click on the ACCEPT button to finish the process and to close the dialog box.
Enter descriptions for the different locales.
1. Click on the button in the “Description” field. Following this appears a dialogbox that features individual input fields for the different locales.
2. Enter the multilingual descriptions in the respective input fields.
3. Click on the ACCEPT button to finish the process and to close the dialog box.
From the “Version” menu, select a taxonomy. When executing the datafeed export, only products from this taxonomy will be exported.

From the “Context” menu, select a context level.
Specify whether the export only contains attribute values from the selected context level or whether in case of empty attributes on the selected context level, the export contains attribute values that were inherited from a superordinate context level (first introduced in version 5.6):
- In order to set that only attribute values from the selected context level are exported, move the “Export only data from selected context” toggle switch to the position.
- In order to set that attribute values inherited from a superordinate context level are exported, move the “Export only data from selected context” toggle switch to the position.
From the “Partner” menu, possibly select a partner. When executing the datafeed export, the product data from this partner will be exported.
From the “Locale” menu, select an output language. This setting specifies the data language plane whose data is exported when executing the datafeed export.
From the “Fallback language” menu, possibly select a fallback language. If there is no data on the selected locale level, product data from this language level will be exported.
From the “Export area” menu, select an export area. You can choose between the options:
- Item: Product data on the item level will be exported.
- Item sorted by 1. dimension: Product data on the item level will be exported. Hereby the items will be sorted by variants.
- Product: Product data on the item level will be exported.
- Products an items: Product data of the product level and the item level will be exported.
From the “Validity range” menu, select the validity range. You can choose between the options:
- All active products: Only product data of active products will be exported.
- All active and inactive products: Product data of active as well as inactive products will be exported.
- All inactive products: Only product data of inactive products will be exported.
- Valid products: Only product data of valid products will be exported. This comprises products whose period of validity period includes the time when export is executed.
- Invalid products: Only product data of invalid products will be exported. This comprises products whose period of validity period excludes the time when export is executed.
From the “Digital asset export profile” menu, possibly select a digital asset export profile. This setting specifies the quality in which digital assets are exported. You can choose between the options:
- Original format: Images are exported in the original size and original resolution.
- Pictures in JPG, size large: Images are exported in a large format and a resolution of 72 dpi.
- Pictures in JPG, size medium: Images are exported in a medium format and a resolution of 72 dpi.
- Pictures in JPG, size small: Images are exported in a small format and a resolution of 72 dpi.
Activate respectively deactivate the datafeed:
- In order to activate the datafeed, move the “Activation” toggle switch to the position.
- In order to deactivate the datafeed, move the “Activation” toggle switch to the position.
Specify if the export comprises all the relevant product data or just the products which was updated since the last export:
- In order to set that only updated product data will be exported, move the “Incrementally” toggle switch to the position.
- In order to set that all the relevant product data will be exported, move the “Incrementally” toggle switch to the position.
From the “Type” menu, select a datafeed type. You can choose between the options:
- iPIM Standard datafeed: This is the standard datafeed which can also be executed via the action menu in iPIM Portal.
- iPIM Buy datafeed: This datafeed can be executed from iPIM Buy via the REST interface.
- iPIM Supply datafeed: This datafeed can be executed from iPIM Supply via the REST interface.

Enter a file name as well as a file extension in the input field “File name” (e. g. “filename.xlsx”)*.
Since version 5.4.2: Possibly specify a user right. Following this, only users possessing the respective right can trigger or edit the datafeed**/***:
1. Click on the button in the “User right” field.A slider showing the user right directory is shown.
2. Choose the right from the rights directory. Possibly use the text search to filter the list of rights by a search term.
3. Click on the right to select it.The previous slider is shown again.

*In order to have current date/time stamps included in the file name of the export file, you need to include the variable “{0}” in the file name; e.g. “filename{0}.xlsx” for an export file such as “filename2024-02-05”. If you use the variable “{1}” instead of “{0}”, the file name includes the date/time when the exported data was updated most recently.

Possibly enter a date format in the input field “File name date format”; for example yyyy-MM-dd which results in a date format such as 2024-01-05.
Regarding the date formats you can refer to the Java simple format guideline.
From the “Transfer profile” menu, select a data transfer profile. Transfer profiles are specified in iPIM CC. For example, in a transfer profile it can be specified that the export file can be downloaded via the fold-out menu “Tasks”.
From the “Export format” menu, select an export format. When selecting an export format, make sure that it corresponds to the file extensions you have entered further above:
- XLS: Export as an .xls file (Excel format till 2007).
- XLS+attribute model: Export as an .xls file with a second table sheet that shows the essential properties of the exported attributes, among them are the individual values of a value set.
- XLSX: Export as an .xlsx file (Excel format since 2007).
- XLSX+attribute model: Export as an .xlsx file with a second table sheet that shows the essential properties of the exported attributes, among them are the individual values of a value set.
- CSV: Export as a .csv file. Here, you additionally need to select an encoding (UTF-8 or ISO 885915) and you need to enter a separator.
- Quoted CSV: Export as a .csv file with the individual attribute values enclosed by quotation marks.
- iPIM-XML: Export as a .xml file.****
- BMEcat v.1.2: Export as a file in the BMEcat format.
- Export template: Export based on a Jasper report template. Here you need to select a template as well as an export format (PDF for a .pdf file or XLSX for a .xlsx file).
- Export template, single: Export based on a Jasper report template with a separate file created for each exported product.

In order to finish the process, click on the SAVE button. The new dataset is now created and it appears in the list of datafeeds.
In order to cancel the process, click on the RESET button.

**The right “ipim-core.api.actions.export-datafeed” is required to be allowed to assign a user right to a datafeed.
***The restriction via a user right is only valid for iPIM Export. In the iPIM Portal, the respective datafeed can still be triggered by any user as long as they possess the right to trigger a datafeed.
****For this export format, you must not define a 2nd target column in the attribute mappings.

If a datafeed includes digital assets, a .zip archive containing the digital assets is created during the export and stored on the set transfer directory under the specified file name.

FAQ

Can I change the automatically generated datafeed identifier?

Yes, the datafeed identifier assigned by the system can be changed if needed.

What is the purpose of the selection in the “Version” menu?

From the “Version” menu, a taxonomy is selected. When executing the datafeed export, only products from this taxonomy will be exported.

What does the “Export only data from selected context” setting do?

This setting specifies whether the export only contains attribute values from the selected context level, or whether, in case of empty attributes on the selected context level, attribute values inherited from a superordinate context level are exported instead.

What is the purpose of the selection in the “Partner” menu?

From the “Partner” menu, you can possibly select a partner in order to specifically export the product data from this partner.

What is the function of the “Locale” menu?

From the “Locale” menu, the output language is selected. This setting specifies the data language plane whose data is exported when executing the datafeed export.

What is the purpose of the “Fallback language”?

The fallback language selected from the “Fallback language” menu is used if there is no data on the selected locale level for a product.

What is the difference between “active” and “valid” products in the context of the export?

“Active/inactive products” refer to the activation status of a product, while “valid/invalid products” refer to a product’s period of validity, i.e. whether this period includes the time when the export is executed.

What happens to digital assets when exporting a datafeed?

If a datafeed includes digital assets, a zip archive containing the digital assets is created during the export and stored on the set transfer directory under the specified file name.

What does the “Incrementally” setting mean?

The “Incrementally” toggle switch specifies whether only product data that has been updated since the last export is exported, or whether all the relevant product data is always exported.

How can I ensure that export files automatically receive a current timestamp in the file name?

To do so, include the variable “{0}” in the file name, for example “filename{0}.xlsx”, which results in an export file such as “filename2024-02-05”. If you use the variable “{1}” instead, the file name includes the date/time when the exported data was updated most recently.

How can I customize the date format used in the file name?

Enter a format such as “yyyy-MM-dd” in the “File name date format” field. Regarding the date format, you can refer to the Java simple format guideline.

How can access to a datafeed be restricted?

Since version 5.4.2, a right can be selected from the rights directory in the “User right” field. Following this, only users possessing the respective right can trigger or edit the datafeed. In order to be allowed to assign a user right at this point, the right “ipim-core.api.actions.export-datafeed” is required.

Does the restriction via the assigned user right also apply in the iPIM Portal?

No, the restriction is only valid for iPIM Export. In the iPIM Portal, the respective datafeed can still be triggered by any user as long as they possess the general right to trigger a datafeed.

Where are transfer profiles configured and what is their purpose?

Transfer profiles are specified in iPIM CC. For example, in a transfer profile it can be specified that the export file can be downloaded via the fold-out menu “Tasks”.

What needs to be considered when selecting the export format?

You need to make sure that the selected export format corresponds to the file extension entered in the “File name” field further above.