Comma separated not semicolon separated file

30.07.2016 15:56
#1
danchef
Joomshopping forum user no avatar
Name: Boris
27.07.2015
Сообщения: 31
Quote
Comma separated not semicolon separated file

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

 
31.07.2016 07:37
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25854
Quote
Aw: Comma separated not semicolon separated file

order export version?

 
31.07.2016 09:54
#3
danchef
Joomshopping forum user no avatar
Name: Boris
27.07.2015
Сообщения: 31
Quote
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
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25854
Quote
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
#5
danchef
Joomshopping forum user no avatar
Name: Boris
27.07.2015
Сообщения: 31
Quote
Aw: Comma separated not semicolon separated file

Hi,

Perfect -it's working now.

Regards
Boris

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.