WordPress.org

Ready to get started?Download WordPress

Forums

Contact Form DB
Google Live Data Solution is here (2 posts)

  1. micmicwang
    Member
    Posted 8 months ago #

    Finally, I found the solution to Google Live Data. All the error came from WordPress Login authentication.

    This is not the perfect solution, but it works.

    1. In http://wordpress.org/support/topic/wordpress-to-google-drive-spreadsheet-step-by-step , cardboardmonet says:

    On line 62
    var url = "http://my-domain.tld/wp-content/plugins/contact-form-7-to-database-extension/export.php?form=myform";

    I used the following one:

    var url = "http://my-domain.tld/wp-content/plugins/contact-form-7-to-database-extension/export.php?form=";
    url += formName;

    2. In http://wordpress.org/support/topic/cfdb-with-google-spreadsheet-error-500, azghanvi says:

    1) contact-form-7-to-database-extension/ExportToCsvUtf8.php: Added new If and commented old if.

    if($_REQUEST["secret"] != "redacted"){
    $this->assertSecurityErrorMessage();
    return;
    }
    /*
    // Security Check
    if (!$this->isAuthorized()) {
    $this->assertSecurityErrorMessage();
    return;
    }
    */

    2) In Code.gs (script editor) added secret param.

    url += '%26'+encodeURI("secret=redacted");
    return UrlFetchApp.fetch(
    ...

    Do exactly as he says in step 1, but in step 2, use

    url += encodeURI("&secret=redacted");

    You may want to change the secret code to something complex.

    Also, an improved step one is here, this one will not influence the original export function:

    if($_REQUEST["secret"] != "redacted"){
    if (!$this->isAuthorized()) {
    $this->assertSecurityErrorMessage();
    return;
    }
    }

    Hope this helps.

    http://wordpress.org/plugins/contact-form-7-to-database-extension/

  2. cardboardmonet
    Member
    Posted 8 months ago #

    I'm glad my post could help! At the moment I'm trying to get the new entries to appear at the bottom of the spreadsheet (opposed to the top). If you have any insight into how to get this to work, please let me know! I'll be playing around with it a bit.

Reply

You must log in to post.

About this Plugin

About this Topic