Node Red TrashDate

Installation

npm install @aingtii/node-red-trashdate

Node Description

A node that read an CSV File and generate Date, Type and count the days for next and overnext Date of Trash.

Preparation

1. create an CSV File with two colums
2. Line 1: col1;col2
3. next lines: Date;TrashType

|Example CSV File | |--------------------------------| |col1;col2 | |05.01.2024;Yellow Bag | |12.01.2024;Blue Trash | |19.01.2024;Brown Trash | |...;... and so on (whole year) | | |

see example file Kalender.csv

4. save this file in a folder that NodeRed has access

Settings:

1. CSV File: path of the CSV File (mandatory) like: /opt/iobroker/trashcalendar.csv
2. Name: you can set a name of the node (optional)

Inputs:

|Inputs: | |----------------------------------------| |just inject, with repetition every Day |

Outputs:

|Outputs: | | |---------|-----------------------------------| |Output 1 | Date (col1) of next Trash | |Output 2 | Type (col2) of the next Trash | |Output 3 | Days until next Trash | |Output 4 | Date (col1) of overnext Trash | |Output 5 | Type (col2) of the overnext Trash | |Output 6 | Days until overnext Trash | |Output 7 | Special Output (Setup) |

Output 3 & 6 setup:

here you can change the output value of Output 3&6 by default is what you see as placeholder (grey)

Special Output 7

This Output is specialy for users of Homematic Mediola AIO Crerator so you can visible or unvisible a trash icon with this output

This Output you can Setup in the properties for Today, Tomorrow and for other Days...

Example: Today => Heute Tomorrow => Morgen alle other Days => Leer

so in AIo Creator you can visible or unvisible a trash icon with this output Like this:

Example Flow

Example Flow

... [{"id":"7da36d25d832619e","type":"inject","z":"61b3b2b50abe2c5d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"00 00 * * *","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":410,"y":720,"wires":[["8aa8da39274203af"]]},{"id":"1ed27416fdf65289","type":"debug","z":"61b3b2b50abe2c5d","name":"Date 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":810,"y":600,"wires":[]},{"id":"abf287d26d38c692","type":"debug","z":"61b3b2b50abe2c5d","name":"Type 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":810,"y":640,"wires":[]},{"id":"beab9eae83db9f1e","type":"debug","z":"61b3b2b50abe2c5d","name":"Days 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":820,"y":680,"wires":[]},{"id":"f02060b5f9b31977","type":"debug","z":"61b3b2b50abe2c5d","name":"Date 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":810,"y":760,"wires":[]},{"id":"7712f374dbd741f7","type":"debug","z":"61b3b2b50abe2c5d","name":"Type 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":810,"y":800,"wires":[]},{"id":"0b2a4fee274720b7","type":"debug","z":"61b3b2b50abe2c5d","name":"Days 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":820,"y":840,"wires":[]},{"id":"8aa8da39274203af","type":"TrashDate","z":"61b3b2b50abe2c5d","name":"","filename":"/opt/iobroker/Kalender.csv","heute":"","morgen":"","weitere":"Blende das Blöde Ding aus","day0":"","day1":"","day2":"","day3":"","day4":"","day5":"Bernd Versteht es nicht","day6":"","day7":"","day8":"","day9":"","day10":"","day11":"","day12":"das Versteht Bernd nicht","day13":"","day14":"","day15":"","x":590,"y":720,"wires":[["1ed27416fdf65289"],["abf287d26d38c692"],["beab9eae83db9f1e"],["f02060b5f9b31977"],["7712f374dbd741f7"],["0b2a4fee274720b7"],["6a3a563662393349"]]},{"id":"6a3a563662393349","type":"debug","z":"61b3b2b50abe2c5d","name":"Special","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":820,"y":880,"wires":[]}]

...