WordPress.org

Ready to get started?Download WordPress

Forums

St-Daily-Tip
File Upload Problem (13 posts)

  1. shughey
    Member
    Posted 1 year ago #

    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/

  2. Dhara Shah
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. shughey
    Member
    Posted 1 year ago #

    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 Faith
    Charles 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

  4. shughey
    Member
    Posted 1 year ago #

    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')

  5. Dhara Shah
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  6. shughey
    Member
    Posted 1 year ago #

    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.')

  7. shughey
    Member
    Posted 1 year ago #

    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

  8. bryanwMSB
    Member
    Posted 1 year ago #

    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!

  9. Michael Broder
    Member
    Posted 1 year ago #

    I have the same problem as bryanwMSB.

  10. Dhara Shah
    Member
    Plugin Author

    Posted 1 year ago #

    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

  11. Dhara Shah
    Member
    Plugin Author

    Posted 1 year ago #

    Dear All,
    Please check the latest update.
    It should solve the problem

  12. shughey
    Member
    Posted 10 months ago #

    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

  13. Dhara Shah
    Member
    Plugin Author

    Posted 10 months ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic