Use:
[gdata_import sheet=”https://docs.google.com/spreadsheet/ccc?key=0AqYxEthPndJ8dDUzXzhzblZfY29GVTJGN216YTNvZUE#gid=0″ worksheet=”PrayerSchedule” user=”learningazigo” pass=”thisisnottherealpass”]
Its “pass” instead of “password.”
Thanks for the reply Ankit. I changed my mistake of “password” to “pass” and now get the following:
ERROR: DOMDocument cannot parse XML: DOMDocument::loadXML() [domdocument.loadxml]: Premature end of data in tag html line 1 in Entity, line: 37
Thanks for your time helping this newbie figure it out…
Use
sheet="https://spreadsheets.google.com/feeds/spreadsheets/0AqYxEthPndJ8dDUzXzhzblZfY29GVTJGN216YTNvZUE"
Thanks for the continued assitance. I thought it was going to work this time, but it returned the following error:
ERROR: Unable to Connect to ssl://docs.google.com:443. Error #110: Connection timed out
Some hosting providers do not allow https connections to be made from their servers, Contact your Hosting to assist & solve the problem.
Refer:https://developers.google.com/gdata/articles/php_client_lib#appendix_issues_proxy
After several days of my web host (Arvixe) troubleshooting the problem, here is the latest from their tech support:
“Hello,
I have re-installed firewall and now outgoing SSL connections are allowed from server. Now your wordpress page shows the error:
ERROR: DOMDocument cannot parse XML: DOMDocument::loadXML() [domdocument.loadxml]: Extra content at the end of the document in Entity, line: 25
This appears to be due to bad XML file that is being loaded. Can you please verify it?”
Can you send me the exact shortcode you are using?
Hello, I too am having some issues getting it to work.
“ERROR: SET ALL ATTRIBUTES i.e sheet, worksheet, user and pass.”
I followed both instructions above;
[gdata_import sheet=”https://spreadsheets.google.com/feeds/spreadsheets/0AtU7Gc7Z5rtfdGxkOFZFQU1QQnZ1Sm5QLUsxdENtYWc” worksheet=”one-location” user=”dcrowe13″ pass=”xxxxxxxxxxx”]
any ideas? I also tried dcrowe13@gmail.com as my user with no luck.
Are you using the latest version of plugin?