[Plugin: GData Importer] Cannot Get Plugin to Work

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 [email protected] as my user with no luck.

Are you using the latest version of plugin?