Thread Rating:
  • 4 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Esperyd´s Raspberry PI project
(06-17-2019, 07:42 PM)daromer Wrote: Yes you can. Best is IF the values only have different tags but in same series
Last solar sis have better layout for this (not pushed to hit yet) but doable with current too

Values are in the same series but still don’t understand how (for example) to sum them. Only operation I am able to do is to stack values if on graph......
Reply
You need to manually write some code for it. I can post examples later but you also have earlier in this thread.
iomagico likes this post
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
Reply
(06-18-2019, 02:56 AM)daromer Wrote: You need to manually write some code for it. I can post examples later but you also have earlier in this thread.

Yes please, if you can post one example I’ll appreciate it.

Let immagine I want to simply sum the active power coming from the 3 inverters. Remember I have 3 differente sources, so I can put the values in a serie but I don’t know how to operate math between them. Maybe I can set a variable for each value?
Reply
I took a look at all thread but had no way to solve the problem.
Main question is that my datas coming from different inverters.
On grafana metrics I can do math between fields but the source ( FROM in grafana metric) is always the same.
I think that a solution can be using Singlestat math “alias by”, that transform the single operation in a variable and put the alias is another math, but I still don’t understand how it works.
Reply
(06-19-2019, 07:41 AM)iomagico Wrote: I took a look at all thread but had no way to solve the problem.
Main question is that my datas coming from different inverters.
On grafana metrics I can do math between fields but the source ( FROM in grafana metric) is always the same.
I think that a solution can be using Singlestat math “alias by”, that transform the single operation in a variable and put the alias is another math, but I still don’t understand how it works.

If you run 3 instances of the solar_pip, only modifying the serial port,  you are inserting triple data and you can not difference the inverter wich data that comes from. 

I think the best way is to change calls.json file to change response section on every folder to insert in the same meassurement (general_status) but different fields (grid_voltage1, grid_voltage2, grid_voltage3), etc, so you can differenciate and agregate data from different inverters in grafana.

Regards
iomagico likes this post
Reply
iomagico Have you looked back in the thread?

Example of sum I do:
select sum(sum1) from ( select (mean(solar_input_power_1)+mean(solar_input_power_2)) as sum1 from solar where device='mpi' AND $timeFilter GROUP BY time($__interval) fill(null)), (SELECT sum(last) as sum1 from(select mean("charging_power") as last FROM "solar" group by device) where $timeFilter GROUP BY time($__interval) fill(null)) GROUP BY time($__interval)
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
Reply
(06-19-2019, 07:06 PM)jesusangel Wrote:
(06-19-2019, 07:41 AM)iomagico Wrote: I took a look at all thread but had no way to solve the problem.
Main question is that my datas coming from different inverters.
On grafana metrics I can do math between fields but the source ( FROM in grafana metric) is always the same.
I think that a solution can be using Singlestat math “alias by”, that transform the single operation in a variable and put the alias is another math, but I still don’t understand how it works.

If you run 3 instances of the solar_pip, only modifying the serial port,  you are inserting triple data and you can not difference the inverter wich data that comes from. 

I think the best way is to change calls.json file to change response section on every folder to insert in the same meassurement (general_status) but different fields (grid_voltage1, grid_voltage2, grid_voltage3), etc, so you can differenciate and agregate data from different inverters in grafana.

Regards

What I did was to create 3 different solar_pip folders so I can perfectly differenciate the values from different inverters.
So I can display results and I can even add values from different inverters (stacking them). What I can’t is to operate math when FROM is different.
All math operations I am able to compute are with same FROM field.
Here I am attaching two pictures from grafana.

Ps: will try the Jesuangel solution
Reply
thanks @Jesusangel and @daromer

The correct process to visualize and process datas from more than one source (inverter, charger, etc...) is to create more than one solar_pipX.service (etc/systemd/system/), more than one solas-sisX folder (one for each source) and modify session.json to assign one serial to each source and modify calls.json to assign values for each source (example: battery_voltage_1, battery_charging_current_3, etc...).

