Hi guys, I need to export orders via a Middleware as a CSV. We need one file per order and one line

U018XELUZS9

Hi guys, I need to export orders via a Middleware as a CSV. We need one file per order and one line per orderitem. I need something like this in the end:

order_nr,position,article_numer
123,1,article1
123,2,article2
123,3,article3

What's the best way to solve this?

U018XELUZS9

My initial idea was to iterate about orders (with an OrderReadStreamPlugin), because I have all of the needed data there (order-data and also order-item-data in the item key).
Another approach would be to iterate over orderitems (with an OrderItemReadStreamPlugin), but I have no idea if it's possible to write them to the same order-csv afterwards.

If I try to use OrderReadStreamPlugin as the input with this mapping:

'order_nr' => 'order_reference',
'position' => function($payload) {
    return array_keys($payload['items']);
},
'article_numer' => function($payload) {
    return array_column($payload['items'], 'sku');
}

... it fails while writing the CSV, because two items of the payload are now arrays:

Array to string conversion

Unknown

i think the approach is generally the one that would be triggered here https://documentation.spryker.com/docs/spryker-middleware#omsmiddlewareconnector-module, right?

Unknown

can you dump what these arrays are that can’t be converted?

Unknown

what is the writer you are using?

U018XELUZS9

SprykerMiddleware\Zed\Process\Communication\Plugin\Stream\CsvOutputStreamPlugin

U018XELUZS9

Exactly this one: https://github.com/spryker-middleware/process/blob/1.3.0/src/SprykerMiddleware/Zed/Process/Communication/Plugin/Stream/CsvOutputStreamPlugin.php

Unknown

well, this does not look like it is conceptually possible

Unknown

you are trying to put a hierarchical structure into a flat structure

Unknown

or, i misunderstood. you do not need the above meta data for the order, but just the items, correct?

U018XELUZS9

I know the order-metadata in every row

Unknown

which field from the provided data maps to which field of the target structure?

U018XELUZS9

kind of weird, but that's how it is 😄

Unknown

ok 😊

U018XELUZS9

which field from the provided data maps to which field of the target structure?

What do you mean?

Unknown

something like artikel_nummer -> article_numer

Unknown

but that is already clearer

U018XELUZS9

oh, I just tried to simplify the mapping, the payload in the screenshot uses still the real mapping, just with more fields

U018XELUZS9

I was also thinking about creating an OrderItemIterator which processes als order-items and saves them into the file (per order), but not sure if this will work.

U018XELUZS9

see https://github.com/spryker-middleware/process/blob/1.3.0/src/SprykerMiddleware/Zed/Process/Business/Process/Processor.php#L108-L123

Unknown

i think that is the way to go

Unknown

not 100% sure though where to hook in. the iterator might be a good place