• Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
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 409.0k 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 Away
    sdetweil @Perlchamp
    last edited by sdetweil Apr 30, 2020, 6:51 PM Apr 30, 2020, 6:39 PM

    @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
    • P Offline
      Perlchamp
      last edited by Perlchamp Apr 30, 2020, 6:52 PM Apr 30, 2020, 6:51 PM

      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 Apr 30, 2020, 6:55 PM Reply Quote 0
      • S Away
        sdetweil @Perlchamp
        last edited by sdetweil Apr 30, 2020, 7:01 PM Apr 30, 2020, 6:55 PM

        @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
        • P Offline
          Perlchamp
          last edited by Apr 30, 2020, 7:16 PM

          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 Apr 30, 2020, 7:18 PM Reply Quote 0
          • S Away
            sdetweil @Perlchamp
            last edited by Apr 30, 2020, 7:18 PM

            @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
            • P Offline
              Perlchamp
              last edited by Apr 30, 2020, 7:25 PM

              @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 Apr 30, 2020, 7:26 PM Reply Quote 0
              • S Away
                sdetweil @Perlchamp
                last edited by Apr 30, 2020, 7:26 PM

                @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
                • P Offline
                  Perlchamp
                  last edited by Apr 30, 2020, 11:04 PM

                  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 Apr 30, 2020, 11:22 PM Reply Quote 0
                  • S Away
                    sdetweil @Perlchamp
                    last edited by sdetweil Apr 30, 2020, 11:34 PM Apr 30, 2020, 11:22 PM

                    @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
                    • P Offline
                      Perlchamp
                      last edited by Perlchamp Apr 30, 2020, 11:38 PM Apr 30, 2020, 11:34 PM

                      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 Apr 30, 2020, 11:37 PM Reply Quote 0
                      • 1
                      • 2
                      • 6
                      • 7
                      • 8
                      • 9
                      • 10
                      • 31
                      • 32
                      • 8 / 32
                      8 / 32
                      • First post
                        71/313
                        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