UPDATE 31.10.: Amazon Alexa - ioBroker Skill läuft aus ?

[sigi234]

@Homoran

Hallo, was mache ich Falsch?

[Homoran]

@sigi234
Was kommt denn raus?

[sigi234]

@Homoran sagte in Skripten des E-Control Spritpreisrechners:

@sigi234
Was kommt denn raus?

[{"id":34612,"name":"AVIA Xpress (Automaten-Tankstelle)","location":{"address":"Wiener Straße 33","postalCode":"4053","city":"Haid","latitude":48.197898,"longitude":14.251821},"contact":{"telephone":"43775287991","fax":"4377528799184","mail":"vertrieb@seifriedsberger.at","website":"http://www.seifriedsberger.at"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"06:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"06:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"06:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"06:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"06:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"06:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"06:00","to":"22:00"},{"day":"FE","label":"Feiertag","order":8,"from":"06:00","to":"22:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":true},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"AVIAmat-Tankkarte"},"paymentArrangements":{"cooperative":false,"clubCard":false},"otherServiceOffers":"LKW-tauglich","position":1,"open":true,"distance":6.890972361536602,"prices":[{"fuelType":"DIE","amount":1.174,"label":"Diesel"}]},{"id":264416,"name":"AVIA Xpress (Automaten-Tankstelle)","location":{"address":"Kremstalstrasse 50","postalCode":"4501","city":"Neuhofen an der Krems","latitude":48.131053,"longitude":14.220532},"contact":{"telephone":"43775287991","fax":"4377528799184","mail":"office@seifriedsberger.at","website":"http://www.seifriedsberger.at"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"06:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"06:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"06:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"06:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"06:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"06:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"06:00","to":"22:00"},{"day":"FE","label":"Feiertag","order":8,"from":"06:00","to":"22:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":true},"paymentMethods":{"cash":false,"debitCard":true,"creditCard":true,"others":"AVIAmat Tankkarte"},"paymentArrangements":{"cooperative":false,"clubCard":false,"accessMod":"AVIAmat Tankkarte"},"position":2,"open":true,"distance":0.9709991509304108,"prices":[{"fuelType":"DIE","amount":1.177,"label":"Diesel"}]},{"id":1406206,"name":"Turmöl","location":{"address":"Sipbach 10","postalCode":"4511","city":"Allhaming","latitude":48.150116,"longitude":14.1789738},"contact":{"telephone":"437227710417","fax":"437227710418"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"06:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"06:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"06:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"06:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"06:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"06:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"06:00","to":"22:00"},{"day":"FE","label":"Feiertag","order":8,"from":"06:00","to":"22:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":false},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true},"paymentArrangements":{"cooperative":false,"clubCard":false},"position":3,"open":true,"distance":3.918723482306115,"prices":[{"fuelType":"DIE","amount":1.177,"label":"Diesel"}]},{"id":621253,"name":"OIL! Tankstelle","location":{"address":"Salzburgerstrasse 12","postalCode":"4053","city":"Haid","latitude":48.2032,"longitude":14.2496},"contact":{},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"06:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"06:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"06:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"06:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"06:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"06:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"08:00","to":"21:00"},{"day":"FE","label":"Feiertag","order":8,"from":"08:00","to":"21:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":false},"paymentMethods":{"cash":true,"debitCard":false,"creditCard":false},"paymentArrangements":{"cooperative":false,"clubCard":true},"otherServiceOffers":"Werkstatt, Autopflege, Reifenservice, Bistro, Vignette","position":4,"open":true,"distance":7.427065116028797,"prices":[{"fuelType":"DIE","amount":1.187,"label":"Diesel"}]},{"id":676543,"name":"IQ Allhaming","location":{"address":"Poststrasse 3","postalCode":"4511","city":"Allhaming","latitude":48.153132,"longitude":14.158255},"contact":{"mail":"office@stiglechner.co.at"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"00:00","to":"24:00"},{"day":"DI","label":"Dienstag","order":2,"from":"00:00","to":"24:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"00:00","to":"24:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"00:00","to":"24:00"},{"day":"FR","label":"Freitag","order":5,"from":"00:00","to":"24:00"},{"day":"SA","label":"Samstag","order":6,"from":"00:00","to":"24:00"},{"day":"SO","label":"Sonntag","order":7,"from":"00:00","to":"24:00"},{"day":"FE","label":"Feiertag","order":8,"from":"00:00","to":"24:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":true},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"IQ Card, Euroshell, DKV, UTA, Hoyer"},"paymentArrangements":{"cooperative":false,"clubCard":false},"position":5,"open":true,"distance":5.48313957459672,"prices":[{"fuelType":"DIE","amount":1.194,"label":"Diesel"}]},{"id":4111,"name":"LAGERHAUS Genol","location":{"address":"STEYRERSTRASSE 28","postalCode":"4501","city":"NEUHOFEN","latitude":48.1379881,"longitude":14.2393913},"contact":{"telephone":"43820988144","mail":"energie@lagerhaus-traunviertel.at"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"05:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"05:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"05:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"05:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"05:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"05:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"05:00","to":"22:00"},{"day":"FE","label":"Feiertag","order":8,"from":"05:00","to":"22:00"}],"offerInformation":{"service":false,"selfService":false,"unattended":true},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"Lagerhaus Traunviertel Tankkarte"},"paymentArrangements":{"cooperative":false,"clubCard":false},"position":6,"open":true,"distance":0.8096145670288883,"prices":[]},{"id":6671,"name":"Turmöl Schmidberger","location":{"address":"Linzerstr. 54","postalCode":"4531","city":"Kematen/Krems","latitude":48.105947781697,"longitude":14.189147600194},"contact":{"telephone":"4372287245","fax":"437228724533","mail":"office@ernst-schmidberger.at","website":"http://www.ernst-schmidberger.at"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"00:00","to":"24:00"},{"day":"DI","label":"Dienstag","order":2,"from":"00:00","to":"24:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"00:00","to":"24:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"00:00","to":"24:00"},{"day":"FR","label":"Freitag","order":5,"from":"00:00","to":"24:00"},{"day":"SA","label":"Samstag","order":6,"from":"00:00","to":"24:00"},{"day":"SO","label":"Sonntag","order":7,"from":"00:00","to":"24:00"},{"day":"FE","label":"Feiertag","order":8,"from":"00:00","to":"24:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":true},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"BP-Routex, UTA, DKV, Austorcard, AP-Card"},"paymentArrangements":{"cooperative":false,"clubCard":false},"otherServiceOffers":"Kfz-Werkstätte, Abschleppdienst, Landmaschinen, Gartengeräte, Zweiradhandel","position":7,"open":true,"distance":4.610077744425186,"prices":[]},{"id":247991,"name":"eni","location":{"address":"Kremstalstrasse 117","postalCode":"4053","city":"Ritzlhof","latitude":48.187343,"longitude":14.249556},"contact":{"telephone":"0722988351","fax":"0722982134"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"06:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"06:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"06:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"06:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"06:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"06:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"06:00","to":"22:00"},{"day":"FE","label":"Feiertag","order":8,"from":"06:00","to":"22:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":false},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"AMEX,Maestro,Diners Club,DKV,GUTS,MasterCard,Routex,UTA,VISA"},"paymentArrangements":{"cooperative":false,"clubCard":false},"position":8,"open":true,"distance":5.713226774009689,"prices":[]},{"id":325,"name":"OMV - Haid Kremstalstraße 30","location":{"address":"Kremstalstrasse 30","postalCode":"4053","city":"Haid","latitude":48.20365,"longitude":14.24699},"contact":{"telephone":"722988344","fax":"72298834413","mail":"retail.at.3557@omv.com","website":"www.omv.com"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"05:00","to":"24:00"},{"day":"DI","label":"Dienstag","order":2,"from":"05:00","to":"24:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"05:00","to":"24:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"05:00","to":"24:00"},{"day":"FR","label":"Freitag","order":5,"from":"05:00","to":"24:00"},{"day":"SA","label":"Samstag","order":6,"from":"05:00","to":"24:00"},{"day":"SO","label":"Sonntag","order":7,"from":"05:00","to":"24:00"},{"day":"FE","label":"Feiertag","order":8,"from":"05:00","to":"24:00"}],"offerInformation":{"service":true,"selfService":true,"unattended":false},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"UTA, ENI Routex Card, OMV ROUTEX, STATOIL card, BP card, MASTERCARD, MAESTRO, DINERS, VISA, AMEX, OMV STATIONSKARTE"},"paymentArrangements":{"cooperative":false,"clubCard":false},"position":9,"open":true,"distance":7.43782801378163,"prices":[]},{"id":33347,"name":"Shell Tankstelle","location":{"address":"Linzer Strasse 41","postalCode":"4501","city":"Neuhofen","latitude":48.143876,"longitude":14.228437},"contact":{"telephone":"72275055","fax":"722750554","mail":"office@stiglechner.co.at"},"openingHours":[{"day":"MO","label":"Montag","order":1,"from":"06:00","to":"22:00"},{"day":"DI","label":"Dienstag","order":2,"from":"06:00","to":"22:00"},{"day":"MI","label":"Mittwoch","order":3,"from":"06:00","to":"22:00"},{"day":"DO","label":"Donnerstag","order":4,"from":"06:00","to":"22:00"},{"day":"FR","label":"Freitag","order":5,"from":"06:00","to":"22:00"},{"day":"SA","label":"Samstag","order":6,"from":"07:00","to":"22:00"},{"day":"SO","label":"Sonntag","order":7,"from":"07:00","to":"21:00"},{"day":"FE","label":"Feiertag","order":8,"from":"07:00","to":"21:00"}],"offerInformation":{"service":false,"selfService":true,"unattended":false},"paymentMethods":{"cash":true,"debitCard":true,"creditCard":true,"others":"IQ Card, Euroshell, UTA"},"paymentArrangements":{"cooperative":false,"clubCard":false},"otherServiceOffers":"Shop, Bistro, Portalwaschanlage, SB Staubsauger, Diesel HL Zapfs„ule","position":10,"open":true,"distance":0.6571283670169982,"prices":[]}]

