Johan Conradie Posted December 30, 2019 Share Posted December 30, 2019 I added a Raspberry Pie to my solar system. System consists of 2 x 5KvA Axpert Inverters, batteries and a PV array. The Raspberry came with pre-installed ICC software. It was a simple plug and play. Extremely easy. Thanks you to https://centurionsolar.co.za/?gclid=EAIaIQobChMIo_eY3Ofc5gIV0ed3Ch3ElQQqEAAYASAAEgKPD_D_BwE for the easy setup. With a few tweaks, here and there, the software is monitoring the usage (consumption) and electricity generated by the PV array. I can control the inverters very accurately with the software. It is also useful when calculating where to spend money on, i.e. more PV’s or more batteries and so forth. I am new to Raspberry. My questions are: Does the software should create a data file on the raspberry? If so where? File name? Can it be exported and viewed on another windows machine? Quote Link to comment Share on other sites More sharing options...
ChristoSnake Posted December 30, 2019 Share Posted December 30, 2019 ICC software stores its data in a SQLite file. You can use the Pi's "DB Browser for SQLite" to view the data: Click on the Raspberry icon, then Accessories -> DB Browser for SQLite Click Open Database, browse to the ICC directory and select the Solar.db file Use the File -> Export menu to save a backup copy of the database, or to export a single table at a time to a CSV file it's always a good idea to stop the ICC app before making any changes to the database contents... Johan Conradie 1 Quote Link to comment Share on other sites More sharing options...
Wilfred Posted December 30, 2019 Share Posted December 30, 2019 9 hours ago, Johan Conradie said: I added a Raspberry Pie to my solar system. System consists of 2 x 5KvA Axpert Inverters, batteries and a PV array. The Raspberry came with pre-installed ICC software. It was a simple plug and play. Extremely easy. Thanks you to https://centurionsolar.co.za/?gclid=EAIaIQobChMIo_eY3Ofc5gIV0ed3Ch3ElQQqEAAYASAAEgKPD_D_BwE for the easy setup. With a few tweaks, here and there, the software is monitoring the usage (consumption) and electricity generated by the PV array. I can control the inverters very accurately with the software. It is also useful when calculating where to spend money on, i.e. more PV’s or more batteries and so forth. I am new to Raspberry. My questions are: Does the software should create a data file on the raspberry? If so where? File name? Can it be exported and viewed on another windows machine? Your Pi should send the data to a server provided by Centurion solar, just ask them, the data is usually sent to Emoncms and you can use it with graphs, etc on you laptop or desktop pc or even on your tablet. Also maybe check, they should/could have send you an email with instructions. Quote Link to comment Share on other sites More sharing options...
jasonvanwyk Posted January 4, 2020 Share Posted January 4, 2020 On 2019/12/30 at 9:17 AM, Johan Conradie said: Does the software should create a data file on the raspberry? If so where? Hi Johan. Beside this - you can just simply download the data (your data) straight from emoncms (csv format). your can do this from the comfort of any PC that has internet access. I find this a lot easier, than "fiddling" with the pi happy data Quote Link to comment Share on other sites More sharing options...
___ Posted January 4, 2020 Share Posted January 4, 2020 I still wonder a bit about this use of emoncms in the ICC universe. Emoncms is under the GNU Affero license, which means any changes made to the server side code must be made available to the public. That basically means only unmodified instances my be used for commercial purposes. Which I'm sure is the case... sometimes I just wonder. (I don't particularly like the Affero license, btw, I generally prefer GPL-2 for things). Quote Link to comment Share on other sites More sharing options...
Johan Conradie Posted January 4, 2020 Author Share Posted January 4, 2020 Thank you all for the advice and thoughts. I think I will start with the supplier (Centurionsolar) on Monday and see if they can read the data. They might then also be able to say what is missing to go off grid. (My gut says batteries, but it may also be 3 x 300 watt PV's) Quote Link to comment Share on other sites More sharing options...
Johan Conradie Posted January 6, 2020 Author Share Posted January 6, 2020 Dear All, I have figured out how to access the data (CSV) from the internet server, with the help of CenturionSolar. I have to admit: All that data means absolutely nothing to me. I know where my abilities begins and end. The reason for the installation of the monitoring software was to get enough data to analyze and then ask for advice on what changes should be made and what should be added to the current configuration. The aim is to go off grid. Are there any interested people out there that can (or want to) read the data and give me an indication of the road ahead, please? Quote Link to comment Share on other sites More sharing options...
Wilfred Posted February 3, 2020 Share Posted February 3, 2020 Sorry for the late reply. I will for sure help you if I can. Quote Link to comment Share on other sites More sharing options...
Johan Conradie Posted February 3, 2020 Author Share Posted February 3, 2020 4 minutes ago, Wilfred said: Sorry for the late reply. I will for sure help you if I can. Hi, so how do we get in touch? :-) Quote Link to comment Share on other sites More sharing options...
Wilfred Posted February 3, 2020 Share Posted February 3, 2020 Sending you a pm. Quote Link to comment Share on other sites More sharing options...
jasonvanwyk Posted February 16, 2020 Share Posted February 16, 2020 Hi Johan - I hope you've come right? Just a side note (most here probably know - perhaps you too) If you are using excel (other spreadsheets can do too) it would serve you well to learn how to filter and order data. This becomes really helpful in narrowing down pinpointing what you are looking for - not to mention saving you a time - good Luck! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.