did it !
this.loaded = true; was wrong placed …
Read the statement by Michael Teeuw here.
Posts
-
RE: read csv-data and put it in an array
-
RE: read csv-data and put it in an array
@Perlchamp said in read csv-data and put it in an array:
bodyTD.innerHTML = person.name + “” + person.age + “”;
should be:
bodyTD.innerHTML = person.name + span class = … + person.age + /span;can’t send html tags here ? how i have to escape them here ?
-
RE: read csv-data and put it in an array
hi sam, i know that the code of table is working (in testmodule). but can’t get objects in there. did look in dev-widow, but looks fine. in the terminal-window i see that objects have been handed over (node to module.js). this is the code for the body of the table:
// create TBODY section with day names var tBody = document.createElement("tBody"); tBody.className = "tbody"; tBody.id = "birthday-tbody"; for(var birthday of Object.keys(this.active_birthdays)) { for(var person of this.active_birthdays[birthday]) { //var m = document.createElement('div'); // create looped row section var bodyTR = document.createElement("tr"); bodyTR.className = "tr-body"; bodyTR.id = "birthday-tr-body"; var bodyTDimage = document.createElement("td"); bodyTDimage.className = "td-image"; bodyTDimage.id = "birthday-td-image"; bodyTDimage.innerHTML = birthday; var bodyTD = document.createElement("td"); bodyTD.className = "td-body"; bodyTD.id = "birthday-td-body"; bodyTD.innerHTML = person.name + "<span class=\"age-span\">" + person.age + "</span>"; //m.innerText = birthday + ' ' + person.name + ' age=' + person.age; //wrapper.appendChild(m); bodyTR.appendChild(bodyTDimage); bodyTR.appendChild(bodyTD); tBody.appendChild(bodyTR); wrapper.appendChild(tBody); } }what did i make wrong ?
-
RE: read csv-data and put it in an array
cool too :-) , so you still burn, too :-))
-
RE: read csv-data and put it in an array
thanks :-)
i although thought about to include a template, but first i want to figure out the html-stuff and the if … than -statements (people the same day, date passed, and so on …), but you see i’m on fire right now … -
RE: read csv-data and put it in an array
hi sam, yes i thought about. in the moment this is the actually file, though there is code annotate and at the wrong place, … just so you don’t wonder … :
/* global Module */ /* Magic Mirror * Module: birthdaylist * * Author: perlchamp@gmx.net * Lizenz: MIT */ Module.register("birthdaylist", { // Default module config. defaults: { debugging: false, initialLoadDelay: 0, // How many seconds to wait on a fresh start up. // This is to prevent collision with all other modules also // loading all at the same time. This only happens once, // when the mirror first starts up. dimmEntries: true, // true: dims entries and the associated // symbol when the date has expired. // false: delete entries and the associated // symbol when the date has expired. language: "de", // needed for dateformatting updateDelay: 5 // How many seconds after midnight before a refresh // This is to prevent collision with other modules refreshing // at the same time. }, active_birthdays: { }, init: function() { Log.log(this.name + " is in init!"); }, // Override start method start: function() { Log.log("Starting module: " + this.name); // set locale here, default: de moment.locale(config.language); // Calculate next midnight and add updateDelay var now = moment(); this.midnight = moment([now.year(), now.month(), now.date() + 1]).add(this.config.updateDelay, "seconds"); this.loaded = false; this.scheduleUpdate(this.config.initialLoadDelay * 1000); }, loaded: function(callback) { Log.log(this.name + " is loaded!"); callback(); }, // return list of other functional scripts to use, if any (like require in node_helper) getScripts: function () { return ["moment.js"]; }, // return list of stylesheet files to use if any getStyles: function() { return [this.data.path + "/css/bdl.css"]; }, // you can configure the heading of the list in config.js getHeader: function() { return this.data.header; }, // messages received from other modules and the system (NOT from your node helper) // payload is a notification dependent data structure notificationReceived: function(notification, payload, sender) { // once everybody is loaded up if(notification === "ALL_MODULES_STARTED") { // send our config to our node_helper this.sendSocketNotification("CONFIG",this.config); } if (sender) { Log.log(this.name + " received a module notification: " + notification + " from sender: " + sender.name); } else { Log.log(this.name + " received a system notification: " + notification); } }, // messages received from from your node helper (NOT other modules or the system) // payload is a notification dependent data structure, up to you to design between module and node_helper socketNotificationReceived: function(notification, payload) { if(notification === "JSONDATA") { var self = this; Log.log(this.name + " received a socket notification: " + notification + " - Payload: " + payload); var now = moment(); var day_month = moment().format("DD"); for(var birthday of payload) { // get 1st 5 chars of birthdate, thru month // we will use this as the key in the hash var birth_date = birthday.birth.substring(0,5); // get the birthday as a moment in this year, for comparing var birth_date_moment = moment(birth_date + now.year(),"DD.MMYYYY"); // you can add days to a moment object and then compare // if the birthdate is before that date (and after now) // so within the next xx days // if the date is the same or later, don't use time of day if(birth_date_moment.month() == now.month() ) { // birthday is in this month // check the hash if we've seen anything for today yet // if we haven't see this date yet if(this.active_birthdays[birth_date] == undefined) { // create the holder for its info (array of // names) in the hash this.active_birthdays[birth_date] = []; } // save the persons name on the list self.active_birthdays[birth_date].push({'name':birthday.name, 'age': now.diff(moment(birthday.birth,'DD.MM.YYYY'), 'years') }) } } // tell MM to call and get our content self.updateDom(); } }, // system notification your module is being hidden // typically you would stop doing UI updates (getDom/updateDom) if the module is hidden suspend: function() { }, // system notification your module is being unhidden/shown // typically you would resume doing UI updates (getDom/updateDom) if the module is shown resume: function() { }, // this is the major worker of the module, it provides the // displayable content for this module getDom: function() { var self = this; var wrapper = document.createElement("div"); // tell MM to call and get our content Log.log(JSON.stringify(this.active_birthdays)) if ((moment() > this.midnight) || (!this.loaded)) { var month = moment().month(); var year = moment().year(); // var monthName = moment().format("MMMM"); // var monthLength = moment().daysInMonth(); // tabelle erstellen var wrapper = document.createElement("table"); wrapper.className = 'table'; wrapper.id = 'birthday-table'; // tabellenkopf erstellen var tHeader = document.createElement("thead"); tHeader.className = "thead"; tHeader.id = "birthday-thead"; var headerTR = document.createElement("tr"); headerTR.className = "tr-head"; headerTR.id = "birthday-tr-head"; var headerTH = document.createElement("th"); headerTH.colSpan = "2"; headerTH.scope = "col"; headerTH.className = "th-head"; headerTH.id = "birthday-th-head"; headerTH.innerHTML = this.translate(this.config.title); headerTR.appendChild(headerTH); tHeader.appendChild(headerTR); wrapper.appendChild(tHeader); // Create TFOOT section -- currently used for debugging only var tFooter = document.createElement('tfoot'); tFooter.className = "tfoot"; tFooter.id = "birthday-tfoot"; var footerTR = document.createElement("tr"); footerTR.className = "tr-foot"; footerTR.id = "birthday-tr-foot"; var footerTD = document.createElement("td"); footerTD.colSpan ="2"; footerTD.className = "td-foot"; footerTD.id = "birthday-td-foot"; if (this.config.debugging) { footerTD.innerHTML = "Birthdaylist is currently in DEBUG mode!<br />Please see console log."; } else { footerTD.innerHTML = ""; } footerTR.appendChild(footerTD); tFooter.appendChild(footerTR); wrapper.appendChild(tFooter); for(var birthday of Object.keys(this.active_birthdays)) { for(var person of this.active_birthdays[birthday]) { var m=document.createElement('div'); // create tour table row here m.innerText = birthday + ' ' + person.name + ' age=' + person.age; wrapper.appendChild(m); } } // pass the created content back to MM to add to DOM. this.loaded = true; return wrapper; /* // Create TBODY section with day names var eintraege = 3; for (var i=1; i<=eintraege; i++) { var tBody = document.createElement("tBody"); tBody.className = "tbody"; tBody.id = "birthday-tbody"; var bodyTR = document.createElement("tr"); bodyTR.className = "tr-body"; bodyTR.id = "birthday-tr-body"; var bodyTDimage = document.createElement("td"); bodyTDimage.className = "td-image"; bodyTDimage.id = "birthday-td-image"; bodyTDimage.innerHTML = "23"; var bodyTD = document.createElement("td"); bodyTD.className = "td-body"; bodyTD.id = "birthday-td-body"; bodyTD.innerHTML = "Bettina Zimmermann <span class=\"age-span\">46</span></br>Frank Dubiel <span class=\"age-span\">54</span></br>Jürgen Gruse <span class=\"age-span\">52</span>"; // var bodyAgeSpan = document.createElement("span"); // bodyAgeSpan.className = "age-span"; // bodyAgeSpan.id = "birthday-age-span"; // bodyAgeSpan.innerHTML = " 46"; // bodyTD.appendChild(bodyAgeSpan); bodyTR.appendChild(bodyTDimage); bodyTR.appendChild(bodyTD); tBody.appendChild(bodyTR); wrapper.appendChild(tBody); } */ }, scheduleUpdate: function(delay) { if (this.config.debugging) { Log.log("= = = = = = = = = = = = = = = = = = = = = = = = = = = = = ="); Log.log("Birthdaylist IS IN DEBUG MODE!"); Log.log("Remove 'debugging' option from config/config.js to disable."); Log.log("Current moment(): " + moment() + " (" + moment().format("hh:mm:ss a") + ")"); Log.log("scheduleUpdate() delay set at: " + delay); } if (typeof delay !== "undefined" && delay >= 0) { nextReload = delay; } if (delay > 0) { // Calculate the time DIFFERENCE to that next reload! nextReload = moment.duration(nextReload.diff(moment(), "milliseconds")); if (this.config.debugging) { var hours = Math.floor(nextReload.asHours()); var mins = Math.floor(nextReload.asMinutes()) - hours * 60; var secs = Math.floor(nextReload.asSeconds()) - ((hours * 3600 ) + (mins * 60)); Log.log(" nextReload should happen at: " + delay + " (" + moment(delay).format("hh:mm:ss a") + ")"); Log.log(" which is in: " + mins + " minutes and " + secs + " seconds."); Log.log(" midnight set at: " + this.midnight + " (" + moment(this.midnight).format("hh:mm:ss a") + ")"); Log.log("= = = = = = = = = = = = = = = = = = = = = = = = = = = = = ="); } } var self = this; setTimeout(function() { self.reloadDom(); }, nextReload); }, reloadDom: function() { if (this.config.debugging) { Log.log(" Calling reloadDom()!"); } var now = moment(); if (now > this.midnight) { this.updateDom(this.config.fadeSpeed * 1000); this.midnight = moment([now.year(), now.month(), now.date() + 1]).add(this.config.updateDelay, "seconds"); } var nextRefresh = moment([now.year(), now.month(), now.date(), now.hour() + 1]); this.scheduleUpdate(nextRefresh); } });and thanks agaibn for your time …
-
RE: read csv-data and put it in an array
i will have a look on it, though MERCI !
-
RE: read csv-data and put it in an array
general question:
is there something like “print”? (for debugging) or have i use innerText or innerHTML or Log.log ? … to display something on screen ? -
RE: read csv-data and put it in an array
ah, oooook … hm. shooted to fast. but let me figured out by myself, cause i don’t wonna feel like a baby … i think if-statements and moment() could be helpfully.
-
RE: read csv-data and put it in an array
I do not think so. I could never answer questions about any problems …
i did:... age='+(person.age + 1);the styles you could get from me, no problem. it’s just fair, isn’t it ?
-
RE: read csv-data and put it in an array
i think, too. thanks very much, sam. I don’t know how to thank you Thank you very much !
you’re great !
and it is up to you whether you publish this module. I will not adorn myself with foreign feathers! -
RE: read csv-data and put it in an array
without i have a black screen, with everythings fine.
another information:
age must be +1 but i think i will solve this alone. if not i’m too stuipid for this all :-)
so i can create my table now. but i see:
people who has birthday the same day:
date should be displayed once, and the names in the same, separated by -
RE: read csv-data and put it in an array
great, thanks !
to your information:
there are NO semikolons in your posted code. within them it goes ! -
RE: read csv-data and put it in an array
ok, there is a light at the end of the tunnel:

-
RE: read csv-data and put it in an array
question:
in thesocketNotificationReceived: function(notification, payload) { if(notification === "HAVEDATA") { var self = this; ...payload should be the variable in which the jsonString is saved ?
-
RE: read csv-data and put it in an array
done, it’s frozen now. must restart …
-
RE: read csv-data and put it in an array
shame on me, sorry for that. now it’s changed to:
if(birth_date_moment.startOf('month').isSameOrAfter(now.startOf('month')) && birth_date_moment.startOf('month').isSameOrBefore(birthday_time_window.startOf('month'))) {nothing changed, i have configured the terminal-window to scroll about 3000 (!) lines, but can’t see the beginning …

-
RE: read csv-data and put it in an array
node_helper.js:
var NodeHelper = require("node_helper"); var moment = require("moment"); // add require of other javascripot components here // var xxx = require('yyy'); here const csv = require("csvtojson"); var birthdaysArray = []; module.exports = NodeHelper.create({ init(){ console.log("init module helper MMM-Perlchamp"); }, start() { }, stop(){ console.log("Stopping module helper: ",this.name); }, // handle messages from our module// each notification indicates a different messages // payload is a data structure that is different per message.. up to you to design this socketNotificationReceived(notification, payload) { var self = this; console.log("Starting module helper: ",this.name); // convert the csv-file into a JSON-String const csvFilePath = this.path + '/data/birthdays.csv'; csv() .fromFile(csvFilePath) .then(function(jsonObj) { JSON.stringify(jsonObj); // send data to [modulname].js self.sendSocketNotification("HAVEDATA", jsonObj); }) // if config message from module if (notification === "CONFIG") { // save payload config info this.config = payload; // wait 15 seconds, send a message back to module setTimeout(()=> {this.sendSocketNotification("message_from_helper"," this is a test_message")}, 15000); } else if(notification === "????2") { } }, });MMM-Perlchamp.js:
Module.register("MMM-Perlchamp", { defaults: { language: "de", dimmEntries: true // true: dims entries and the associated // symbol when the date has expired. // false: delete entries and the associated // symbol when the date has expired. }, active_birthdays: { }, init: function(){ Log.log(this.name + " is in init!"); }, start: function(){ Log.log("Starting module: " + this.name); // Set locale moment.locale(config.language); }, loaded: function(callback) { Log.log(this.name + " is loaded!"); callback(); }, // return list of other functional scripts to use, if any (like require in node_helper) getScripts: function() { return ["moment.js"]; }, // return list of stylesheet files to use if any getStyles: function() { return [this.data.path + "/css/MMM-Perlchamp.css"]; }, // only called if the module header was configured in module config in config.js getHeader: function() { return this.data.header; }, // messages received from other modules and the system (NOT from your node helper) // payload is a notification dependent data structure notificationReceived: function(notification, payload, sender) { // once everybody is loaded up if(notification === "ALL_MODULES_STARTED"){ // send our config to our node_helper this.sendSocketNotification("CONFIG",this.config); } if (sender) { Log.log(this.name + " received a module notification: " + notification + " from sender: " + sender.name); } else { Log.log(this.name + " received a system notification: " + notification); } }, // messages received from from your node helper (NOT other modules or the system) // payload is a notification dependent data structure, up to you to design between module and node_helper socketNotificationReceived: function(notification, payload) { if(notification === "HAVEDATA") { var self = this; Log.log(this.name + " received a socket notification: " + notification + " - Payload: " + payload); var now = moment(); for(var birthday of payload) { // get 1st 5 chars of birthdate, thru month // we will use this as the key in the hash var birth_date = birthday.birth.substring(0,5); // get the birthday as a moment in this year, for comparing var birth_date_moment = moment(birth_date + now.year(),"DD.MMYYYY"); // u can add days to a moment object and then compare // if the birthdate is before that date (and after now) // so within the next xx days // if the date is the same or later, don't use time of day if(birth_date_moment.startOf('day').isSameOrAfter(now.startOf('day')) && birth_date_moment.startOf('day').isSameOrBefore(birthday_time_window.startOf('day'))) { // birthday is in this month // check the hash if we've seen anything for today yet // if we haven't see this date yet if(this.active_birthdays[birth_date] == undefined){ // create the holder for its info (array of // names) in the hash this.active_birthdays[birth_date] = []; } // save the persons name on the list self.active_birthdays[birth_date].push({'name':birthday.name, 'age': now.diff(moment(birthday.birth,'DD.MM.YYYY'), 'years') }) } } // this.active_birthdays[birth_date].push(birthday.name); // this.active_birthdays[birth_date].push(birthday.name); // } // // } Log.log("this.active_birthdays >>>>> ", this.active_birthdays); /* // var currentMonth = new Date().toLocaleDateString('en', {month:'2-digit'}); var currentMonth = moment().format("MM"); var result = Object.entries(payload .filter(({birth}) => birth.split('.')[1] === currentMonth) .reduce((a, {birth, name}) => { const day = +birth.split('.')[0]; a[day] = [...(a[day] || []), name]; return a }, {}) ).map(([day, name]) => ({day, name})).sort((a, b) => +a.day - b.day); console.log("LISTE >> ", result); */ // tell MM to call and get our content self.updateDom(); } }, // system notification your module is being hidden // typically you would stop doing UI updates (getDom/updateDom) if the module is hidden suspend: function() { }, // system notification your module is being unhidden/shown // typically you would resume doing UI updates (getDom/updateDom) if the module is shown resume: function() { }, // this is the major worker of the module, it provides the displayable content for this module getDom: function() { var self = this; var wrapper = document.createElement("div"); // tell MM to call and get our content Log.log(JSON.stringify(this.active_birthdays)) // add this line self.updateDom(); // before this line in the notification code.. for(var birthday of Object.keys(this.active_birthdays)) { for(var name of this.active_birthdays[birthday]) { var m = document.createElement("div"); Log.log("BIRTHDAY >> " + birthday); Log.log("NAME >> " + name); m.innerText = birthday + " " + name; wrapper.appendChild(m); } } // pass the created content back to MM to add to DOM. return wrapper; } })birthdays.csv in folder MMM-Perlchamp/data:
birth,name 03.01.1940,aaa AAAAA 06.01.1969,bbb BBBBB 15.02.1939,ccc CCCCC 07.03.1972,ddd DDDDD 10.05.1969,eee EEEEE 16.05.2012,fff FFFFF 16.05.1988,ggg GGGGG 27.05.2002,hhh HHHHH 08.07.1976,iiii IIIII 13.07.1914,jjj JJJJJ 27.08.1968,kkk KKKKK 21.09.1967,lll LLLLL 13.10.1965,mmm MMMMM 16.10.2010,nnn NNNNN 23.10.1941,ooo OOOOO 19.12.1935,ppp PPPPPMMM-Perlchamp.css in folder MMM-Perlchamp/css
.MMM-Perlchamp header { letter-spacing: 0.1em; text-transform: uppercase; font-size: 20px; font-family: "Roboto Condensed", Arial, Helvetica, sans-serif; font-weight: 400; border-bottom: 1px solid #444444; line-height: 20px; padding-bottom: 5px; color: #ffffff; /* font-variant: small-caps; */ } -
RE: read csv-data and put it in an array
i could send you the three files (node_helper.js, MMM-Perlchamp.js, birthdays.csv) via email ?

-
RE: read csv-data and put it in an array
i got this:
[2020-05-02 18:10:50.465] [LOG] {} (/home/dirk/MagicMirror/modules/MMM-Logging/node_helper.js:34 Class.socketNotificationReceived)for each entry. i have 5 birthdays in may …