I'm trying to create an FTP server with Node Red on the node-red-contrib-ftp-server
where its working. The screen shot below is the ftp node ingesting some data I sent to the Node Red server via FT.
The debug for the what the data looks like is a confusing, highlighted yellow on the right hand side above.
Ultimately this is what the data file looks like in Excel:
Can someone help me understand:
-
Do I need a JavaScript function block to recreate the data structure of the csv file? Its time series data of an electric meter
-
- Would anyone have tips for saving the data? I dont know a lot about data bases, is there any easy one to work with for the newbie? What I am hoping for is to find some solution that I can implement where an electric meter csv file will get uploaded via ftp to the Node Red ftp server ONCE PER DAY (or something similar) and the data can be continuously appended to a database; where then on some future date I can retrieve the data on hopefully somewhat of an easy process.
Any help and tips, links to tutorials greatly appreciated. I don't have a ton of JavaScript experience.