The Data Receipt report is an automated email that is sent to specified contacts when data is loaded, informing them of the success (or partial success) of the file that was loaded.

The  report contains 5 pages.

Page 1 : Summary

This page contains 2 sections Overview and Row Breakdown.

Overview

This section confirms the main information pertaining to the status of the file loaded.

File name: The name of the file received

Uploaded on: The date (In GMT) that the file was processed

File Status: The status of the file, this will always show either 'Loaded' or 'Error'

Total Rows: The total amount of rows contain in the file received

Read Errors  The amount of rows which were unable to be read 

Rows Skipped: The amount of rows which were skipped by the connector

Rows Read: The total amount of rows which were successfully matched to a row specification

Rows Loaded: The total amount of rows which were loaded into the platform, if this value is lower than the amount of rows read there are two possible reasons for this

  • There were load errors in the file

  • The connector performed data aggregation, which has caused multiple rows to be merged into one

Row Breakdown

This section shows a graphical representation of the data that was loaded, as percentages of the total amount of rows successfully read (not the total amount of rows in the file).

Records Added to New Accounts: This indicates that the connector could not find a matching account in the platform and has created a new account for the account item to be loaded into

Records Added to Existing Accounts: This indicates that the connector has successfully loaded an account item into a new account

Unprocessed Records: This occurs when there are load errors when attempting to load the data

Page 2 : Load Errors

These errors are presented whenever the row was successfully read, but there was an issue with loading the data into the server.

There are a number of reasons this could happen, each type will be listed here when available.

  • Unable to resolve location 

  • Date format invalid

  • Number format invalid

  • Account closed

  • Date exceeds lock down date

Page 3 : Read Errors

These errors are presented the the pattern of a row in the file does not match any row specification written in the connector

  • Unable to match a row to any row specification

  • Trying to retrieve a value from a column that does not exist in a row

Page 4 : Skip Rows

These are for any row which is designated in the connector to be skipped. The name of the row specification in the connector determine the message displayed in the receipt for skip rows.

Page 5 : Data Breakdown

This last section contains detailed information, aggregated by account style, showing where data has been loaded, and how much data has been loaded.

  • Account Style: The account style that the data was loaded to

  • Records Added (New Accounts) : How many records were added to newly created accounts

  • Records Added (Existing Accounts) : How many records were added to pre-existing accounts

  • Accounts Created: How many new accounts were created

  • Accounts Updated: How many pre-existing accounts had records added to them

  • Units (In): The total sum of all data loaded into the primary measure of the account style

  • Total Cost: The sum of the 'total cost' field for all data loaded

  • Earliest/Latest Date: The first and last data of data received for this particular account style