Importing Metered Service Points

This topic provides additional details related to importing metered service points from a customer information system into Digital Asset Management / Digital Asset Cloud Service.

Metered Service Point Import File Format

Metered service point import files use the following tab-separated values format:

Field Name

Optional/Required

Notes

External Reference Id

Optional

The metered service point's reference ID in the CIS application.

Change Date Time

Optional

The date and time on which the metered service point was changed.

Applicable only for Incremental Uploads

Will be used to sequence processing in case there are multiple changes to the same metered service point.

Initial Load Sync Flag

Required

A value that indicates the type of upload. Valid values are:

  • F1IL - Initial Load

  • F1IC - Incremental

External Id

Required

The metered service point's ID in the CIS application.

When importing data from Customer to Meter or Customer Cloud Service this is the Service Point External ID.

Metered SP Type

Required

The type of metered service point. When importing data from Customer to Meter or Customer Cloud Service this comes from the Service Point Type.

If the provided metered service point type has not been defined as a Metered Service Point Type in Digital Asset Management / Digital Asset Cloud Service an extendable lookup is used to map this value to the Metered Service Point Type used in Digital Asset Management / Digital Asset Cloud Service.

SP Source Status

Required

The metered service point's source status. Valid values are values for the Source Status (SP_​SRC_​STAT_​FLG) lookup, and include:

  • D1CN (Connected)

  • D1DC (Disconnected)

Division

Optional

The metered service point's division.

If the provided division has not been defined as a Division in Digital Asset Management / Digital Asset Cloud Service an extendable lookup is used to map this value to the Division used in Digital Asset Management / Digital Asset Cloud Service.

External Premise Id

Optional

The ID of the premise associated with the metered service point in the CIS application.

Time Zone

Required

The time zone in which the metered service point is located.

Country

Optional

The country in which the metered service point is located.

Postal

Optional

The metered service point's postal code.

Address 1

Optional

The metered service point's address.

Address 2

Optional

Additional details regarding the metered service point's address (if applicable).

Address 3

Optional

Additional details regarding the metered service point's address (if applicable).

Address 4

Optional

Additional details regarding the metered service point's address (if applicable).

City

Optional

The city in which the metered service point is located.

County

Optional

The county in which the metered service point is located.

State

Optional

The state in which the metered service point is located.

Longitude

Optional

The metered service point's longitude.

Latitude

Optional

The metered service point's latitude.

Life Support Sensitive Load Flag

Required

A flag that indicates if the metered service point requires a Life Support Sensitive Load. Valid values are "true" and "false"

An extendable lookup is used to map this value to the Life Support Sensitive Load flag used in Digital Asset Management / Digital Asset Cloud Service

Life Support Sensitive Load Description

Optional

An optional description for Life Support Sensitive Load.

Status

Required

The current state of the metered service point. Valid values are "ACTIVE" and "INACTIVE".

Sample Record

Below is a sample file:

EXTREFMSP11    2023-06-21T14:01:00-08:00    F1IC    EXTMSP1    ZZ-EXTMSPTYPE    D1CN    ZZEDV    EXTPREM1    USPACIFIC    USA    94705    7610 Block Derby St    Addr2    Addr3    Addr4    Berkley    Alameda    CA    -81.697494    41.501120    false        ACTIVE

Upload Batch Process

Metered service point import files are uploaded using the Metered Service Point File Upload (X1-MSPUP) batch process. Use the Batch Control portal to view the parameters used by this batch process. This process should be run as needed for the initial import, as well as subsequent incremental updates.

This process creates inbound sync requests in the "Pending" state (see below).

The Metered Service Point File Upload - DACS (X1MSPUPL) algorithm used by this batch process uses the following extendable lookups to map data in the import file to values defined in Digital Asset Management / Digital Asset Cloud Service:

  • CCB Service Point Type Mapping (D1-CCBSPTypeLookup)

  • CCB Life Support Sensitive Load Mapping (D1-CCBLifeSupSensitiveLdLookup)

  • CIS Division Mapping (D1-CCBDivisionLookup)

Values must be defined for these extendable lookups before import files can be uploaded into Digital Asset Management / Digital Asset Cloud Service.

Inbound Sync Request Business Object

Metered service point inbound sync requests are based on the Metered Service Point Sync Request BO (X1-SyncReqMeteredSP) business object.

Inbound sync requests are created in the "Pending" state. The Sync Request Monitor (F1-SYNRQ) batch process is used to transition these to the "Transform/Validate" state where the data is validated and transformed as needed for import. What happens next is based on the type of sync request:

  • Initial Load sync requests then move to the "Validated" state (or "Validation Error" if an error is encountered). These are processed by an "Initial Sync Request Load" batch process (see below) .

  • Incremental sync requests move to the "Add/Update" state in which algorithms add or update records as appropriate and then to the "Synchronized" state.

  • The Create Acknowledgement (X1-CRESRACK) algorithm on the "Synchronized" state can be configured to send an acknowledgement to the system from which the imported data originated. This requires specifying the "Send Sync Request Acknowledgement" (X1-SYNREQACK) outbound message type for the Outbound Message Type parameter on the algorithm.

Initial Sync Request Load Batch Process

Metered service points imported as part of an Initial Load upload are created from Initial Load inbound sync requests using the Initial Sync Request - Load Metered SP (X1-SLMSP) batch process. Use the Batch Control portal to view the parameters used by this batch process. This process should be run as needed for the initial import, as well as subsequent incremental updates.

This process transitions the inbound sync requests to the "Loaded" state.