We have a machine that sends a csv every 30 seconds with this data:
Date,Time,speed
2022/10/07,08:01:00,36
My goal is to create a Node-Red flow that reads the content of the file and then send it to MQTT. The only thing "that matters" is the speed. If I have a few seconds between the time in the csv and the time in the MQTT is not a problem.
The problem is that my knowledge in Node-Red is very basic. I tried to get the data from the FTP but with no luck. I think the goal will be using functions (I guess) but as I said I'm very limited at this point.
Is reading the file via ftp the only way of accessing the data? Does the machine support modbus for example?
If you need to fetch it by ftp then first make sure you can do that using an FTP client on a PC. Then you should be able to do the same in node-red. I have not had much success with the FTP nodes though, so when I needed to do this I used Exec nodes to execute the required command line ftp commands.