Hello. I am using verion 1.3.9h. Running on a Linux Platform with MySQL ver 4.1.11.

I just finished a campaign and need to setup dozens of unique coupons. I can not seem to import the data. I have a csv file which I exported from the coupons table and copied my data in to the appropriate fields.

using the following code I attempted to import the file (disclaimer: I am not a programmer):

LOAD DATA INFILE '/cravincs0322-2.csv'
INTO TABLE coupons
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(`coupon_id`, `coupon_type`, `coupon_code`, `coupon_amount`, `coupon_minimum_order`, `coupon_start_date`, `coupon_expire_date`, `uses_per_coupon`, `uses_per_user`, `restrict_to_products`, `restrict_to_categories`, `restrict_to_customers`, `coupon_active`, `date_created`, `date_modified`, `coupon_zone_restriction`);

I get generic syntax errors and I don't know what to do from this point.

Any help is appreciated.