| Info |
|---|
As mentioned on the Prepare the Product Data page, this part of the documentation describes the requirementsthat your product data feed needs to fulfill in order to build Product Guides entirely yourselves with the excentos Workbench. |
...
If you have more complex feeds (e.g. web services or XML feed), please return to the Prepare the Product Data section or contact excentos support if you have any questions regarding your data - we'll help you getting any data feed requirements covered. |
Table of Contents:
| Table of Contents | ||
|---|---|---|
|
...
| Type / Field | Specification | ||
|---|---|---|---|
| File type | CSV file (preferred encoded as UTF-8) | ||
| Field separator | Needs to be one of the following: ',' (comma), ';' (semi-colon), ':' (colon), '|' (pipe), tab or whitespace character. | ||
| Text separator | Coherent text has to be surrounded by " " (double quote) or ' ' (single quote). One of them at the beginning of a cell; one at the end of a cell. This is especially important if the text contains a specified field separator. | ||
| Escape character | The escape character is used within the text separators. Normally this is a '\' (backslash), to escape a single double quote another single double quote can also be used. | ||
| Decimal separator | Has to be a '.' (dot), e.g. '799.99'. All comma separated decimals (e.g. '799,99') cannot be converted into numbers at the moment. | ||
| Multiple values separator | If some attributes contain cells with more than one value in a cell (e.g. the attribute color with the values black and blue) these values need to be separated by a separator (e.g. a comma; result: "black,blue"). Otherwise these two values are always interpreted as one value and cannot be split by using the "Multi value" switch button in the data attribute table (see Upload your Product Data File, Multi Values).
| ||
| Units | Such as kilogram, currencies etc. need toshould be in a separate field if the data field should be interpreted as a number. (we've marked this as suggestion only because the unit is only required if it shall be displayed in the Product Guide. The unit is not technically required, except if prices are displayed in the result list because we then need to know the currency) |
| Info | ||
|---|---|---|
| ||
The field and text separator as well as the file type encoding and the escape character can be set during the uploading process of your product data file (local upload). |
...