During the CCAP Integrated billing upload process, each row is validated. If an error is found in one row, CCAP will terminate the entire upload in most cases. However, CCAP may be able to complete a partial upload if the only errors present are one of the following:
The meter_code refers to a meter that does not currently exist in CCAP
The asset_code assigned to a particular meter_code is inconsistent with the asset to which the meter belongs in CCAP
The resource_type_code assigned to a particular billing row for a meter is inconsistent with the resource type to which the meter belongs in CCAP
In these cases, CCAP will ignore these rows and attempt to process the remaining rows in an upload. If successful, the validated billing data will be imported and all invalid rows become Unprocessed Billing Rows. You will receive an email from the CCAP team to notify you of Unprocessed Billing Rows.
You can view or reprocess this data by navigating to the Unprocessed Data section, located under Admin → Data Processing. Please be aware that only owners and admins may access this page, and you may need to talk to the owner of the CCAP tool for your organisation to arrange access.
On this page, the user may check and confirm the meter_code, asset_code and resource_type_code. Please ensure that there are no typos or missing digits/checksums in your meter_code before reprocessing as this may lead to creation of duplicate meters and impact the data completeness for your organisation.
Once you believe that the information is correct, click the Reprocess button.
If a meter exists with the confirmed code, but the confirmed asset or resource type does not match, the user will see an error.
If no meters in the upload contain errors, all non-existing meters will be created and a new upload will be created.
If the new upload contains other errors (such as date errors), it will fail. If this happens. the file can be downloaded from the uploads page, fixed, and then reuploaded.