My goal is to make a sort of time-keeper wich logs the coming and going of about 10 people who are working at our place.
With ESPhome i already setup a RFID Tag-reading terminal, in HA i can setup those tags and
my wish is to let HA create a excel file wich will be always updated when a tag was scanned.
In the excel file there should be rfid-id,date,time, status(coming or going).
Is an Automation wich can create a file possible?
You can indeed create an automation which can log event time and RFID to a file using the command line integration. You can even put this file in the public HTTP directory of Home Assistant, so that you can download it from anywhere at any point in time. This file will not be an Excel file, but you can then write a bit of Python to turn this into a CSV file, which can then be imported (or used as a data source) in Excel.
Alternatively you can use the Google Sheets integration to write your row of data on every event out to a Google Sheet.
Would it be possible to control a short LED strip with D1 mini or something, that individual LED represents workers (changes colour when they’re in/out).
When all the workers are out, arm the alarm.
And when at least 1 worker come in, disarm.
And then use this to output all the changes to the google sheet to track the working time?
I need help with the first part thou, LED strip and programming the arm/disarm automation.
I got the google sheet working with door sensors logging.
The coming/going switch is connected to A0, because of no more GPIOs …
The LCD is a 5V LCD with a diode in vcc, to get a good contrast.
the on_tag sensor is send to HA, there is an automation wich decides on tag id who is coming in / going out.
It makes an append-csv-file with date, time and name wich will be sorted in future by an js.
So far it works very well since 02.12.2022.
All our people that work for us have saved their times into that csv file.
if you wonder why the brighness of the lcd-background-led is set to 1 when rfid-tag is scanned and turnt to 240 : the background led is connected to vcc and gpio, so the less the pwm so brighter the led.
So the display gets dark if nothing happens and gets bright when someone holds the rfid chip to it.