WHAT IS A FILE MAPPING?
  • 22 Oct 2019
  • 1 Minute To Read
  • Contributors
  • Print
  • Share
  • Dark
    Light

WHAT IS A FILE MAPPING?

  • Print
  • Share
  • Dark
    Light

[VIDEO]

  • Utilities dispatch instructions to meter reading companies.

  • Invariably, Each Utility has its own data format wherein it formats the data instructions to the meter reading company. These formats can be derived from legacy or ERP systems or they can be in simple ad hoc CSV or TSV files.

  • WeBilll requires the Utility meter Instructions to be formatted into a structure that the WeBill system can handle. To this end, WeBill has defined a Canonical structure of WeBill meter instruction data format.

  • A Mapping maps the unique Utility data structure to WeBill’s Canonical structure.

  • With a mapping created for a Utility’s data structure to Canonical, you can now drag and drop any data formats supplied by the Utility into the Instructions upload section of WeBill and the Mapping will guarantee that the Utility format is converted to the WeBill Canonical format.

  • A Utility can have one or more Mappings.

  • The Mapping process is carried out once per Utility data format. If the Utility data format changes, the Mapping can also be edited.
    At this stage, the Utility data format is presumed to be contained in a flat file delimited structure.

  • When creating the mapping, a valid mapping will require certain compulsory fields to be filled in. Essentially, a mapping comprises of mapping, one or more source columns from the Utility format to a field in the Canonical. A Canonical requires certain compulsory fields and a mapping will only be valid when these compulsory fields have a corresponding mapping from the source Utility data format.

Was This Article Helpful?