Description: Create an excel uploader within Node-Red to be able to upload shift information. Generate a table within Influx which uses the latest uploaded shift information for each time period.
1. Excel Uploader to handle the following columns
Supervisor Name (string, free text)
Shift Start (Datetime)
Shift End (Datetime)
Shift ID (String, Dropdown list A,B,C,D)
Number of people on shift (Int)
The shift data should be added as a new Data_Type in Influx called ‘Shift_Data’
A query should be created to pull the last uploaded shift data for each time period – for example if yesterday I uploaded shift data for 22/07/21 and the shift ID was ‘A’, then today I reuploaded for the same time period and the shift ID was ‘B’, then the query should identify the shift ID as ‘B’.
Write a query to map the shift ID to the continuous data so that all data points can be attributed to a shift – e.g. for each timestamp in the continuous data there will be a field tag ‘Shift’ and ‘_value’ is set to the corresponding shift
Hi, there I am a senior cloud engineer with a strong experiences in Monitoring platform, especially focusing on Node-red, influxdb proficient with flux query and influx query competent at building TICK script and TIG s Plus
3 freelances font une offre moyenne de 162 £ pour ce travail
Hello I’m Professional Web Developer ,designer & Programmer. I am absolutely sure that I can do the project very well. Thank you