X-Cart forums

[InteractM]

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

SQL:

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

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

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

include/orders_export.tpl:

    '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

[InteractM]

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

Thanks

[InteractM]

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

[InteractM]

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