problem uploading csv file


  • Your avatar
    seyi    
     6 years ago
    0

    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
  • Your avatar
    seyi    
     6 years ago
    0

    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'?
  • Default avatar
    Ksanna    
     6 years ago
    0

    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?
  • Your avatar
    seyi    
     6 years ago
    0

    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.
  • Default avatar
    melaina    
     4 years ago
    0

    hi, how do you identify which column is causing the problem and once identified how does one remove the null string?
  • Your avatar
    seyi    
     4 years ago
    0

    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.
  • Default avatar
    diem28    
     4 years ago
    0

    I am getting error messages or a blank screen when i try to upload my comma deliminated csv file.
  • Your avatar
    seyi    
     4 years ago
    0

    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.
  • Default avatar
    diem28    
     4 years ago
    0

    how do i get to the error logs?
  • Your avatar
    seyi    
     4 years ago
    0

    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.
  • Default avatar
    diem28    
     4 years ago
    0

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

    Thank you.
  • Your avatar
    seyi    
     4 years ago
    0

    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.