Read the statement by Michael Teeuw here.
Updating Compliments using a spreadsheet
-
@bwente can you post the data structure you are receiving from spreadsheet?
-
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." } } ] } } -
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 ?
-
@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.
-
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”
-
@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.
-
@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.
-
@emrah_asl yeh, that won’t work
-
@sdetweil so, what is formula to run this ? what do you think acording your experience ?
-
@emrah_asl well, the problem is coming up w something u have the skills to do.
