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 439.7k 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
      sdetweil @Perlchamp
      last edited by

      @Perlchamp

      [{"
      

      array [ of objects {}, {}. {} ]
      the names of the object elements are the names of the columns (row 1 in the csv)

      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

        @sdetweil said in read csv-data and put it in an array:

        the names of the object elements are the names of the columns (row 1 in the csv)

        yes i know.
        i thought it’s an dictionairy and not an array. but it’s ok …

        S 1 Reply Last reply Reply Quote 0
        • S Offline
          sdetweil @Perlchamp
          last edited by

          @Perlchamp the [ (open square bracket) means array in javascript

          the array can be numbers, strings or objects (open squiggly bracket)

          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

            status:
            i wanted to “play” with the jsonArray, but things like jsonArray[“birth”][0] or jsonArray.birth[3] will not be accepted, although it is listed in many websites … i try and try and read and read, but in the moment no solution. the parameter “length” count the number of letters and numbers ?
            then I will have to deal with moment () first …

            S 1 Reply Last reply Reply Quote 0
            • S Offline
              sdetweil @Perlchamp
              last edited by sdetweil

              @Perlchamp u did not show the code, so I will call the output of the csvtojson() birthday_info

              example of how to navigate the json data

              in module there would be no ‘var’ cause of the way the modulename and helper are packaged inside object

              // if not using numbers but month names 
              // make indexOf return 1-12, not 0-11 (dummy thing never matched 1st)
              // fix this with your language abbreviations
              // usually in lower case, then always convert data to lowercase for compare to prevent having users remember to get the case right
              var months= ["0", "jan","feb","mar"...."dec"]
              
              var today_day_month = moment().format("DDMM")
              // today would be "3004"
              // tomorrow will be "0105"
              // loop thru the array of birthday info from file, one 'row' per birthday
              
              for(var birthday of birthday_info) {
                   // get the day/month string in numbers to match output of moment()
                   // get the last 2 chars of the day and month with a 0 on front.. 01-09, 12, ---31, or 01-09,10/11/12
                   if( ("0"+birthday.Geburtstag).subString(-2)+("0"+months.indexOf(birthday.Geburtsmonat.toLowerCase())).subString(-2) 
                                       == today_month_day) {
                       // this birthday is for today
                          condole.log(" birthday on "+ today_day _month+" is for "+birthday.Name);
                   } 
              }
              
              ``

              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

                i didn’t post the code, because it only was a status-info …
                but here is the code. i think i will first try alone. if there any questions i will post them.
                here is my array:

                [{"birth":"12.09.1967", "name":"Otto Billing"},{...}]
                

                many thanks in advance

                S 1 Reply Last reply Reply Quote 0
                • S Offline
                  sdetweil @Perlchamp
                  last edited by sdetweil

                  @Perlchamp ok, went to numbers, SO much easier!!

                  var today_day_month = moment().format("DD.MM")
                  // today would be "30.04"
                  // tomorrow will be "01.05"
                  // loop thru the array of birthday info from file, one 'row' per birthday
                  
                  for(var birthday of birthday_info) {
                       if( (birthday.birth.startsWith(today_day_month)) {
                           // this birthday is for today
                              console.log(" birthday on "+ today_day_month+" is for "+birthday.name);
                       } 
                  }
                  

                  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

                    @sdetweil said in read csv-data and put it in an array:

                    ok, went to numbers, SO much easier!!

                    ok, i will try. therefor my array don’t match, i think … that’s right ?

                    S 1 Reply Last reply Reply Quote 0
                    • S Offline
                      sdetweil @Perlchamp
                      last edited by

                      @Perlchamp the new data matches my new code

                      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, but now i’m a little bit confused, because my master problem will be, to reorg the array, to combine people with the same date of birth in as list in one row with the day of birth. but let me try …

                        S 1 Reply Last reply Reply Quote 0
                        • 1
                        • 2
                        • 6
                        • 7
                        • 8
                        • 9
                        • 10
                        • 31
                        • 32
                        • 8 / 32
                        • 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