• 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
#20
Are there any chances you can help me with a database? I own a car rental business with almost 60 vehicles. The main difficulty is to memorize which cars are available and which are rented. I have a database, but the information within is structured poorly, and with no sense. I have no idea how to structure the information properly to see what cars are available. My friend suggested finding companies online that deal with lead data enrichment. They usually sell already-created databases with all the necessary information. What do you think?
  Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Information InfluxDB - Time series database under Windows patrick 1 4,133 February-1st-2021, 07:13 PM
Last Post: Armin@netPI
  Read/write data from S7 with netPI over Profinet student 10 9,438 September-9th-2020, 04:59 PM
Last Post: Armin@netPI
  Send Data to Specific Port via UDP Hoeber 2 3,359 July-29th-2020, 09:10 AM
Last Post: Hoeber
  TOSIBOX enables netPI remote access from anywhere jkrimpenfort 3 6,257 July-18th-2020, 06:35 AM
Last Post: Armin@netPI
  PROFINET to OPC UA data conversion with Node-RED Armin@netPI 0 3,481 July-7th-2020, 12:20 PM
Last Post: Armin@netPI
  Getting data from AllenBradley PLC MarcoMedina 3 4,037 February-26th-2020, 11:53 AM
Last Post: Armin@netPI
  Fetch data from S7 PLC Profibus DP MGharat 3 3,682 March-14th-2019, 11:21 AM
Last Post: Armin@netPI
  [SOLVED] EtherCAT Slave snortman 5 5,755 February-7th-2019, 07:36 AM
Last Post: Armin@netPI
  Secomea Remote Acccess ballesj 1 7,538 May-15th-2018, 12:42 PM
Last Post: Armin@netPI
  IBM sensor data historian and analytics engine for the netPi AlexKoeMuc 0 2,275 November-28th-2017, 01:39 PM
Last Post: AlexKoeMuc

Forum Jump:


Users browsing this thread: 2 Guest(s)