Dear all,
I got several Google sheets sheets document to read or to write.
Is there anybody that has tried this kind of… experience ???
Many thanks
Giovannino
Hello PauloMarcelo.
I founded also the http://framework.zend.com/downloads/latest that has Zend_Gdata library inside that in teory does the job.
Is Zend_Gdata included yet on Scriptcase libraries ?
I’m not a programmer and seeing example there are tons of code to write… 
I was hoping that within Scriptcase there was a kind of connector to read and write Google Sheets data.
[QUOTE=giovannino;36747]Hello PauloMarcelo.
I founded also the http://framework.zend.com/downloads/latest that has Zend_Gdata library inside that in teory does the job.
Is Zend_Gdata included yet on Scriptcase libraries ?
I’m not a programmer and seeing example there are tons of code to write…
I was hoping that within Scriptcase there was a kind of connector to read and write Google Sheets data.[/QUOTE]
The Zend Gdata is not included in the scriptcase libraries, but the library is very interesting. I will try to use this lib with scriptcase.
Hello,
please let me know if you will be able to do something in a easy way…
I’m not programmer … ;-(
but I’m very smart … Ahahah
[QUOTE=giovannino;36761]Hello,
but I’m very smart … Ahahah
[/QUOTE]
What makes you say that??? 
Just kidding, but I couldn’t resist.
jsb
Hey Jsb …
I like to joke… sometime.
I don’t like to be a very…“serious” … professional…
I will be interested in implementing Google Sheets into SC App as well. Please report back when you get any results.
Arthur
Hello,
We need to wait PauloMarcelo tests becouse I’m not able to use libraries and that stuff.
If it could be helpful for you I did some test using the Pentaho ETL PDI ex Kettle that has the input and output step ready to use .
It works fine and also for a not programmer it’s easy to understand.
I hope that SC will make a macro or something like that ready to use to… (we will wait a couple of years… )
Bye
There are odbc drivers for google sheets:
https://visualstudiogallery.msdn.microsoft.com/b4717628-a718-45b0-9ff7-9bdbb29f9f44 (aparently not that good since all is memo) als this: http://community.tableau.com/thread/135281
http://www.cdata.com/drivers/gsheets/odbc/
etc… with some searching you can find even more solutions… I havent tested any of them…
The first one is apparently for free…
I have run some tests few months ago and AFAIK SC ODBC drives are not working (unless you did fixed it).
Arthur
Well then you should simply use the google sheets api and make a php program that reads from a sheet and writes into a table…
There are lots of ways of doing this…
http://stackoverflow.com/questions/14780804/how-do-i-read-a-google-drive-spreadsheet-in-php
https://github.com/asimlqt/php-google-spreadsheet-client
http://www.farinspace.com/saving-form-data-to-google-spreadsheets/
etc… you can find many different solutions but you have to customise here and there to get it all working.
It doesnt look all that difficult, you just need to make some customised code and there are enough examples.
Standard SC indeed doesnt do it but that is to be expected…
so for I haven’t seen even one example of API implementation. Can you post one please ? Telling us it is easy and needs customization doesn’t help much.
If I could ass at least one example project I would have an idea …
Arthur
[QUOTE=giovannino;37038]Hello,
We need to wait PauloMarcelo tests becouse I’m not able to use libraries and that stuff.
If it could be helpful for you I did some test using the Pentaho ETL PDI ex Kettle that has the input and output step ready to use .
It works fine and also for a not programmer it’s easy to understand.
I hope that SC will make a macro or something like that ready to use to… (we will wait a couple of years… )
Bye[/QUOTE]
Hello Giovannino, unfortunately, I have a lot of stuff to make before this study, so this test can take more time to get done. So if you are in a hurry I advise you to look for another alternative. The library is very interesting, but i do not have any use of this library to any current project. So i have to finish my other priorities and after this I will test the library for some upcoming project that needs this feature.
Hi All,
Has anyone ever resolved this and successfully integrated with Google Spreadsheets?
That’s really a helpful discussion. I was facing same problem in managing data in google sheets. Being a business developer at eduhelphub.com it is highly difficult to manage all the data at the very same time, and hope this discussion will useful for me.