• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[SOLVED] Storing data on a (remote) database
#11
Hello,

Thanks for your help.

I am able to create databse now ,. I have connected netPI to Ethernet/IP Master & reading data from master & storing into database. Below attached some screenshot of data when I click on read database, 

BR

Madhumati


Attached Files Thumbnail(s)
   
  Reply
#12
Best feed back for the day Madhumati. Thank you very much for your effort. I think it is a good project for others too and I should shift the thread better to the "project" folder than to "software" folder where it is located now.

Thx
ARmin
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#13
Here I get timestamp as time"2019-05-30T09:10:02.289Z"
date matches correct  ,but the time not matching with my system time & netPI 
Is something wrong here?/missing?

BR

Madhumati


Attached Files Thumbnail(s)
   
  Reply
#14
Yes you missed to set the timezone in the container while you started it. Seach word "timeout" in forum and you will find help.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#15
Hello Armin,

Regarding TimeZone , I checked on Influx DB, It mentions for NTP synchronization time which I am missing here that may be cause I am not getting correct timestamps. I will try to do NTP synchronize later & test this again.

meanwhile my customer wants further the database object data(read in node-red debug )  to be displayed over dashboard , what can be best way for this?is any suggestion?

Thanks
BR

Madhumati
  Reply
#16
Hello Madhumati,

Node-RED includes very good embedded dashboard in case you install the Node-RED node named "node-red-dashboard" additionally.

For a good impression how powerful it is: here is the home page link of the node https://flows.nodered.org/node/node-red-dashboard

After installation you have about 16 additional nodes to create a perfect local visualization on netPI in Node-RED.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#17
There are many Youtube videos such as this https://www.youtube.com/watch?v=X8ustpkAJ-U explaining the usage of the dashboard.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#18
Hello Armin,

As of above i was able to see data into Node-RED when I click upon 'Read Database ', 
Now further in order to see the data into the remote database server , what should be the procedure?
how we can link the data from node-RED to remote InFlux DB database? any guidance?

Thanks in advance.
BR
Madhumati
  Reply
#19
Hello Madhumati,

your InfluxDB remote database server will have an IP address for sure, right?

So first of all your Node-RED device needs to be physically networked to this InfluxDB database server over an IP network.

And finally you have to configure your InfluxDB read/write node with double click under "server/host" settings with the corresponding IP address of your InfluxDB server at standard port 8086. Furthermore you gave your database a name for sure when you installed it. So you have to enter the database name in the node settings as well. And also your database server will have an admin user and password. These credentials you have to enter as well into the node setting.

After you set everthing right, any read/write access will be addressed to the Influxdb remote database server. This is the easiest setup I have ever seen to be honest.

Thx
Armin
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
Information [INFO] - InfluxDB - Time series database under Windows patrick 0 64 May-28th-2019, 02:10 PM
Last Post: patrick
  Fetch data from S7 PLC Profibus DP MGharat 3 30 March-14th-2019, 11:21 AM
Last Post: Armin@netPI
  Secomea Remote Acccess ballesj 1 157 May-15th-2018, 12:42 PM
Last Post: Armin@netPI
  IBM sensor data historian and analytics engine for the netPi AlexKoeMuc 0 84 November-28th-2017, 01:39 PM
Last Post: AlexKoeMuc

Forum Jump:


Users browsing this thread: 1 Guest(s)