Thanks, what do you mean by snapshot a video file?

@@csongorvarga With refer to your another most fantastic ever video tutorial kzfaq.info/get/bejne/n86KitV70sirdo0.html In which, it does not play video clip on the Nodered UI but snapshot only with the previous image only. This new video tutorial given me an idea that it is good to have such file retriever for images and video, save as backup and image&video quick view. U r too brilliant...

Check the two CSV node as well. On both of them you have to list the columns you want to save. Those names have to match with the attribute names you add to the msg.payload in Set Data.

What do you mean. This is Node-Red and the Node-Red Dashboard. I just used the features available there.

@@csongorvarga Yep but the way you use it is amazing! Im new with node red so im still figuring things out. Just found your video for "Browsing files in dashboard". Thanks bro love your work! 👍

@@ahmadhafidzmuhdmawardi5743 Yes, it needs a lot of thinking, because you need to design the UI differently in order to accommodate the framework.

@@csongorvarga Yeah but i can say its been really enjoyable learning it. Just a question if you have the time, im currently trying to use the date picker to select a range of dates (for example between 24th November to 28th), then merge the csv files of those dates and display it on a chart. If you have the time i would appreciate some tips or references that would help😁

Also have this problem, file upload block give out this error message: /home/pi/log_upload.sh: No such file or directory". Author, please help! Thank You!

Yes, you are right. What I would do that when the temperature and the humidity comes in, store them in flow variables. And when the pressure comes, put the pressure into the data structure along with the temp, humidity which is stored in flow variables. Technically the readings are going to be still slightly off, but I assume these measurements come in close to each other.

Thanks. My source was not MQTT and the data came this way. But if you are getting the data via MQTT, it can simply be just msg.payload. It really depends on what you get via MQTT. If your device sends multiple values in a single MQTT topic, for example in JSON format, you can use the JSON node to convert the JSON to a Javascript object, and you can reference to the various fields like msg.payload.temp, or msg.payload.humidity (depending on how your data looks like). But if it comes through in several MQTT topcis, it is different. In that case need to store the data in flow variable (e.g. send them to a change node where you set "Set" "flow." "something") to each of them, except one. And send one of the MQTT to Send Data, and in the code "temperature": msg.payload; so this mqtt will be stored in the temperature column, and on other lines "humidity": flow.get("something"); so that will fetch the last stored value in the "something" flow variable and store it in the humidity column. And so on as many as you need. Setting the time on the raspi, first make sure the timezone is set correctly (sudo raspi-config and it is under Internationalization options) and after you can use the date command like sudo date -s "2016-10-16 21:00". I never set time manually myself, but Google says this is the way to do it.

@@csongorvarga thank you so much for the quick answer! date changing worked perfect. but the other problem i can´t solve.. don´t know what i am doing wrong.

@@lovelyKINDofGIRL Which one is the other problem? What did you change so far?

@@csongorvarga I changed the Set to and i fixed it with just separating everything. But now I want to have the real time and seconds in my csv. Do you have an idea how to change timestamp into it in the "set to" node? Thanks in regard!

@@lovelyKINDofGIRL What do you mean real time?

This is the formula to convert unix timestamp to Excel date: (A1/86400)+DATE(1970,1,1)

@@csongorvarga thank you very much for the very fast reply. I had found this formula too, but it doesn't work and I can't understand why

@@emanuelegiuliani2385 Oh yes, because it is =(A2/86400000)+DATE(1970,1,1). I just tried myself. Unix timestamp is milliseconds and not just seconds.

@@csongorvarga it work with =(A2/86400000) + DATA(1970;1;1) (excel in ita and ; ) thank you so much!

From the Palette Manager, it is called node-red-contrib-fs. I talk about it somewhere in the video.

You can just have copy and paste this flow multiple times and change the file pattern in the function node. I do the same.

@@csongorvarga I saw you have two devices on the turorial. They are publishing to two different topics right? each topic with it's subtopics (temp, Voltage). What it's still not clear it's how the flow knows in which CSV to write the data, maybe looking at the device ID? I will have 5 different Wheater Stations for a personal project and this flow is like perfect for me, except i still have doubt on how to handle the MQTT messages, like, is one single flow enough to handle different devices or i must have a flow for each device. Anyhow, i'm so happy to have found your Channel, it's probably the best Node-Red content in KZfaq for sure.

@@exprymer If you have a lot of different topics, probably the best to do, that you save each payload to a different flow or global variable. That will always update and keep the latest value in those variables. And in the "Set data" function, you can recall the data from those flow variables. Like msg.payload = { "timestamp": now.getTime(), "temperature": flow.get("temp"), "humidity": flow.get("humidity") }. I did not have to do that because all the data I wanted to save was in a single object in one payload. So I could extract all of them at the same time.

you could use regular expressions aka regex

It is not part of the default installation. Click on the hamburger menu on the right, Manage Palette, on the Install tab, enter node-red-contrib-fs and install the new node. Once it is installed you can import the flow without error.

Which node you get this? On the "File Lister" node?

@@ramsai0268 what about it?

I am not sure about the username and password part. I don't know how it works under linux, in Windows you can maybe map it as a new driver with the user credentials, so anyone accessing the drive will not need to enter user and password again. Maybe something similar exists in Linux as well. The file name is getting generated in the function node. You can easily add a flow variable there. I show in the video where and how the file name is getting generated.

In one column? In Excel? Is it possible that your have a different field separator set in your windows settings as in the CSV file? How the CSV file looks like when you open it in notepad?

@@csongorvarga thank you very much for the fast reply. You are correct, in my country there are other settings in excel

Sure. You can save the readings in a flow variable. And have a separate inject that triggers let's hourly and get the latest reading from the flow variable.

@@csongorvarga well, I added a "join" node between "set data" and "filename generator". The join node is set to "Array" and generates an output every 60 inputs. This does the trick so far. Need to verify the data but looks good at the Moment...

No, I don't. But I have used modbus TCP for other devices in the past, and the modbus node for Node-Red is pretty good.

@@csongorvarga Pode enviar o link da Aula Modbus TCP?

Probably the easiest way to do is to log the data in your own server and use the exec node to start a shell script which FTPs the data onto your remote server.

What is your issue?