Article: Bill Export

Avatar

rudiemm
2012-01-09 10:43

Avatar

sdg.marinusvz
2014-10-03 14:08

Of the remaining export formats, there are various PDF downloads (user readable documents); and then some exports to specific billing systems, e.g. MDA, Pastel, SAMRAS and Sebata.

Avatar

sdg.marinusvz
2014-10-03 14:11

For the MDA and Pastel exports, it is necessary to set up all the necessary Meter Account fields correctly, as it is in the MDA or Pastel system, so that the acounts match up when you import the Bill Export file. There is more posted on this on the wiki, do a search on Pastel or MDA on this site and you will find a lot of documentation on that.
For the SAMRAS and Sebata exports, the interface used is the same one as used for Manual Meter Readers. In these cases the process is to receive a file from the system to say which meters must be read, then upload it into PNPSCADA in this screen, download the results file from PNPSCADA, and upload the results file as downloaded from PNPSCADA into the SAMRAS/Sebata system.

Avatar

sdg.marinusvz
2014-10-03 14:17

The format of the SAMRAS file imported into PNPSCADA from the SAMRAS system is a flat text file, where a snippet typically looks like this:
[CODE]
74001600000521262115 LEEU DASSSENBERG EPAARL 00000031731300E 00300604330063785900003238000000016. 00000000000000000000000000 74001600000521262115 LEEU DASSSENBERG EPAARL 00000031731400K 00300604330000000000000000000000014. 00000000000000000000000000 74001600000521262115 LEEU DASSSENBERG EPAARL 00000077393400K 00300604330000000000000000000000014UTILIZED DEMAND 00000000000000000000000000 74001800000010492040 ROYAL ANTHEM INVESFRANSCHHOEK 00000052887200E 00361309210047864700003834000000016. 00000000000000000000000000 74001800000010492040 ROYAL ANTHEM INVESFRANSCHHOEK 00000052887300K 00361309210000000000000000000000014. 00000000000000000000000000 74001800000010492040 ROYAL ANTHEM INVESFRANSCHHOEK 00000077385600K 00361309210000000000000000000000014UTILIZED DEMAND 00000000000000000000000000 74001900000000013686 MONT ROCHELLE FARM: MONT ROCH 00000077938200E 00530698560001265600003016000000017. 00000000000000000000000000 74001900000000013686 MONT ROCHELLE FARM: MONT ROCH 00000077938300E 00530698560003093900007398000000017. 00000000000000000000000000 74001900000000013686 MONT ROCHELLE FARM: MONT ROCH 00000077938400E 00530698560003561500008496000000017. 00000000000000000000000000 74001900000000013686 MONT ROCHELLE FARM: MONT ROCH 00000077938500K 00530698560000000000000000000000016. 00000000000000000000000000 74001900000000013686 MONT ROCHELLE FARM: MONT ROCH 00000077938700K 00530698560000000000000000000000016. 00000000000000000000000000 74001900000000013686 MONT ROCHELLE FARM: MONT ROCH 00000077938800K 00530698560000000000000000000000017. 00000000000000000000000000 74002200000000003041Mev P FRIEDMAN WILHELMINA STRE 1 00000048379800E 00360367750024619100004784000000016. 00000000000000000000000000 74002200000000003041Mev P FRIEDMAN WILHELMINA STRE 1 00000048379900K 00360367750000000000000000000000014. 00000000000000000000000000 74002200000000003041Mev P FRIEDMAN WILHELMINA STRE 1 00000077380400K 00360367750000000000000000000000014UTILIZED 00000000000000000000000000
[/CODE]
The E and K in the about column 83 is important, it means Energy or Maximum Demand. In general, E means it is a counter that counts up, and K is something which can go up and down between months, e.g. Maximum Demand and excess reactive energy charge, and so on.
The meter serial number is about 3 characters after that, for 10 digits, right aligned.
They will be sorted in order of service key sequence. This is important when you identify registers in the TOU calendar. Start the register identifier with K or E, and then put the index and the total for that meter account, e.g. E[1/3] says match the register with the first line of three lines in the file that charges E, for that meter account. For example if Peak is first, then Standard and then Off-Peak in the export file from SAMRAS, then Peak would be E[1/3] and Standard would be E[2/3] and Off-Peak would be E[3/3].

Avatar

sdg.marinusvz
2014-10-03 14:45

An important thing with both SAMRAS and Sebata exports, is that if you do TOU registers, it is going to want separate registers that count up, because it deduces the consumption by subtracting last month's reading from this month's reading.
To do that correctly, it is important that the TOU calendar that the tariff uses must be configured for the meter in the Advanced Meter Setting screen. On that screen, the link to the Billing system and the optional link(s) to the Meter TOU registers must be specified for it all to synchronize correctly.

Avatar

sdg.marinusvz
2014-10-03 14:48

The format of the Sebata file imported into PNPSCADA from the Sebata system is a csv text file, with the following column headings in the first line: "Physical mtr no", "Dials", "Old reading", "Old date", "New Reading", "New date" and "Account".
The way that the register is chosen, is by either putting a space behind the meter serial number and then the Billing Identifier, or alternatively by putting one letter at the end of the meter serial number (that letter then becomes the Billing Identifier)

Please log in to post a comment