Importing Gas Composition Data
The Gas Composition import feature will allow the user to bulk upload gas compositions (GCs) to their meters on Zedi Access using a .csv file. It is easy to use and provides better feedback on what Gas Compositions were received and written to the meter. The dashboard offers visibility and feedback on what is sent vs what was written to the device. The user does have the ability to manually enter GCs to their meters as needed
To Import Gas Composition
1. In the home screen, select Data and select Gas Composition Import.
2. To Import your file:
a. Select the file that you would like imported. The import will take a couple of minutes.
b. Select the “i” icon to view the Gas Composition CSV Format.
c. Select the download icon to download a template of the CSV format needed to download the Gas Composition Import.
Once your file has been selected, you will see the following screen below.
d. Import Date. This will be the companies time zone.
e. File Name. This must be a cvs. file
f. Imported by. This will be the users Zedi Access username.
g. Import Progress. It will be Processing: Importing gas composition records or Completed: all records uploaded have been submitted.
h. The Total Records shows how many Gas Compositions were included in the file imported.
i. Total Records that were imported and passed validation. These records will be attempted to write out devices.
j. Errors are the amount of records that did not pass validation.
k. Error Log: you can download this csv file with any errors. A file will only be available for download when the import progress status shows complete.
- See Error Message files at the end of this document.
Gas Composition Import Dashboards
The Gas Compositions are displayed in the dashboards. These are designed to help support the user by providing info for set up and verification of importing GCs. These dashboards are located on the ‘Analytics’ tab of Zedi Access under the name ‘Gas Composition Imports’
1. SCADA Location Compatibility – Detail listing of devices you have permissions to seeing on Zedi Access and whether they are supported or unsupported for bulk GC import.
a. Protocol Summary – tally/summary of supported vs unsupported devices by communication protocol
2. New Locations – list newly commissioned sites onto Zedi Access
3. Gas Composition Write Status - details the success or failure of the gas composition writing out to the device.
4. Upcoming Gas Composition Writes – this outlines a list of GCs that are waiting for the effective date/start date to roll around before the GCs are written to device.
Error Messages
Error Message |
Error Description/Notes |
Action to fix |
This location is associated with a [Unsupported device here] device. That device type is not supported for gas composition imports |
Gas Comps cannot be updated through the import for these devices Zed-PAC, PAC2, PAC4, Field Gateway, MTRAC, and Zedi EFM Walk-up. |
Only action is to manually enter the GC on Zedi Access |
This location is not attached to a device |
The Zedi ID they provided does not have a device attached to it for the GC to write to |
verify the Zedi id is correct |
Location does not exist. Please verify Zedi ID |
Could not find a matching Zedi ID |
verify the Zedi id is correct |
This location uses [unsupported protocol name here] Protocol. That protocol is not supported for gas composition imports |
GC import only supports certain devices with compatible communication protocols. Please refer to the device protocol dashboard to see what is supported vs unsupported |
Only action is to manually enter the GC on Zedi Access |
The configuration for the device associated with this location could not be found. Please contact customer support |
This device not configured properly in ACM |
Submit support request to AES team supplying the Zedi ID asking them to verify this location is configured in ACM |
A gas composition with the same effective date has already been imported for this location |
A GC on the uploaded file has a duplicate record (Zedi ID and Effective date). |
Verify the GC is a duplicate or not. If a duplicate, this can be ignored. If not, check the Zedi ID or modify the effective date. |
The Effective Date cannot be older than the first day of the previous month (yyyy-mm-dd) |
we do not allow GCs to be backdated further than the 1 of the previous month |
Change the effective date to meet the requirement. |
The Effective Date cannot be more that 31 days in the future (yyyy-mm-dd) |
we do not allow GCs to be future dated more than 31 days into the future |
Change the effective date to meet the requirement. |
Gas component total of 'Total of composition' is outside the valid range of 0.98 to 1.02 |
The total of all the components for this GC is outside the range of 0.98 and 1.02 |
Verify the GC components are accurate and correct as necessary |
Zedi ID must be numeric. 'VALUE SUPPLIED' is invalid". |
All Zedi IDs are numeric only. No letters, or symbols should be appearing in this value |
verify the Zedi id is correct |
[Component] - Is required and must be numeric. The value sent is '' |
Gas components are required fields and the value supplied must be a numeric value. |
Verify the GC components are accurate and correct as necessary |
Meter Code - The string exceeds the maximum length of 255 |
This is an optional field, but the value supplied exceeds 255 characters |
remove the meter code or reduce the number of characters |
Oil test wells cannot be imported using the parent Zedi ID. Import again using the child Zedi ID |
For well test satellite locations, GCs can only be written down to the child location (well test location). These child locations have their own Zedi ID which is different than the parent Zedi ID |
verify the Zedi id is correct using the child location of the well test satellite |
Unable to find a location associated with the Zedi ID 'VALUE SUPPLIED’ |
Could not find a matching Zedi ID |
verify the Zedi id is correct |
User does not have permission to manage gas compositions for this location |
User must have "Manage Gas Composition" well permission to each location they wish to import GCs too. |
check users well permission to the location they are attempting to write a GC too. |
Customer support service by UserEcho