Skip to main content
Home
for DLMS smart meters

Main navigation

  • Home
  • Products
  • About us
  • Open Source
  • Community
  • Forum
  • Downloads
User account menu
  • Log in

Breadcrumb

  1. Home
  2. Tip To Use Collected Data In Other Applications

Tip to use collected data in other applications

By VegardS, 17 March, 2025
Forums
Gurux.DLMS.AMI

First of thank you for providing these excellent tools open-source!

I have successfully running the AMI4 in docker and connected it to MySQL (MariaDB) and a meter (Cewe Prometer 100). Imported the Device Template form GXDLMSDirector with some COSEM-objects.
Running fine!

But I have a "missing link" in my knowledge to get access to the data from other applications.
I thought that I could query the SQL database but i seams hard. And it also seams difficult thought the REST also.

I wish to retrieve the data from a ProfileGeneric Object with time and data. Preferably with option of time-range.

Could you give me a tip on the way?
Below is a snippet by inspecting the COSEM object. I have already run the read command, collection approx 7 month of 15 minutes interval data 


  
1.0.99.1.0.255

 
LiFo
  
   
   
   
   

0.0.1.0.0.255 
Ch. 0 Clock object #1

1.0.1.29.0.255 
Ch. 0 Sum Li Active power+ (QI+QIV) Time integral 5

1.0.2.29.0.255 
Ch. 0 Sum Li Active power- (QII+QIII) Time integral 5

1.0.129.29.0.255 
Man. specific

1.0.130.29.0.255 
Man. specific

1.0.5.29.0.255 
Ch. 0 Sum Li Reactive power QI Time integral 5

1.0.8.29.0.255 
Ch. 0 Sum Li Reactive power QIV Time integral 5

1.0.6.29.0.255 
Ch. 0 Sum Li Reactive power QII Time integral 5

1.0.7.29.0.255 
Ch. 0 Sum Li Reactive power QIII Time integral 5

1.0.9.29.0.255 
Ch. 0 Sum Li Apparent power+ (QI+QIV) Time integral 5

1.0.10.29.0.255 
Ch. 0 Sum Li Apparent power- (QII+QIII) Time integral 5

1.0.96.5.4.255 
Ch. 0 Internal operating status (status word #4)

 

12/4/2023 12:15:00.000 AM

0

0

0

0

0

0

0

0

0

0

1

Profile picture for user Kurumi

Kurumi

2 months ago

Hi, You can use the Swagger…

Hi,

You can use the Swagger to show the REST interface. The address is something like:
https://localhost:8001/swagger

You can read the value using api/Value/List API.

BR,
Mikko

  • Log in or register to post comments
  • Create new account
  • Reset your password

Hire Us!

Latest Releases

  • Tue, 05/20/2025 - 08:40
    gurux.dlms.c 9.0.2505.2001
  • Mon, 05/19/2025 - 10:19
    gurux.net.java 1.0.30
  • Mon, 05/19/2025 - 10:00
    gurux.dlms.c 9.0.2505.1901
  • Thu, 05/15/2025 - 16:26
    gurux.dlms.c 9.0.2505.1501
  • Wed, 05/14/2025 - 08:30
    gurux.dlms.c 9.0.2505.1401

New forum topics

  • Reading all "Data" object type parameter together
  • com_read getting failed for billing profile and instantaneous profile
  • Simulator connection closed
  • Regarding the dlms android project
  • Issue with "ServiceError Initiate Error exception. Service UNSUPPORTED"
More
RSS feed
Privacy FAQ GXDN Issues Contact
Follow Gurux on Twitter Follow Gurux on Linkedin