Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. ioBroker Allgemein
    4. Forecast.solar mit dem Systeminfo Adapter

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Forecast.solar mit dem Systeminfo Adapter

    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      MartyBr @paul53 last edited by

      @paul53
      Danke, hat funktioniert und die Werte kommen

      Ich setze hier das komplette (finale Script) für drei Strings rein:

      /* read solar forecasts for 3 different orientations
       Author : gargano
       Display in VIS : use JSON Chart from Scrounger
       Version 1.0.1 
       Last Update 16.3.2021 
       Change history :
       1.0.1 / 16.3.2021   :   use setStateAsync(myUrl.mySolarJSON.. to avoid time conflicts 
                               dp's are now saved in '0_userdata.0.'
                               use variables for setting lat, lon, color..
      1.0.2  / 21.11.2021  :   Umbau auf 3 Strings
       */
       
      const prefix = 'javascript.2.'; 
       
      const SolarJSON1            = prefix+"SolarForecast1.JSON1";
      const SolarJSON2            = prefix+"SolarForecast1.JSON2";
      const SolarJSON3            = prefix+"SolarForecast1.JSON3";
      const SolarJSONAll1         = prefix+"SolarForecast1.JSONAll1";
      const SolarJSONAll2         = prefix+"SolarForecast1.JSONAll2";
      const SolarJSONAll3         = prefix+"SolarForecast1.JSONAll3";
      const SolarJSONGraphAll1    = prefix+"SolarForecast1.JSONGraphAll1";
      const SolarJSONGraphAll2    = prefix+"SolarForecast1.JSONGraphAll2";
      const SolarJSONGraphAll3    = prefix+"SolarForecast1.JSONGraphAll3";
      const SolarJSONTable        = prefix+"SolarForecast1.JSONTable";
      const SolarJSONGraph        = prefix+"SolarForecast1.JSONGraph";
       
      const createStateList = [
          {name :SolarJSON1, type:"string", role : "value"},
          {name :SolarJSON2, type:"string", role : "value"},
          {name :SolarJSON3, type:"string", role : "value"},
          {name :SolarJSONAll1, type:"string", role : "value"},
          {name :SolarJSONAll2, type:"string", role : "value"},
          {name :SolarJSONAll3, type:"string", role : "value"},
          {name :SolarJSONGraphAll1, type:"string", role : "value"},
          {name :SolarJSONGraphAll2, type:"string", role : "value"},
          {name :SolarJSONGraphAll3, type:"string", role : "value"},
          {name :SolarJSONTable, type:"string", role : "value"},
          {name :SolarJSONGraph, type:"string", role : "value"}
      ]
       
      // create states if not exists 
       async function createMyState(item) {
           if (!existsState(item.name)) {
           await createStateAsync(item.name, { 
                   type: item.type,
                   min: 0,
                   def: 0,
                   role: item.role 
               });    
           }
       }
        
       async function makeMyStateList (array) {
           // map array to promises
           const promises = array.map(createMyState);
           await Promise.all(promises);
       }
        
       var mySchedule = '0,30 * * * *';
        
       async function main () {
           await makeMyStateList(createStateList);
           schedule(mySchedule, getSolar );
           getSolar();
       }
        
       main(); 
        
       // set logging = true for logging
       const logging = true;
        
       var request = require('request');
        
        
       /* https://api.forecast.solar/estimate/:lat/:lon/:dec/:az/:kwp
       lat - latitude of location, -90 (south) … 90 (north)
       lon - longitude of location, -180 (west) … 180 (east)
       dec - plane declination, 0 (horizontal) … 90 (vertical)
       az - plane azimuth, -180 … 180 (-180 = north, -90 = east, 0 = south, 90 = west, 180 = north)
       kwp - installed modules power in kilo watt
       */
        
       // set lat and lon for the destination
       const lat = '52.xxxx'
       const lon = '13.yyyy'
        
       const forcastUrl = 'https://api.forecast.solar';
        
       // if use the api key remove '//' and insert '//' in front of const api = '';
       //const api = '/xxxxxxxxxxxxxxxx';
       // else 
      const api = '';
        
       const declination = ['25','25','25'];
       const azimuth = ['-90','0','90'];
       const kwp = ['7.7','6.15','7.7'];
        
       var options1 = {url: forcastUrl+api+'/estimate/'+lat+'/'+lon+'/'+declination[0]+'/'+azimuth[0]+'/'+kwp[0], method: 'GET', headers: { 'User-Agent': 'request' }};
       var options2 = {url: forcastUrl+api+'/estimate/'+lat+'/'+lon+'/'+declination[1]+'/'+azimuth[1]+'/'+kwp[1], method: 'GET', headers: { 'User-Agent': 'request' }};
       var options3 = {url: forcastUrl+api+'/estimate/'+lat+'/'+lon+'/'+declination[2]+'/'+azimuth[2]+'/'+kwp[2], method: 'GET', headers: { 'User-Agent': 'request' }};
      
       const legendTest = ["West","Ost"];
       const graphColor = ["blue","red"];
       const datalabelColor = ["lightblue","lightblue"];
        
       const tooltip_AppendText= " Watt";
        
       var urls = [
         {myUrl:options1,mySolarJSON:SolarJSON1,mySolarJSONAll:SolarJSONAll1,mySolarJSONGraphAll:SolarJSONGraphAll1},
         {myUrl:options2,mySolarJSON:SolarJSON2,mySolarJSONAll:SolarJSONAll2,mySolarJSONGraphAll:SolarJSONGraphAll2},
         {myUrl:options3,mySolarJSON:SolarJSON3,mySolarJSONAll:SolarJSONAll3,mySolarJSONGraphAll:SolarJSONGraphAll3}
       ]
      
       // handle the request : convert the result to table and graph 
       function myAsyncRequest(myUrl) {
         log('Request '+myUrl.myUrl.url);
         return new Promise((resolve, reject) => {
            request(myUrl.myUrl.url, async function(error, response, body) {
               if (!error && response.statusCode == 200) {
                   if (logging) console.log ('body : '+body);
                   let watts = JSON.parse(body).result.watts;
                   setState(myUrl.mySolarJSONAll, JSON.stringify(watts), true);
                   let table = [];
                   for(let time in watts) {
                           let entry = {};
                           entry.Uhrzeit = time;
                           entry.Leistung = watts[time];
                           table.push(entry);
                   }  
                   if (logging) console.log ('JSON: '+myUrl.mySolarJSON);
                   await setStateAsync(myUrl.mySolarJSON, JSON.stringify(table), true);
                   
                   // make GraphTable
                   let graphTimeData = [];
                        for(let time in watts) {
                           let graphEntry ={};
                           graphEntry.t = Date.parse(time);
                           graphEntry.y = watts[time];
                           graphTimeData.push(graphEntry);
                   } 
                   var graph = {};
                   var graphData ={};
                   var graphAllData = [];
                   graphData.data = graphTimeData;
                   graphAllData.push(graphData);
                   graph.graphs=graphAllData;
                   setState(myUrl.mySolarJSONGraphAll, JSON.stringify(graph), true);
        
                   resolve (body);
               } else 
                   reject(new Error("Could not load " + myUrl.myUrl.url+' Error '+error +'Status '+ response.statusCode));
           });  
         })
       }
        
        
       // summarize the single watts results to table and graph 
       function makeTable () {
           if (logging) console.log ('MakeTable');
           let watts1 = JSON.parse(getState(SolarJSON1).val);
           let watts2 = JSON.parse(getState(SolarJSON2).val);
           let watts3 = JSON.parse(getState(SolarJSON3).val); 
           if (logging) console.log ('Items: '+watts1.length);
           let table = [];
       	let axisLabels = [];
       	
           // make table
           for(var n=0;n<watts1.length;n++) {
                   let entry = {};
                   entry.Uhrzeit = watts1[n].Uhrzeit;
                   entry.Leistung1 = watts1[n].Leistung;
                   entry.Leistung2 = watts2[n].Leistung;
                   entry.Leistung3 = watts3[n].Leistung;
                   entry.Summe = watts1[n].Leistung + watts2[n].Leistung + watts3[n].Leistung;
                   table.push(entry);
           } 
       	
           // prepare data for graph
       	let graphTimeData1 = [];
           for(var n=0;n<watts1.length;n++) {
           	graphTimeData1.push(watts1[n].Leistung);
               let time = watts1[n].Uhrzeit.substr(11,5);
               axisLabels.push(time);		
           } 
        
       	let graphTimeData2 = [];
           for(var n=0;n<watts2.length;n++) {
          		graphTimeData2.push(watts2[n].Leistung);	
           } 
        
       	let graphTimeData3 = [];
           for(var n=0;n<watts3.length;n++) {
          		graphTimeData3.push(watts3[n].Leistung);	
           } 
      
           // make total graph
           var graph = {};
           var graphAllData = [];
           var graphData = {"tooltip_AppendText":  tooltip_AppendText,"legendText": legendTest[0],"yAxis_id": 1,"type": "bar","displayOrder": 2,"barIsStacked": true,"color":graphColor[0],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[0],"datalabel_fontSize":10};
          graphData.data = graphTimeData1;
          graphAllData.push(graphData);
      
       	graphData = {"tooltip_AppendText": tooltip_AppendText,"legendText": legendTest[1],"yAxis_id": 1,"type": "bar","displayOrder": 1,"barIsStacked": true,"color":graphColor[1],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[1],"datalabel_fontSize":10};
          graphData.data = graphTimeData2;
      
          graphData = {"tooltip_AppendText": tooltip_AppendText,"legendText": legendTest[2],"yAxis_id": 1,"type": "bar","displayOrder": 1,"barIsStacked": true,"color":graphColor[1],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[2],"datalabel_fontSize":10};
          graphData.data = graphTimeData3;
      
           graphAllData.push(graphData);
           graph.graphs=graphAllData;
       	 graph.axisLabels =  axisLabels;
           setState(SolarJSONTable, JSON.stringify(table), true);
           setState(SolarJSONGraph, JSON.stringify(graph), true);
       }
        
       // get the requests 
       async function getSolar() {
          let promises = urls.map(myAsyncRequest);
          await Promise.all(promises)
           .then(function(bodys) {
               if (logging) console.log("All url loaded");
               makeTable();
           })
           .catch(error => {
               console.log('Error : '+error)
           })  
       }
      
      
      M 1 Reply Last reply Reply Quote 0
      • M
        MartyBr @MartyBr last edited by

        @martybr
        Die Daten des dritten Strings fehlen in dem DP SolarJSINGraph. Ich warte mal bis morgen ab, ob das Script die Daten noch integriert.

        Glasfaser 1 Reply Last reply Reply Quote 0
        • Glasfaser
          Glasfaser @MartyBr last edited by Glasfaser

          @martybr

          Habe schon lange den dritten String , versuche mal hiermit

          //10 Juni 2021 .. Glasfaser Änderung auf 3 Strings
          
          /* read solar forecasts for 2 different orientations
          Author : gargano
          
          Display in VIS : use JSON Chart from Scrounger
          
          Version 1.0.1 
          Last Update 16.3.2021 
          
          Change history :
          1.0.1 / 16.3.2021   :   use setStateAsync(myUrl.mySolarJSON.. to avoid time conflicts 
                                  dp's are now saved in '0_userdata.0.'
                                  use variables for setting lat, lon, color..
          */
          
          const prefix = 'javascript.0.'; 
          
          const SolarJSON1            = prefix+"SolarForecast.JSON1";
          const SolarJSON2            = prefix+"SolarForecast.JSON2";
          const SolarJSON3            = prefix+"SolarForecast.JSON3";
          const SolarJSONAll1         = prefix+"SolarForecast.JSONAll1";
          const SolarJSONAll2         = prefix+"SolarForecast.JSONAll2";
          const SolarJSONAll3         = prefix+"SolarForecast.JSONAll3";
          const SolarJSONGraphAll1    = prefix+"SolarForecast.JSONGraphAll1";
          const SolarJSONGraphAll2    = prefix+"SolarForecast.JSONGraphAll2";
          const SolarJSONGraphAll3    = prefix+"SolarForecast.JSONGraphAll3";
          const SolarJSONTable        = prefix+"SolarForecast.JSONTable";
          const SolarJSONGraph        = prefix+"SolarForecast.JSONGraph";
           
          const createStateList = [
              {name :SolarJSON1, type:"string", role : "value"},
              {name :SolarJSON2, type:"string", role : "value"},
              {name :SolarJSON3, type:"string", role : "value"},
              {name :SolarJSONAll1, type:"string", role : "value"},
              {name :SolarJSONAll2, type:"string", role : "value"},
              {name :SolarJSONAll3, type:"string", role : "value"},
              {name :SolarJSONGraphAll1, type:"string", role : "value"},
              {name :SolarJSONGraphAll2, type:"string", role : "value"},
              {name :SolarJSONGraphAll3, type:"string", role : "value"},
              {name :SolarJSONTable, type:"string", role : "value"},
              {name :SolarJSONGraph, type:"string", role : "value"}
          ]
           
          // create states if not exists 
          async function createMyState(item) {
              if (!existsState(item.name)) {
              await createStateAsync(item.name, { 
                      type: item.type,
                      min: 0,
                      def: 0,
                      role: item.role 
                  });    
              }
          }
          
          async function makeMyStateList (array) {
              // map array to promises
              const promises = array.map(createMyState);
              await Promise.all(promises);
          }
           
          var mySchedule = '3 1 * * *';
           
          async function main () {
              await makeMyStateList(createStateList);
              schedule(mySchedule, getSolar );
              getSolar();
          }
          
          main(); 
          
          // set logging = true for logging
          const logging = true;
          
          var request = require('request');
          
          
          /* https://api.forecast.solar/estimate/:lat/:lon/:dec/:az/:kwp
          lat - latitude of location, -90 (south) … 90 (north)
          lon - longitude of location, -180 (west) … 180 (east)
          dec - plane declination, 0 (horizontal) … 90 (vertical)
          az - plane azimuth, -180 … 180 (-180 = north, -90 = east, 0 = south, 90 = west, 180 = north)
          kwp - installed modules power in kilo watt
          https://api.forecast.solar/estimate/51.38501/6.74986/35/90/2.240'
          */
          
          // set lat and lon for the destination
          const lat = 'xx.xxxxx'
          const lon = 'x.xxxxx'
          
          const forcastUrl = 'https://api.forecast.solar';
          
          // if use the api key remove '//' and insert '//' in front of const api = '';
          //const api = '/xxxxxxxxxxxxxxxx;
          // else 
          const api = '';
          
          const declination = ['30','30','4'];
          const azimuth = ['-90','90','90'];
          const kwp = ['x.xx','x.xx','x.xx'];
          
          var options1 = {url: forcastUrl+api+'/estimate/'+lat+'/'+lon+'/'+declination[0]+'/'+azimuth[0]+'/'+kwp[0], method: 'GET', headers: { 'User-Agent': 'request' }};
          var options2 = {url: forcastUrl+api+'/estimate/'+lat+'/'+lon+'/'+declination[1]+'/'+azimuth[1]+'/'+kwp[1], method: 'GET', headers: { 'User-Agent': 'request' }};
          var options3 = {url: forcastUrl+api+'/estimate/'+lat+'/'+lon+'/'+declination[2]+'/'+azimuth[2]+'/'+kwp[2], method: 'GET', headers: { 'User-Agent': 'request' }};
           
          const legendTest = ["Ost","West","West_Carport"];
          const graphColor = ["red","green","blue"];
          const datalabelColor = ["lightgreen","lightblue","lightred"];
          
          const tooltip_AppendText= " Watt";
           
          var urls = [
            {myUrl:options1,mySolarJSON:SolarJSON1,mySolarJSONAll:SolarJSONAll1,mySolarJSONGraphAll:SolarJSONGraphAll1},
            {myUrl:options2,mySolarJSON:SolarJSON2,mySolarJSONAll:SolarJSONAll2,mySolarJSONGraphAll:SolarJSONGraphAll2},
            {myUrl:options3,mySolarJSON:SolarJSON3,mySolarJSONAll:SolarJSONAll3,mySolarJSONGraphAll:SolarJSONGraphAll3}
          ]
           
          
          // handle the request : convert the result to table and graph 
          function myAsyncRequest(myUrl) {
            log('Request '+myUrl.myUrl.url);
            return new Promise((resolve, reject) => {
               request(myUrl.myUrl.url, async function(error, response, body) {
                  if (!error && response.statusCode == 200) {
                      if (logging) console.log ('body : '+body);
                      let watts = JSON.parse(body).result.watts;
                      setState(myUrl.mySolarJSONAll, JSON.stringify(watts), true);
                      let table = [];
                      for(let time in watts) {
                              let entry = {};
                              entry.Uhrzeit = time;
                              entry.Leistung = watts[time];
                              table.push(entry);
                      }  
                      if (logging) console.log ('JSON: '+myUrl.mySolarJSON);
                      await setStateAsync(myUrl.mySolarJSON, JSON.stringify(table), true);
                      
                      // make GraphTable
                      let graphTimeData = [];
                           for(let time in watts) {
                              let graphEntry ={};
                              graphEntry.t = Date.parse(time);
                              graphEntry.y = watts[time];
                              graphTimeData.push(graphEntry);
                      } 
                      var graph = {};
                      var graphData ={};
                      var graphAllData = [];
                      graphData.data = graphTimeData;
                      graphAllData.push(graphData);
                      graph.graphs=graphAllData;
                      setState(myUrl.mySolarJSONGraphAll, JSON.stringify(graph), true);
           
                      resolve (body);
                  } else 
                      reject(new Error("Could not load " + myUrl.myUrl.url+' Error '+error +'Status '+ response.statusCode));
              });  
            })
          }
           
          
          // summarize the single watts results to table and graph 
          function makeTable () {
              if (logging) console.log ('MakeTable');
              let watts1 = JSON.parse(getState(SolarJSON1).val);
              let watts2 = JSON.parse(getState(SolarJSON2).val); 
              let watts3 = JSON.parse(getState(SolarJSON3).val);
              if (logging) console.log ('Items: '+watts1.length);
              let table = [];
          	let axisLabels = [];
          	
              // make table
              for(var n=0;n<watts1.length;n++) {
                      let entry = {};
                      entry.Uhrzeit = watts1[n].Uhrzeit;
                      entry.Leistung1 = watts1[n].Leistung;
                      entry.Leistung2 = watts2[n].Leistung;
                      entry.Leistung3 = watts3[n].Leistung;
                      entry.Summe = watts1[n].Leistung + watts2[n].Leistung + watts3[n].Leistung;
                      table.push(entry);
              } 
          	
              // prepare data for graph
          	let graphTimeData1 = [];
              for(var n=0;n<watts1.length;n++) {
              	graphTimeData1.push(watts1[n].Leistung);
                  let time = watts1[n].Uhrzeit.substr(11,5);
                  axisLabels.push(time);		
              } 
           
          	let graphTimeData2 = [];
              for(var n=0;n<watts2.length;n++) {
             		graphTimeData2.push(watts2[n].Leistung);	
              } 
          
              let graphTimeData3 = [];
              for(var n=0;n<watts3.length;n++) {
             		graphTimeData3.push(watts3[n].Leistung);	
              } 
              
          
          
              // make total graph
              var graph = {};
              var graphAllData = [];
              var graphData = {"tooltip_AppendText":  tooltip_AppendText,"legendText": legendTest[0],"yAxis_id": 1,"type": "bar","displayOrder": 1,"barIsStacked": true,"color":graphColor[0],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[0],"datalabel_fontSize":10};
              graphData.data = graphTimeData1;
              graphAllData.push(graphData);
          	graphData = {"tooltip_AppendText": tooltip_AppendText,"legendText": legendTest[1],"yAxis_id": 1,"type": "bar","displayOrder": 3,"barIsStacked": true,"color":graphColor[1],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[1],"datalabel_fontSize":10};
              graphData.data = graphTimeData2;
              graphAllData.push(graphData);
              graphData = {"tooltip_AppendText": tooltip_AppendText,"legendText": legendTest[2],"yAxis_id": 1,"type": "bar","displayOrder": 2,"barIsStacked": true,"color":graphColor[2],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[2],"datalabel_fontSize":10};
              graphData.data = graphTimeData3;
              graphAllData.push(graphData);
              graph.graphs=graphAllData;
          	graph.axisLabels =  axisLabels;
              setState(SolarJSONTable, JSON.stringify(table), true);
              setState(SolarJSONGraph, JSON.stringify(graph), true);
          }
           
          // get the requests 
          async function getSolar() {
             let promises = urls.map(myAsyncRequest);
             await Promise.all(promises)
              .then(function(bodys) {
                  if (logging) console.log("All url loaded");
                  makeTable();
              })
              .catch(error => {
                  console.log('Error : '+error)
              })  
          }
          


          5416e8ff-f88e-499b-8910-0819ece34d93-grafik.png

          M 1 Reply Last reply Reply Quote 1
          • M
            MartyBr @Glasfaser last edited by

            @glasfaser
            Super, klappt. Alle Strings in dem JSON! Ganz herzlichen Dank.

            1 Reply Last reply Reply Quote 0
            • T
              Tigger66 last edited by

              Ein Hallo in die Runde
              und eine Frage an die Nutzer dieses Adapters. Ich hab das Problem, das ich bei den Einstellungen in den Instanzen, eigentlich keine Einstellmöglichkeit habe. Bei mir erscheint: "This adapter version has no support for "Admin 4" configuration. Please switch to "Admin 5" UI or downgrade to an older version (see changelog for details). "
              Ich habe aber die Admin Version 5.3.8 installiert. Hat jemand eine Idee woran dass liegen kann? Danke für Eure Unterstützung...

              Glasfaser 1 Reply Last reply Reply Quote 0
              • Glasfaser
                Glasfaser @Tigger66 last edited by

                @tigger66 sagte in Forecast.solar mit dem Systeminfo Adapter:

                an die Nutzer dieses Adapters.

                ... das wäre dann hier ...

                https://forum.iobroker.net/topic/45315/test-pv-forecast-adapter

                1 Reply Last reply Reply Quote 0
                • T
                  Tigger66 last edited by

                  ...da habe ich wohl nicht richtig gelesen...danke für den Hinweis...

                  1 Reply Last reply Reply Quote 0
                  • chriz77
                    chriz77 last edited by

                    Hallo,
                    wäre es möglich, die "Adjust forecast" von Forecast.solar einzubauen? Hat jemand damit Erfahrung? Werden die Prognosen damit besser?
                    Viele Grüße
                    Chris

                    Edde 1 Reply Last reply Reply Quote 0
                    • Edde
                      Edde @chriz77 last edited by

                      Hallo zusammen.

                      Ich wüsste gerne wie Ihr die Vorhersage für eine 2 String Anlage wählen würdet.

                      Ich habe 24 PV Module Richtung osten und weitere 14 Richtung Westen. Alle zusammen liefern etwa 16kw Peak mit einem 11kw Wechselrichter.

                      Wie müsste ich nun meine Api erstellen bzw. Mit welchem Azimuth? Die zwei String Auflösung findet dann erst im Adapter statt? Ich mochte natürlich eine theoretische Gesamtprognose für die gesamte Anlage über den Tag verteilt bekommen.

                      Screenshot_20240312-045834.png Screenshot_20240312-045853.png Screenshot_20240312-045958~2.png

                      1 Reply Last reply Reply Quote 0
                      • JB_Sullivan
                        JB_Sullivan last edited by

                        @Gargano

                        Da du der Ersteller des Java Skriptes bist eine Frage:

                        Ich habe aktuell den JavaSkript Adapter auf 8.7.5 aktualisiert.

                        Als Meldung bekomme ich seit dem für dein Forecast Skript die folgende Meldung. Gibt es schon eine neuere Version die auf httpGet oder axios aufsetzt?

                        
                        javascript.0
                        8144	2024-07-28 13:17:45.887	warn	script.js.Solar.SolarForcast: request package is deprecated - please use httpGet (or a stable lib like axios) instead!
                        
                        Gargano 1 Reply Last reply Reply Quote 0
                        • Gargano
                          Gargano @JB_Sullivan last edited by Gargano

                          @jb_sullivan Hier der Code mit axios:
                          getSolar() ist die eigentliche Funktion.

                          Es gibt auch einen Adapter, der aus dem Script hervorging
                          hier der Adapter

                          // Test mit VS Code Extension
                          
                          /* read solar forecasts for 3 different orientations
                          Author : gargano
                          
                          Display in VIS : use JSON Chart from Scrounger
                          
                          Version 1.1.0 
                          Last Update 13.3.2022 
                          
                          Change history :
                          use axios
                          */
                          
                          const prefix = '0_userdata.0.'; 
                          
                          const idSolarJSON1        = prefix+"SolarForecast3.SuedOst.JSON";
                          const idSolarJSON2        = prefix+"SolarForecast3.Dach.JSON";
                          const idSolarJSON3        = prefix+"SolarForecast3.SuedWest.JSON";
                          const idSolarToday1       = prefix+"SolarForecast3.SuedOst.Today";
                          const idSolarToday2       = prefix+"SolarForecast3.Dach.Today";
                          const idSolarToday3       = prefix+"SolarForecast3.SuedWest.Today";
                          const idSolarTomorrow1    = prefix+"SolarForecast3.SuedOst.Tomorrow";
                          const idSolarTomorrow2    = prefix+"SolarForecast3.Dach.Tomorrow";
                          const idSolarPanelTomorrow= prefix+"SolarForecast3.Solar.Tomorrow";
                          const idSolarPanelToDay   = prefix+"SolarForecast3.Solar.ToDay";
                          const idSolarTomorrow3    = prefix+"SolarForecast3.SuedWest.Tomorrow";
                          const idSolarJSONTable    = prefix+"SolarForecast3.JSONTable";
                          const idSolarJSONGraph    = prefix+"SolarForecast3.JSONGraph";
                          const idSolarDachJSONGraph    = prefix+"SolarForecast3.Dach.JSONGraph";
                          
                          const createStateList = [
                              {name :idSolarJSON1, type:"string", role : "value"},
                              {name :idSolarJSON2, type:"string", role : "value"},
                              {name :idSolarJSON3, type:"string", role : "value"},
                              {name :idSolarToday1, type:"number", role : "value"},
                              {name :idSolarToday2, type:"number", role : "value"},
                              {name :idSolarToday3, type:"number", role : "value"},
                              {name :idSolarTomorrow1, type:"number", role : "value"},
                              {name :idSolarTomorrow2, type:"number", role : "value"},
                              {name :idSolarTomorrow3, type:"number", role : "value"},
                              {name :idSolarPanelTomorrow, type:"number", role : "value"},
                              {name :idSolarPanelToDay, type:"number", role : "value"},
                              {name :idSolarJSONTable, type:"string", role : "value"},
                              {name :idSolarJSONGraph, type:"string", role : "value"},
                              {name :idSolarDachJSONGraph, type:"string", role : "value"}
                          ]
                          
                          // create states if not exists 
                          async function createMyState(item) {
                              if (!existsState(item.name)) {
                                  await createStateAsync(item.name, { 
                                      type: item.type,
                                      min: 0,
                                      def: 0,
                                      role: item.role 
                                  });    
                              }
                          }
                          
                          async function makeMyStateList (array) {
                              // map array to promises
                              const promises = array.map(createMyState);
                              await Promise.all(promises);
                          }
                          
                          async function main () {
                              await makeMyStateList(createStateList);
                              schedule(mySchedule, getSolar );
                              getSolar();
                          }
                          
                          main();
                          
                          
                          // define axios and url
                          const axios = require('axios');
                          
                          /* https://api.forecast.solar/estimate/:lat/:lon/:dec/:az/:kwp
                          lat - latitude of location, -90 (south) … 90 (north)
                          lon - longitude of location, -180 (west) … 180 (east)
                          dec - plane declination, 0 (horizontal) … 90 (vertical)
                          az - plane azimuth, -180 … 180 (-180 = north, -90 = east, 0 = south, 90 = west, 180 = north)
                          kwp - installed modules power in kilo watt
                          */
                          
                          // set lat and lon for the destination
                          const lat = myLat;      // defined in global
                          const long = myLon;     // defined in global
                          const url = 'https://api.forecast.solar/estimate/';
                          
                          // Fenster Wohnzimmer
                          var url1 = url+lat+'/'+long+'/90/-30/1';
                          // Dach
                          var url2 = url+lat+'/'+long+'/35/60/6.2';
                          // Fenster Küche / Schlafzimmer
                          var url3 = url+lat+'/'+long+'/90/60/1';
                          
                          const legendTest = ["Wohn","Dach","Küche"];
                          const graphColor = ["red","green","yellow"];
                          const datalabelColor = ["lightgreen","lightblue","lightblue"];
                          
                          const tooltipAppendText= " kWh";
                          
                          
                          var solarJson1;
                          var solarJson2;
                          var solarJson3;
                          var solarJsons = [solarJson1,solarJson2,solarJson3];
                          
                          const idSolarJSONS = [idSolarJSON1,idSolarJSON2,idSolarJSON3]
                          const idSolarToDayS = [idSolarToday1,idSolarToday2,idSolarToday3]
                          const idSolarTomorrowS = [idSolarTomorrow1,idSolarTomorrow2,idSolarTomorrow3]
                          
                          const logging = true;
                          
                          const mySchedule ='{"time":{"start":"03:00","end":"23:00","mode":"hours","interval":1},"period":{"days":1}}'
                          
                          // handle the request : convert the result to table and graph 
                          async function makeResponse (thisResponse,thisIDSolarJSON,idx,thisIDSolarToDay,thisIDSolarTomorrow) {
                              // handle success
                              var datetoday = new Date();
                              var datetomorrow = new Date(datetoday.getTime()+(1000 * 60 * 60 * 24 * 1)); // übermorgen wäre dann am Ende eine 2 anstatt 1
                          
                              let today = formatDate(datetoday, 'YYYY-MM-DD');
                              let tomorrow = formatDate(datetomorrow, 'YYYY-MM-DD');
                              var watts = thisResponse.data.result.watts; 
                              if (logging) log ('Watts '+JSON.stringify(watts)); 
                              let table = [];
                              for(let time in watts) {
                                      let entry = {};
                                      entry.Uhrzeit = time;
                                      entry.Leistung = watts[time];
                                      table.push(entry);
                              }  
                              let kWhToDay = thisResponse.data.result.watt_hours_day[today]/1000;
                              let kWhTomorrow = thisResponse.data.result.watt_hours_day[tomorrow]/1000;
                              solarJsons[idx] = JSON.stringify(table); 
                              await setStateAsync(thisIDSolarJSON, JSON.stringify(table), true);  
                              await setStateAsync(thisIDSolarToDay, kWhToDay, true); 
                              await setStateAsync(thisIDSolarTomorrow, kWhTomorrow, true);
                          }
                          
                          // summarize the single watts results to table and graph 
                          async function makeTable () {
                              if (logging) log ('MakeTable');
                              
                              let watts1 = JSON.parse(solarJsons[0]);
                              let watts2 = JSON.parse(solarJsons[1]); 
                              let watts3 = JSON.parse(solarJsons[2]); 
                              if (logging) log ('Items: '+watts1.length);
                              let table = [];
                              let axisLabels = [];
                              
                              // make table
                              for(var n=0;n<watts1.length;n++) {
                                      let entry = {};
                                      entry.Uhrzeit = watts1[n].Uhrzeit;
                                      entry.Leistung1 = watts1[n].Leistung;
                                      entry.Leistung2 = watts2[n].Leistung;
                                      entry.Leistung3 = watts3[n].Leistung;
                                      entry.Summe = watts1[n].Leistung + watts2[n].Leistung+ watts3[n].Leistung;
                                      table.push(entry);
                              } 
                          
                              // prepare data for graph
                              let graphTimeData1 = [];
                              for(var n=0;n<watts1.length;n++) {
                              	graphTimeData1.push(watts1[n].Leistung);
                                  let time = watts1[n].Uhrzeit.substr(11,5);
                                  axisLabels.push(time);		
                              } 
                           
                          	let graphTimeData2 = [];
                              for(var n=0;n<watts2.length;n++) {
                             		graphTimeData2.push(watts2[n].Leistung);	
                              } 
                          
                              let graphTimeData3 = [];
                              for(var n=0;n<watts3.length;n++) {
                             		graphTimeData3.push(watts3[n].Leistung);	
                              } 
                          
                              // make total graph
                              var graph = {};
                              var graphAllData = [];
                              var graphData = {"tooltip_AppendText":tooltipAppendText,"legendText": legendTest[0],"yAxis_id": 1,"type": "bar","displayOrder": 1,"barIsStacked": true,"color":graphColor[0],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[0],"datalabel_fontSize":10};
                              graphData.data = graphTimeData1;
                              graphAllData.push(graphData);
                          	graphData = {"tooltip_AppendText": tooltipAppendText,"legendText": legendTest[1],"yAxis_id": 1,"type": "bar","displayOrder": 2,"barIsStacked": true,"color":graphColor[1],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[1],"datalabel_fontSize":10};
                              graphData.data = graphTimeData2;
                              graphAllData.push(graphData);
                              graphData = {"tooltip_AppendText": tooltipAppendText,"legendText": legendTest[2],"yAxis_id": 1,"type": "bar","displayOrder": 3,"barIsStacked": true,"color":graphColor[2],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[2],"datalabel_fontSize":10};
                              graphData.data = graphTimeData3;
                              graphAllData.push(graphData);
                              graph.graphs=graphAllData;
                          	graph.axisLabels =  axisLabels;
                              setState(idSolarJSONTable, JSON.stringify(table), true);
                              setState(idSolarJSONGraph, JSON.stringify(graph), true);
                          
                               // make Dach graph
                              var graph = {};
                              var graphAllData = [];
                              var graphData = {"tooltip_AppendText":tooltipAppendText,"legendText": legendTest[1],"yAxis_id": 1,"type": "bar","displayOrder": 1,"barIsStacked": true,"color":graphColor[0],"barStackId":1,"datalabel_rotation":-90,"datalabel_color":datalabelColor[0],"datalabel_fontSize":10};
                              graphData.data = graphTimeData2;
                              graphAllData.push(graphData);
                              graph.graphs=graphAllData;
                          	graph.axisLabels =  axisLabels;
                              setState(idSolarDachJSONGraph, JSON.stringify(graph), true);
                          }
                          
                          
                          async function getSolar() {
                              const request1 = axios.get(url1);
                              const request2 = axios.get(url2);
                              const request3 = axios.get(url3);
                              let requests = [request1,request2,request3];
                              await axios
                                  .all(requests)
                                  .then (axios.spread(async (...responses) =>  {
                                      // use/access the results 
                                      for (var n=0;n<responses.length;n++) {
                                          if (logging) console.log(responses[n].data);
                                          await makeResponse (responses[n],idSolarJSONS[n],n,idSolarToDayS[n],idSolarTomorrowS[n]);      
                                      }
                                      if (logging) console.log("All url loaded");
                                      await makeTable();
                                      let vDachToDay = parseFloat(((await getStateAsync(idSolarToday2)).val).toFixed(2));
                                      setState(idSolarPanelToDay,vDachToDay);
                                      let vDachTomorrow = parseFloat(((await getStateAsync(idSolarTomorrow2)).val).toFixed(2));
                                      setState(idSolarPanelTomorrow,vDachTomorrow);
                                  }))
                                  .catch(errors => {
                                      // react on errors.
                                      console.log(errors)
                                  })
                          }
                          
                          
                          1 Reply Last reply Reply Quote 0
                          • First post
                            Last post

                          Support us

                          ioBroker
                          Community Adapters
                          Donate
                          FAQ Cloud / IOT
                          HowTo: Node.js-Update
                          HowTo: Backup/Restore
                          Downloads
                          BLOG

                          556
                          Online

                          31.9k
                          Users

                          80.3k
                          Topics

                          1.3m
                          Posts

                          json solar systeminfo
                          15
                          188
                          20576
                          Loading More Posts
                          • Oldest to Newest
                          • Newest to Oldest
                          • Most Votes
                          Reply
                          • Reply as topic
                          Log in to reply
                          Community
                          Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                          The ioBroker Community 2014-2023
                          logo