farinspace / google-spreadsheet

Google Spreadsheet PHP Helper Class (Uses Zend GData)
http://farinspace.com/2009/05/saving-form-data-to-google-spreadsheets/
105 stars 63 forks source link

ClientLogin Removed #4

Open coolshrimp opened 9 years ago

coolshrimp commented 9 years ago

No longer working can you please fix.

ClientLogin needed to switch to oAuth2

cyrilg67 commented 9 years ago

I have a problem since the recent update of wordpress : Fatal error: Uncaught exception 'Zend_Gdata_App_Exception' with message 'DOMDocument cannot parse XML: DOMDocument::loadXML() [domdocument.loadxml]: Empty string supplied as input'

jlipinski3 commented 9 years ago

Bump. ClientLogin not working, can't fetch spreadsheet id.

jkleroy commented 9 years ago

Same error here.

coolshrimp commented 9 years ago

I have created a solution, not using zdata anymore.

jlipinski3 commented 9 years ago

@coolshrimp can you upload a new package or give details on the fix?

coolshrimp commented 9 years ago

I will shortly putting a package together for release

Coolshrimp Modz Brampton,ON www.CoolshrimpModz.com

On Jun 8, 2015, at 8:37 AM, "jlipinski3" notifications@github.com wrote:

@coolshrimp can you upload a new package or give details on the fix?

— Reply to this email directly or view it on GitHub.

farinspace commented 9 years ago

@coolshrimp let me know if you would like to take over maintenance of this package, I would be more than happy to transfer ownership of the repo.

Personally, I have stopped using this package and simply do not have the time to maintenance it.

coolshrimp commented 9 years ago

Hey sure I'll let you know. Been a bit busy myself I'm making a nice simple package for people to grab and customize.

Coolshrimp Modz Brampton,ON www.CoolshrimpModz.com

On Jun 8, 2015, at 2:34 PM, "Dimas Begunoff" notifications@github.com wrote:

@coolshrimp let me know if you would like to take over maintenance of this package, I would be more than happy to transfer ownership of the repo.

Personally, I have stopped using this package and simply do not have the time to maintenance it.

— Reply to this email directly or view it on GitHub.

KMantas commented 9 years ago

@coolshrimp is it possible to get some code for this? even if it is not well packed? thanks :)

cyrilg67 commented 9 years ago

Now ClientLogin is working again ! Is it temporary or not ? I think this will not be available for a long time so did someone already made some code using Auth2.0 ?

andrewzirkel commented 9 years ago

Is ClientLogin working for anyone, I don't think it is working today. I verified that www.google.com/accounts/ClientLogin is now giving a 404 error.

@coolshrimp I'd be excited to try out your code.

coolshrimp commented 9 years ago

hey iv been pretty busy ill try to have it up in a day or so

pedrocasado commented 9 years ago

@coolshrimp , great! looking forward to it.

andrewzirkel commented 9 years ago

I'm re-writing this class based on this post: http://stackoverflow.com/questions/21470405/google-api-how-to-connect-to-receive-values-from-spreadsheet Looks promising so far. Setting up oauth is a pain. I'll post it when it's usable. Maybe @coolshrimp has a better implementation.

farinspace commented 9 years ago

Have a look at the oath packages of "the php league" https://thephpleague.com/#packages

andrewzirkel commented 9 years ago

I put up what I have here: https://gist.github.com/andrewzirkel/8ff2a0d0ea8ef49bfdf3

I have the following working:

login - which now takes Service Account OAuth2 creds (https://console.developers.google.com/)
getrows - works the same as before
addrows - works the same as before

I don't have time to look at the rest at the moment, those functions are what I use.

To use the update function I think you will have to use a query to get the row number to update.

jlipinski3 commented 9 years ago

@andrewzirkel Thanks andrew, although this is obviously not just a simple copy/paste of the google spreadsheet class. Tried that, but I don't know what these new parameters are for the new __construct. @coolshrimp any update? Some days ClientLogin works, mostly it doesn't. Ugh. You can never count on anything working for the long haul when it comes to web development.

coolshrimp commented 9 years ago

here is my working script: http://shop.coolshrimpmodz.com/index.php/other/html-form-to-google-doc-script.html