X-Cart forums - Export orders in custom format

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Export orders in custom format (https://forum.x-cart.com/showthread.php?t=59695)

Export orders in custom format

I would like to have "pipe" delimited CSV export file as one of options. So far I have done:

SQL:

Code:

INSERT INTO xcart_languages VALUES ('en','lbl_with_pipe_delimiter','(with pipe delimiter)','Labels');

common/main/order_list.tpl:
common/main/orders.tpl:

Code:

<option value="csv_pipe">{$lng.lbl_40x_compatible}: CSV {$lng.lbl_with_pipe_delimiter}</option>

include/orders_export.tpl:

Code:

    'csv_pipe' => array (

        'ctype' => 'application/csv',

        'delim' => '|',

        'file' => 'orders.csv'

    ),

But when I have exported as "pipped" some rows are cut after order date compare to tabbed/commas export files. Any idea what can be wrong?

Thanks

Re: Export orders in custom format

Anybody? Also where I can customize orders export file data structure?

Thanks

Re: Export orders in custom format

Never mind - got everything to work. In the meantime found a bug in X-Cart related to orders export.

Re: Export orders in custom format

Is there any way to export Extra Fields for product orders? I have try to use {item.extra_field[1]} but looks like this is a wrong way.

Thanks