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

      @Perlchamp yeh, that shell script was removed in 2.11… again I copied someone elses module and improved it for me.

      you can do that

      export ELECTRON_ENABLE_LOGGING=true
      

      in the terminal window where you will do npm start

      but with my changes, I don’t think u need to do that instruction anymore…

      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, that’s fine

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

          ok, now i can see the output of my csvtojson object. now the question about handle this all:
          is it better (csv-file) to call the rows ‘month of birth’, ‘birthday’, ‘year of birth’, ‘name’
          => mai,23,1964,stan smith
          or ‘birth’,name
          => 05.23.1964,stan smith

          how said:
          i want to display the birthdays of the current month, then the name and the age. if people should have birthday at the same day, they should listed, in which the daynumber only displayed once (=> two cells).
          what should happen, if the day of birth is over, i don’t know yet. there will be two options, i think, between the user can choose:

          1. delete the names on the list (with daynumber)
          2. dimm these entries.
            finally it should display like this:
            picture
          S 1 Reply Last reply Reply Quote 0
          • S Offline
            sdetweil @Perlchamp
            last edited by sdetweil

            @Perlchamp welcome to the fun

            its really month and day… year you would only want to know for big event things… 18, 21, 30, 40,50, …

            so, I would reorg the data as a hash (object) by date, and list [array] of people [‘Stan Smith’, ‘Joe Anyone’]

            birthdays = {}
            u can use the moment() object to get the month/day, or had code to extract the part of the date month/day,
            birthdays[birth_date][‘names’] = [‘Stan Smith’, ‘Joe Anyone’]
            then send the birthdays object up to modulename.js

            modulename.js in getDom()
            it uses moment().format(‘MMDD’) or (‘DDMM’) (same as node_helper did)
            then
            if( this.birthdays[date] !=undefined) // if there is something for today
            then can add the names in a for loop to the html to display

            and if you use moment() in modulename, u can add/subtract to look ahead, and it will format the right month/day,
            and u can get the day name

            today,
            tomorrow
            saturday
            sunday,
            next week…

            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

              uff, now first i have to read some papers for understanding that stuff …
              in the moment i only can see the output of the json-object via terminal. i don’t have them saved in an array or string. i wanted to use a async-method (by await), but it seems that this is the wrong way (error-messages) …
              i think to put the data first in an array couldn’t be wrong so far ?

               {
                  Geburtsmonat: 'März',
                  Geburtstag: '7',
                  Geburtsjahr: '1972',
                  Name: 'Julia Ützglütz'
                },
              {
              ...
              }
              
              

              could it ?

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

                @Perlchamp should already be an array of row(of column name/value pairs)…

                the JSON class has stringify(object) to convert json to text,

                console.log(JSON.stringify(results of convert))

                also has parse (from text form of json to object)

                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, now i have a dictionary (is that called though?) - always 4 columns (i will change that, if i read how to put it all in an array. in the moment i just have the output via console …)

                  [{"Geburtsmonat":"Januar","Geburtstag":"3","Geburtsjahr":"1940","Name":"Renate Stögger"},{...},{...}]
                  

                  but i’m on the right way, thanks again :-)

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