• Products
    • Isadora
    • Get It
    • ADD-ONS
    • IzzyCast
    • Get It
  • Forum
  • Help
  • Werkstatt
  • Newsletter
  • Impressum
  • Dsgvo
  • Press
  • Isadora
  • Get It
  • ADD-ONS
  • IzzyCast
  • Get It
  • Press
  • Dsgvo
  • Impressum

Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    • Tags

    Data from Google Spreadsheets into Isadora

    How To... ?
    3
    6
    2503
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      martin Beta Gold last edited by

      I am trying to pull numerical data from a google spreadsheet into Isadora.

      From what I see, the options are either to write a patch in MaxMsp or Processing that imports the data from the google doc, then output it to isadora as graphic through syphon, or to somehow convert the data from the google doc into a text file and use the data array actor.
      I'm looking for the quickest way, with the lowest level of programming needed.
      Has anyone dealt with this before and maybe has a patch that's easy to adapt?
      Thanks

      Win 10 64bit, 6-core i7-10750H, 32GB DDR4, 1TB SSD, RTX 2070 Max-Q

      1 Reply Last reply Reply Quote 0
      • DusX
        DusX Tech Staff last edited by

        I would suggest that easier methods exist with Isadora 2.0 and the use of Javascript.

        Troikatronix Technical Support

        • New Support Ticket Link: https://support.troikatronix.com/support/tickets/new
        • My Add-ons: https://troikatronix.com/add-ons/?u=dusx
        • Profession Services: https://support.troikatronix.com/support/solutions/articles/13000109444-professional-services

        Running: Win 11 64bit, i7, M.2 PCIe SSD's, 32gb DDR4, nVidia GTX 4070 | located in Ontario Canada.

        1 Reply Last reply Reply Quote 0
        • I
          ian Beta Platinum last edited by

          If it's fine to export the document from google docs, you can also simply export the data from a google spreadsheet as a tab separated value (.tsv) file (which works just like a .txt file) and open that file using the data array actor as you normally would.

          Here's a data array patch example using a test file downloaded as a .tsv...

          And as @Dusx suggests using  Javascript in 2.0 would let you pull the data directly from your live documents...

          c3301e-google-spreadsheet-data-array.izz 232821-sheet1.txt

          Ian Winters
          2022 M1Max 64gb osx 13.x, 2020 ImacPro 12 core 32gb 13.x, 2018, Retina MBP 2.9ghz i7 / 16gb / Radeon Pro 560x 4gb / 13.x /
          video and media design / ianwinters.com

          1 Reply Last reply Reply Quote 0
          • DusX
            DusX Tech Staff last edited by

            Getting the data live would require using the TCP-IP actors, and passing the returned text to either Javascript or a text actor of some type.
            If possible, I think @ian idea is great! It really makes it much simpler.

            Troikatronix Technical Support

            • New Support Ticket Link: https://support.troikatronix.com/support/tickets/new
            • My Add-ons: https://troikatronix.com/add-ons/?u=dusx
            • Profession Services: https://support.troikatronix.com/support/solutions/articles/13000109444-professional-services

            Running: Win 11 64bit, i7, M.2 PCIe SSD's, 32gb DDR4, nVidia GTX 4070 | located in Ontario Canada.

            1 Reply Last reply Reply Quote 0
            • M
              martin Beta Gold last edited by

              Just got 2.0, so I'm eager to see what that has in store.

              Thanks for the patch, Ian. It's good to know that the data array actor can work with .tsv files.
              I'll still need to code something that will automatically save the google spreadsheet to .tsv periodically.
              I failed to mention that this is a live updating spreadsheet and I want to get the data projected live, with minimal human intervention.

              Win 10 64bit, 6-core i7-10750H, 32GB DDR4, 1TB SSD, RTX 2070 Max-Q

              1 Reply Last reply Reply Quote 0
              • DusX
                DusX Tech Staff last edited by

                Well if its necessary to be live data, then using the the TCP-ip actors is a good option.
                You would need to make the spreadsheet a publicly accessible page (for viewing only).

                This way you can grab the data with the TCP-IP acotrs (assuming that the data isn't loaded via ajax, that might cause a problem). Then pass the whole string to a Javascript actor for easy parsing.

                see may tutorial on TCP-IP here: http://dusxproductions.com/blog/web-apis-in-isadora-part-1/

                note, that the actors have changed a bit in 2.0 but it still works the same for the most part.

                Troikatronix Technical Support

                • New Support Ticket Link: https://support.troikatronix.com/support/tickets/new
                • My Add-ons: https://troikatronix.com/add-ons/?u=dusx
                • Profession Services: https://support.troikatronix.com/support/solutions/articles/13000109444-professional-services

                Running: Win 11 64bit, i7, M.2 PCIe SSD's, 32gb DDR4, nVidia GTX 4070 | located in Ontario Canada.

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post