[Homoran]

@sigi234
Warum trägst du keine RegEx ein?
ohne die ergibt ein Parser keinen Sinn

Preis (DIEsel:

IE"[^\d]+(\d\.\d+)

Name:

me":"(\D+)","

[sigi234]

@Homoran sagte in Skripten des E-Control Spritpreisrechners:

Warum trägst du keine RegEx ein?

Ja, ich Koffer aber wie lautet diese?

[sigi234]

@Homoran

Du Hellseher!:relaxed:

[sigi234]

@Homoran

Super Danke, funktioniert..

Jetzt muss ich für jede Tankstelle das selbe machen? Wie ist die RegEx für: Adresse oder die anderen Datenpunkte?
Wo kann ich das nachlesen was in die RegEx eingetragen werden muss?

[Homoran]

@sigi234
Du muss nur unter Num statt der 0 weiter hochzählen.
URL bleibt überall gleich
Regex jeweils bei Name und preis gleich

[Homoran]

@sigi234 sagte in Skripten des E-Control Spritpreisrechners:

Wie ist die RegEx für: Adresse oder die anderen Datenpunkte?

Konntest du das nicht 10 Minuten früher fragen.

Jetzt ist der pc aus und ich bin nur noch mit dem tablet im bett :sleeping:

[sigi234]

@Homoran sagte in Skripten des E-Control Spritpreisrechners:

@sigi234 sagte in Skripten des E-Control Spritpreisrechners:

Wie ist die RegEx für: Adresse oder die anderen Datenpunkte?

Konntest du das nicht 10 Minuten früher fragen.

Jetzt ist der pc aus und ich bin nur noch mit dem tablet im bett :sleeping:

Ok, sorry kein Problem.........können wir auch Morgen mal machen.

Lag aber auch nicht bei mir:

[SmarthomeMF]

So nun habe ich alle neu gemacht mit nur 5 Tankstellen

und läuft vorerst mal... ob es Aktualisiert weis ich erst morgen!!
Nur möchte ich den Preis von der Shell in Perg und in Mauthausen wissen
und in Arbing vom Breiteneder!
Ich habe zwei Standorte gemacht

1. Perg Shell
2. Arbing Breiteneder

Sie sind wohl nicht bei den 5 günstigsten dabei!
was mach ich da? gibt es da eine lösen... oder einfach nur Pech gehabt!

@Homoran sagte in Skripten des E-Control Spritpreisrechners:

Du muss nur unter Num statt der 0 weiter hochzählen.
URL bleibt überall gleich
Regex jeweils bei Name und preis gleich

muss ich mich da auskennen was ihr da macht..
das ist wieder völlig anders?

[Negalein]

@SmarthomeMF sagte in Skripten des E-Control Spritpreisrechners:

Sie sind wohl nicht bei den 5 günstigsten dabei!
was mach ich da? gibt es da eine lösen... oder einfach nur Pech gehabt!

Ich tipp mal auf Pech gehabt, da es von der e-Control nicht vorgesehen ist, mehr als 5 mit Preise anzuzeigen.

[sigi234]

@SmarthomeMF

Hm... hast du jetzt das Skript genommen?

[sigi234]

@Negalein sagte in Skripten des E-Control Spritpreisrechners:

@SmarthomeMF sagte in Skripten des E-Control Spritpreisrechners:

Sie sind wohl nicht bei den 5 günstigsten dabei!
was mach ich da? gibt es da eine lösen... oder einfach nur Pech gehabt!

Ich tipp mal auf Pech gehabt, da es von der e-Control nicht vorgesehen ist, mehr als 5 mit Preise anzuzeigEN

Das Glaube ich auch, aber die 5 sind auch Ok.

[SmarthomeMF]

gibt es nicht was wie der Tankerkönig!!
wo ich meine ca 8 Tankstellen eingebe und der preis wird angezeigt?
Ein Preisunterschied von 0,05€ ist sowieso egal!!
mein Auto brauch 10-20l/100 KM Benzin und da brauche ich keinen Umweg von ca 5 KM fahren!!
das ist nicht rentabel.

[Negalein]

@SmarthomeMF sagte in Skripten des E-Control Spritpreisrechners:

gibt es nicht was wie der Tankerkönig!!

Nein, gibt es für uns nicht.
Bei uns können wir schon von Glück reden, dass die e-Control überhaupt die API zur Verfügung stellt.

[Homoran]

@sigi234 sagte in Skripten des E-Control Spritpreisrechners:

Wie ist die RegEx für: Adresse oder die anderen Datenpunkte?

Konntest du das nicht 10 Minuten früher fragen.

Jetzt ist der pc aus und ich bin nur noch mit dem tablet im bett

Strasse

ss":"(\D+\d+)","

PLZ

de":"(\d+)","

Ort

ty":"(\D+)","

[metaxa]

Guten Morgen in die Runde!

Danke Homoran für deine Lösung, anfangs bin ich an der Synatx gescheitert :-)

