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:
|
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:
|
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.