read csv-data and put it in an array

[Perlchamp]

hello,
i want to read a csv-file and put it in an array. should be like this:
[line 1, line2, line3, …]
i don’t know how to handle it. who can help me, please.

Many thanks in advance

[sdetweil]

@Perlchamp there are a bunch of libraries for csv to ???

google is your friend

https://www.npmjs.com/package/convert-csv-to-array

if u convert it to json, its a lot easier to work with in code
I use https://www.npmjs.com/package/csvtojson

[Perlchamp]

@sdtweil:
thanks a lot. I will take a look at it.

so long

[Perlchamp]

to include in my modul i have to do the following ?

1. go in my module-folder
2. npm i --save csvtojson

than i have to include in my module.js:
// required scripts
getScripts: function() {
return [“moment.js”, “csvtojson.js”];
},

is this right?
if so, how to use it in my script ?

many thanks in advance.
stay healthy !

[sdetweil]

@Perlchamp you have to use the node_helper.js … the module.js file runs in the browser and doesn’t have access to local files

var xxx= require(‘’)…

then module has to send request to node_helper and node_helper has to send results back

see my MyCovid19 module
https://github.com/sdetweil/MyCovid19

[Perlchamp]

hello sam,
i’m a noob. sorry for that. i will have a look to your module.
this all is new for me. it will take some time …
if you would help me, that would be great. but first i have to read some things …

so long

[sdetweil]

@Perlchamp my sample module might be helpful too…
https://github.com/sdetweil/SampleModule

implements what is in the developing module documentation
https://docs.magicmirror.builders/development/introduction.html

[Perlchamp]

hello sam,
thanks a lot. i will have a look on it, too. sure, i will learn a lot.

so long

[Perlchamp]

covid chart do not load :-(

[sdetweil]

@Perlchamp show me the config for the module?

[Perlchamp]

in config.js i didn’t use the config section. i thought the defaults should be enough. ok, i will put the config section into the config.js. just a moment, please …

[sdetweil]

@Perlchamp no… I don’t pick any countries or states, or describe how big the charts should be…
try this

		{
			module:"MyCovid19",
			disabled:false,
			position:"top_left",
			classes: 'sam',			
			config:{
				countries:["Italy","USA","China","Spain", "France",'Sweden'],
				// line colors can be any definition of color either a name ,or a hex string
				// one per country above, used in order,
				line_colors:['red','white','green','yellow','#34ebde','#34eb00'],
				//				
				chart_type:"cumulative_deaths",  // or "cumulative deaths"
				chart_title:"cumulative deaths by country", // however u want to label
				// the vertical steps on the chart.. how tall u want it to be and how mant increments 
				ranges:{min:0,max:30000,stepSize:5000},
				// size of the chart in pixels
			    width: 400,
			    height: 400,	
			    // only used if we need to debug something
			    debug:false,
			    startDate:'02/01/2020',
			    //backgroundColor: 'white',
			},
		},	

[Perlchamp]

still loading …

{
			module: "MyCovid19",
			position: "top_right",
			config:{
				countries: "Italy",
			    //countries:["Italy","USA","China","Spain","France"],
                //OR
			    //states:['New York','Illinois','Texas'],

			    // one of countries or states MUST be specified

			    // line colors can be any definition of color either a name ,or a hex string
			    // one per country above, used in order,
			    //line_colors:['red','white','green','yellow','blue'],
			    line_colors: "white",
			    //				
			    chart_type:"cumulative_cases",  // or "cumulative deaths"
			    chart_title:"Cumulative Cases", // however u want to label
			    // the vertical steps on the chart.. how tall u want it to be and how mant increments
			    ranges:{min:0,max:8000,stepSize:10000},
			    // size of the chart in pixels
		        width: 400,
		        height: 500,
		        // only used if we need to debug something
		        debug:false,
		        startDate: "02/01/2020"
		    }
		},

[sdetweil]

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

  		countries: "Italy",

must be an array countries : [ ‘Italy’ ] ,

[Perlchamp]

to include csvtojson i have to do the following ?

getScripts: function () {
		    return ["moment.js", "modules/" + this.name + "/node_modules/csvtojson/bin/csvtojson.js"];
		},

is that right ?
covid do not run … black screen, no loading message …

[sdetweil]

@Perlchamp no… see the node_helper.js

you cannot use the csvtojson in the modulename.js

[sdetweil]

@Perlchamp did u use my config info above? just to make it work

[Perlchamp]

yes.
[“Italy”],

which one? in your corona ?

[sdetweil]

@Perlchamp i provided a complete working sample for my module above… copy/paste it into your config.js

[Perlchamp]

i did copy it, but doesn’t work yet. have i look on your code. is there a comma after the date. i think this shouldn’t be there. i deleted it, but still does not work => black screen