<commit_before># Enecsys_Dashboard
is based on the need for a Solar Dashboard to monitor on a local server. to monitor the enecsys inverters 

It needs the database of the script that Omoerkbeek generates: https://github.com/omoerbeek/e2pv

Forum Topic on Tweakers: http://gathering.tweakers.net/forum/list_messages/1627615/0

Page 1 has a tutorial on how to install the complete setup on a raspberry pi. 
a linux server can handle the same thing.

Demo: http://vanmarion.nl/projects/enecsys/dashboard/
every update will also be available on this link. mysql data is not live though.

#Setup:
Create Table:
```
CREATE TABLE IF NOT EXISTS `inverters` (
  `data_id` int(11) NOT NULL AUTO_INCREMENT,
  `inverter_serial` varchar(30) NOT NULL,
  `inverter_type` varchar(30) NOT NULL,
  `duo_single` varchar(30) NOT NULL,
  `parts_nr` varchar(30) NOT NULL,
  `build_date` datetime NOT NULL,
  `panel_1` int(11) DEFAULT NULL,
  `panel_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`data_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
```
Insert the inverters you have (based on the number of inverters)
``` 
where xxxx is your serial of the converter,
type: is the type of the inverter
when having duo inverters they are connected to 2 inverters. you can input that here
panel_1, panel_2
```
this table might be updated later

-- insert into inverters
```
INSERT INTO `inverters` (`inverter_serial`, `inverter_type`, `duo_single`, `parts_nr`, `build_date`, `panel_1`, `panel_2`) VALUES
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2012-09-12 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
```<commit_msg>readme typo<commit_after># Enecsys_Dashboard
is based on the need for a Solar Dashboard to monitor on a local server. to monitor the enecsys inverters 

It needs the database of the script that Omoerkbeek generates: https://github.com/omoerbeek/e2pv

Forum Topic on Tweakers: http://gathering.tweakers.net/forum/list_messages/1627615/0

Page 1 has a tutorial on how to install the complete setup on a raspberry pi. 
a linux server can handle the same thing.

Demo: http://vanmarion.nl/projects/enecsys/dashboard/
every update will also be available on this link. mysql data is not live though.

#Setup:
Create Table:
```
CREATE TABLE IF NOT EXISTS `inverters` (
  `data_id` int(11) NOT NULL AUTO_INCREMENT,
  `inverter_serial` varchar(30) NOT NULL,
  `inverter_type` varchar(30) NOT NULL,
  `duo_single` varchar(30) NOT NULL,
  `parts_nr` varchar(30) NOT NULL,
  `build_date` datetime NOT NULL,
  `panel_1` int(11) DEFAULT NULL,
  `panel_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`data_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
```
Insert the inverters you have (based on the number of inverters)
``` 
where xxxx is your serial of the converter,
type: is the type of the inverter
when having duo inverters they are connected to 2 inverters. you can input that here
panel_1, panel_2
```
this table might be updated later

-- insert into inverters
```
INSERT INTO `inverters` (`inverter_serial`, `inverter_type`, `duo_single`, `parts_nr`, `build_date`, `panel_1`, `panel_2`) VALUES
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2012-09-12 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0),
('xxxx', 'SMI-480-60', 'duo', 'xxxx', '2013-04-13 00:00:00', 0, 0);
```
{'fraction_non_alphanumeric': 0.14348302300109528, 'fraction_numerical': 0.07502738225629792, 'mean_word_length': 4.798412698412698, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3966966', 'n_tokens_mistral': 1562, 'n_tokens_neox': 1329, 'n_words': 461}