Skip to content

Latest commit

 

History

History
39 lines (26 loc) · 1.56 KB

README.md

File metadata and controls

39 lines (26 loc) · 1.56 KB

solarlog-csv

A python package for creating csv-files from data generated by Solar-Log devices.

The csv-files generated are structured per inverter per year. A UNIX-timestamp collumn is added for ease of import in databases etc.

Requirements

Install

sudo pip3 install git+https://github.com/MikiDi/solarlog-csv.git

Usage

  1. Download all your min*.js-files from the Solar-Log ftp-server. The address of the Solar-Log server you are registered on is the same as the address you use to access the online dashboard.

     mkdir solarlog-download
 cd solarlog-download
 wget ftp://username:password@solarlog-server.eu/min*.js

  2. Run solarlog-csv

     solarlog-csv ./path/to/solarlog-download 'Europe/Brussels'

note: Because the timestamps provided by Solar-Log are local you should make sure to also provide your timezone for the conversion to UNIX-timestamp to work correctly (supported timezones in TZ collumn of Wikipedia table of timezones)

Example data

An example of a min.js file can be found here: min120515.js

Excerpt from a generated csv-file:

timestamp,localtime,Pac,Pdc,Eday,Udc
1357056000,01.01.13 17:00:00,0,0,929,307
1357055760,01.01.13 16:56:00,0,0,929,381
1357055400,01.01.13 16:50:00,0,0,929,403

Supported devices

Tested with Solar-Log 500