Export in different rows OneToMany, mTm or localized fields

Specifically, I aim to export my product names in all available languages

First you need to extract the data in the different languages. There are 2 ways do do that:

Create separate raw data fields with data query selectors name#en, name#es and name#de.
Create one raw data field with data query selector name#all This will result in a JSON object:
```
{
  "en": "hello",
  "es": "hola",
  "de": "hallo"
}
```
This way has the advantage that you will get the name in all configured languages - so if you add a new one in Pimcore's system settings, this will automatically be present in this array, too.

To achieve a CSV output like you want it

productId, language, name 1, en, hello 1, es, hola 1, de, hallo you will have to adjust the result callback function template for CSV. By default it exports the data of each field in a separate column. But you want it in rows. This can be achieved with a result callback function like this (I assume that you have 2 raw data fields: id and name#all):
$separator = {{ CSV separator }} ?: ';';

if({{ CSV ENCODING }}) { $separator = iconv('UTF-8', {{ CSV ENCODING }}, $separator); }

if(!$params['response']->hasContent()) { $params['response']->headers->set('Content-Type', 'text/csv');

$result = '';
if(!{{ CSV ENCODING }} || strtolower({{ CSV ENCODING }}) === 'utf-8') {
    $result .= "\xEF\xBB\xBF";
}

$result .= '"productId", "language", "name"'."\n";

} else { $result = ''; }

$decodeValue = function($value) use ($params) { if(!is_scalar($value)) { if(is_array($value) && is_scalar(reset($value))) { $value = implode(', ', $value); } else { $value = json_encode($value, \JSON_UNESCAPED_SLASHES | \JSON_UNESCAPED_UNICODE); } }

if({{ CSV ENCODING }}) {
    $value = iconv('UTF-8', {{ CSV ENCODING }}, $value);
}

return '"'.str_replace('"', '""', $value).'"';

};

if($params['rawItemData']) { foreach({{ name#all }} as $language => $name) { $line = []; $line[] = $decodeValue({{ id }}); $line[] = $decodeValue($language); $line[] = $decodeValue($name); $result .= implode($separator, $line)."\n"; } }

$params['response']->addContent($result);



> Additionally, I'm interested in exporting the relationships of my products, such as:

productId, categoryId, productName, categoryName
1, 1, pencil, cat1
1, 2, pencil, cat2
1, 3, pencil, cat3

This works the same as above for the languages but this time you have to select `categories:each:(id;name)` to retrieve the categories which are assigned to the currently processed product.

Next time, please be so fair and write such project-specific questions to help@blackbit.com

BlackbitDigitalCommerce / pimcore-data-director

Export in different rows OneToMany, mTm or localized fields #133