I am running Gurux.DLMS.AMI with MSSQL database. When I read Profile from meter, there are in "Value" table string in xml format ( type of table is varchar(max)):
<Structure> <None/> <UInt8 Value="0" /> <UInt32 Value="16" /> <UInt32 Value="4" /> <UInt32 Value="8" /> <UInt32 Value="0" /> <UInt16 Value="240" /> <UInt16 Value="239" /> <UInt16 Value="241" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="1000" /> </Structure>
There should be Clock ( OBIS 1.0.0 ) as first value, but there is <None/>
When I read this profile, the first record has right value ( in octet string }
<Structure> <OctetString Value="07 E3 0C 16 07 06 0F 00 00 FF C4 00" /> <UInt8 Value="0" /> <UInt32 Value="12" /> <UInt32 Value="0" /> <UInt32 Value="4" /> <UInt32 Value="0" /> <UInt16 Value="241" /> <UInt16 Value="240" /> <UInt16 Value="241" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="1000" /> </Structure>
but every other record has <None/> . I know, that every record is 15 minutes after previous, but it will be better with real Clock value. The best, with no octet format.
I try it only with MSSQL now. Maybe some test on linux with MariaDB will show something else.
I need to check if date-time can be saved in textual format and not octet string. It'll help a lot, but the main problem is that data is lost, example is DST used.
Hi,
Hi,
Are you reading Iskra meter? Iskra is saving bytes and date-time is null except for the first row when data is read. This is not DB depending issue.
BR,
Mikko
Yes, it is Iskra meter. I
Yes, it is Iskra meter. I must count it from first line.
Thank You.
Hi,
Hi,
I need to check if date-time can be saved in textual format and not octet string. It'll help a lot, but the main problem is that data is lost, example is DST used.
BR,
Mikko
Hi,
Hi,
There is a new version where support for Iskraemeco is improved.
BR,
Mikko