Ich möchte für 1.000 Kunden einen Gutschein (Coupon-Code) über 10% Rabatt in den Shop importieren. Die Datei liegt als xlsx bzw. csv vor:
"coupon_id","coupon_type","coupon_code","coupon_value","tax_id","used","for_user_id","coupon_start_date","coupon_expire_date","finished_after_used","coupon_publish"
"1","0","86828898","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"2","0","72081833","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"3","0","10083791","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"4","0","45412069","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
...
"1","0","86828898","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"2","0","72081833","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"3","0","10083791","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"4","0","45412069","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
...
Der Import via MySQL funktioniert nicht, gibt es eine Lösung?
-------------------------------------------
I wish to import 1,000 coupons for customers (coupon codes)
over 10% discount in the shop. The file is a
xlsx and/or csv file:
"coupon_id","coupon_type","coupon_code","coupon_value","tax_id","used","for_user_id","coupon_start_date","coupon_expire_date","finished_after_used","coupon_publish"
"1","0","86828898","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"2","0","72081833","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"3","0","10083791","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"4","0","45412069","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
...
"1","0","86828898","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"2","0","72081833","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"3","0","10083791","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
"4","0","45412069","20.00","0","0","0","0000-00-00","2011-12-31","1","1"
...
The import via MySQL does not work, there is a Solution?
Joomla: 1.5.22
JoomShopping: 2.8.4
JoomShopping: 2.8.4