Home-Assistant integration of 'Abfall.IO' waste collection dates & schedule

Wow, that are major improvements. Is it OK if i adapt my script with your changes and update the snippet on my blog? I would of course link back to this thread here.

Thanks and cheers
Tom

Yes, of course it’s okay.

Great, thanks!

I changed my blog post and also added my notification configuration (i get one day before pick up an Telegram notification to bring the rubbish out).

Changed blog post should be online in few minutes…

Cheers
Tom

Hi together,

thanks for the nice write up! Was interested in a way to track garbage collection for my place and managed to setup the component. Still, I am currently struggling with getting the right IDs for my location.

Could someone give me a hnit on how to get them, as I was not able to extract them from either Homepage or App. Or did I miss some point in the instruction?

Thanks in advance!

Hi,

from which city are you? Can you give me the link where the “Abfallkalender” can get generated for your city. I try to generate the right ID’s for you.

Cheers
Tom

Hi Tom,

thanks for your offer. It would be the following site: https://www.wuerzburg.de/themen/umwelt-verkehr/vorsorge-entsorgung/abfallkalender/index.html
But if I got the right impression, they are using a different API to generate the calendar. So it seems I will have to do some work on my own :wink:

Regards,
Nils

Hi Nils,

you are right, it seems they use something proprietary. But as far as I see its fairly simple to extract the data from them. If you open the Developer Tools in Google Chrome on the page, and then select the correct values, you get an Ajax request to this URL (I took random data):

https://www.wuerzburg.de/themen/umwelt-verkehr/vorsorge-entsorgung/abfallkalender/index.html?_func=evList&_mod=events&ev[start]=2018-12-24&ev[end]=2019-02-03&ev[cat]=&ev[subcat]=&ev[addr]=19939&ev[search]=&_y=2019&_m=01&recon=p6ehg218vh6hks4rdi9illmi98&_dc=1546369043376

If you open the URL you get the data without further manipulation.

Cheers
Tom

I uploaded a small update to reflect an issue with “in 1 Tagen” which is incorrect.
The code now adds heute/today, morgen/tomorrow or “in X Tagen”/“in X days”

Is it possible to read the dates from a pdf or a ics export file?

you dont need to, you just need to replace the “pdf” or “ics” in the request URL with “csv”.

I have to use an other site for collecting the dates and there is only the possibility to get the dates as pdf / ics.

Example:
https://www.awigo.de/index.php?eID=awigoCalendar&calendar[method]=getPDFfile&calendar[locationID]=648892001&calendar[cityID]=5337001&calendar[address_full_street]=Heideweg%202&calendar[address_full_cityplz]=Belm%20(49191)

I tried to manipulate the URL and it seems you cant get CSV files with this service.

I think its quite hard to parse PDF’s. I reckon its easier you parse the ICS file. But you need to write a custom parser for this.

Sorry I cant help you here.

Thanks, no problem. I already implemented a solution for my waste collection (via google calendar). Working fine but an addon with collecting data from a web url is much better than manually adding the ics to the calendar.
When I have some time I am going to parse the ICS file…

Hi Tom,

I came to the same conclusion and was able to adapt the component to use the json I recieved via the Ajax request. Component is working fine now.

Thanks for the help,
Nils

I had a strange bug. The order of the columns in the response no longer matches the payload. Therefore I had wrong data. I fixed it by saving the index from the first line in a dictionary.
If someone else has the same problem:

        rowCounter = 0
        columns = None
        gelberSack = []
        restAbfall = []
        papierTonne = []
        bioTonne = []
        problemStoffMobil = []
        
        for row in reader:
            if rowCounter == 0:
                columns = {k:row.index(k) for k in row}
            else:
                if (row[columns["Biotonne"]] != ""):
                    bioTonne.append(datetime.strptime(row[columns["Biotonne"]], "%d.%m.%Y"))

                if (row[columns["Restmülltonne"]] != ""):
                    restAbfall.append(datetime.strptime(row[columns["Restmülltonne"]], "%d.%m.%Y"))

                if (row[columns["Papiertonne"]] != ""):
                    papierTonne.append(datetime.strptime(row[columns["Papiertonne"]], "%d.%m.%Y"))

                if (row[columns["Gelber Sack"]] != ""):
                    gelberSack.append(datetime.strptime(row[columns["Gelber Sack"]], "%d.%m.%Y"))

                if (row[columns["Problemstoffmobil"]] != ""):
                    problemStoffMobil.append(datetime.strptime(row[columns["Problemstoffmobil"]], "%d.%m.%Y"))                        

            rowCounter = rowCounter + 1

Thanks for publishing this. I changed the code at home with your recommendation. Just in case the change the order of values in Landshut too :slight_smile: works like a charm.

if its okay, i publish the changed code on my blog.

cheers
Tom

Of course :slight_smile:

I changed the date comparisons from

if nextDate > datetime.now():

to

if nextDate.date() >= datetime.now().date():

It showed me the next date when the actual date is today on HA restart.

Thanks for this component!

Hi,

I have a google calendar integration with the dates. Is it possible to modify your module to use this google calendar? Right now I have 3 entities from the google calendar with dates but I also want to see how many days and so on.

The Date of one of these entities in found in an attribute. For Example the entity name is calendar.abfall_papier and in the atribute “start_time” is the date.

Thanks and cheers

alex

Hello,

I am pretty new to HA and just found this integration. My town works with the MyMüll App but also has a script on the homepage to get to the collection dates. Could anyone help me to find out if this website could be integrated and how:
https://abfallservice.kreis-hoexter.de/kundencenter/abfall-kalender/index.html

Thanks for your help
Berni