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.
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!
If you contact me at info@cfdbplugin.com and give me a login to the site, then I’ll see if I can figure out the problem.
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
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: http://…”
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.
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>
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)
🙁
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:
http://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?
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
