Trying to read .dat Files from Actaris

Forum Rules

Before commenting read Forum rules

Don't comment the topic if you have a new question.

You can create a new topic selecting correct category from Gurux Forum and then create a new topic selecting "New Topic" from the top left.

By spuentesp , 29 March, 2018
Forums
General discussion

Hi,

i'm a software engineer specialized in front-end and middleware, so i know absolutely nothing (except from what google taught me) about smart meters, electrical metering, etc.

We have a client that needs to read dat files. As far as i know, these DAT files are converted to Excel files by a software called "Notus XLS" from Actaris. We can't open the files directly with excel. they must be converted.

for now, we have only the information in the beggining of the file, that we can read using a HEX editor:

NOTUS1_DATAFILE☺.▬...ç←..DLMSADDR=17;USER=LABORATORY;MAE=METERID;. MODE=2;FONE=33574406;MTYPE=1;UserInit=;WS=7;MODE2=. 30040258. 02030001. ......2.30. 3 wire AUTODETECTION.

The rest of the file is gibberish.

Is there a library, software, or utility that can allow me to extract the data WITHOUT using the Actaris Notus XLS? we need to convert files in bulk (about 20.000 files), and the actaris software is 100% manual.

If this is not the place to ask this, please excuse me.

Thanks!

Kurumi

8 years 2 months ago

Hi,

I don't know the structure of dat files. You can use our software to read data directly from the meters. I believe you should aks this information from the meter vendor. I'm sorry to say, but support usually from meter manufacturers is really bad.

BR,
Mikko