Title: Error in Import
Last modified: October 6, 2016

---

# Error in Import

 *  [heinelg](https://wordpress.org/support/users/heinelg/)
 * (@heinelg)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/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!

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Dhara Shah](https://wordpress.org/support/users/dharashah/)
 * (@dharashah)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/error-in-import/#post-8265786)
 * 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](https://wordpress.org/support/users/heinelg/)
 * (@heinelg)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/error-in-import/#post-8355217)
 * 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!
 *  [akinboro](https://wordpress.org/support/users/akinboro/)
 * (@akinboro)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/error-in-import/#post-8604149)
 * 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](https://wordpress.org/support/users/dharashah/)
 * (@dharashah)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/error-in-import/#post-8621337)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/st-daily-tip_9eb177.svg)
 * [St-Daily-Tip](https://wordpress.org/plugins/st-daily-tip/)
 * [Support Threads](https://wordpress.org/support/plugin/st-daily-tip/)
 * [Active Topics](https://wordpress.org/support/plugin/st-daily-tip/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/st-daily-tip/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/st-daily-tip/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [Dhara Shah](https://wordpress.org/support/users/dharashah/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/error-in-import/#post-8621337)
 * Status: not resolved