Error in Import
-
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!
- The topic ‘Error in Import’ is closed to new replies.