Comma separated not semicolon separated file

30.07.2016 15:56
#1
danchef
Joomshopping forum user no avatar
Name: Boris
27.07.2015
Posts: 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
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16509
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
Posts: 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
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16509
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
Posts: 31
Quote
Aw: Comma separated not semicolon separated file

Hi,

Perfect -it's working now.

Regards
Boris

 
Copyrights MAXXmarketing GmbH. All Rights Reserved