External Import
- Mark Holland (Unlicensed)
- Robert Hendry
Description
Use this page to review and import data from an external provider.
Usage
Click the orange download button 
to download the uploaded data in .csv files meeting the standard import formats in InPay.
If the uploaded data is incorrect, there are two options:
- Request a new upload from the external provider
- Alter the data in the .csv files and upload using the Import page
If the uploaded data is acceptable, click the green import button 
to import the data into InPay. Each import format will then be validated and imported into InPay if it passes validation. If there are any errors on the files, these may be viewed by clicking the import status.
Errors
No External Id in InPay
When an employee is added manually, the ExternalId column (external providers employee Id) must be populated.
If it’s not known at the time, it can be updated afterwards. It must be updated before the import is run.
The ExternalId can be inserted in the Employee Starter import format and updated in the Employee Basic import format.
To fix, request the employee’s ID from the external provider and update using the Employee Basic import format. It will then be possible to download the zip file and import using the Import page.
Multiple payments with the same amount
This can be an issue with the data from the external company. This may require them to send a new submission without duplicates.