problem uploading csv file

Dear all.

I struggle the whole morning to import 2000 Coupons via .csv

I found out, that the component has a problem with the Mac version of the .csv but still when I make the file on a normal PC I get (now different) error messages and can not seem to solve them.

-- Please enter a valid function type
-- Please enter a valid function type 2 mode

I used the CSV Spreadsheet Format (from the sample in the component)

ID 1
Coupon Code 12345
Published Published
Function Type Coupon
Function Type 2 Product
Percent or Amount Percent
Discount Type Value Overall
Value Definition 10
Number of Uses NULL
Minimum Value 0
Expiration(YYYYMMDD) 20111230
Customers empty
Asset NULL
NULL

I really need help. What is wrong here?

Thanks

Hello,

what is the id of the error you are receiving when entering the above, is it 1? Also can you verify that column D is 'coupon' and column E is 'product'?

The ID of the errors is 1 to 2000 (all the coupons I want to upload IDs)

Column D is Coupon and column E is Product yes!

Any Idea?

the problem within the import file was the string "NULL". Within csv, this is rendered as a string and not an actual null value. The solution was removing this string.

hi, how do you identify which column is causing the problem and once identified how does one remove the null string?

if you have the string 'NULL' within your csv file, then delete it. Best way to have a template for importing is to create some coupons, then go to reports->coupon list and click the export to excel icon. This is a template that can be imported back, after changing the coupon codes.

I am getting error messages or a blank screen when i try to upload my comma deliminated csv file.

Hello,

For the blank screen, do you have access to your error logs? If so can you look at them to see what is stopping execution? For the error messages, maybe you can email the file and I can have a look. Please use the email address on the contact us page.

how do i get to the error logs?

No need, I receive the same fatal error. I m not really sure what it is, but it has to do with the --- used in some columns that should be just blank. Once I removed all the dashes the file works fine. I will email it back to you.

it worked just fine. Please note that your sample on the import page shows "---" you may want to remove that. :)

Thank you.

I see now. That is there to indicate that field is not used for that specific type of coupon. Maybe we will color code it instead.