Title: File Upload Problem Last modified: August 20, 2016 --- # File Upload Problem * [shughey](https://wordpress.org/support/users/shughey/) * (@shughey) * [13 years, 7 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/) * Love the plugin. It has satisfied a need I couldn’t find with any other plugin. However, I’m having a problem doing a file upload. Is the format wrong somewhere, if so, where? Appreciate any help you can offer. * Below is the error message I’m getting: * Error occured while trying to import! * Insert into the Database failed for the following Query: INSERT INTO wp_dailytipdata( tip_text,display_date,display_day,group_name,Display_yearly) VALUES (‘Cheque Book of the Bank of Faith Charles Spurgeon * November 8 * Heavenly Wealth * No good thing will he withhold from them that walk uprightly.Many pleasing things the Lord may withhold but \”no good thing.\” He is the best judge of what is good for us. Some things are assuredly good’,’and these we may have for the asking through Jesus Christ our Lord. (Psalm 84:11) * Holiness is a good thing’,’and this He will work in us freely. Victory over evil tendencies’,’strong tempers’,’and evil habits He will gladly grant’,’and we ought not to remain without it. * Full assurance He will bestow’,’and near communion with Himself’,’and access into all truth’,’and boldness with prevalence at the mercy seat. If we have not these’,’it is from want of faith to receive and not from any unwillingness of God to give. A calm’,’a heavenly frame’,’great patience’,’and fervent love—all these will He give to holy diligence. * But note well that we must \\\”walk uprightly.\\\” There must be no cross purposes an’) Insert into the Database failed for the following Query: INSERT INTO wp_dailytipdata( tip_text,display_date,display_day,group_name,Display_yearly) VALUES (‘d crooked dealings; no hypocrisy nor deceit. If we walk foully God cannot give us favors’,’ for that would be a premium upon sin. The way of uprightness is the way of heavenly wealth-wealth so large as to include every good thing. * What a promise to plead in prayer! Let us get to our knees.’,’2012-11-08′,’5′,’ spurgeon.morning’,’on’) * [http://wordpress.org/extend/plugins/st-daily-tip/](http://wordpress.org/extend/plugins/st-daily-tip/) Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Author [Dhara Shah](https://wordpress.org/support/users/dharashah/) * (@dharashah) * [13 years, 7 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176784) * Problem seems to be the Tip Text. As it contains comma “,” in the text, i guess the CSV file is not forming correctly. I.e. the Commas in the Tip Text are being considered and field separators for the CSV file. Kindly try to remove the “,” from the Text and try again. * If this doesn’t solve the problem, kindly provide the actual CSV if possible. * Thread Starter [shughey](https://wordpress.org/support/users/shughey/) * (@shughey) * [13 years, 6 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176842) * Dhara, * I appreciate your assistance and have been trying to resolve this on my own but obviously I’m not doing something correctly. * Here is the CSV file: * Tip Text, Display Date,Display Day,Group Name,Repeat Yearly. Cheque Book of the Bank of FaithCharles Spurgeon * November 25 * Heavenly Wealth * _No good thing will he withhold from them that walk uprightly_.Many pleasing things the Lord may withhold but “no good thing.” He is the best judge of what is good for us. Some things are assuredly good”,” and these we may have for the asking through Jesus Christ our Lord. (Psalm 84:11) * Holiness is a good thing”,” and this He will work in us freely. Victory over evil tendencies”,” strong tempers”,” and evil habits He will gladly grant”,” and we ought not to remain without it. * Full assurance He will bestow”,” and near communion with Himself”,” and access into all truth”,” and boldness with prevalence at the mercy seat. If we have not these”,” it is from want of faith to receive and not from any unwillingness of God to give. A calm”,” a heavenly frame”,” great patience”,” and fervent love— all these will He give to holy diligence. * But note well that we must “walk uprightly.” There must be no cross purposes and crooked dealings; no hypocrisy nor deceit. If we walk foully God cannot give us favors”,” for that would be a premium upon sin. The way of uprightness is the way of heavenly wealth-wealth so large as to include every good thing. * What a promise to plead in prayer! Let us get to our knees.”,”2012-11-25″,”5″,” f.b.myer”,”on” * Greatly appreciate any assistance you can offer. * Thanks, Sam Hughey * Thread Starter [shughey](https://wordpress.org/support/users/shughey/) * (@shughey) * [13 years, 6 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176843) * After uploading the file, I receive this: * Error occured while trying to import! * Insert into the Database failed for the following Query: INSERT INTO wp_dailytipdata( tip_text,display_date,display_day,group_name,Display_yearly) VALUES (‘Cheque Book of the Bank of Faith Charles Spurgeon * November 8 * Heavenly Wealth * No good thing will he withhold from them that walk uprightly.Many pleasing things the Lord may withhold but \”no good thing.\” He is the best judge of what is good for us. Some things are assuredly good\”‘,’ and these we may have for the asking through Jesus Christ our Lord. (Psalm 84:11) * Holiness is a good thing’,’ and this He will work in us freely. Victory over evil tendencies’,’ strong tempers’,’ and evil habits He will gladly grant’,’ and we ought not to remain without it. * Full assurance He will bestow’,’ and near communion with Himself’,’ and access into all truth’,’ and boldness with prevalence at the mercy seat. If we have not these’,’ it is from want of faith to receive and not from any unwillingness of God to give. A calm’,’ a heavenly frame’,’ great patience’,’ and fervent love— all these will He give to holy diligence. * But note well that we must walk uprightly.\\\” There must’) Insert into the Database failed for the following Query: INSERT INTO wp_dailytipdata (tip_text, display_date,display_day,group_name,Display_yearly) VALUES (‘be no cross purposes and crooked dealings; no hypocrisy nor deceit. If we walk foully God cannot give us favors\”‘,’ for that would be a premium upon sin. The way of uprightness is the way of heavenly wealth-wealth so large as to include every good thing. * What a promise to plead in prayer! Let us get to our knees.’,’2012-11-25′,’5′,’ f.b.myer’,’on’) * Plugin Author [Dhara Shah](https://wordpress.org/support/users/dharashah/) * (@dharashah) * [13 years, 6 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176844) * It still seems problem with the CSV file. Please open the CSV file using MS Excel to see the columns created. * All the commas creates different columns. and the fields are not going in their proper places. * Thread Starter [shughey](https://wordpress.org/support/users/shughey/) * (@shughey) * [13 years, 6 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176845) * I have double quotes around each comma which isn’t a different column per your latest upgrade instructions and I’ve placed each field, separated by a comma, per the header example. Can you show me precisely where the errors are please? * **Error occured while trying to import!** * Insert into the Database failed for the following Query: INSERT INTO wp_dailytipdata( tip_text,display_date,display_day,group_name,Display_yearly) VALUES (‘Cheque Book of the Bank of Faith Charles Spurgeon * November 26 * Heavenly Wealth * No good thing will he withhold from them that walk uprightly.Many pleasing things the Lord may withhold but \”no good thing.\” He is the best judge of what is good for us. Some things are assuredly good\”‘,’ and these we may have for the asking through Jesus Christ our Lord. (Psalm 84:11) * Holiness is a good thing’,’ and this He will work in us freely. Victory over evil tendencies’,’ strong tempers’,’ and evil habits He will gladly grant’,’ and we ought not to remain without it. * Full assurance He will bestow’,’ and near communion with Himself’,’ and access into all truth’,’ and boldness with prevalence at the mercy seat. If we have not these’,’ it is from want of faith to receive and not from any unwillingness of God to give. A calm’,’ a heavenly frame’,’ great patience’,’ and fervent love— all these will He give to holy diligence. * But note well that we must walk uprightly.\\\” There mus’) Insert into the Database failed for the following Query: INSERT INTO wp_dailytipdata (tip_text,display_date, display_day,group_name,Display_yearly) VALUES (‘t be no cross purposes and crooked dealings; no hypocrisy nor deceit. If we walk foully God cannot give us favors\”‘,’ for that would be a premium upon sin. The way of uprightness is the way of heavenly wealth-wealth so large as to include every good thing. * What a promise to plead in prayer! Let us get to our knees.’,’2012-11-26′,’5′,’ f.b.myer’,’on.’) * Thread Starter [shughey](https://wordpress.org/support/users/shughey/) * (@shughey) * [13 years, 6 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176846) * I found the problem and it’s working now. It doesn’t like double quotes around words, i.e., “this”. I removed those and the file uploaded correctly. * Thanks, Sam Hughey * [bryanwMSB](https://wordpress.org/support/users/bryanwmsb/) * (@bryanwmsb) * [13 years, 5 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176855) * Hello, * 1- I upload csv, it says it uploaded fine, but none of the posts are displayed 2-When I try to view 100 posts, nothing happens. * thanks! * [Michael Broder](https://wordpress.org/support/users/michael-broder/) * (@michael-broder) * [13 years, 5 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176861) * I have the same problem as bryanwMSB. * Plugin Author [Dhara Shah](https://wordpress.org/support/users/dharashah/) * (@dharashah) * [13 years, 4 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176863) * Hi bryanwMSB and Michael Broder Did you check the format of CSV? Please check if CSV contains , in the tip text * If possible, you can send me your CSV on [info@sanskrutitech.in](https://wordpress.org/support/topic/file-upload-problem-2-2/info@sanskrutitech.in?output_format=md) * Plugin Author [Dhara Shah](https://wordpress.org/support/users/dharashah/) * (@dharashah) * [13 years, 4 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176865) * Dear All, Please check the latest update. It should solve the problem * Thread Starter [shughey](https://wordpress.org/support/users/shughey/) * (@shughey) * [12 years, 8 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176883) * Dhara, * I’d love to use this plugin and would even contribute to it’s development, but the file upload is just too confusing to understand. Is there an example somewhere of how the file should look? * Thanks, Sam * Plugin Author [Dhara Shah](https://wordpress.org/support/users/dharashah/) * (@dharashah) * [12 years, 8 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176884) * hi Shughey, * we are working on a feature to export the tips to csv. It might help to understand the CSV format for upload. * I believe the file upload part can handle only simple text. thats why you are facing problem. * you are more than welcome to join the development. We could really use some help. If you are aware about a better way to upload the CSV, please do share, i will surely add it in the plugin. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘File Upload Problem’ 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/) * 12 replies * 4 participants * Last reply from: [Dhara Shah](https://wordpress.org/support/users/dharashah/) * Last activity: [12 years, 8 months ago](https://wordpress.org/support/topic/file-upload-problem-2-2/#post-3176884) * Status: not resolved