Laserfiche WebLink
6.4 Location File <br />Allegiant will work with Elk River, MN to create a CSV file that contains the following data elements to load <br />into Allegiant's "Peak Workflow" program conducting the meter exchanges in the field. <br />Sample: <br />Allegiant Utility Services Template - Existing Meter Location File CSV Preferred File Format <br />Instructions: Update column headers, column positions, and length constraints as appropriate to Utility's CIS. <br />Column <br />Column Header <br />Positio <br />Required from Utility CIS <br />Length <br />n <br />Notes <br />x <br />Account <br />50 <br />1 <br />Customer account number <br />x <br />Old Meter Number <br />20 <br />2 <br />Old meter serial number (Primary Key) <br />x <br />Last kWh Reading <br />10 <br />3 <br />Typical KWH reading <br />x <br />Meter Form <br />15 <br />4 <br />i.e. 2S, 2S-SD, etc. <br />x <br />Read Notes <br />100 <br />5 <br />Notes regarding service location, gate codes, etc. <br />x <br />SubArea <br />50 <br />6 <br />i.e. Substation <br />x <br />Circuit Number <br />50 <br />7 <br />i.e. Feeder <br />x <br />Billing Cycle <br />50 <br />8 <br />Code or name of cycle <br />X <br />Route <br />50 <br />9 <br />Code or name of route <br />x <br />Old Latitude <br />15 <br />10 <br />Can be 18 if needed for NISC <br />x <br />Old Longitude <br />15 <br />11 <br />Can be 19 if needed for NISC <br />Account <br />Old Meter Number Last kWh Reading Meter Form <br />Read Notes SubArea Circuit Number Billing Cycle Route Old Latitude Old Longitude <br />34534534 <br />TS3242353 <br />3425 <br />2S <br />Gate Code:1234 r 02 r 04 r 03 01 44.9453656-93.3358785: <br />64645456 <br />TS329546 <br />4203 <br />2S <br />r 01 r 03 r 02 02 43.5403388-109.6520657 <br />a. Location files are typically loaded daily/weekly during the course of the project to keep the <br />data up to date. <br />b. Files are typically sent across Allegiant's SFTP site. <br />C. Post Meter Change Out Import File <br />d. Allegiant will work with Utility to create a file for import into NISC for the meter change <br />outs. <br />Sample: <br />Allegiant Utility Services Template - Completed Meter Exchange File (Extended) CSV Preferred File Format <br />Instructions: <br />Update column headers, <br />column positions, and length constraints as appropriate to Utility's CIS. <br />Column Header to <br />Column <br />Exported <br />Utility CIS <br />Length <br />Position Notes <br />x <br />Account <br />30 <br />1 Customer account number <br />x <br />Old Meter Number <br />is <br />2 Old meter serial number <br />x <br />Old kWh Reading <br />30 <br />3 <br />Old kW Reading <br />10 <br />Optional based on project <br />Old kVa Reading <br />10 <br />Optional based on project <br />Old kVar Reading <br />10 <br />Optional based on project <br />x <br />New Meter <br />1s <br />4 <br />x <br />New kWh Reading <br />10 <br />5 <br />New kW Reading <br />15 <br />New kVa Reading <br />15 <br />New kVar Reading <br />15 <br />New Meter Dial <br />10 <br />x <br />Reading Date <br />8 <br />6 UTC unless otherwise agreed <br />Meter Set Number <br />5 <br />Demand Code <br />5 <br />Service Location <br />20 <br />Map Number <br />20 <br />x <br />New Latitude <br />15 <br />7 Can be 18 if needed for NISC <br />x <br />New Longitude <br />25 <br />8 Can be 19 if needed for NISC <br />228 <br />