Source data set configuration

Label

this is the name of your source data set

Key

prefedined value

SAWSConnector

this is the application you chose when adding your station. This value cannot be altered

HTTPS required

indicates if HTTPS protocol will be used (default setting = HTTP)

Format

json/html/xml/debug

use “json” for the SimpleExcel connector

Default language

the default language of your source data set

defines what language your source data set will be displayed in

Select source of data

PIM Product, PIM View or MAM files

defines if exported data stem from the product directly, from PIM views or from MAM files

Filter objects by class

defines which classes will be considered for export

select every class you wish to export. No hand-down of parent nodes! If you wish to consider all sub-nodes of a class, they must all be selected separately here.

Procedure for multilanguage values

“new row for every language” or “new column for every language; extend attribute name in column by language key”

defines how values for several languages should be handled. The first option will wirte a new line for every language option of your product/view/MAM file. The second option will write a new column for every language option of your product/view/MAM file and extend the column’s key by the key of the language entered in the language mapping of the source data set (see below).

Language separator

Set a separation sign for the extension of the language key (see above). For example, set the underscore “_”.

Remove attributes that are not configured?(see mapping table, active = yes

yes/no

if activated, only attributes that are configured in the mapping table (see section attribute mapping) will be exported. If a plugin is set in the mapping table, it will technically be considered as “not configured”. If you use project-specific plugins, please do not activate this checkbox.

Export only columns that are found in your template

yes/no

if activated, only attributes that are defined in the header row of your template will be used for export. Keys will not be extended by language for example. Keys that you added to your attribute mapping but are not contained in your template file, will not be exported.

Set your output file format

.xlsx, .xls, .csv

Select the file format of your export files.

PHP Memory Limit in MB

512 (by default), increase if desired.

Set higher values if you wish to export a lot of data or if your template file contains large images.

Path to XLS template file

You can set a path to the template file here. If you indicated a CS MAM path below, this option here will be overwritten. Both options will overwrite the setting you may have made in your station.

CS MAM path to XLS template file

Upload your template file to the CS MAM module and select it here using the file dialogue.

Configuration of the output file

Save your settings after you set the paths to your template file. The SAWSConnector will read the template; the following settings depend on your template file!

Target tab: set the target sheet in your template file for your first data map.

Use data map #: select the data map you wish to export to the selected sheet

Row number of header row: indicate which line in your template sheet contains your keys

Number of first data row: indicate which line is the first line that you wish data to be written to

Sort by column: indicate if you wish to sort your output file by a certain column.

Deactivated: set to active if you do not wish to use the particular line for export anymore.