• I created a CSV file to import daily tips for a year but when I tried to import it there were mostly errors: “Insert into the Database failed for the following Query:”

    I then reduced the file to one month and the first seven lines were imported and the rest had the same error. Are there restricted characters in the import such as ‘ and “? An example of the failed line is:

    INSERT INTO pra_dailytipdata (tip_title,tip_text,display_date,display_day,group_name,Display_yearly,added_date) VALUES (‘Don�t Try For Too Much In One Ad’,’Probably one of the most common errors in advertising�and it happens in television, radio, and print�is to try to do too much in one ad. \n\nIf, for example, a hardware store lists all the things it has on sale this week in one radio ad, no one can remember after the sixth item what was first. \n\nThe ad would have done a much better job if it had simply mentioned a �store-wide sale� with items reduced in every department. The consumer is now aware of the sale and not confused by too much detail. Let us help you.’,’2016-01-08′,’0′,’TIP’,’on’,’2016-10-06 15:30:18′)

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Dhara Shah

    (@dharashah)

    Hi Heinelg,

    it seems the above INSERT is not proper.
    Can you please send me the csv file in email?
    dhara[at]sanskrutitech[dot]in

    Thread Starter heinelg

    (@heinelg)

    My analysis identified several special characters from MS word that I needed to replace. Now it looks like the problem occurs when there is a comma (“,”) in the tip text. Is there a way to escape commas in the tip text so they can be displayed?

    Thanks!

    Hello, my Import works, but the dates show up as 0000-00-00

    is there a way I can fix this?

    Thanks

    Plugin Author Dhara Shah

    (@dharashah)

    Hi,

    Please make sure the data in csv file is YYYY-MM-DD format.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error in Import’ is closed to new replies.