Zur Erklärung:
Der Unterscheid zwischen der alleinigen Parserlösung und dem Scriptgedanken von "steinejo_io" (Eingangspost) liegt in der häufigen Abfrage der API Schnittstelle.

• Das JS holt sich 1x den kompletten JSON und zerlegt ihn dann.

• Für eine Tankstelle werden in Rainers Parserlösung - ich glaub 5x (name, PLZ, citiy, Strase, Preis) die URL abgefragt. Also bei 5 Tankstellen rund 25x und das wahrscheinlich kurz hintereinandert weil der Parser gleiche ms hinterlegt hat. Deswegen schreibt Rainer auch

Bedingung ist, die Reihenfolge in dem json bleibt unverändert, und man will nur wenige Stationen monitoren.

@SmarthomeMF
Das Script reagiert auf irgendeine Änderung der JSON. Wenn du diese Änderung nicht erzwingst (z.P. im Parser auf boolen umstellen, speichern, kontrollieren, wieder zurückstellen, speichern) dann musst du warten bis sich die abgefragte URL von selbst ändert.

LG, mxa

[sigi234]

@metaxa sagte in Skripten des E-Control Spritpreisrechners:

Danke Homoran für deine Lösung, anfangs bin ich an der Synatx gescheitert

Ich auch, habe es mal in den Parser eingebaut...........muss überlegen wie das in Vis einbaue, da die Tankstellen sich ja immer ändern. Also Zuordnung von Name, Strasse, Ort, Plz,Preis........

[Negalein]

@sigi234 sagte in Skripten des E-Control Spritpreisrechners:

Ich auch, habe es mal in den Parser eingebaut...........muss überlegen wie das in Vis einbaue, da die Tankstellen sich ja immer ändern. Also Zuordnung von Name, Strasse, Ort, Plz,Preis........

Ich hab jetzt mal 1 Tankstelle mit Regex (PLZ, Ort, Preis, Name) eingetragen.
Da ist mir aufgefallen, dass PLZ nicht zum Ort passte. Preis war zur angegebenen Tankstelle auch falsch.

Mit JSON und JS passt es.