Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. ioBroker Allgemein
    4. Corona-Ampel Österreich in VIS anzeigen

    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

    Corona-Ampel Österreich in VIS anzeigen

    This topic has been deleted. Only users with topic management privileges can see it.
    • liv-in-sky
      liv-in-sky @bergjet last edited by

      @bergjet was gehen sollte:

      besorge dir die emojis als bilder, roter,grüner kreis ...

      kopiere die bilder in deine vis mit upload über setup-Dateimanager

      ändere im script: pfad zum bild

      Image 9.png

      ändere im invento json widget

      Image 10.png

      dann werden bilder angezeigt - keine emojis

      1 Reply Last reply Reply Quote 0
      • bergjet
        bergjet @liv-in-sky last edited by

        @liv-in-sky sagte in Corona-Ampel Österreich in VIS anzeigen:

        du nutzt das invento json widget für die anzeige?

        Die json Tabelle von den ioBroker.vis-materialdesign.

        liv-in-sky 2 Replies Last reply Reply Quote 0
        • liv-in-sky
          liv-in-sky @bergjet last edited by liv-in-sky

          @bergjet

          dann evtl im script damit arbeiten:

          "<img src="+"/pfad/pfad"+" height=\"80\" width=\"80\">"
          

          nicht getestet:

          Image 11.png

          1 Reply Last reply Reply Quote 0
          • liv-in-sky
            liv-in-sky @bergjet last edited by

            @bergjet zur auswahl habe ich nur die - evtl eigene machen ?


            orange.png grün.png gelb.png rot.png

            bergjet sigi234 2 Replies Last reply Reply Quote 0
            • bergjet
              bergjet @liv-in-sky last edited by bergjet

              @liv-in-sky Danke, jetzt geht es mit der Skript-Änderung auf Image Dateien. Habe die invento Tabelle nun genommen.
              Bildschirmfoto 2020-10-18 um 18.40.47.png

              orange.png grün.png rot.png gelb.png

              1 Reply Last reply Reply Quote 0
              • sigi234
                sigi234 Forum Testing Most Active @liv-in-sky last edited by sigi234

                @liv-in-sky

                Haben die wieder was geändert, es werden nur mehr Warn 3 angezeigt?

                Screenshot (864)_LI.jpg

                var zusatzRegionen=["1","2","3","4","5","6","7","8","9","410"]
                
                liv-in-sky 1 Reply Last reply Reply Quote 0
                • liv-in-sky
                  liv-in-sky @sigi234 last edited by

                  @sigi234

                  hast du mal die seiten von denen gecheckt (sind im script ganz oben)

                  was steht da drin für deine regionen

                  sigi234 1 Reply Last reply Reply Quote 0
                  • sigi234
                    sigi234 Forum Testing Most Active @liv-in-sky last edited by

                    @liv-in-sky sagte in Corona-Ampel Österreich in VIS anzeigen:

                    @sigi234

                    hast du mal die seiten von denen gecheckt (sind im script ganz oben)

                    was steht da drin für deine regionen

                    {
                            "Region": "Bundesland",
                            "GKZ": "1",
                            "Name": "Burgenland",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "2",
                            "Name": "Kärnten",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "3",
                            "Name": "Niederösterreich",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "4",
                            "Name": "Oberösterreich",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "5",
                            "Name": "Salzburg",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "6",
                            "Name": "Steiermark",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "7",
                            "Name": "Tirol",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "8",
                            "Name": "Vorarlberg",
                            "Warnstufe": "1"
                          },
                          {
                            "Region": "Bundesland",
                            "GKZ": "9",
                            "Name": "Wien",
                            "Warnstufe": "2"
                          },
                          {
                            "Region": "Staat",
                            "GKZ": "0",
                            "Name": null,
                            "Warnstufe": "1"
                          }
                    
                    sigi234 1 Reply Last reply Reply Quote 0
                    • sigi234
                      sigi234 Forum Testing Most Active @sigi234 last edited by sigi234

                      @sigi234 sagte in Corona-Ampel Österreich in VIS anzeigen:

                      was steht da drin für deine regionen

                      Da geht es um die Zusatzregionen, hat vorher funktioniert, jetzt werden nur mehr 2 Regionen angezeigt obwohl mehr eingetragen sind. ( 9 und 410 gehen )

                      var zusatzRegionen=["1","2","3","4","5","6","7","8","9","410"]
                      

                      ALT

                      1601980922731-screenshot-772-_li.jpg

                      NEU

                      1603041740459-screenshot-864-_li.jpg

                      F 1 Reply Last reply Reply Quote 0
                      • F
                        fastfoot @sigi234 last edited by

                        @sigi234 Das liegt daran, dass im neuesten Datensatz(15.10.) nur Wien gelistet ist als Bundesland

                        sigi234 liv-in-sky 2 Replies Last reply Reply Quote 1
                        • sigi234
                          sigi234 Forum Testing Most Active @fastfoot last edited by sigi234

                          @fastfoot sagte in Corona-Ampel Österreich in VIS anzeigen:

                          nur Wien gelistet ist als Bundesland

                          Typisch Österreich.😠

                          Habe es angepasst:

                          Screenshot (867).png

                          F 1 Reply Last reply Reply Quote 0
                          • liv-in-sky
                            liv-in-sky @fastfoot last edited by

                            danke @fastfoot

                            kann ich bestätigen - die fehlen darin

                            1 Reply Last reply Reply Quote 0
                            • F
                              fastfoot @sigi234 last edited by

                              @sigi234 sagte in Corona-Ampel Österreich in VIS anzeigen:

                              Typisch Österreich.
                              Habe es angepasst:

                              Ich wollte mal etwas mit jsonata rumspielen, das schien mir sehr geeignet um das Problem mit fehlenden neueren Daten zu lösen. Mit jsonata filtere ich die Regionen und nehme vom Ergebnis den ersten(neuesten) Datensatz. Somit ist jetzt auch Vorarlberg wieder auf der Liste. Der Code ist einfach so reingesaut, war mir zuviel Arbeit das aufzuhübschen, am Gesamtergebnis ändert sich aber nichts außer die json-Tabelle. Wers brauchen kann 🙂
                              AmpelAT.PNG

                              //18.10.2020 20:35
                              const url2 = 'https://corona-ampel.gv.at/sites/corona-ampel.gv.at/files/assets/Warnstufen_Corona_Ampel_aktuell.json';
                              const url = 'https://corona-ampel.gv.at/sites/corona-ampel.gv.at/files/assets/Warnstufen_Corona_Ampel_Gemeinden_aktuell.json';
                              var warnstufe=0;
                              var htmlwidget ='';
                              var arrStand="";
                              var sucheGKZ="320"
                              var zusatzRegionen=["1","2","3","4","5","6","7","8","9","410"]
                              
                              var farbwertLevel1 = '#04B404'
                              var farbwertLevel2 = '#FFFF00'
                              var farbwertLevel3 = '#FF8000'
                              var farbwertLevel4 = '#DF0101'
                              var warngebiet = ''
                              var warnregion="";
                              var anzahl=0;
                              var gkz=""
                              var directory = 'Coronaampel' //javascript.0.xxx
                              var tableContent = ''
                              var dpSort;
                              
                              createState(directory  + '.warnstufe', {
                                name: 'Corona Warnstufe',
                                read: true, 
                                write: false, 
                                type: "number", 
                                def: 0
                              });
                              createState(directory  + '.anzahl', {
                                name: 'Corona Anzahl',
                                read: true, 
                                write: false, 
                                type: "number", 
                                def: 0
                              });
                              createState(directory  + '.Sortierung', {
                                name: 'Corona Sortierung',
                                read: true, 
                                write: true, 
                                type: "number", 
                                def: 1
                              });
                              createState(directory  + '.Refresh', {
                                name: 'Corona Refresh',
                                read: true, 
                                write: true, 
                                type: "boolean", 
                                def: false
                              });
                              
                              createState(directory  + '.warngebiet', {
                                name: 'Corona Warngebiet',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              
                              createState(directory  + '.warnfarbe', {
                                name: 'Corona Warnfarbe',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              createState(directory  + '.geholt', {
                                name: 'Corona Datum',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              
                              createState(directory  + '.GKZ', {
                                name: 'Corona GKZ',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              
                              createState(directory  + '.warnregion', {
                                name: 'Corona Region',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              
                              createState(directory  + '.stand', {
                                name: 'Corona stand',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              
                              createState(directory  + '.warntabelle', {
                                name: 'Corona Tabelle',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              
                              
                              createState(directory  + '.jsonTable', {
                                name: 'Corona jsonTabelle',
                                read: true, 
                                write: false, 
                                type: "string", 
                                def: ""
                              });
                              var myObj=[];
                              
                              schedule(' 14 */4 * * *', function() { 
                                 main()
                              });
                              
                              setTimeout(function(){main()},100);
                              
                              
                              
                              function main() {   
                                 dpSort=getState(directory+'.Sortierung').val
                                myObj=[];
                                warnstufe = 0;
                                tableContent = ''
                                request(url, function(err, response, json) {
                              
                                     //let arr = (JSON.parse(json)[0]).Warnstufen;
                                     arrStand = (JSON.parse(json)[0]).Stand;
                                     let newarr=JSON.parse(json);
                                   request(url2, function(err, response, json) {
                              
                                    //let arr2 = (JSON.parse(json)[0]).Warnstufen;
                                    let newarr2 = JSON.parse(json);
                                    //arr= arr.concat(arr2)
                                     newarr = newarr.concat(newarr2);
                                     zusatzRegionen.forEach((Region,i) =>{
                                         let expr = `
                                             $.Stand@$S.Warnstufen[GKZ="${Region}"].{
                                             "Stand": $S,
                                             "Region":Region,
                                             "GKZ": GKZ,
                                             "Name":Name,
                                             "Warnstufe":Warnstufe
                                             }[0]`
                                         let res = jsonataExpression(newarr, expr);
                                         if(res) myObj.push(res);
                                     })
                                     /*for(var z = 0; z < zusatzRegionen.length; z++) {    
                                         for(let i = 0; i < arr.length; i++) { 
                                         if(arr[i].GKZ == zusatzRegionen[z]){
                                             myObj.push(arr[i])
                                             break;
                                             }
                                     }
                                     }*/
                                         let expr = `
                                             $.Stand@$S.Warnstufen[GKZ="${sucheGKZ}"].{
                                             "Stand": $S,
                                             "Region":Region,
                                             "GKZ": GKZ,
                                             "Name":Name,
                                             "Warnstufe":Warnstufe
                                             }[0]`
                                         let res = jsonataExpression(newarr, expr);
                                         warnstufe = Number(res.Warnstufe);
                                         gkz=sucheGKZ
                                         warnregion=res.Region
                                         warngebiet = res.Name 
                                 /*for(let i = 0; i < arr.length; i++) { 
                                       if(arr[i].GKZ == sucheGKZ){
                                         //log(' Warnstufe für ' + suchwertBezirk + ': ' + arr[i].Warnstufe)
                                         warnstufe = Number(arr[i].Warnstufe);
                                         gkz=sucheGKZ
                                         warnregion=arr[i].Region
                                         warngebiet = arr[i].Name 
                                        break;}}*/
                                     let arr = newarr;
                                    anzahl=arr.length
                                    for(let i = 0; i < arr.length; i++) { 
                                        fillTable(arr[i].Region,arr[i].Name,arr[i].Warnstufe,arr[i].GKZ)
                                    }
                                    finishTable()
                                saveData()
                              
                                });
                                });
                              
                              }
                              
                              function fillTable(gebiet,name,warnstufe,gkz){
                                if (tableContent == ''){
                                  tableContent = '<table ><tbody>'  
                                }
                                tableContent += '<tr><td>' + gebiet + '</td>'
                                tableContent += '<td>' + gkz + '</td>'
                                tableContent += '<td>' + name + '</td>'
                                tableContent += '<td>' + warnstufe + '</td>'
                                tableContent += '</tr>';
                              }
                              
                              function finishTable(){
                              
                                tableContent += '</tbody></table>'
                                setState(directory+'.warntabelle',tableContent)
                              }
                              
                              function saveData(){
                                  sotiereJson(dpSort)    
                                        
                              
                                jsonWarn()
                                 setState(directory+'.jsonTable',JSON.stringify(myObj))
                              
                                setState(directory+'.Refresh',false)
                                setState(directory+'.anzahl',anzahl)
                              //  setState(directory+'.searchbyGKZ',suchGKZactivieren)
                                setState(directory+'.warnstufe',warnstufe)
                                setState(directory+'.warngebiet',warngebiet)
                                setState(directory+'.GKZ',gkz)
                                setState(directory+'.warnregion',warnregion)
                                setState(directory+'.geholt',formatDate(getDateObject((new Date().getTime())), "hh:mm"))
                                setState(directory+'.stand',   formatDate(getDateObject(arrStand.toString()), "TT:MM:JJJJ -  SS:mm"));
                                switch (warnstufe) {
                                            case 1: 
                                                            setState(directory+'.warnfarbe',farbwertLevel1)
                                                            break;
                                            case 2: 
                                                             setState(directory+'.warnfarbe',farbwertLevel2)
                                                            break;
                                            case 3: 
                                                            setState(directory+'.warnfarbe',farbwertLevel3)
                                                            break;
                                            case 4   : 
                                                            setState(directory+'.warnfarbe',farbwertLevel4)
                                                            break;
                                            default: setState(directory+'.warnfarbe',"");
                                            ;
                                        }
                              }
                              
                              function jsonWarn(){
                              
                                 for(let i = 0; i < myObj.length; i++) { 
                                   var istWarnstufe=Number(myObj[i].Warnstufe)
                                    switch (istWarnstufe) {
                                            case 1: 
                                                            myObj[i].Warnstufe="🟢"
                                                            break;
                                            case 2: 
                                                            myObj[i].Warnstufe="🟡"
                                                            break;
                                            case 3: 
                                                            myObj[i].Warnstufe="🟠"
                                                            break;
                                            case 4   : 
                                                            myObj[i].Warnstufe="🔴"
                                                            break;
                                            default: myObj[i].Warnstufe="?";
                                            ;
                                        }
                                      }
                                      }
                                      
                              
                              function sotiereJson(mySort) {
                                // log(mySort.toString())
                              switch (mySort) {
                                            case 1: 
                                                             myObj.sort(function (alpha, beta) {
                                                                  if (alpha.Region > beta.Region )
                                         
                                                                  return 1;
                                                                  if (beta.Region > alpha.Region)
                                                                  return -1;
                                                                  return 0;
                                                               }); 
                                                            break;
                                            case 2: 
                                                            myObj.sort(function (alpha, beta) {
                                                                 if (Number(alpha.GKZ) > Number(beta.GKZ) )
                                                                 return 1;
                                                                if (Number(beta.GKZ) > Number(alpha.GKZ)  )
                                                                return -1;
                                                                return 0;
                                                                    }); 
                                                            break;
                                            case 3: 
                                                          myObj.sort(function (alpha, beta) {
                                                                 if (alpha.Name > beta.Name )
                                         
                                                                 return 1;
                                                                if (beta.Name > alpha.Name)
                                                                return -1;
                                                                return 0;
                                        });
                                                            break;
                                            case 4   : 
                                                            myObj.sort(function(a, b){
                                                            return b.Warnstufe - a.Warnstufe;
                                                            });
                                                            break;
                                            default:        myObj.sort(function(a, b){
                                                            return b.Warnstufe - a.Warnstufe;
                                                            });
                                            ;
                                        }
                              
                              
                              
                              }
                              
                              on({id: 'javascript.'+instance+'.'+directory  + '.Sortierung', change: "any"}, function (obj) { 
                                
                                 main()
                              
                              });
                              on({id: 'javascript.'+instance+'.'+directory  + '.Refresh', val: true}, function (obj) { 
                                
                                 main()
                                 
                              
                              });
                              
                              

                              1 Reply Last reply Reply Quote 1
                              • G
                                G4l4h4d @sigi234 last edited by

                                Hallo Leute,
                                gibt es mittlerweile auch eine Deutschland Ampel?

                                F 1 Reply Last reply Reply Quote 0
                                • F
                                  fastfoot @G4l4h4d last edited by

                                  @G4l4h4d sagte in Corona-Ampel Österreich in VIS anzeigen:

                                  Hallo Leute,
                                  gibt es mittlerweile auch eine Deutschland Ampel?

                                  meines Wissens gibt es so etwas nicht, vielleicht interessiert dich aber folgende Lösung

                                  G 1 Reply Last reply Reply Quote 1
                                  • G
                                    G4l4h4d @fastfoot last edited by

                                    @fastfoot Danke das schaue ich mir sehr gerne an.

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

                                      An die Spezialisten.
                                      Es gibt eine neue Datei, in der die 7 Tage Inzidenz enthalten ist.
                                      https://covid19-dashboard.ages.at/data/CovidFaelle_Timeline_GKZ.csv

                                      Diese wäre bei der Auswertung auch sehr interessant.

                                      F 1 Reply Last reply Reply Quote 0
                                      • F
                                        fastfoot @bergjet last edited by

                                        @bergjet sagte in Corona-Ampel Österreich in VIS anzeigen:

                                        An die Spezialisten.
                                        Es gibt eine neue Datei, in der die 7 Tage Inzidenz enthalten ist.
                                        https://covid19-dashboard.ages.at/data/CovidFaelle_Timeline_GKZ.csv

                                        Diese wäre bei der Auswertung auch sehr interessant.

                                        Ich hätte das hier, ist noch nicht ganz fertig und kann auch nur eine GKZ
                                        AT.PNG

                                        bergjet 1 Reply Last reply Reply Quote 0
                                        • bergjet
                                          bergjet @fastfoot last edited by

                                          @fastfoot sagte in Corona-Ampel Österreich in VIS anzeigen:

                                          Ich hätte das hier, ist noch nicht ganz fertig und kann auch nur eine GKZ

                                          Na das wäre ja was. Bei dem Script müsste ich ja gar nichts ändern, ist doch meine GKZ schon eingetragen.
                                          Wärst du so nett, mir das zukommen zu lassen und auch noch dazu erklären was zu machen ist, damit das auch bei mir funktioniert?

                                          F 1 Reply Last reply Reply Quote 0
                                          • F
                                            fastfoot @bergjet last edited by

                                            @bergjet sagte in Corona-Ampel Österreich in VIS anzeigen:

                                            Na das wäre ja was. Bei dem Script müsste ich ja gar nichts ändern, ist doch meine GKZ schon eingetragen.
                                            Wärst du so nett, mir das zukommen zu lassen und auch noch dazu erklären was zu machen ist, damit das auch bei mir funktioniert?

                                            Du musst dazu

                                            • axios in der JS-Instanz eintragen
                                            • csvjson in der JS-Instanz eintragen
                                            • für die JSON Tabelle(unten rechts) musst du den inventwo Widget Adapter installieren
                                            • für die Charts musst du den Material-Design-Widgets Adapter installieren
                                            • die Datenpunkte werden automatisch erstellt, sollte der Ort (variable idBase) geändert werden, muss dies natürlich auch in der View geändert werden
                                            • Im Skript oben unter Persönliche Einstellungen kannst du eine andere GKZ und die tgl. Updatezeit einstellen

                                            bei Fragen, fragen...

                                            /**
                                            * Zweck:           Covid-19 Fälle Österreich
                                            * Datum:           05.01.2021
                                            * Author:          @fastfoot
                                            * Forum:           https://forum.iobroker.net/topic/36632/corona-ampel-%C3%B6sterreich-in-vis-anzeigen/160
                                            * 
                                            * Voraussetzung:   Die npm-Module axios und csvjson müssen in der JS-Instanz eingetragen werden
                                            * 
                                            */
                                            
                                            /**
                                            *                                      Persönliche Einstellungen
                                            */
                                            const dbg = false;                                      // für Fehlersuche
                                            const fileName = 'CovidFaelle_Timeline_GKZ.csv';        // Dateiname
                                            const filePath = '/opt/iobroker/iobroker-data/files';   // Dateipfad
                                            const myGKZ = '320';                                    // anzuzeigende GKZ
                                            const mySchedule = '30 14 * * *';                       // täglicher Download der Daten hier 14:30Uhr
                                            const idBase = '0_userdata.0.Corona.AT.Faelle';         // Ort für Datenpunkte (die VIS ist hierauf eingestellt!)
                                            
                                            /**
                                            *                                          Ab hier nichts abändern!
                                            */
                                            const axios = require('axios').default;                 // In der JS-Instanz unter Module eintragen
                                            const csvjson = require('csvjson');                     // In der JS-Instanz unter Module eintragen
                                            const fs = require('fs');
                                            const Path = require('path');
                                            const idJson = `${idBase}.json`;
                                            const idChart1 = `${idBase}.chart1`;
                                            const idChart2 = `${idBase}.chart2`;
                                            const idRefresh = `${idBase}.Refresh`;
                                            const timeFormats = {
                                               millisecond: "H:mm:ss.SSS",
                                               second: "H:mm:ss",
                                               minute: "H:mm",
                                               hour: "dd.[\\n]H:mm",
                                               day: "dd[\\n]DD.MM",
                                               week: "dd[\\n]DD.MM",
                                               month: "MMM YY",
                                               quarter: "[Q]Q - YYYY",
                                               year: "YYYY"
                                            };
                                            
                                            // main routine
                                            async function getData(refresh = false) {
                                               let data;
                                               const url = 'https://covid19-dashboard.ages.at/data/CovidFaelle_Timeline_GKZ.csv';
                                               let firstRun = await createDatapoints();
                                               if(refresh || firstRun) await getCSVFile(url);
                                               data = fs.readFileSync(Path.resolve(filePath, '', fileName), 'utf8');
                                               let json = csvjson.toObject(data, {delimiter : ';'});
                                               let js = [];
                                               json.forEach((record) => {
                                                   if (record.GKZ == myGKZ){
                                                       let t = record.Time.replace(/(\d+).(\d+).(\d+)/,'$3-$2-$1');
                                                       record.Time = getDateObject(t);//.getTime();
                                                       record.SiebenTageInzidenzFaelle = record.SiebenTageInzidenzFaelle.replace(',','.');
                                                       record.Aktiv = record.AnzahlFaelleSum - record.AnzahlTotSum - record.AnzahlGeheiltSum
                                                       js.push(record);
                                                   }
                                               })
                                               js.sort((a,b) => a.Time < b.Time ? 1 : -1)
                                               setState(idJson, JSON.stringify(js));
                                               createChart(js);
                                            }
                                            
                                            // create chart data
                                            function createChart(data) {
                                               const monatNow = new Date().getMonth();
                                               const startTime = new Date(2020,2,1,0,0,0,0).getTime();
                                               const endTime = new Date(2021,monatNow + 1,1,0,0,0,0).getTime();
                                               let chart = {}, chartTote = {}, chartInzidenz = {},Tote = [],Aktiv = [], Fälle = [], Genesen = [], time, axisLabels = [];
                                               let Inzidenz = [];
                                               Tote.push({t: startTime, y: null});
                                               Inzidenz.push({t: startTime, y: null});
                                               Aktiv.push({t: startTime, y: null});
                                               Fälle.push({t: startTime, y: null});
                                               Genesen.push({t: startTime, y: null});
                                            
                                               data.forEach((record,i) => {
                                                   time = getDateObject(record.Time).getTime();
                                                   if (time >= startTime && time <= endTime){
                                                       Tote.push({t: time, y: record.AnzahlTotSum})
                                                       Inzidenz.push({t: time, y: Math.max(record.SiebenTageInzidenzFaelle.replace(',','.'),0)})
                                                       Aktiv.push({t: time, y: record.Aktiv})
                                                       Fälle.push({t: time, y: record.AnzahlFaelleSum})
                                                       Genesen.push({t: time, y: record.AnzahlGeheiltSum})
                                                   }
                                               })
                                               Tote.push({t: endTime, y: null});
                                               Inzidenz.push({t: endTime, y: null});
                                               Aktiv.push({t: endTime, y: null});
                                               Fälle.push({t: endTime, y: null});
                                               Genesen.push({t: endTime, y: null});
                                               chart = {
                                                   //axisLabels: axisLabels,
                                                   graphs: [
                                                       {
                                                           legendText: 'Tote',
                                                           data: Tote,
                                                           type: 'line',
                                                           color: 'red',
                                                           displayOrder: 3,
                                                           xAxis_time_unit: 'month',
                                                           xAxis_bounds: 'ticks', // ticks, data
                                                           xAxis_timeFormats: timeFormats,
                                                           line_pointSize: 0.2,
                                                           line_Thickness: 1,
                                                           datalabel_show: !true,
                                                           datalabel_steps: 300,
                                                           yAxis_id: 0,
                                                           //yAxis_min: yMin,
                                                           //yAxis_max: yMax,
                                                           yAxis_gridLines_show: true,
                                                           yAxis_gridLines_color: '#ffffff',
                                                           yAxis_gridLines_lineWidth: 0.3,
                                                           yAxis_zeroLineWidth: 0.4,
                                                       }, {
                                                           legendText: 'Aktive Fälle',
                                                           data: Aktiv,
                                                           type: 'line',
                                                           color: 'green',
                                                           displayOrder: 2,
                                                           xAxis_time_unit: 'month',
                                                           xAxis_bounds: 'ticks', // ticks, data
                                                           xAxis_timeFormats: timeFormats,
                                                           line_pointSize: 0.2,
                                                           line_Thickness: 1,
                                                           datalabel_show: !true,
                                                           datalabel_steps: 300,
                                                           yAxis_id: 0,
                                                           //yAxis_min: yMin,
                                                           //yAxis_max: yMax,
                                                           yAxis_gridLines_show: true,
                                                           yAxis_gridLines_color: '#ffffff',
                                                           yAxis_gridLines_lineWidth: 0.3,
                                                           yAxis_zeroLineWidth: 0.4,
                                                       }, {
                                                           legendText: 'Infektionen gesamt',
                                                           data: Fälle,
                                                           type: 'line',
                                                           color: 'white',
                                                           displayOrder: 0,
                                                           xAxis_time_unit: 'month',
                                                           xAxis_bounds: 'ticks', // ticks, data
                                                           xAxis_timeFormats: timeFormats,
                                                           line_pointSize: 0.2,
                                                           line_Thickness: 1,
                                                           datalabel_show: !true,
                                                           datalabel_steps: 300,
                                                           yAxis_id: 0,
                                                           //yAxis_min: yMin,
                                                           //yAxis_max: yMax,
                                                           yAxis_gridLines_show: true,
                                                           yAxis_gridLines_color: '#ffffff',
                                                           yAxis_gridLines_lineWidth: 0.3,
                                                           yAxis_zeroLineWidth: 0.4,
                                                       }, {
                                                           legendText: 'Genesen',
                                                           data: Genesen,
                                                           type: 'line',
                                                           color: 'yellow',
                                                           displayOrder: 1,
                                                           xAxis_time_unit: 'month',
                                                           xAxis_bounds: 'ticks', // ticks, data
                                                           xAxis_timeFormats: timeFormats,
                                                           line_pointSize: 0.2,
                                                           line_Thickness: 1,
                                                           datalabel_show: !true,
                                                           datalabel_steps: 300,
                                                           yAxis_id: 0,
                                                           //yAxis_min: yMin,
                                                           //yAxis_max: yMax,
                                                           yAxis_gridLines_show: true,
                                                           yAxis_gridLines_color: '#ffffff',
                                                           yAxis_gridLines_lineWidth: 0.3,
                                                           yAxis_zeroLineWidth: 0.4,
                                                       }
                                            
                                                   ]
                                               }
                                            
                                               chartInzidenz = {
                                                   //axisLabels: axisLabels,
                                                   graphs: [
                                                       {
                                                           legendText: 'Inzidenz 7 Tage',
                                                           data: Inzidenz,
                                                           type: 'line',
                                                           color: '#ff0000',
                                                           xAxis_time_unit: 'month',
                                                           xAxis_bounds: 'ticks', // ticks, data
                                                           xAxis_timeFormats: timeFormats,
                                                           line_pointSize: 0,
                                                           line_Thickness: 1,
                                                           datalabel_show: !true,
                                                           datalabel_steps: 100,
                                                           yAxis_id: 0,
                                                           yAxis_gridLines_show: true,
                                                           yAxis_gridLines_color: '#ffffff',
                                                           yAxis_gridLines_lineWidth: 0.3,
                                                           yAxis_zeroLineWidth: 0.4,
                                                       }
                                                   ]
                                               }
                                               setState(idChart1,JSON.stringify(chart))
                                               setState(idChart2,JSON.stringify(chartInzidenz))
                                            }
                                            
                                            // create data points if not existing
                                            async function createDatapoints() {
                                               let dp,
                                                   idKey,
                                                   firstRun = false;
                                               
                                               const stateAttributes = {
                                                   "json":{"name":"Json Tabelle","type":"string","role":"","read":true,"write":true,"desc":"von Skript erstellt","def":""},
                                                   "Refresh":{"name":"Refresh","type":"boolean","role":"","read":true,"write":true,"desc":"von Skript erstellt","def":false},
                                                   "chart1":{"name":"Chart 1","type":"string","role":"","read":true,"write":true,"desc":"von Skript erstellt","def": ""},
                                                   "chart2":{"name":"Chart 1","type":"string","role":"","read":true,"write":true,"desc":"von Skript erstellt","def": ""},
                                               }
                                            
                                               for(let key in stateAttributes) {
                                            
                                                   idKey = idBase + '.' + key;
                                            
                                                   if (!(await existsStateAsync(idKey))) {
                                                       dp = stateAttributes[key];
                                                       firstRun = true;
                                                       await createStateAsync(idKey, dp);
                                                   }
                                               }
                                            
                                               return firstRun;
                                            
                                            }
                                            
                                            // download and save csv file
                                            async function getCSVFile (url) {  
                                               const writer = fs.createWriteStream(Path.resolve(filePath, '', fileName));
                                            
                                               const response = await axios({
                                                   url: url,
                                                   method: 'GET',
                                                   responseType: 'stream'
                                               })
                                               response.data.pipe(writer);
                                            
                                               return new Promise((resolve, reject) => {
                                                   writer.on('finish', resolve)
                                                   writer.on('error', reject)
                                               })
                                            }
                                            
                                            schedule(mySchedule, () => {getData(true)});
                                            
                                            on({id: idRefresh, change: 'any'},() => {getData(true)})
                                            
                                            getData(false);
                                            

                                            {
                                             "settings": {
                                               "style": {
                                                 "background_class": ""
                                               },
                                               "theme": "redmond",
                                               "sizex": "",
                                               "sizey": "",
                                               "gridSize": "10",
                                               "snapType": 2
                                             },
                                             "widgets": {
                                               "e00001": {
                                                 "tpl": "tplVis-materialdesign-Chart-JSON",
                                                 "data": {
                                                   "oid": "0_userdata.0.Corona.AT.Faelle.chart1",
                                                   "g_fixed": false,
                                                   "g_visibility": false,
                                                   "g_css_font_text": false,
                                                   "g_css_background": false,
                                                   "g_css_shadow_padding": false,
                                                   "g_css_border": true,
                                                   "g_gestures": false,
                                                   "g_signals": false,
                                                   "g_last_change": false,
                                                   "chartType": "line",
                                                   "showLegend": true,
                                                   "legendPosition": "top",
                                                   "legendPointStyle": true,
                                                   "showTooltip": "true",
                                                   "tooltipMode": "nearest",
                                                   "tooltipShowColorBox": "true",
                                                   "xAxisPosition": "bottom",
                                                   "xAxisValueDistanceToAxis": "10",
                                                   "xAxisShowAxis": true,
                                                   "xAxisShowAxisLabels": true,
                                                   "xAxisShowGridLines": true,
                                                   "xAxisShowTicks": true,
                                                   "xAxisMinRotation": "45",
                                                   "xAxisMaxRotation": "60",
                                                   "yAxisValueDistanceToAxis": "6",
                                                   "signals-cond-0": "==",
                                                   "signals-val-0": true,
                                                   "signals-icon-0": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-0": 0,
                                                   "signals-blink-0": false,
                                                   "signals-horz-0": 0,
                                                   "signals-vert-0": 0,
                                                   "signals-hide-edit-0": false,
                                                   "signals-cond-1": "==",
                                                   "signals-val-1": true,
                                                   "signals-icon-1": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-1": 0,
                                                   "signals-blink-1": false,
                                                   "signals-horz-1": 0,
                                                   "signals-vert-1": 0,
                                                   "signals-hide-edit-1": false,
                                                   "signals-cond-2": "==",
                                                   "signals-val-2": true,
                                                   "signals-icon-2": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-2": 0,
                                                   "signals-blink-2": false,
                                                   "signals-horz-2": 0,
                                                   "signals-vert-2": 0,
                                                   "signals-hide-edit-2": false,
                                                   "lc-type": "last-change",
                                                   "lc-is-interval": true,
                                                   "lc-is-moment": false,
                                                   "lc-format": "",
                                                   "lc-position-vert": "top",
                                                   "lc-position-horz": "right",
                                                   "lc-offset-vert": 0,
                                                   "lc-offset-horz": 0,
                                                   "lc-font-size": "12px",
                                                   "lc-font-family": "",
                                                   "lc-font-style": "",
                                                   "lc-bkg-color": "",
                                                   "lc-color": "",
                                                   "lc-border-width": "0",
                                                   "lc-border-style": "",
                                                   "lc-border-color": "",
                                                   "lc-border-radius": 10,
                                                   "lc-zindex": 0,
                                                   "xAxisMaxLabel": "15",
                                                   "xAxisTitle": "",
                                                   "xAxisTitleFontFamily": "Arial, Helvetica, sans-serif",
                                                   "axisLabelAutoSkip": true,
                                                   "xAxisOffsetGridLines": false,
                                                   "xAxisTickLength": "12",
                                                   "xAxisZeroLineWidth": "0.8",
                                                   "xAxisValueFontSize": "14",
                                                   "xAxisTitleColor": "#0e0c0c",
                                                   "xAxisValueLabelColor": "#000000",
                                                   "xAxisGridLinesColor": "#ffffff",
                                                   "xAxisGridLinesWitdh": "0.3",
                                                   "xAxisZeroLineColor": "#ff0000",
                                                   "yAxisValueFontSize": "12",
                                                   "yAxisValueLabelColor": "#000000",
                                                   "colorScheme": "scrounger.pie",
                                                   "disableHoverEffects": true,
                                                   "barWidth": "6",
                                                   "backgroundColor": "#eee9c4",
                                                   "chartAreaBackgroundColor": "#000000",
                                                   "chartPaddingTop": "10",
                                                   "chartPaddingLeft": "10",
                                                   "chartPaddingRight": "10",
                                                   "chartPaddingBottom": "10",
                                                   "globalColor": "#fe972f",
                                                   "animationDuration": "",
                                                   "yAxisValueFontFamily": "Arial, Helvetica, sans-serif",
                                                   "xAxisValueFontFamily": "Tahoma, Geneva, sans-serif",
                                                   "legendFontColor": "#000000",
                                                   "legendFontFamily": "{vis-materialdesign.0.fonts.charts.legend}",
                                                   "legendFontSize": "{vis-materialdesign.0.fontSizes.charts.legend}",
                                                   "tooltipTimeFormats": "{\"millisecond\":\"lll:ss\",\"second\":\"lll:ss\",\"minute\":\"lll\",\"hour\":\"lll\",\"day\":\"lll\",\"week\":\"lll\",\"month\":\"lll\",\"quarter\":\"lll\",\"year\":\"lll\"}",
                                                   "tooltipBackgroundColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_background;dark:vis-materialdesign.0.colors.dark.charts.tooltip_background; mode === \"true\" ? dark : light}",
                                                   "tooltipTitleFontColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_title;dark:vis-materialdesign.0.colors.dark.charts.tooltip_title; mode === \"true\" ? dark : light}",
                                                   "tooltipTitleFontFamily": "{vis-materialdesign.0.fonts.charts.tooltip_title}",
                                                   "tooltipTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.tooltip_title}",
                                                   "tooltipBodyFontColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_text;dark:vis-materialdesign.0.colors.dark.charts.tooltip_text; mode === \"true\" ? dark : light}",
                                                   "tooltipBodyFontFamily": "{vis-materialdesign.0.fonts.charts.tooltip_text}",
                                                   "tooltipBodyFontSize": "{vis-materialdesign.0.fontSizes.charts.tooltip_text}",
                                                   "xAxisTicksSource": "auto",
                                                   "xAxisTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.x_axis_title}",
                                                   "xAxisDistanceBetweenTicks": "10",
                                                   "yAxisTitleColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.y_axis_values;dark:vis-materialdesign.0.colors.dark.charts.y_axis_values; mode === \"true\" ? dark : light}",
                                                   "yAxisTitleFontFamily": "{vis-materialdesign.0.fonts.charts.y_axis_title}",
                                                   "yAxisTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.y_axis_title}",
                                                   "xAxisOffset": false,
                                                   "xAxisLabelUseTodayYesterday": false,
                                                   "visibility-cond": "==",
                                                   "visibility-val": 1,
                                                   "visibility-groups-action": "hide",
                                                   "legendPadding": "20"
                                                 },
                                                 "style": {
                                                   "left": "10px",
                                                   "top": "60px",
                                                   "width": "720px",
                                                   "height": "300px",
                                                   "z-index": "1",
                                                   "border-style": "solid",
                                                   "border-width": "1px",
                                                   "border-color": "red"
                                                 },
                                                 "widgetSet": "materialdesign"
                                               },
                                               "e00002": {
                                                 "tpl": "tplVis-materialdesign-Chart-JSON",
                                                 "data": {
                                                   "oid": "0_userdata.0.Corona.AT.Faelle.chart2",
                                                   "g_fixed": false,
                                                   "g_visibility": false,
                                                   "g_css_font_text": false,
                                                   "g_css_background": false,
                                                   "g_css_shadow_padding": false,
                                                   "g_css_border": true,
                                                   "g_gestures": false,
                                                   "g_signals": false,
                                                   "g_last_change": false,
                                                   "chartType": "line",
                                                   "showLegend": true,
                                                   "legendPosition": "top",
                                                   "legendPointStyle": true,
                                                   "showTooltip": "true",
                                                   "tooltipMode": "nearest",
                                                   "tooltipShowColorBox": "true",
                                                   "xAxisPosition": "bottom",
                                                   "xAxisValueDistanceToAxis": "10",
                                                   "xAxisShowAxis": true,
                                                   "xAxisShowAxisLabels": true,
                                                   "xAxisShowGridLines": true,
                                                   "xAxisShowTicks": true,
                                                   "xAxisMinRotation": "45",
                                                   "xAxisMaxRotation": "60",
                                                   "yAxisValueDistanceToAxis": "6",
                                                   "signals-cond-0": "==",
                                                   "signals-val-0": true,
                                                   "signals-icon-0": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-0": 0,
                                                   "signals-blink-0": false,
                                                   "signals-horz-0": 0,
                                                   "signals-vert-0": 0,
                                                   "signals-hide-edit-0": false,
                                                   "signals-cond-1": "==",
                                                   "signals-val-1": true,
                                                   "signals-icon-1": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-1": 0,
                                                   "signals-blink-1": false,
                                                   "signals-horz-1": 0,
                                                   "signals-vert-1": 0,
                                                   "signals-hide-edit-1": false,
                                                   "signals-cond-2": "==",
                                                   "signals-val-2": true,
                                                   "signals-icon-2": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-2": 0,
                                                   "signals-blink-2": false,
                                                   "signals-horz-2": 0,
                                                   "signals-vert-2": 0,
                                                   "signals-hide-edit-2": false,
                                                   "lc-type": "last-change",
                                                   "lc-is-interval": true,
                                                   "lc-is-moment": false,
                                                   "lc-format": "",
                                                   "lc-position-vert": "top",
                                                   "lc-position-horz": "right",
                                                   "lc-offset-vert": 0,
                                                   "lc-offset-horz": 0,
                                                   "lc-font-size": "12px",
                                                   "lc-font-family": "",
                                                   "lc-font-style": "",
                                                   "lc-bkg-color": "",
                                                   "lc-color": "",
                                                   "lc-border-width": "0",
                                                   "lc-border-style": "",
                                                   "lc-border-color": "",
                                                   "lc-border-radius": 10,
                                                   "lc-zindex": 0,
                                                   "xAxisMaxLabel": "15",
                                                   "xAxisTitle": "",
                                                   "xAxisTitleFontFamily": "Arial, Helvetica, sans-serif",
                                                   "axisLabelAutoSkip": true,
                                                   "xAxisOffsetGridLines": false,
                                                   "xAxisTickLength": "12",
                                                   "xAxisZeroLineWidth": "0.8",
                                                   "xAxisValueFontSize": "14",
                                                   "xAxisTitleColor": "#0e0c0c",
                                                   "xAxisValueLabelColor": "#000000",
                                                   "xAxisGridLinesColor": "#ffffff",
                                                   "xAxisGridLinesWitdh": "0.3",
                                                   "xAxisZeroLineColor": "#ff0000",
                                                   "yAxisValueFontSize": "12",
                                                   "yAxisValueLabelColor": "#000000",
                                                   "colorScheme": "scrounger.pie",
                                                   "disableHoverEffects": true,
                                                   "barWidth": "6",
                                                   "backgroundColor": "#eee9c4",
                                                   "chartAreaBackgroundColor": "#000000",
                                                   "chartPaddingTop": "10",
                                                   "chartPaddingLeft": "10",
                                                   "chartPaddingRight": "10",
                                                   "chartPaddingBottom": "10",
                                                   "globalColor": "#fe972f",
                                                   "animationDuration": "",
                                                   "yAxisValueFontFamily": "Arial, Helvetica, sans-serif",
                                                   "xAxisValueFontFamily": "Tahoma, Geneva, sans-serif",
                                                   "legendFontColor": "#000000",
                                                   "legendFontFamily": "{vis-materialdesign.0.fonts.charts.legend}",
                                                   "legendFontSize": "{vis-materialdesign.0.fontSizes.charts.legend}",
                                                   "tooltipTimeFormats": "{\"millisecond\":\"lll:ss\",\"second\":\"lll:ss\",\"minute\":\"lll\",\"hour\":\"lll\",\"day\":\"lll\",\"week\":\"lll\",\"month\":\"lll\",\"quarter\":\"lll\",\"year\":\"lll\"}",
                                                   "tooltipBackgroundColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_background;dark:vis-materialdesign.0.colors.dark.charts.tooltip_background; mode === \"true\" ? dark : light}",
                                                   "tooltipTitleFontColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_title;dark:vis-materialdesign.0.colors.dark.charts.tooltip_title; mode === \"true\" ? dark : light}",
                                                   "tooltipTitleFontFamily": "{vis-materialdesign.0.fonts.charts.tooltip_title}",
                                                   "tooltipTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.tooltip_title}",
                                                   "tooltipBodyFontColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_text;dark:vis-materialdesign.0.colors.dark.charts.tooltip_text; mode === \"true\" ? dark : light}",
                                                   "tooltipBodyFontFamily": "{vis-materialdesign.0.fonts.charts.tooltip_text}",
                                                   "tooltipBodyFontSize": "{vis-materialdesign.0.fontSizes.charts.tooltip_text}",
                                                   "xAxisTicksSource": "auto",
                                                   "xAxisTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.x_axis_title}",
                                                   "xAxisDistanceBetweenTicks": "10",
                                                   "yAxisTitleColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.y_axis_values;dark:vis-materialdesign.0.colors.dark.charts.y_axis_values; mode === \"true\" ? dark : light}",
                                                   "yAxisTitleFontFamily": "{vis-materialdesign.0.fonts.charts.y_axis_title}",
                                                   "yAxisTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.y_axis_title}",
                                                   "xAxisOffset": false,
                                                   "xAxisLabelUseTodayYesterday": false,
                                                   "visibility-cond": "==",
                                                   "visibility-val": 1,
                                                   "visibility-groups-action": "hide",
                                                   "legendPadding": "20"
                                                 },
                                                 "style": {
                                                   "left": "10px",
                                                   "top": "380px",
                                                   "width": "720px",
                                                   "height": "300px",
                                                   "z-index": "1",
                                                   "border-style": "solid",
                                                   "border-width": "1px",
                                                   "border-color": "red"
                                                 },
                                                 "widgetSet": "materialdesign"
                                               },
                                               "e00003": {
                                                 "tpl": "tplVis-materialdesign-Chart-JSON",
                                                 "data": {
                                                   "oid": "0_userdata.0.Corona.AT.Faelle.chart1",
                                                   "g_fixed": false,
                                                   "g_visibility": false,
                                                   "g_css_font_text": false,
                                                   "g_css_background": false,
                                                   "g_css_shadow_padding": false,
                                                   "g_css_border": true,
                                                   "g_gestures": false,
                                                   "g_signals": false,
                                                   "g_last_change": false,
                                                   "chartType": "line",
                                                   "showLegend": true,
                                                   "legendPosition": "top",
                                                   "legendPointStyle": true,
                                                   "showTooltip": "true",
                                                   "tooltipMode": "nearest",
                                                   "tooltipShowColorBox": "true",
                                                   "xAxisPosition": "bottom",
                                                   "xAxisValueDistanceToAxis": "10",
                                                   "xAxisShowAxis": true,
                                                   "xAxisShowAxisLabels": true,
                                                   "xAxisShowGridLines": true,
                                                   "xAxisShowTicks": true,
                                                   "xAxisMinRotation": "45",
                                                   "xAxisMaxRotation": "60",
                                                   "yAxisValueDistanceToAxis": "6",
                                                   "signals-cond-0": "==",
                                                   "signals-val-0": true,
                                                   "signals-icon-0": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-0": 0,
                                                   "signals-blink-0": false,
                                                   "signals-horz-0": 0,
                                                   "signals-vert-0": 0,
                                                   "signals-hide-edit-0": false,
                                                   "signals-cond-1": "==",
                                                   "signals-val-1": true,
                                                   "signals-icon-1": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-1": 0,
                                                   "signals-blink-1": false,
                                                   "signals-horz-1": 0,
                                                   "signals-vert-1": 0,
                                                   "signals-hide-edit-1": false,
                                                   "signals-cond-2": "==",
                                                   "signals-val-2": true,
                                                   "signals-icon-2": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-2": 0,
                                                   "signals-blink-2": false,
                                                   "signals-horz-2": 0,
                                                   "signals-vert-2": 0,
                                                   "signals-hide-edit-2": false,
                                                   "lc-type": "last-change",
                                                   "lc-is-interval": true,
                                                   "lc-is-moment": false,
                                                   "lc-format": "",
                                                   "lc-position-vert": "top",
                                                   "lc-position-horz": "right",
                                                   "lc-offset-vert": 0,
                                                   "lc-offset-horz": 0,
                                                   "lc-font-size": "12px",
                                                   "lc-font-family": "",
                                                   "lc-font-style": "",
                                                   "lc-bkg-color": "",
                                                   "lc-color": "",
                                                   "lc-border-width": "0",
                                                   "lc-border-style": "",
                                                   "lc-border-color": "",
                                                   "lc-border-radius": 10,
                                                   "lc-zindex": 0,
                                                   "xAxisMaxLabel": "15",
                                                   "xAxisTitle": "",
                                                   "xAxisTitleFontFamily": "Arial, Helvetica, sans-serif",
                                                   "axisLabelAutoSkip": true,
                                                   "xAxisOffsetGridLines": false,
                                                   "xAxisTickLength": "12",
                                                   "xAxisZeroLineWidth": "0.8",
                                                   "xAxisValueFontSize": "14",
                                                   "xAxisTitleColor": "#0e0c0c",
                                                   "xAxisValueLabelColor": "#000000",
                                                   "xAxisGridLinesColor": "#ffffff",
                                                   "xAxisGridLinesWitdh": "0.3",
                                                   "xAxisZeroLineColor": "#ff0000",
                                                   "yAxisValueFontSize": "12",
                                                   "yAxisValueLabelColor": "#000000",
                                                   "colorScheme": "scrounger.pie",
                                                   "disableHoverEffects": true,
                                                   "barWidth": "6",
                                                   "backgroundColor": "#eee9c4",
                                                   "chartAreaBackgroundColor": "#000000",
                                                   "chartPaddingTop": "10",
                                                   "chartPaddingLeft": "10",
                                                   "chartPaddingRight": "10",
                                                   "chartPaddingBottom": "10",
                                                   "globalColor": "#fe972f",
                                                   "animationDuration": "",
                                                   "yAxisValueFontFamily": "Arial, Helvetica, sans-serif",
                                                   "xAxisValueFontFamily": "Tahoma, Geneva, sans-serif",
                                                   "legendFontColor": "#000000",
                                                   "legendFontFamily": "{vis-materialdesign.0.fonts.charts.legend}",
                                                   "legendFontSize": "{vis-materialdesign.0.fontSizes.charts.legend}",
                                                   "tooltipTimeFormats": "{\"millisecond\":\"lll:ss\",\"second\":\"lll:ss\",\"minute\":\"lll\",\"hour\":\"lll\",\"day\":\"lll\",\"week\":\"lll\",\"month\":\"lll\",\"quarter\":\"lll\",\"year\":\"lll\"}",
                                                   "tooltipBackgroundColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_background;dark:vis-materialdesign.0.colors.dark.charts.tooltip_background; mode === \"true\" ? dark : light}",
                                                   "tooltipTitleFontColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_title;dark:vis-materialdesign.0.colors.dark.charts.tooltip_title; mode === \"true\" ? dark : light}",
                                                   "tooltipTitleFontFamily": "{vis-materialdesign.0.fonts.charts.tooltip_title}",
                                                   "tooltipTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.tooltip_title}",
                                                   "tooltipBodyFontColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.tooltip_text;dark:vis-materialdesign.0.colors.dark.charts.tooltip_text; mode === \"true\" ? dark : light}",
                                                   "tooltipBodyFontFamily": "{vis-materialdesign.0.fonts.charts.tooltip_text}",
                                                   "tooltipBodyFontSize": "{vis-materialdesign.0.fontSizes.charts.tooltip_text}",
                                                   "xAxisTicksSource": "auto",
                                                   "xAxisTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.x_axis_title}",
                                                   "xAxisDistanceBetweenTicks": "10",
                                                   "yAxisTitleColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.charts.y_axis_values;dark:vis-materialdesign.0.colors.dark.charts.y_axis_values; mode === \"true\" ? dark : light}",
                                                   "yAxisTitleFontFamily": "{vis-materialdesign.0.fonts.charts.y_axis_title}",
                                                   "yAxisTitleFontSize": "{vis-materialdesign.0.fontSizes.charts.y_axis_title}",
                                                   "xAxisOffset": false,
                                                   "xAxisLabelUseTodayYesterday": false,
                                                   "visibility-cond": "==",
                                                   "visibility-val": 1,
                                                   "visibility-groups-action": "hide",
                                                   "legendPadding": "20"
                                                 },
                                                 "style": {
                                                   "left": "740px",
                                                   "top": "60px",
                                                   "width": "720px",
                                                   "height": "300px",
                                                   "z-index": "1",
                                                   "border-style": "solid",
                                                   "border-width": "1px",
                                                   "border-color": "red"
                                                 },
                                                 "widgetSet": "materialdesign"
                                               },
                                               "e00004": {
                                                 "tpl": "i-vis-jsontable",
                                                 "data": {
                                                   "g_fixed": false,
                                                   "g_visibility": false,
                                                   "g_css_font_text": false,
                                                   "g_css_background": false,
                                                   "g_css_shadow_padding": false,
                                                   "g_css_border": false,
                                                   "g_gestures": false,
                                                   "g_signals": false,
                                                   "g_last_change": false,
                                                   "visibility-cond": "==",
                                                   "visibility-val": 1,
                                                   "visibility-groups-action": "hide",
                                                   "iTblRowLimit": "30000",
                                                   "iTableRefreshRate": "0",
                                                   "iColCount": "12",
                                                   "iColShow1": "true",
                                                   "iTblCellFormat1": "datetime",
                                                   "iTblCellImageSize1": "200",
                                                   "iTblCellBooleanCheckbox1": "false",
                                                   "iTblCellBooleanColorFalse1": "#ff0000",
                                                   "iTblCellBooleanColorTrue1": "#00ff00",
                                                   "iTblCellNumberDecimals1": "0",
                                                   "iTblCellNumberDecimalSeperator1": ",",
                                                   "iTblCellNumberThousandSeperator1": ".",
                                                   "iTblTextAlign1": "left",
                                                   "iOpacityAll": "1",
                                                   "iTblRowEvenColor": "#333333",
                                                   "iTblRowUnevenColor": "#455618",
                                                   "iTblHeaderColor": "#333333",
                                                   "iRowSpacing": "10",
                                                   "iTblRowEvenTextColor": "#ffffff",
                                                   "iTblRowUnevenTextColor": "#ffffff",
                                                   "iTblHeaderTextColor": "#ffffff",
                                                   "iBorderSize": "1",
                                                   "iBorderStyleLeft": "solid",
                                                   "iBorderStyleRight": "solid",
                                                   "iBorderStyleUp": "none",
                                                   "iBorderStyleDown": "none",
                                                   "iBorderColor": "#ffffff",
                                                   "signals-cond-0": "==",
                                                   "signals-val-0": true,
                                                   "signals-icon-0": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-0": 0,
                                                   "signals-blink-0": false,
                                                   "signals-horz-0": 0,
                                                   "signals-vert-0": 0,
                                                   "signals-hide-edit-0": false,
                                                   "signals-cond-1": "==",
                                                   "signals-val-1": true,
                                                   "signals-icon-1": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-1": 0,
                                                   "signals-blink-1": false,
                                                   "signals-horz-1": 0,
                                                   "signals-vert-1": 0,
                                                   "signals-hide-edit-1": false,
                                                   "signals-cond-2": "==",
                                                   "signals-val-2": true,
                                                   "signals-icon-2": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-2": 0,
                                                   "signals-blink-2": false,
                                                   "signals-horz-2": 0,
                                                   "signals-vert-2": 0,
                                                   "signals-hide-edit-2": false,
                                                   "lc-type": "last-change",
                                                   "lc-is-interval": true,
                                                   "lc-is-moment": false,
                                                   "lc-format": "",
                                                   "lc-position-vert": "top",
                                                   "lc-position-horz": "right",
                                                   "lc-offset-vert": 0,
                                                   "lc-offset-horz": 0,
                                                   "lc-font-size": "12px",
                                                   "lc-font-family": "",
                                                   "lc-font-style": "",
                                                   "lc-bkg-color": "",
                                                   "lc-color": "",
                                                   "lc-border-width": "0",
                                                   "lc-border-style": "",
                                                   "lc-border-color": "",
                                                   "lc-border-radius": 10,
                                                   "lc-zindex": 0,
                                                   "oid": "0_userdata.0.Corona.AT.Faelle.json",
                                                   "iTblShowHead": true,
                                                   "iVertScroll": true,
                                                   "iColShow2": "true",
                                                   "iTblCellFormat2": "normal",
                                                   "iTblCellImageSize2": "200",
                                                   "iTblCellBooleanCheckbox2": "false",
                                                   "iTblCellBooleanColorFalse2": "#ff0000",
                                                   "iTblCellBooleanColorTrue2": "#00ff00",
                                                   "iTblCellNumberDecimals2": "0",
                                                   "iTblCellNumberDecimalSeperator2": ",",
                                                   "iTblCellNumberThousandSeperator2": ".",
                                                   "iTblTextAlign2": "left",
                                                   "iColShow3": "true",
                                                   "iTblCellFormat3": "normal",
                                                   "iTblCellImageSize3": "200",
                                                   "iTblCellBooleanCheckbox3": "false",
                                                   "iTblCellBooleanColorFalse3": "#ff0000",
                                                   "iTblCellBooleanColorTrue3": "#00ff00",
                                                   "iTblCellNumberDecimals3": "0",
                                                   "iTblCellNumberDecimalSeperator3": ",",
                                                   "iTblCellNumberThousandSeperator3": ".",
                                                   "iTblTextAlign3": "left",
                                                   "iColShow4": "true",
                                                   "iTblCellFormat4": "normal",
                                                   "iTblCellImageSize4": "200",
                                                   "iTblCellBooleanCheckbox4": "false",
                                                   "iTblCellBooleanColorFalse4": "#ff0000",
                                                   "iTblCellBooleanColorTrue4": "#00ff00",
                                                   "iTblCellNumberDecimals4": "0",
                                                   "iTblCellNumberDecimalSeperator4": ",",
                                                   "iTblCellNumberThousandSeperator4": ".",
                                                   "iTblTextAlign4": "right",
                                                   "iColShow5": "true",
                                                   "iTblCellFormat5": "normal",
                                                   "iTblCellImageSize5": "200",
                                                   "iTblCellBooleanCheckbox5": "false",
                                                   "iTblCellBooleanColorFalse5": "#ff0000",
                                                   "iTblCellBooleanColorTrue5": "#00ff00",
                                                   "iTblCellNumberDecimals5": "0",
                                                   "iTblCellNumberDecimalSeperator5": ",",
                                                   "iTblCellNumberThousandSeperator5": ".",
                                                   "iTblTextAlign5": "right",
                                                   "iColShow6": "true",
                                                   "iTblCellFormat6": "normal",
                                                   "iTblCellImageSize6": "200",
                                                   "iTblCellBooleanCheckbox6": "false",
                                                   "iTblCellBooleanColorFalse6": "#ff0000",
                                                   "iTblCellBooleanColorTrue6": "#00ff00",
                                                   "iTblCellNumberDecimals6": "0",
                                                   "iTblCellNumberDecimalSeperator6": ",",
                                                   "iTblCellNumberThousandSeperator6": ".",
                                                   "iTblTextAlign6": "right",
                                                   "iColShow7": "true",
                                                   "iTblCellFormat7": "normal",
                                                   "iTblCellImageSize7": "200",
                                                   "iTblCellBooleanCheckbox7": "false",
                                                   "iTblCellBooleanColorFalse7": "#ff0000",
                                                   "iTblCellBooleanColorTrue7": "#00ff00",
                                                   "iTblCellNumberDecimals7": "0",
                                                   "iTblCellNumberDecimalSeperator7": ",",
                                                   "iTblCellNumberThousandSeperator7": ".",
                                                   "iTblTextAlign7": "right",
                                                   "iColShow8": "true",
                                                   "iTblCellFormat8": "number",
                                                   "iTblCellImageSize8": "200",
                                                   "iTblCellBooleanCheckbox8": "false",
                                                   "iTblCellBooleanColorFalse8": "#ff0000",
                                                   "iTblCellBooleanColorTrue8": "#00ff00",
                                                   "iTblCellNumberDecimals8": "2",
                                                   "iTblCellNumberDecimalSeperator8": ",",
                                                   "iTblCellNumberThousandSeperator8": ".",
                                                   "iTblTextAlign8": "right",
                                                   "iColShow9": "true",
                                                   "iTblCellFormat9": "normal",
                                                   "iTblCellImageSize9": "200",
                                                   "iTblCellBooleanCheckbox9": "false",
                                                   "iTblCellBooleanColorFalse9": "#ff0000",
                                                   "iTblCellBooleanColorTrue9": "#00ff00",
                                                   "iTblCellNumberDecimals9": "0",
                                                   "iTblCellNumberDecimalSeperator9": ",",
                                                   "iTblCellNumberThousandSeperator9": ".",
                                                   "iTblTextAlign9": "right",
                                                   "iColShow10": "true",
                                                   "iTblCellFormat10": "normal",
                                                   "iTblCellImageSize10": "200",
                                                   "iTblCellBooleanCheckbox10": "false",
                                                   "iTblCellBooleanColorFalse10": "#ff0000",
                                                   "iTblCellBooleanColorTrue10": "#00ff00",
                                                   "iTblCellNumberDecimals10": "0",
                                                   "iTblCellNumberDecimalSeperator10": ",",
                                                   "iTblCellNumberThousandSeperator10": ".",
                                                   "iTblTextAlign10": "right",
                                                   "iColShow11": "true",
                                                   "iTblCellFormat11": "normal",
                                                   "iTblCellImageSize11": "200",
                                                   "iTblCellBooleanCheckbox11": "false",
                                                   "iTblCellBooleanColorFalse11": "#ff0000",
                                                   "iTblCellBooleanColorTrue11": "#00ff00",
                                                   "iTblCellNumberDecimals11": "0",
                                                   "iTblCellNumberDecimalSeperator11": ",",
                                                   "iTblCellNumberThousandSeperator11": ".",
                                                   "iTblTextAlign11": "right",
                                                   "iColShow12": "true",
                                                   "iTblCellFormat12": "normal",
                                                   "iTblCellImageSize12": "200",
                                                   "iTblCellBooleanCheckbox12": "false",
                                                   "iTblCellBooleanColorFalse12": "#ff0000",
                                                   "iTblCellBooleanColorTrue12": "#00ff00",
                                                   "iTblCellNumberDecimals12": "0",
                                                   "iTblCellNumberDecimalSeperator12": ",",
                                                   "iTblCellNumberThousandSeperator12": ".",
                                                   "iTblTextAlign12": "right",
                                                   "iColShow13": "true",
                                                   "iTblCellFormat13": "normal",
                                                   "iTblCellImageSize13": "200",
                                                   "iTblCellBooleanCheckbox13": "false",
                                                   "iTblCellBooleanColorFalse13": "#ff0000",
                                                   "iTblCellBooleanColorTrue13": "#00ff00",
                                                   "iTblCellNumberDecimals13": "0",
                                                   "iTblCellNumberDecimalSeperator13": ",",
                                                   "iTblCellNumberThousandSeperator13": ".",
                                                   "iTblTextAlign13": "left",
                                                   "iColShow14": "true",
                                                   "iTblCellFormat14": "normal",
                                                   "iTblCellImageSize14": "200",
                                                   "iTblCellBooleanCheckbox14": "false",
                                                   "iTblCellBooleanColorFalse14": "#ff0000",
                                                   "iTblCellBooleanColorTrue14": "#00ff00",
                                                   "iTblCellNumberDecimals14": "0",
                                                   "iTblCellNumberDecimalSeperator14": ",",
                                                   "iTblCellNumberThousandSeperator14": ".",
                                                   "iTblTextAlign14": "left",
                                                   "iColShow15": "true",
                                                   "iTblCellFormat15": "normal",
                                                   "iTblCellImageSize15": "200",
                                                   "iTblCellBooleanCheckbox15": "false",
                                                   "iTblCellBooleanColorFalse15": "#ff0000",
                                                   "iTblCellBooleanColorTrue15": "#00ff00",
                                                   "iTblCellNumberDecimals15": "0",
                                                   "iTblCellNumberDecimalSeperator15": ",",
                                                   "iTblCellNumberThousandSeperator15": ".",
                                                   "iTblTextAlign15": "left",
                                                   "iTblCellDatetimeFormat1": "d.m.y",
                                                   "iColName4": "EWZ",
                                                   "iColName5": "Fälle",
                                                   "iColName6": "Fälle kum",
                                                   "iColName7": "Fälle7",
                                                   "iColName8": "Inzidenz7",
                                                   "iColName9": "Tote",
                                                   "iColName10": "Tote kum",
                                                   "iColName11": "Geheilt",
                                                   "iColName12": "Geheilt kum",
                                                   "iTblFixedHead": true,
                                                   "iHorScroll": true
                                                 },
                                                 "style": {
                                                   "left": "740px",
                                                   "top": "380px",
                                                   "height": "319px",
                                                   "width": "720px"
                                                 },
                                                 "widgetSet": "vis-inventwo"
                                               },
                                               "e00005": {
                                                 "tpl": "tplVis-materialdesign-Button-State",
                                                 "data": {
                                                   "oid": "0_userdata.0.Corona.AT.Faelle.Refresh",
                                                   "g_fixed": false,
                                                   "g_visibility": false,
                                                   "g_css_font_text": true,
                                                   "g_css_background": true,
                                                   "g_css_shadow_padding": false,
                                                   "g_css_border": false,
                                                   "g_gestures": false,
                                                   "g_signals": false,
                                                   "g_last_change": false,
                                                   "visibility-cond": "==",
                                                   "visibility-val": 1,
                                                   "visibility-groups-action": "hide",
                                                   "buttonStyle": "unelevated",
                                                   "vibrateOnMobilDevices": "50",
                                                   "iconPosition": "left",
                                                   "autoLockAfter": "10",
                                                   "lockFilterGrayscale": "30",
                                                   "signals-cond-0": "==",
                                                   "signals-val-0": true,
                                                   "signals-icon-0": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-0": 0,
                                                   "signals-blink-0": false,
                                                   "signals-horz-0": 0,
                                                   "signals-vert-0": 0,
                                                   "signals-hide-edit-0": false,
                                                   "signals-cond-1": "==",
                                                   "signals-val-1": true,
                                                   "signals-icon-1": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-1": 0,
                                                   "signals-blink-1": false,
                                                   "signals-horz-1": 0,
                                                   "signals-vert-1": 0,
                                                   "signals-hide-edit-1": false,
                                                   "signals-cond-2": "==",
                                                   "signals-val-2": true,
                                                   "signals-icon-2": "/vis/signals/lowbattery.png",
                                                   "signals-icon-size-2": 0,
                                                   "signals-blink-2": false,
                                                   "signals-horz-2": 0,
                                                   "signals-vert-2": 0,
                                                   "signals-hide-edit-2": false,
                                                   "lc-type": "last-change",
                                                   "lc-is-interval": true,
                                                   "lc-is-moment": false,
                                                   "lc-format": "",
                                                   "lc-position-vert": "top",
                                                   "lc-position-horz": "right",
                                                   "lc-offset-vert": 0,
                                                   "lc-offset-horz": 0,
                                                   "lc-font-size": "12px",
                                                   "lc-font-family": "",
                                                   "lc-font-style": "",
                                                   "lc-bkg-color": "",
                                                   "lc-color": "",
                                                   "lc-border-width": "0",
                                                   "lc-border-style": "",
                                                   "lc-border-color": "",
                                                   "lc-border-radius": 10,
                                                   "lc-zindex": 0,
                                                   "buttontext": "Refresh",
                                                   "colorPress": "#ff0000",
                                                   "labelWidth": "0",
                                                   "exportData": "true",
                                                   "value": "true",
                                                   "textFontFamily": "{vis-materialdesign.0.fonts.button.text}",
                                                   "textFontSize": "{vis-materialdesign.0.fontSizes.button.text}",
                                                   "lockIconColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.button.lock_icon;dark:vis-materialdesign.0.colors.dark.button.lock_icon; mode === \"true\" ? dark : light}",
                                                   "mdwButtonPrimaryColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.button.default.primary;dark:vis-materialdesign.0.colors.dark.button.default.primary; mode === \"true\" ? dark : light}",
                                                   "mdwButtonSecondaryColor": "{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.button.default.secondary;dark:vis-materialdesign.0.colors.dark.button.default.secondary; mode === \"true\" ? dark : light}"
                                                 },
                                                 "style": {
                                                   "left": "10px",
                                                   "top": "10px",
                                                   "width": "71px",
                                                   "height": "29px",
                                                   "color": "#FF0000",
                                                   "background-color": "#000000"
                                                 },
                                                 "widgetSet": "materialdesign"
                                               }
                                             },
                                             "name": "AT",
                                             "filterList": []
                                            }
                                            

                                            sigi234 bergjet F 4 Replies 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

                                            627
                                            Online

                                            31.9k
                                            Users

                                            80.1k
                                            Topics

                                            1.3m
                                            Posts

                                            corona vis
                                            10
                                            217
                                            19630
                                            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