CFDB Google Spreadsheet Live Data not linking (CFDB 2.8.3)

Viewing 15 replies - 1 through 15 (of 32 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    Put that URL in your browser and see what it gives you. If it works, it should display or download a .csv file of your data. If not, hopefully the browser give you some indication of what the problems is.

    Thread Starter bizwizkid

    (@bizwizkid)

    Hi Michael, I should’ve mentioned that I did try the URL directly in the browser. All I get when I do that is a blank page in Chrome. I’ve tried with a few different CFDB forms as well, each with 1-5 records of data.

    Thanks!

    Plugin Author Michael Simpson

    (@msimpson)

    If you contact me at [email protected] and give me a login to the site, then I’ll see if I can figure out the problem.

    Thread Starter bizwizkid

    (@bizwizkid)

    Ok thanks Michael. I just emailed you.

    Hi!, I have the same problem, I’m trying to build a live update link between CFDB and a Google spreadsheet. I enter the URL that the plugin indicates me and I get an #N/A in the table cell and a popup that says Error: Could not fetch URL…

    Can you help me, please?, Thanks

    Plugin Author Michael Simpson

    (@msimpson)

    On the short code builder page, when you select options for Google SS Live Data, you see a checkbox for “Hide Credentials”. With the previous user, we found that it did not work when this option is checked. With that checked, you see the user name and password endcoded in the URL. But when he unchecked that and it created a URL with the user name and password in plain text, then it worked. Try that.

    Hey Michael, appreciate all the responses I’ve seen from you on various similar bugs. I’m having the exact issue described in the original post. Using the Export and Short Code Builder, I’ve tried both checking and unchecking the “Hide credentials” checkbox and pasting the code into Google Spreadsheets without success.

    If I am logged into WordPress, the .csv is downloaded when visiting the provided URL, but if I am not logged in I get only a white page. In Google Spreadsheets, the cell returns #N/A with the error: “Error: Could not fetch url: https://…”

    Do you happen to have any other tricks up your sleeve for troubleshooting this problem? Thanks.

    Edit: This is interesting. I just tried it with a completely different WordPress site and it worked fine on the first try with the hidden credentials. Maybe it could be something on the server-side? Both sites have the same version of CForm7 and CForm DB.

    Plugin Author Michael Simpson

    (@msimpson)

    I don’t know why that doesn’t work on the one site. Are there plugins in one site that are not in the other (other than CF7 & CFDB?)

    I’m also experiencing an error after updating the plugin. The URL works when logged in, and I successfully download the file. Unfortunately when I put the code in Google Spreadsheets this error appears:

    <!DOCTYPE HTML PUBLIC “-//IETF//DTD HTML 2.0//EN”>
    <html><head>
    <title>406 Not Acceptable</title>
    </head><body>
    <h1>Not Acceptable</h1>
    <p>An appropriate representation of the requested resource /wp-admin/admin-ajax.php could not be found on this server.</p>
    </body></html>

    Plugin Author Michael Simpson

    (@msimpson)

    This is a new issue -> https://www.ads-software.com/support/topic/error-live-exporting-to-gd?replies=1#post-6331406

    Hello, same problem issue for me.

    Tried to paste the export link in the browser and it works (with no hidden credential)letting me download the csv file, but using the link with the import function on google spreadsheet it does not work.

    Thinking about server security configuration I tried to use on my wordpress site one page with embeddec code (iframe tags)to avoid external calls to server: the page show the google spreadsheet but I got the same error.
    Note that my db data contains also some jpg picture and that the url to the pictures (also simply used into the browser) give me one error about corrupted picture (but pictures are correctly store on the mysql DB and in the server (checked through ftp)
    ??

    Plugin Author Michael Simpson

    (@msimpson)

    The export link my work in the browser if you are logged into your WordPress site during that browser session. Log out of your site, then try the link again in the browser.

    So,
    using this export link while I was logged out from my wordpress site I obtained a blank page.
    This is the link I used:
    https://www.uniqueventi.com/wp-admin/admin-ajax.php?action=cfdb-login&cfdb-action=cfdb-export&form=Preventivo&user_login=admin&user_password=xxxxx
    (I put the xxxx instead of password).

    Any idea?
    And what about the other question about the picture links?

    Plugin Author Michael Simpson

    (@msimpson)

    I’ve been googling this and it sounds like the following (mod_security on Apache)

    https://www.tipsandtricks-hq.com/apache-mod-security-update-how-to-fix-error-406-or-not-acceptable-issue-259
    https://sourabhjainblog.wordpress.com/2013/11/15/406-error-not-acceptable/
    https://www.nethosted.co.uk/community/viewtopic.php?f=2&t=3553

    Thank you but I’m in doubt about the solution: does it work also for Windows hosting?

    I’m asking this because reading the solutions above and checking on my server I have no .htaccess file

    P.S.
    I’m following other discussion with you about changing the form from cf7 before saving on the db

Viewing 15 replies - 1 through 15 (of 32 total)
  • The topic ‘CFDB Google Spreadsheet Live Data not linking (CFDB 2.8.3)’ is closed to new replies.

Tags