• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[SOLVED] Storing data in 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


Possibly Related Threads...
Thread Author Replies Views Last Post
Information [INFO] - InfluxDB - Time series database under Windows Patrick@netPI 0 48 May-28th-2019, 02:10 PM
Last Post: Patrick@netPI
  Fetch data from S7 PLC Profibus DP MGharat 3 25 March-14th-2019, 11:21 AM
Last Post: Armin@netPI
  Secomea Remote Acccess ballesj 1 156 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: 3 Guest(s)