CFDB Google Spreadsheet Live Data not linking (CFDB 2.8.3)

I don’t know.

Hi, I’m halfway there with the same problem.
If I put the URL into the browser, it downloads the CSV file and the content looks fine. I can even successfully manually import the downloaded .csv file into the google spreadsheet and get a good result.

However, if i put the ‘live’ code generated in CFDB into my google doc, I get the whole:

Error: Could not fetch url: https://www.goodmanbrothers.com/GBP2015/wp-admin/admin-ajax.p…..

etc

Any help appreciated.

Joel

I haven’t see this one. But generally the problem tends to be getting the Google sheet request to be authenticated on WordPress. If you have any plugins that require additional information to login other than username/password then the request will probably fail.

Also, in the short code builder page, it gives you the option to hide the password or not in the URL. Try both options.

I’ve already tried both options in the short-code builder, but no luck.
I’ve looked through my list of plugins and cant see any which would be restricting with passwords. I’ve even tried disabling a few, but it doesn’t seem to make any difference.
How could I go about debugging this?

thanks in advance.

This is difficult to debug since we can’t see what Google Sheet IMPORTDATA function is doing under the covers.

Maybe this is the issue: google product forum
The last posts suggests putting “//http/” in front of the URL.

I’ve posted on google docs help forums, so hopefully a solution will come out of that.
What do you think it means by putting “//http/” in front of the url?

=IMPORTDATA(“//http/https://www.goodmanbrothers.com/G
that doesn’t look right (or work! ?? )

I’ve also tried:
=IMPORTDATA(“//http//www.goodmanbrothers.com/G

no dice there either.

So close to getting this all working the way I need!

Too bad. I’m grasping at straws here. I hope the Google Forums can help. Please post a solution here if you get one…

Is there any chance it has to to with the Zend Framework.
I have no real idea of what this is, but when I try and export from CFDB with the setting “google spreadsheet” i get this:

Missing Zend Framework
This function requires part of the Zend framework that interacts with Google.
It appears that either:

The Zend Framework is not on the include_path or
You do not have the Zend Framework installed
include_path=”.:/usr/local/lib/php-5.3.13/lib/php”
php.ini file is “/opt/users/ipg/j/g/ipg.jgoodman/php53/php.ini “
locate the the Zend directory on your computer
If found, here is one way to put it on the include path
copy the php.ini file to your WordPress installation to [wp-dir]/wp-content/plugins/contact-form-7-to-database-extension/php.ini
add a line to this new file:
include_path=”.:/usr/local/lib/php-5.3.13/lib/php:[Zend-parent-directory]”
If not found, install and configure Zend version 1.11.11 (or contact or administrator or host provider)
See: Getting Started with the Google Data PHP Client Library
To download the part of Zend 1.11.11 required, see: Zend GData

could this be the same thing causing issues with the live google linkup?

cheers

Zend is only for pushing an export to Google spreadsheet and NOT for the “Live Data” export (Google pulls from WordPress)

As an FYI, I’m trying to add some debug to the code to see what’s actually being captured.

I’ve noticed when I’ve modified the script as follows:

//  var response = UrlFetchApp.fetch(url, { method: "post", payload: payload });

   var options =
   {
     "method" : "post",
     "payload" : payload,
     "muteHttpExceptions" : true
   };

  var response = UrlFetchApp.fetch(url, options);

I’m able to see the full response of the page. In my case at least it’s Cloudflare generating the 403.

here is a snippit:

//<![CDATA[ try{(function(a){var b=”https://&#8221;,c=”mydomain.org”,d=”/cdn-cgi/cl/”,e=”img.gif”,f=new a;f.src=[b,c,d,e].join(“”)})(Image)}catch(e){} //]]>
</script>
<h1>
Error 403
</h1>
<p>
We’re sorry, but we could not fulfill your request for /wp-admin/admin-ajax.php on this server.
</p>
<p>
An invalid request was received from your browser. This may be caused by a malfunctioning proxy server or browser privacy software.
</p>

… going to try pausing cloudflare to see if this is indeed the culprit. Will report back.

@joelgvfx By chance, are you behind cloudflare?

Had no affect.

Found this, may be of help…

https://stackoverflow.com/questions/19567105/how-to-fetch-a-wordpress-admin-page-using-google-apps-script

I’m perplexed…

I can’t even get a simple page function to work.

function myFunction() {

   // The code below logs the HTML code of the Google home page.
  var response = UrlFetchApp.fetch("https://mydomain.org/wp-login.php", {muteHttpExceptions: true });
 Logger.log(response.getContentText());

}

This results in the following log being created:

[15-02-09 14:21:27:202 EST] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--< html xmlns="https://www.w3.org/1999/xhtml">-->
<head>
<title>HTTP Error 403</title>
</head>
<body>
<h1>Error 403</h1>
<p>We're sorry, but we could not fulfill your request for
/wp-login.php on this server.</p>
<p>An invalid request was received from your browser. This may be caused by a malfunctioning proxy server or browser privacy software.</p>
<p>Your technical support key is: <strong>a2a1-7566-707</strong></p>
<p>You can use this key to <a href="https://www.ioerror.us/bb2-support-key?key=a2a1-7566-707">fix this problem yourself</a>.</p>
<p>If you are unable to fix the problem yourself, please contact <a href="mailto:[email protected]">online at mydomain.org</a> and be sure to provide the technical support key shown above.</p>

(obviously mydomain.org was replaced for this post)

Even my apache log shows the following:

66.249.83.185 – – [09/Feb/2015:14:25:21 -0500] “GET /wp-login.php HTTP/1.1” 403 882 “-” “Mozilla/5.0 (compatible; Google-Apps-Script)”

Found my problem….

:/

Kicking myself..

I had a plugin ‘Bad Behavior’ which was creating the 403….

works like a charm. Hope my hours of torture can help someone…

Hi. I’m afraid I have no comprehension of the meaning of your last 4 posts, house98 ??
I don’t think I’m behind Cloudfire. I’m hosted with ipage, and there is no Cloudfire plugin installed.

If you could help with troubleshooting my issue, it would be much appreciated. ??

thanks in advance!

Similar issue:

When I put the shortcode into Google Sheets I get “Error Resource at url not found.”. I have tried toggling the “hide credentials option”, but no luck with either generated shortcode. I am also able to access and download a CSV file from the URL that populates within the shortcode so I’m not sure why Google sheets is not able to pull the data.

Thanks for any help!