Order export is not a correct CSV file, separator is the semicolon!
How do I exported a proper CSV file (,)
Our system can import a correct CSV, Tab separated, xls or xlsx files.
Regards
Boris
30.07.2016 15:56
|
|
danchef
Name: Boris
27.07.2015
Сообщения: 31
|
|
31.07.2016 07:37
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25854
|
|
31.07.2016 09:54
|
|
danchef
Name: Boris
27.07.2015
Сообщения: 31
|
Aw: Comma separated not semicolon separated file
Hi, I am using vers. JoomShopping_orderexport_2.3.6 order_id;number;user_id;total;subtotal;tax;tax_extended;shippingprice;paymentprice;shipping_tax;payment_tax;discount;currency_code;status;date;shipping;payment;payment_params;name;family;title;firma_name;email;street;home;apartment;zip;city;state;country;phone;mobil_phone;fax;d_name;d_family;d_title;d_firma_name;d_email;d_street;d_home;d_apartment;d_zip;d_city;d_state;d_country;d_phone;d_mobil_phone;d_fax;subtotal_netto;shippingprice_netto;paymentprice_netto;subtotal_brutto;shippingprice_brutto;paymentprice_brutto;delivery;pdf_file;ip;vendor;coupon_code 19;00000019;491;80.0000;80.0000;0.0000;;0.0000;0.0000;0.0000;0.0000;0.0000;;Paid;2016-07-30 14:27:06;;;;Scott Dollerup;;;Tigermedia;boris@danchef.dk;;;;;;;;123456;;;Scott Dollerup;;;Tigermedia;boris@danchef.dk;;;;;;;;123456;;;80;0;0;80.0000;0.0000;0.0000;;19_73b3d5a7ed7023ff9d218d512025d414.pdf;62.107.118.15;; File: 10yo_jshopping_orders(1).csv Is exported directly from phpMyAdmin Regards Boris 10yo_jshopping_orders_1_.csv |
31.07.2016 20:41
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25854
|
Aw: Comma separated not semicolon separated file
change in fiel administrator\components\com_jshopping\importexport\orderexport\orderexport.php row 279 $csv = new csv(); change to $csv = new csv(); $csv->setDelimit(','); And row 335 $csv = new csv(); change to $csv = new csv(); $csv->setDelimit(','); |
02.08.2016 17:45
|
|
danchef
Name: Boris
27.07.2015
Сообщения: 31
|
|