• Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
MagicMirror Forum
  • Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
A New Chapter for MagicMirror: The Community Takes the Lead
Read the statement by Michael Teeuw here.

Updating Compliments using a spreadsheet

Scheduled Pinned Locked Moved Development
14 Posts 4 Posters 3.8k Views 4 Watching
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.
  • S Offline
    strawberry 3.141 Project Sponsor Module Developer @bwente
    last edited by Aug 14, 2017, 6:42 AM

    @bwente can you post the data structure you are receiving from spreadsheet?

    Please create a github issue if you need help, so I can keep track

    B 1 Reply Last reply Aug 14, 2017, 11:29 AM Reply Quote 0
    • B Offline
      bwente @strawberry 3.141
      last edited by Aug 14, 2017, 11:29 AM

      @strawberry-3.141

      Google being very through with their JSON…

      {
        "version": "1.0",
        "encoding": "UTF-8",
        "feed": {
          "xmlns": "http://www.w3.org/2005/Atom",
          "xmlns$openSearch": "http://a9.com/-/spec/opensearchrss/1.0/",
          "xmlns$gsx": "http://schemas.google.com/spreadsheets/2006/extended",
          "id": {
            "$t": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values"
          },
          "updated": {
            "$t": "2017-08-14T03:28:11.565Z"
          },
          "category": [
            {
              "scheme": "http://schemas.google.com/spreadsheets/2006",
              "term": "http://schemas.google.com/spreadsheets/2006#list"
            }
          ],
          "title": {
            "type": "text",
            "$t": "Sheet1"
          },
          "link": [
            {
              "rel": "alternate",
              "type": "application/atom+xml",
              "href": "https://docs.google.com/spreadsheets/d/YOUR_SECRET_SHEET_LINK_ID/pubhtml"
            },
            {
              "rel": "http://schemas.google.com/g/2005#feed",
              "type": "application/atom+xml",
              "href": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values"
            },
            {
              "rel": "http://schemas.google.com/g/2005#post",
              "type": "application/atom+xml",
              "href": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values"
            },
            {
              "rel": "self",
              "type": "application/atom+xml",
              "href": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values?alt=json"
            }
          ],
          "author": [
            {
              "name": {
                "$t": "bwente"
              },
              "email": {
                "$t": "bwente@email.com"
              }
            }
          ],
          "openSearch$totalResults": {
            "$t": "3"
          },
          "openSearch$startIndex": {
            "$t": "1"
          },
          "entry": [
            {
              "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values/cokwr"
              },
              "updated": {
                "$t": "2017-08-14T03:28:11.565Z"
              },
              "category": [
                {
                  "scheme": "http://schemas.google.com/spreadsheets/2006",
                  "term": "http://schemas.google.com/spreadsheets/2006#list"
                }
              ],
              "title": {
                "type": "text",
                "$t": "How you doing?"
              },
              "content": {
                "type": "text",
                "$t": "morning: Good morning, sunshine!, afternoon: Hitting your stride!, evening: You made someone smile today, I know it."
              },
              "link": [
                {
                  "rel": "self",
                  "type": "application/atom+xml",
                  "href": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values/cokwr"
                }
              ],
              "gsx$anytime": {
                "$t": "How you doing?"
              },
              "gsx$morning": {
                "$t": "Good morning, sunshine!"
              },
              "gsx$afternoon": {
                "$t": "Hitting your stride!"
              },
              "gsx$evening": {
                "$t": "You made someone smile today, I know it."
              }
            },
            {
              "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values/cpzh4"
              },
              "updated": {
                "$t": "2017-08-14T03:28:11.565Z"
              },
              "category": [
                {
                  "scheme": "http://schemas.google.com/spreadsheets/2006",
                  "term": "http://schemas.google.com/spreadsheets/2006#list"
                }
              ],
              "title": {
                "type": "text",
                "$t": "Row: 3"
              },
              "content": {
                "type": "text",
                "$t": "morning: Who needs coffee when you have your smile?, afternoon: You are making a difference!, evening: You are making a difference."
              },
              "link": [
                {
                  "rel": "self",
                  "type": "application/atom+xml",
                  "href": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values/cpzh4"
                }
              ],
              "gsx$anytime": {
                "$t": ""
              },
              "gsx$morning": {
                "$t": "Who needs coffee when you have your smile?"
              },
              "gsx$afternoon": {
                "$t": "You are making a difference!"
              },
              "gsx$evening": {
                "$t": "You are making a difference."
              }
            },
            {
              "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values/cre1l"
              },
              "updated": {
                "$t": "2017-08-14T03:28:11.565Z"
              },
              "category": [
                {
                  "scheme": "http://schemas.google.com/spreadsheets/2006",
                  "term": "http://schemas.google.com/spreadsheets/2006#list"
                }
              ],
              "title": {
                "type": "text",
                "$t": "Row: 4"
              },
              "content": {
                "type": "text",
                "$t": "morning: Go get 'em, Tiger!, afternoon: You're more fun than bubble wrap!, evening: The day was better for your efforts."
              },
              "link": [
                {
                  "rel": "self",
                  "type": "application/atom+xml",
                  "href": "https://spreadsheets.google.com/feeds/list/YOUR_SECRET_SHEET_LINK_ID/od6/public/values/cre1l"
                }
              ],
              "gsx$anytime": {
                "$t": ""
              },
              "gsx$morning": {
                "$t": "Go get 'em, Tiger!"
              },
              "gsx$afternoon": {
                "$t": "You're more fun than bubble wrap!"
              },
              "gsx$evening": {
                "$t": "The day was better for your efforts."
              }
            }
          ]
        }
      }
      
      1 Reply Last reply Reply Quote 0
      • E Offline
        emrah_asl
        last edited by Aug 3, 2020, 9:42 AM

        Hi, where did you write this code ? When I try write on “compliments.js” my console does not recognize ‘require’ tag. Could you please share fullcode ?

        S 1 Reply Last reply Aug 3, 2020, 6:47 PM Reply Quote 0
        • S Online
          sdetweil @emrah_asl
          last edited by Aug 3, 2020, 6:47 PM

          @emrah_asl the modulename.js does not allow require(). as it runs inside the browser. anything needing require() must be done in the node_helper.js, and the two parts must send data back and forth with socketNotifications per the mm spec.

          Sam

          How to add modules

          learning how to use browser developers window for css changes

          1 Reply Last reply Reply Quote 0
          • E Offline
            emrah_asl
            last edited by emrah_asl Aug 5, 2020, 10:45 PM Aug 5, 2020, 10:35 PM

            Hi @sdetweil thanks I missed up

            , so what should I customize compliment.js ?

            Here is my change on compliement.js

            remoteFile: "remotefile.json",
            

            I created my json link and create node_helper.js file and put my folder with these codes.

            But I think I missed somethings, it doesn’t work, and there is no file creation on folder called “remotefile.json”

            S 1 Reply Last reply Aug 5, 2020, 10:53 PM Reply Quote 0
            • S Online
              sdetweil @emrah_asl
              last edited by Aug 5, 2020, 10:53 PM

              @emrah_asl well, what does the node_helper do? there is a specific structure to that file, as it is a program under mm as part of a module. if u created it as a standalone pgm, then it won’t work like u want.

              Sam

              How to add modules

              learning how to use browser developers window for css changes

              E 1 Reply Last reply Aug 6, 2020, 12:30 AM Reply Quote 0
              • E Offline
                emrah_asl @sdetweil
                last edited by Aug 6, 2020, 12:30 AM

                @sdetweil after I created node__helper.js manually, then I typed ‘npm start’ , the file has created, bu this time there was electron error (MM closed) interesting.

                S 1 Reply Last reply Aug 6, 2020, 12:32 AM Reply Quote 0
                • S Online
                  sdetweil @emrah_asl
                  last edited by Aug 6, 2020, 12:32 AM

                  @emrah_asl yeh, that won’t work

                  Sam

                  How to add modules

                  learning how to use browser developers window for css changes

                  1 Reply Last reply Reply Quote 0
                  • E Offline
                    emrah_asl
                    last edited by Aug 6, 2020, 12:33 AM

                    @sdetweil so, what is formula to run this ? what do you think acording your experience ?

                    S 1 Reply Last reply Aug 6, 2020, 1:32 AM Reply Quote 0
                    • S Online
                      sdetweil @emrah_asl
                      last edited by Aug 6, 2020, 1:32 AM

                      @emrah_asl well, the problem is coming up w something u have the skills to do.

                      Sam

                      How to add modules

                      learning how to use browser developers window for css changes

                      1 Reply Last reply Reply Quote 0
                      • 1
                      • 2
                      • 1 / 2
                      • First post
                        Last post
                      Enjoying MagicMirror? Please consider a donation!
                      MagicMirror created by Michael Teeuw.
                      Forum managed by Sam, technical setup by Karsten.
                      This forum is using NodeBB as its core | Contributors
                      Contact | Privacy Policy