I am working my way through the MS MODBUS Specification specs to capture data onto the RPi3.The plan is to avoid fixed control panels, and instead, run a web server on the RPi3 and then view info via smartphone, tablet, laptop, etc clients. A mifi will provide LAN connections.As of last Friday, I have been capturing the 'RAM' data fields for each minute. The fields are listed on page 4.I have no plans to use spreadsheets. I store the data in an sqlite3 database.Here is a sample output from an sql query run from the sqlite3 CLI:day cs cstate avg_bvolts min_btemp max_btemp minutes ---------- -- ------ ---------- ---------- ---------- ----------2017-04-23 3 Night 12.93 9 25 620 2017-04-23 5 Bulk 13.35 9 26 178 2017-04-23 6 PWM 14.86 10 22 328 2017-04-23 7 Float 13.36 22 27 314 The query displays a summary of the minutes for each control state for the previous day. The bank is 270ah AGM which should explain the high Night battery Volts. I do run two 12V compressor fridges 24/7.Looking for Comments, Suggestions, Questions.HTH;JohnTo correct broken MODBUS link. And, yes, I still refer back to this topic.

full_mosey wrote:I am working my way through the MS MODBUS Specification specs to capture data onto the RPi3.The plan is to avoid fixed control panels, and instead, run a web server on the RPi3 and then view info via smartphone, tablet, laptop, etc clients. A mifi will provide LAN connections.As of last Friday, I have been capturing the 'RAM' data fields for each minute. The fields are listed on page 4.I have no plans to use spreadsheets. I store the data in an sqlite3 database.Here is a sample output from an sql query run from the sqlite3 CLI:day cs cstate avg_bvolts min_btemp max_btemp minutes ---------- -- ------ ---------- ---------- ---------- ----------2017-04-23 3 Night 12.93 9 25 620 2017-04-23 5 Bulk 13.35 9 26 178 2017-04-23 6 PWM 14.86 10 22 328 2017-04-23 7 Float 13.36 22 27 314 The query displays a summary of the minutes for each control state for the previous day. The bank is 270ah AGM which should explain the high Night battery Volts. I do run two 12V compressor fridges 24/7.Looking for Comments, Suggestions, Questions.HTH;JohnComment Number 1: COOL!!!!!!!!!! :)Number 2: Sounds like you're a RPi expert but just my two cents: invest in a good microSD card if you're hammering the card with IO, like sqlite will do. I have 6 RPis in the house, and when I buy cheap SD cards they last about 8 months. I bought a couple of Samsung SD cards and they've gone three years.Web Server - Not sure if you have a favorite, but if not I've been running lighttpd on my home Pi and like it. Small. Solid.I've got an RPi3 with a SensorHat in our coach collecting environment and OBD2 data. I'll follow your lead if/when we add solar!

Very good to hear I'm not alone in my madness :)I don't have solar, but do have a RPI2 collecting data from my Magnum and several other custom built WiFi sensors and switches around the trailer... it all ties together in a web based "dashboard" that I can bring up on any tablet or smartphone.Not familiar with the RPI3, but if it's using one of those tiny microsd cards for the database, you'll want to move the db over to a USB stick or external USB hard drive. The SQL server on my RPI2 burned through two microsd cards already, the constant writes killed the cards dead.

RPi3 is an RPi2 with built in WiFi, Bluetooth (BLE) and a higher clock speed (1.2 GHz). Add a heatsink and folks are overclocking to 1.4ish. The RPi3 really needs a good 2.5A or better power supply. Mine was flaky with a 2A feed.

Uno mas - Western Digital has a line of external drives designed especially for the Raspberry Pi.

pconroy328 wrote:Uno mas - Western Digital has a line of external drives designed especially for the Raspberry Pi.I put an old laptop hard drive in a usb box and plugged it into the Pi. Cost about $7 for the box. More space then I'll ever need for databases and source code.

MorningStar TriStar-45 PWM and Raspberry Pi 3 data project

GordonThree
Explorer
Apr 24, 2017
Very good to hear I'm not alone in my madness :)

I don't have solar, but do have a RPI2 collecting data from my Magnum and several other custom built WiFi sensors and switches around the trailer... it all ties together in a web based "dashboard" that I can bring up on any tablet or smartphone.

Not familiar with the RPI3, but if it's using one of those tiny microsd cards for the database, you'll want to move the db over to a USB stick or external USB hard drive. The SQL server on my RPI2 burned through two microsd cards already, the constant writes killed the cards dead.
pconroy328
Explorer
Apr 24, 2017
full_mosey wrote:
I am working my way through the MS MODBUS Specification specs to capture data onto the RPi3.

The plan is to avoid fixed control panels, and instead, run a web server on the RPi3 and then view info via smartphone, tablet, laptop, etc clients. A mifi will provide LAN connections.

As of last Friday, I have been capturing the 'RAM' data fields for each minute. The fields are listed on page 4.

I have no plans to use spreadsheets. I store the data in an sqlite3 database.

Here is a sample output from an sql query run from the sqlite3 CLI:

day cs cstate avg_bvolts min_btemp max_btemp minutes
---------- -- ------ ---------- ---------- ---------- ----------
2017-04-23 3 Night 12.93 9 25 620
2017-04-23 5 Bulk 13.35 9 26 178
2017-04-23 6 PWM 14.86 10 22 328
2017-04-23 7 Float 13.36 22 27 314

The query displays a summary of the minutes for each control state for the previous day.

The bank is 270ah AGM which should explain the high Night battery Volts. I do run two 12V compressor fridges 24/7.

Looking for Comments, Suggestions, Questions.

HTH;
John

Comment Number 1: COOL!!!!!!!!!! :)

Number 2: Sounds like you're a RPi expert but just my two cents: invest in a good microSD card if you're hammering the card with IO, like sqlite will do. I have 6 RPis in the house, and when I buy cheap SD cards they last about 8 months. I bought a couple of Samsung SD cards and they've gone three years.

Web Server - Not sure if you have a favorite, but if not I've been running lighttpd on my home Pi and like it. Small. Solid.

I've got an RPi3 with a SensorHat in our coach collecting environment and OBD2 data. I'll follow your lead if/when we add solar!

Forum Discussion

MorningStar TriStar-45 PWM and Raspberry Pi 3 data project

About RV Must Haves

Related Content

Tristar 45 PWM Custom Profile

Fuse size before and after Tristar 45 PWM

Raspberry Pi Slideshow

MorningStar TS45

What happened to raspberry pies?