[Plugin: Contact Form 7 to Database Extension] Pull data in Google docs spreadsheet

Viewing 15 replies - 31 through 45 (of 52 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    I notice that this URL is missing the form name:

    https://my-domain.tld/wp-login.php?redirect_to=/wp-content/plugins/contact-form-7-to-database-extension/export.php%3Fform%3D

    The name of the form should be added to the end of that URL. (So if your form was “myform” it would be https://my-domain.tld/wp-login.php?redirect_to=/wp-content/plugins/contact-form-7-to-database-extension/export.php%3Fform%3Dmyform )

    1. Check your Google function call has the form name in the second argument. (I bet it is correct, but just check to be sure)
    =CF7ToDBData(“https://my-domain.tld”, “myform”, “”, “user”, “pwd”)

    2. Assuming (1) is ok, let’s try a test. In your browser, try going directly to the form export with the URL: (substitute your form name at the end)
    https://my-domain.tld/wp-content/plugins/contact-form-7-to-database-extension/export.php?form=myform
    Does that work?

    Hej,
    1. Double-checked it!
    2. I tried again with the form name added, now it gives me the correct form via Firefox Download Manager. Before I did not download it, so I missed that it would not have worked.

    Hello Micheal,
    did you have any other ideas over the weekend? It still doesn’t work, unfortunately.

    Another thing is, in Database Options, I cannot not save the field “Submitted From”. It works with captcha-1 (not to be saved any more), but not with that one, probably because of the space – maybe it does not get recognized?

    Plugin Author Michael Simpson

    (@msimpson)

    Given that the URL you put in your browser worked, now try this:
    1. Log out of your WordPress admin in your browser
    2. Put in your browser the URL that the Google Spreadsheet would be using and see what happens. To find this URL, let’s create a function to return it. Add this function to your script:

    function urltest(siteUrl, formName, search, user, pwd) {
  var encformName = encodeURI(formName).replace(new RegExp("%20", "g"), "%2B");
  var url = siteUrl + "/wp-login.php?redirect_to=/wp-content/plugins/contact-form-7-to-database-extension/export.php%3Fform%3D" + encformName;
  if (search != null && search != '') {
      url += '%26search%3D' + encodeURI(search);
  }
  return url;
}

    Then enter in a cell:
    =CF7ToDBData("https://my-domain.tld", "form-name", "", "user", "pwd")
    (use the same parameters as your call to CF7ToDBData)

    Copy the resulting link and put that in a browser. It should take you to your WordPress login page, and once you login, it should export the CSV file. Try that and tell me what happens, and what the URL looks like.

    I replaced the “CF7ToDBData” part in the filled-in cell-code with “urltest”, since I assumed that you meant to call that very function, but Google gives me an error message there as well (‘error while analysing’, it says). There is no link given out.

    Maybe there are some setting within the spreadsheet I have to alter? The error seems to be on the google side of the operation. But I could not find any settings page other than for time and region.

    Plugin Author Michael Simpson

    (@msimpson)

    May you should start over with a fresh spreadsheet and go through the steps again.

    I tried that, this time I even created a new Google account, since I thought that might make a difference. But unfortunately, it still does not work. Maybe some time in the future…

    Hi Michael,

    Your download link https://plugin.michael-simpson.com/download/Cf7ToDBGGoogleSS.js seems to be broken now, is there a new way to download it so I can get this funcionality as it would really help!

    Plugin Author Michael Simpson

    (@msimpson)

    Ignore that download. If you export from the Database admin panel to “Google Spreadsheet Live Data” then it will give you directions on what to do including a link to the script.

    I’ve read through everything here but can’t seem to get it to work. When entering the formula in cell A1 I am presented with #ERROR and the following error message appears when I hover over the cell:

    error: Request failed for https://cammodelstudios.com/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3DSign-Up%2B1 returned code 403. Server response: <!DOCTYPE HTML PUBLIC “-//IETF//DTD HTML 2.0//EN”> <html><head> <title>403 Forbidden</title> </head><body> <h1>Forbidden</h1> <p>You don’t have permission to access /wp-login.php on this server.</p> <p>Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.</p> </body></html>

    I have checked and re-checked the username and password, I have tried whilst being logged in and logged out in my browser.
    I have visited https://cammodelstudios.com/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3DSign-Up%2B1 which takes me to a log in screen, if I log in there it prompts me to save a file, so I guess it could work if it would only log in.

    Any help you can give would be great.

    Ooops realised if put this in a resolved thread, I’ll re-post…

    Plugin Author Michael Simpson

    (@msimpson)

    Maybe the username/password is not getting encoded right or is being encoded when it should not be. If you have any characters in your password like space, slash, etc, try changing the password temporarily in WP to just letters/numbers and try again.

    Thanks for the speedy response, but I’m afraid my password is just numbers at the moment so it doesn’t seem to be the problem

    Plugin Author Michael Simpson

    (@msimpson)

    I’m not sure what’s going on. I can’t reproduce the effect.

    Note that what the Google SS is doing is going to the URL that you listed, but is it doing an HTML POST to that URL with post parameters log=<login> and pwd=<password> (same parameters as on the login form on the WP login page). So if you just put that URL in your browser, you will always get the login page because there is no login info is posted. You are not actually duplicating what the SS connection is doing because the post parameters are missing. P.S. Adding those parameters to the URL will not work.

    I’m trying to think if there could be something different about your WP configuration…

    hey michael, great plugin!!! This works great for me as far as recording submissions as I will be holding facebook contests with emails.

    All works well, but wondering if you ever figured out the auto-update feature for the spreadsheet?? Read whole post and nothing seemed to update the spreadsheet automatically… I have to delete everything, then insert the function again to update results.

    I even tried creating a trigger which runs the CF7ToDBData function but get the following errors:

    Error Message
    Invalid argument: https://[object%20Object]/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3Dundefined (line 66)

    Details:
    error for fetchCF7ToDBCSVResponse
    Invalid argument: https://[object%20Object]/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3Dundefined (line 66)

    error for CF7ToDBData
    Invalid argument: https://[object%20Object]/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3Dundefined (line 66)

    cheers mate. Thanks again for the plugin!!

Viewing 15 replies - 31 through 45 (of 52 total)
  • The topic ‘[Plugin: Contact Form 7 to Database Extension] Pull data in Google docs spreadsheet’ is closed to new replies.