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.

    read csv-data and put it in an array

    Scheduled Pinned Locked Moved Utilities
    313 Posts 3 Posters 495.6k 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 Do not disturb
      sdetweil @Perlchamp
      last edited by

      @Perlchamp I’ll use you last code post

      // loop thru all the brithdays found in the file that match this month, one at a time
      for(var birthday of Object.keys(this.active_birthdays)) {
      
                          // each row is a person
      		    for(var person of this.active_birthdays[birthday]) {
      		    				
      			// create looped row section
                              // create a row
      			var bodyTR = this.createEl('tr', "birthday-tr-body", "TR-BODY", tBody, null);
      
                              // get timne/date of now
      			let now = moment();
                              // we need to change the style to dimmed,. if the BD is in the past
      
      			//let entrie = moment(birthday,"DD.MM");                      // < --- problem
                              // assume the birthday is NOT in the past
      			let entrie = now                                    
                              // if the user requested dimming
      			if(this.config.dimmEntries) {		
                                  // get the brithdate in this year 01.05.2020
                                  // note the value WAS the SAME as 'now'
      			    entrie = moment(birthday,'DD.MM');
      			}
                              // set the default value for the birthdate display			
      			var bd = "";  // assume we don't need to display it
         			// if we have not seen this birthdate in the loop so far, its the fiist time
      			if(birthdays_seen[birthday] == undefined) {
                                  // so we need the number of the day of the month
                                 // if it starts with 0, get from char 1 on sop 01.05 becomes 1.05, then 
                                 // use split to get the parts [ 1, 05]
                                 // if not '0', use all bd numbers 12.05, and split to [12,05]
                                 // and take the 1st element of array 
                                 // 1, or 12, for the two examples
      			    bd = (birthday.startsWith("0")? birthday.substring(1): birthday).split('.')[0];
      
                                  // now we need a row of data for the the person
                                  // class name is either TD-IMAGE or TD-IMAGE_DIMMED
                                  // use the two moments to compare (the fix for the entrie= now above will fix this) 
                                  // if the persons ds is before now, and we want dimmed, then add the tail of the class name on
                                  // else use this the name (concat('') - add nothing))
                                  // this  entrie.isBefore(now)?'_DIMMED':'' means 
                                  // the result of the expression is entrie before now  
                                  // if true return '_DIMMED'
                                  // if false return ''
                                  // "TD-IMAGE".concat() this means add onto the string "TD-IMAGE" whatever is inside the concat() parens, either '_DIMMED' or ''
                                  // so the class will be TD-IMAGE (for people with bithrdays ON or AFTER today)
                                  // or TD-IMAGE_DIMMED for people with birthdays BEFORE today
      			    //var imageTD = this.createEl('td', null, "TD-IMAGE".concat(entrie.isBefore(now)?"_DIMMED":'', bodyTR, bd);
      			    var imageTD = this.createEl("td", null, "TD-IMAGE", bodyTR, bd);
      			    //var nameTD = this.createEl("td", null, "TD-BODY".concat(entrie.isBefore(now)?"_DIMMED":'', bodyTR, person.name);
      			    var nameTDo = this.createEl("td", null, "TD-BODY", bodyTR, person.name);
      			    this.createEl("span", null, "TD-AGE", nameTD, " ");						
      			    
      			    // needs class for width
      			    //var spanTD = this.createEl("span", null, "TD-AGE".concat(entrie.isBefore(now)?"_DIMMED":'', nameTDo, person.age);
      			    var spanTD = this.createEl("span", null, "TD-AGE", nameTD0, person.age);
      			}
      			else{
                                   // we HAVE seen the birthday before, the row is already created, so we need to add to the END THAT ROW, ie after the span of the previous person
      			    // add a break (to the end of the TD for the name (has span already for age)
      			    this.createEl("br", null , null , nameTDo, null);
      			    // add a span with name
      			    //var nameTD = this.createEl("span", null, "TD-BODY".concat(entrie.isBefore(now)?"_DIMMED":'',nameTDo, person.name);
                                  //  add a span for the persons name (after the line break
      			    var nameTD = this.createEl("span", null, "TD-BODY", nameTDo, person.name);
      			    // add a span with for spacing
      			    //var spanTD = this.createEl("span", null, "TD-AGE".concat(entrie.isBefore(now)?"_DIMMED":'', nameTDo, person.age);
                                  // add a span with age
      			    var spanTD = this.createEl("span", null, "TD-AGE", nameTDo, person.age);
                                  // if we have another person with the same BD, new stuff will be added after this span
      			}					
      			
      			var spacerTR = this.createEl("tr", null, null , tBody, null);
      			var spacerTD = this.createEl("td", null, "SPACER", spacerTR, " ");
      			spacerTD.colSpan = "2";
                              // regardless of 1st or second, we have seen this birthdaty
      			birthdays_seen[birthday] = true;
      			
      		    }
      		}
      

      Sam

      How to add modules

      learning how to use browser developers window for css changes

      S 1 Reply Last reply Reply Quote 0
      • S Do not disturb
        sdetweil @sdetweil
        last edited by

        @Perlchamp my code had

        
        					let now = moment()		
        					let entrie=now
        				    if(this.config.dimmEntries) {				
        						entrie = moment(birthday,'DD.MM')
        					}
        					var bd = "";	
        

        Sam

        How to add modules

        learning how to use browser developers window for css changes

        1 Reply Last reply Reply Quote 0
        • PerlchampP Offline
          Perlchamp
          last edited by

          thanks a lot. i will study this …

          S 1 Reply Last reply Reply Quote 0
          • S Do not disturb
            sdetweil @Perlchamp
            last edited by

            @Perlchamp make that one fix and then my code will work too

            Sam

            How to add modules

            learning how to use browser developers window for css changes

            1 Reply Last reply Reply Quote 0
            • PerlchampP Offline
              Perlchamp
              last edited by Perlchamp

              update !
              i tried, but how should i do this ?
              i was in the dev. didn’t helped me. it’s , how said, the part

              .concat(entrie.isBefore(now)?"_DIMMED":''
              

              with => blackScreen
              without => working (formatted => css).

              S 1 Reply Last reply Reply Quote 0
              • S Do not disturb
                sdetweil @Perlchamp
                last edited by

                @Perlchamp have to edit the source code, then reload the browser page, cannot edit in debugger

                let now = moment()		
                					let entrie=now   // <-- this line was not included in yours..   i commented 
                				    if(this.config.dimmEntries) {				
                						entrie = moment(birthday,'DD.MM')
                					}
                

                Sam

                How to add modules

                learning how to use browser developers window for css changes

                1 Reply Last reply Reply Quote 0
                • PerlchampP Offline
                  Perlchamp
                  last edited by

                  this code => blackScreen:

                      getDom: function() {
                  	var wrapper = this.createEl("div", null, null, null, null);
                  	
                  	// 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();
                  	    var now = moment();
                  
                  	    if(Object.keys(this.active_birthdays).length > 0) {
                  	    
                  		// create your table here
                  		var table = this.createEl("table", "birthday-table", "TABLE", wrapper, null);
                  
                  		// create tableheader here, array of column names
                  		var table_header = this.createTableHeader(table, "THEAD", [" "," "]);
                  		//var table_header = this.createTableHeader(table, null, [" "," "," "]);
                  		
                  		// create TBODY section with day names
                  		var tBody = this.createEl('tBody', "birthday-tbody", "TBODY", table, null);
                  
                  		var birthdays_seen = {};		
                  		var spacer = " ";
                  		for(var birthday of Object.keys(this.active_birthdays)) {
                  		    for(var person of this.active_birthdays[birthday]) {
                  		    				
                  			// create looped row section
                  			var bodyTR = this.createEl("tr", "birthday-tr-body", "TR-BODY", tBody, null);
                  
                  			let now = moment();
                  			let entrie = moment(birthday,"DD.MM");
                  			
                  			if(this.config.dimmEntries) {				
                  			    entrie = moment(birthday,"DD.MM");
                  			}
                  			
                  			// delete leading 0 and month
                  			var bd = "";
                  			
                  			if(birthdays_seen[birthday] == undefined) {
                  			    bd = (birthday.startsWith("0")? birthday.substring(1): birthday).split(".")[0];
                  			    var imageTD = this.createEl("td", null, "TD-IMAGE".concat(entrie.isBefore(now)?"_DIMMED":'', bodyTR, bd);
                  			    //var imageTD = this.createEl("td", null, "TD-IMAGE", bodyTR, bd);
                  			    var nameTD = this.createEl("td", null, "TD-BODY".concat(entrie.isBefore(now)?"_DIMMED":'', bodyTR, person.name);
                  			    //var nameTD = this.createEl("td", null, "TD-BODY", bodyTR, person.name);
                  			    this.createEl("span", null, "TD-AGE", nameTD, " ");						
                  			    
                  			    // needs class for width
                  			    var spanTDo = this.createEl("span", null, "TD-AGE".concat(entrie.isBefore(now)?"_DIMMED":'', nameTD, person.age);
                  			    //var spanTDo = this.createEl("span", null, "TD-AGE", nameTD, person.age);
                  			}
                  			else{
                  			    // add a break
                  			    this.createEl("br", null , null , spanTDo, null);
                  			    // add a span with name
                  			    var nameTD = this.createEl("span", null, "TD-BODY".concat(entrie.isBefore(now)?"_DIMMED":'',spanTDo, person.name);
                  			    //var nameTD = this.createEl("span", null, "TD-BODY", spanTDo, person.name);
                  			    // add a span with age
                  			    var spanTD = this.createEl("span", null, "TD-AGE".concat(entrie.isBefore(now)?"_DIMMED":'', spanTDo, person.age);
                  			    //var spanTD = this.createEl("span", null, "TD-AGE", spanTDo, person.age);
                  			}					
                  
                  			birthdays_seen[birthday] = true;
                  		    }
                  		}
                  
                  		// Create TFOOT section -- currently used for debugging only
                  		if (this.config.debugging) {
                  		    var table_footer = this.createTableFooter(tBody, null, [" "," "]);
                  		    //footerTD.innerHTML = "Birthdaylist is currently in DEBUG mode!<br />Please see console log.";
                  		}
                  		else {
                  		    var table_footer = this.createTableFooter(tBody, null, [" "," "]);
                  		}
                  
                  	    }
                  
                  	    // pass the created content back to MM to add to DOM.
                  	    return wrapper;
                  
                  	}
                  	// Dom is loaded
                  	this.loaded = true;
                  
                      },
                  

                  this code works but no css:

                   getDom: function() {
                  	var wrapper = this.createEl("div",null,null,null,null);
                  	
                  	// 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();
                  	    var now = moment();
                  
                  	    if(Object.keys(this.active_birthdays).length > 0) {
                  	    
                  		// create table
                  		var table = this.createEl("table", "birthday-table", "TABLE" , wrapper,null)
                  
                  		// create tableheader here, array of column names
                  		var table_header = this.createTableHeader(table, null, [" "," "]);
                  		
                  		// create TBODY section with day names
                  		var tBody = this.createEl('tBody', "birthday-tbody", "TBODY" , table, null);
                  
                  		var birthdays_seen= {}
                  		var spacer = " ";
                  		for(var birthday of Object.keys(this.active_birthdays)) {
                  		    for(var person of this.active_birthdays[birthday]) {
                  
                  		    				
                  			// create looped row section
                  			var bodyTR = this.createEl('tr', "birthday-tr-body", "TR-BODY" , tBody, null);
                  
                  			let now = moment().format('DD.MM').valueOf();				
                  			let entrie=now;
                  			if(this.config.dimmEntries) {				
                  			    entrie = moment(birthday,'DD.MM').valueOf();
                  			}
                  			
                  			// delete leading 0 and month
                  			var bd = "";
                  			
                  			if(birthdays_seen[birthday] == undefined) {
                  			    bd = (birthday.startsWith("0")? birthday.substring(1): birthday).split('.')[0];
                  
                  			    var imageTD = this.createEl('td', null, "TD-IMAGE" + (entrie < now)?"_DIMMED":'' , bodyTR, bd);		
                  			    var nameTD = this.createEl('td', null, "TD-BODY" + (entrie < now)?"_DIMMED":'' , bodyTR, person.name);
                  			    this.createEl("span", null, null, nameTD, " ");						
                  			    
                  			    // needs class for width
                  			    var spanTDo = this.createEl("span", null, "TD-AGE" + (entrie < now)?"_DIMMED":'', nameTD, person.age);
                  			}
                  			else{
                  			    // add a break
                  			    this.createEl('br', null , null , spanTDo,null);
                  			    // add a span with name
                  			    var nameTD = this.createEl('span', null, "TD-BODY" + (entrie < now)?"_DIMMED":'' ,spanTDo, person.name);
                  			    // add a span with age
                  			    var spanTD = this.createEl("span", null, "TD-AGE" + (entrie < now)?"_DIMMED":'', spanTDo, person.age);						
                  			}					
                  			
                  			var spacerTR = this.createEl('tr', null, null , tBody, null);
                  			var spacerTD = this.createEl('td', null, "SPACER" , spacerTR, " ");
                  			spacerTD.colSpan = "2";
                  			birthdays_seen[birthday] = true;
                  			
                  		    }
                  		}
                  
                  		// Create TFOOT section -- currently used for debugging only
                  		if (this.config.debugging) {
                  		    var table_footer = this.createTableFooter(tBody, null, [" "," "]);
                  		    //footerTD.innerHTML = "Birthdaylist is currently in DEBUG mode!<br />Please see console log.";
                  		}
                  		else {
                  		    var table_footer = this.createTableFooter(tBody, null, [" "," "]);
                  		}
                  
                  	    }
                  
                  	    // pass the created content back to MM to add to DOM.
                  	    return wrapper;
                  
                  	}
                  	// Dom is loaded
                  	this.loaded = true;
                  
                      },
                   
                  
                  S 1 Reply Last reply Reply Quote 0
                  • S Do not disturb
                    sdetweil @Perlchamp
                    last edited by sdetweil

                    @Perlchamp you need to learn the debugger, code fixed

                    	getDom: function(){
                    		var wrapper = this.createEl("div",null,null,null);
                    
                    		if(Object.keys(this.active_birthdays).length>0){
                    
                    			// create your table  here
                    			var table = this.createEl("table", "birthday-table", null, wrapper );
                    
                    			// table header here, array of column names
                    			var table_header=this.createTableHeader(table,null, ["date","Name","age"])		
                    
                    			// create looped row section
                    			var tBody = this.createEl('tbody', "birthday-t-body", "tbody", table, null);		
                    
                    			var birthdays_seen= {}
                    			for(var birthday of Object.keys(this.active_birthdays)) {
                    			    for(var person of this.active_birthdays[birthday]) {			    				
                    
                    					// create looped row section
                    					var bodyTR = this.createEl('tr', null, "TR-BODY" ,tBody, null);	
                    
                    					let now = moment()		
                    					let entrie=now
                    				    if(this.config.dimmEntries) {				
                    						entrie = moment(birthday,'DD.MM')
                    					}
                    					var bd = "";					
                    			    	if(birthdays_seen[birthday]==undefined){
                    						bd =(birthday.startsWith("0")? birthday.substring(1): birthday).split('.')[0];
                    						var imageTD = this.createEl('td', null, "TD-IMAGE".concat(entrie.isBefore(now)?"_DIMMED":'') , bodyTR, bd);		
                    						var nameTD = this.createEl('td', null, "TD-BODY".concat(entrie.isBefore(now)?"_DIMMED":'') , bodyTR, person.name);
                    									 this.createEl("span", null, null, nameTD, " ");						// needs class for width
                    						var spanTDo = this.createEl("span", null, "TD-AGE".concat(entrie.isBefore(now)?"_DIMMED":''), nameTD, person.age);
                    					}	
                    					else{
                    						// add a break
                    						this.createEl('br', null , null , spanTDo,null);
                    						// add a span with name
                    						var nameTD = this.createEl('span', null, "TD-BODY".concat(entrie.isBefore(now)?"_DIMMED":'') ,spanTDo, person.name);
                    						// add a span with age
                    						var spanTD = this.createEl("span", null, "TD-AGE".concat(entrie.isBefore(now)?"_DIMMED":''), spanTDo, person.age);						
                    					}					
                    
                    
                    					var spacerTR = this.createEl('tr', null, null , tBody, null);
                    					var spacerTD = this.createEl('td', null, "SPACER" , spacerTR, " ");
                    					spacerTD.colSpan = "2";
                    					birthdays_seen[birthday] = true;
                    
                    				}
                    		    }
                    		}
                    		return wrapper;
                    	},
                    

                    see the last line of the console

                    Screenshot at 2020-05-03 20-27-54.png
                    black screen means syntax error in some modulename.js, click on the line number and it will take you to that line in the code … note the concat(… is missing its right paren ‘)’

                    Sam

                    How to add modules

                    learning how to use browser developers window for css changes

                    1 Reply Last reply Reply Quote 0
                    • PerlchampP Offline
                      Perlchamp
                      last edited by

                      thank you very much. yes i need more expirience of debugging. it’s my second day i use it, sorry sam. AND MANY THANKS.

                      S 1 Reply Last reply Reply Quote 0
                      • S Do not disturb
                        sdetweil @Perlchamp
                        last edited by

                        @Perlchamp Make an error, take out a comma, or ’

                        reload the page, f5

                        put part of ht module name in the filter field of the console

                        find the error message
                        click the filename/line to the right

                        Sam

                        How to add modules

                        learning how to use browser developers window for css changes

                        1 Reply Last reply Reply Quote 0
                        • PerlchampP Offline
                          Perlchamp
                          last edited by

                          ok, will collect some experience …

                          1 Reply Last reply Reply Quote 0
                          • PerlchampP Offline
                            Perlchamp
                            last edited by

                            ok, the blacksreen is gone, works, but no css

                            S 1 Reply Last reply Reply Quote 0
                            • S Do not disturb
                              sdetweil @Perlchamp
                              last edited by

                              @Perlchamp that comes up for me
                              Copied directly. Will send my module file.

                              Sam

                              How to add modules

                              learning how to use browser developers window for css changes

                              1 Reply Last reply Reply Quote 0
                              • PerlchampP Offline
                                Perlchamp
                                last edited by

                                ok, thanks

                                S 1 Reply Last reply Reply Quote 0
                                • S Do not disturb
                                  sdetweil @Perlchamp
                                  last edited by

                                  @Perlchamp see the expanded html on left

                                  Screenshot at 2020-05-03 21-02-49.png

                                  file sent

                                  Sam

                                  How to add modules

                                  learning how to use browser developers window for css changes

                                  1 Reply Last reply Reply Quote 0
                                  • PerlchampP Offline
                                    Perlchamp
                                    last edited by Perlchamp

                                    it WORKS ! now i hope to find the error :-)

                                    S 1 Reply Last reply Reply Quote 0
                                    • S Do not disturb
                                      sdetweil @Perlchamp
                                      last edited by

                                      @Perlchamp i did not use the classes , no… didn’t care about the layout etc…
                                      I want to make sure the NAMES of the classes are right…

                                      sending file again, sorting the dates

                                      Sam

                                      How to add modules

                                      learning how to use browser developers window for css changes

                                      1 Reply Last reply Reply Quote 0
                                      • PerlchampP Offline
                                        Perlchamp
                                        last edited by

                                        work’s, too :-) , sam

                                        1 Reply Last reply Reply Quote 0
                                        • D Offline
                                          dorinilut
                                          last edited by

                                          @Perlchamp , would it be possible to share the module you came up with? I am looking for the exact same thing and I was thinking I would be getting a copy.

                                          many many thanks!

                                          1 Reply Last reply Reply Quote 1

                                          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                                          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                                          With your input, this post could be even better 💗

                                          Register Login
                                          • 1
                                          • 2
                                          • 12
                                          • 13
                                          • 14
                                          • 15
                                          • 16
                                          • 16 / 16
                                          • 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