Sensus ftp server and iPerl meters

sdg.marinusvz
2023-11-10 14:23
Last Edited 2023-11-10 14:26

This was transcribed from a support call

Are these files valid for uploading via the Sensus ftp server entity?

(GTW_40BD32258B30_RDS_20231103_193313.csv)

And what is the proper index in the add dialog for the meter serial number?

METER_ADDRESS, READING_DATE, READING_VALUE_L, LOW_BATTERY_ALR, LEAK_ALR, MAGNETIC_TAMPER_ALR, METER_ERROR_ALR, BACK_FLOW_ALR, BROKEN_PIPE_ALR, EMPTY_PIPE_ALR, SPECIFIC_ERROR_ALR

1012-113-8326,20:11:05 03/11/2023,414521,0,0,0,0,0,0,0,0

1012-113-8086,20:11:03 03/11/2023,633615,0,0,0,0,0,0,0,0

1012-113-8555,20:05:42 03/11/2023,341084,0,1,0,0,0,0,0,0

1012-032-0999,20:11:14 03/11/2023,357524,0,0,0,0,1,0,0,0

1012-045-2410,19:36:08 03/11/2023,1601359,0,0,0,0,1,0,0,0

1012-043-8887,19:38:23 03/11/2023,2251197,0,1,0,0,1,0,0,0

1012-043-9209,20:11:12 03/11/2023,1688557,0,0,0,0,1,0,0,0

1012-043-8899,19:36:21 03/11/2023,622462,0,0,0,0,1,0,0,0

1012-032-1055,20:11:14 03/11/2023,984366,0,0,0,0,1,0,0,0

1012-043-9720,20:11:02 03/11/2023,374577,0,0,0,0,1,0,0,0

1012-045-1791,20:11:14 03/11/2023,785471,0,0,0,0,1,0,0,0

1012-043-9598,20:11:03 03/11/2023,715154,0,0,0,0,1,0,0,0

sdg.marinusvz
2023-11-10 14:25
Last Edited 2023-11-10 14:34

For the iPerls, we ignore the index in the add dialog, we always use the first column (index 0) for the serial number of the meter.

If the filename has GTW in it, we assume it is an iPerl.

We accept csv files or zip files, generally for the iPerl we accept the RDS files and ignore the RAW files.

For iPerls, we always take the second column (index 1) as the time and date, in the format as per your example, and the third column as the reading (index 2).

For iPerl, we conflute E1 and E2 into one register, that can go up or down.

iPerls do not start disabled (we basically add the meters in the Sensus file the first time the Sensus Ftp entity receives readings for it). So for iPerls, the default pulse weight is 0.001, since it is in liters, but pnpscada is in kilo liters. And therefore they are created with Primary Metering set to No.

furthermore, the iPerl has hardcoded events after that as follows:

LOW_BATTERY_ALR, LEAK_ALR, MAGNETIC_TAMPER_ALR, METER_ERROR_ALR, BACK_FLOW_ALR, BROKEN_PIPE_ALR, EMPTY_PIPE_ALR, SPECIFIC_ERROR_ALR

which we do insert

sdg.marinusvz
2023-11-10 14:37

Remember that the login and password you use for the FTP must be able to see only one Sensus Ftp server or CSV Ftp server entity. So you can use a role with restrictions on entity, and make them see only the one ftp server entity.

Remember that if you added or changed the password on a login that can see an Ftp server entity, you have to restart the server, so that the Ftp server entity can re-initialize its user database on startup.

Please log in to post a comment