Than is possible operate every math.

Thanks again

Angelo
Reply
Hello everyone,

I just installed my 5048MG x2 in parallel.
I Connect both of them in usb directly to my rasp.
I saw that a usb directory in /dev with hiddev0 and hiddev1
when I launch the command it seems that it doesn't respond:

root@grafpi:/energy-logger/solar-sis/example/PIP4048# node project.js
[2019-06-26 18:37:42] http localhost Listening on port: 3001
[2019-06-26 18:37:42] info serial:/dev/usb/hiddev0 Open serial port
[2019-06-26 18:37:42] info queue:ADD_INTERVAL query/general_status:QPIGS·©
[2019-06-26 18:37:42] info queue:ADD_INTERVAL query/device_rated_information:QPIRIÞT
[2019-06-26 18:37:45] info serial:/dev/usb/hiddev0:SEND query/general_status
[2019-06-26 18:37:45] info serial:/dev/usb/hiddev0:SEND_RAW [{"type":"Buffer","data":[81,80,73,71,83,183,169,13]}]
[2019-06-26 18:37:55] ERR! serial:/dev/usb/hiddev0 Reciving reached threshold 10017ms (10000ms)
[2019-06-26 18:37:55] WARN serial:/dev/usb/hiddev0 Close serial port
[2019-06-26 18:37:55] info serial:/dev/usb/hiddev0 Open serial port
[2019-06-26 18:37:55] info serial:/dev/usb/hiddev0 Open serial port
[2019-06-26 18:37:55] info queue:ADD_INTERVAL query/general_status:QPIGS·©
[2019-06-26 18:37:55] info queue:ADD_INTERVAL query/device_rated_information:QPIRIÞT
[2019-06-26 18:37:56] info serial:/dev/usb/hiddev0:SEND query/general_status
[2019-06-26 18:37:56] info serial:/dev/usb/hiddev0:SEND_RAW [{"type":"Buffer","data":[81,80,73,71,83,183,169,13]}]

Any idea ?
Reply
Just because it finds the adaptor doesnt say the adaptor have contact with the inverter. Crosscheck that and that the inverter have the same serial protocol.
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
Reply


Who read this thread?
100 User(s) read this thread:
hbpowerwall, AZ_Tekkie, Chickey, ShaneE, Minx, daromer, Sean, mike, 18650Shrink, goodnowm, AveRageJoe, BigBen, PaulKennett, Joaquinsfy, SJBW, NiVa, MichelKuenemann, Lux_Gamer, Andreas Kvernes, owitte, opus40, RudyLiPower, lgeo, dakoal, VdVoort4, Glubux, Majorphill, Elwood, coolfx, ruby2, JustJim, Korishan, A + A, PAF, FERCSA, Prahe86, Clisse, Zensay, Franky Beuselinck, Batrium, Darmok, Wattsup, Scepterr, eeesOap, BobinTN, Tristan Timmer, Frnandu Martiński, CrankyCoder, Mike C, Droid126, eAnic, Sabado, jdeadman, charlie246, monsted, camils, Zagy, 2146, wim, wimpie007, ericg, frnandu, typ49, John, Christian, Robert Baumer, Alyas Junior Abdul, Jeremy Choy, 1958 greyhound, Abarth595, Sentinal, Tango47, kktuo, civitou, neilmc, Kaspars Krumins, Off Grid Power wall, Verner A. Møller-jensen, Tychipowerwall, rebelrider.mike, kaits31, gaz, watts-on, Dan Lim, jesusangel, Gimpy_AK, fcbrand, Daggerzz, Hanssing, MetalFang, Fredd, autobd, IronSky, Mark Daniel Olsen, DrkHrs13, tamkov, silverse2m6, kot, quake101, Joost2

Forum Jump:


Users browsing this thread: 1 Guest(s)