Announcement

Collapse
No announcement yet.

How write or read data from Google Sheets ??

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How write or read data from Google Sheets ??

    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

  • #2
    You can read this: https://developers.google.com/drive/web/examples/

    https://developers.google.com/drive/web/about-sdk

    Comment


    • #3
      I found this course in internet: https://www.codeschool.com/courses/discover-drive

      Comment


      • #4
        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.

        Comment


        • #5
          Originally posted by giovannino View Post
          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.

          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.

          Comment


          • #6
            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 ;-)

            Comment


            • #7
              Originally posted by giovannino View Post
              Hello,

              but I'm very smart ... Ahahah ;-)
              What makes you say that??? :-D :-D :-D

              Just kidding, but I couldn't resist.

              jsb

              Comment


              • #8
                Hey Jsb ...
                I like to joke... sometime.
                I don't like to be a very..."serious" ... professional... ;-)

                Comment


                • #9
                  I will be interested in implementing Google Sheets into SC App as well. Please report back when you get any results.

                  Arthur
                  -----------------------------------------
                  Arthur Klisiewicz
                  dATA POINT SOFTWARE
                  www.datapointsoftware.com

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      There are odbc drivers for google sheets:
                      https://visualstudiogallery.msdn.mic...7-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...

                      Comment


                      • #12
                        I have run some tests few months ago and AFAIK SC ODBC drives are not working (unless you did fixed it).
                        Arthur
                        -----------------------------------------
                        Arthur Klisiewicz
                        dATA POINT SOFTWARE
                        www.datapointsoftware.com

                        Comment


                        • #13
                          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/1...adsheet-in-php
                          https://github.com/asimlqt/php-googl...adsheet-client
                          http://www.farinspace.com/saving-for...-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...

                          Comment


                          • #14
                            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
                            -----------------------------------------
                            Arthur Klisiewicz
                            dATA POINT SOFTWARE
                            www.datapointsoftware.com

                            Comment


                            • #15
                              Originally posted by giovannino View Post
                              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
                              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.

                              Comment

                              Working...
                              X