… and I’m very grateful to you for that. I learn from your messages every time. I think it’s great that there are people like you. that also costs time (apart from health, the most important thing in life). Thanks again for that!

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 …

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

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

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

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

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 ?

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:
   

ok, that’s fine

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

ok, understand

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

if u install the logging module I suggested, then it captures all the messages from the modulename.js in the browser and prints them to the terminal window log, which would be saved to the file as well.

so i also can do (?):
npm start dev
in the window on the right klicking on “console”. there i see a lot of massages coming from console/moduls
and then i can use your module to lock out other modules (?) …

ok, it’s slowly dawning on me, see little light at the end of the tunnel

always my pleasure

thank you. ok, i will test …

only for your information:

start() {
		console.log(`Starting module helper: ${this.name}`);
	},

	stop(){
		console.log(`Stopping module helper: ${this.name}`);
	},

this is from your SampleModule. i’m not here to reprimand you. it should only be information. so please do not misunderstand.

hallo sam :-)
i have now this in my node_helper.js:

var NodeHelper = require("node_helper");

// add require of other javascripot components here
// var xxx = require('yyy'); here
const csv = require("csvtojson");
const csvFilePath = this.path + 'birthdaylist.csv';


module.exports = NodeHelper.create({

	init(){
		console.log("init module helper perlchamp");
	},

	start() {
		console.log("Starting module helper: ${this.name}");
		console.log("dieser Pfad: ${this.path}");
		
		csv()
		.fromFile(csvFilePath)
		.then((jsonObj)=>{
			console.log(jsonObj);
		})

	},

/*
	stop(){
		console.log(`Stopping module helper: ${this.name}`);
	},
*/
	// handle messages from our module// each notification indicates a different messages
	// payload is a data structure that is different per message.. up to you to design this
	socketNotificationReceived(notification, payload) {
		console.log(this.name + " received a socket notification: " + notification + " - Payload: " + payload);
		// if config message from module
		if (notification === "CONFIG") {
			// save payload config info
			this.config=payload
			// wait 15 seconds, send a message back to module
			setTimeout(()=> { this.sendSocketNotification("message_from_helper"," this is a test_message")}, 15000)
		}
		else if(notification === "????2") {
		}

	},

});

terminal says:

Unhandled rejection Error: File does not exist. Check to make sure the file path to your csv is correct.
    at /home/dirk/MagicMirror/node_modules/csvtojson/v2/Converter.js:81:37
    at suppressedCallback (fs.js:209:5)
    at FSReqCallback.oncomplete (fs.js:153:23)

it’s from your SampleModule …

1. how can i see the console.log statements in the browser, starting MM ?
2. did i enter the code in the right place?
3. if I enter the following into the terminal window:
   node console.log (‘path: $ {this.path}’)
   i got an error message:
   bash: Syntaxerror unexpected word `(’
   what am I doing wrong ?

many thanks in advance

ok thank.
if i want to test

    readCSV: fs.readFile('birthdaylist.csv', 'utf8', function (err, data) {
	var dataArray = data.split(/\r?\n/);
	Log.log(dataArray);

or

readList: function() {
	var JFile=require('jfile');
	var myF=new JFile("MMM-birthday.txt");
	myF.lines // ["first line","second line"]

i have to do this in node_helper right? and first i have to require them and of course to install them … something i forgot ?

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

I open browser from PC to the mirror URL and do it there
I debug from my PC, ssh connected to pi, or I run MM on my PC… and debug there

how ?

AND:
thanks a lot for YOUR time. i hope it will not been wasted … i will working hard to get some results …