read csv-data and put it in an array

sdetweil

so i also can do (?):
npm start dev

yes

can use your module to lock out other modules (

no… it collects all messages. so I add my module name to them…

on windows the notepad++ editor allows you to find all, and gives a new window with the lines
from where the find was done and allows u to click on the find results and navigate to the original file…
very helpful when there is a big log and maybe only 1 or 2 specific messages u are looking for

Perlchamp

ok, understand

Perlchamp

i have another information for you (github - MMM-Logging):

You can find more detailed information on debugging your MagicMirror here: Module Debugging. If you also want the Electron rederer (web browser) console logs to be printed to the standard console (or PM2 logs), change the following line to the very top of ~/MagicMirror/run-start.sh <<

this file does not exist. i can’t find it in the file-manager (i see all hidden files) …

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…

Perlchamp

ok, that’s fine

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:

delete the names on the list (with daynumber)
dimm these entries.
finally it should display like this:

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…

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 ?

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)

Perlchamp

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 :-)

sdetweil

@Perlchamp

[{"

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

Perlchamp

@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 …

sdetweil

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

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

Perlchamp

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 …

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);
     } 
}

``

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

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);
     } 
}

Perlchamp

@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 ?

sdetweil

@Perlchamp the new data matches my new code

Perlchamp

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 …