Export orders in custom format

InteractM · #1 06-08-2011, 08:36 AM

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

InteractM · #2 06-10-2011, 05:58 AM

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

Thanks

InteractM · #3 06-10-2011, 08:46 AM

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

InteractM · #4 06-21-2011, 10:42 AM

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