Help with parse values from a csv-file

[McMelloW]

Hello to all,

Code: Select all

;HR Solar ADVANCED controller [Regler];;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Date / Time;Systemdatum;Temperatur Sensor 1;Temperatur Sensor 2;Temperatur Sensor 3;Temperatur Sensor 4;Temperatur Sensor 5;Temperatur VFS/RPS (S6);TAGE;Volumenstrom V40;Volumenstrom VFS (S6);Volumenstrom Flowrotor (S7);Druck RPS (S6);Drehzahl Relais 1;Drehzahl Relais 2;Drehzahl Relais 3;Drehzahl Relais 4;PWM A;PWM B;Wärmemenge;SW-Version;Betriebssekunden Relais 1;Betriebssekunden Relais 2;Betriebssekunden Relais 3;Betriebssekunden Relais 4;Urlaubsfunktion;Blockierschutz 1;Blockierschutz 2;Blockierschutz 3;Initalisieren;Befüllung;Stabilisieren;Pumpenverzögerung;Überwärmeabfuhr;Nachlauf;Thermische Desinfektion;Speicherkühlung;Systemkühlung;Spreizung;Frostschutz;Kollektorkühlung;Einheit Temperatur;Einheit Durchfluss;Einheit Druck;Einheit Leistung;Einheit Energie;Speichermaximaltemperatur;Neustarts;Fehlermaske;WAMA (Counter);TWAMA
2018-01-06T13:30:26+01:00;06.01.2018 13:29:27;24,2;14,0;888,8;888,8;888,8;999,9;71;0;0;0;99,99;100;0;0;0;31;0;0;1,00;663248;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;888,8

This csv file is the output, after formatting, of the Resol KM2 module of my Solar Boiler. I need some values from row 3 and send it to devices. Sorry about my ignorance, but have no idea how you can parse some of these values. Is there anybody who has some experience with this. I hope to do this in dzVents. That is why I post this here

Very odd searching this forum on "csv" with or without quotes results in zero hits.

[dannybloe]

Yeah, some weirdo in the phpBB community decided that people should not be allowed to search for 3-letter words. Totally insane. You can search the domoticz forums using google: 'csv site:domoticz.com'.

Having said that: http://lua-users.org/wiki/LuaCsv

[Egregius]

If you like to use php I can help you, quite easy there.

[McMelloW]

If you like to use php I can help you, quite easy there.

Thanks for your offer. But I have no idea what php is?

Actually I was looking for something in dzVents or lua. A kind of function like readLuaFromJsonFile(fileName) for csv files. Don't know or something like that exist?

[McMelloW]

Yeah, some weirdo in the phpBB community decided that people should not be allowed to search for 3-letter words. Totally insane. You can search the domoticz forums using google: 'csv site:domoticz.com'.

Having said that: http://lua-users.org/wiki/LuaCsv

Thanks for the search tips. Is there something like readLuaFromJsonFile(fileName) for csv-files in dzVents?

[Egregius]

But I have no idea what php is?

PHP is a programming language just like LUA (but better )

In PHP something like this would already do the job:

Code: Select all

<?php
$data=str_getcsv(file_get_contents('http://192.168.2.10/status.htm'),"\r\n");
$x=0;
foreach($data as $d){
	$x++;
	if($x==3){
		$i=str_getcsv($d,";");
		//Do something with the $i array...
	}
}