> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.2cloudnine.com/llms.txt
> Use this file to discover all available pages before exploring further.
# QRG Integrated Import Tool - Upload and Process Import Files
export const InlineImage = ({src, alt = "", height = "1.6em"}) => {
return 
;
};
## Purpose
The purpose of this quick reference guide is to step through the process of importing Timesheet or Pay Transaction data into a new Import record using the Integrated Import Tool. The intended audience for this document are System Administrators / Standard Users.
## Steps
### Create Imported Record
The new Integrated Import Tool utilises Imported Records as a junction record between uploaded data and the related imported records. This enables users to import data by uploading, validating and processing directly on the Imported Records Object. Timesheets, Allowance Timesheet Items and Pay Transaction records may all be imported using this process.
To create a new Imported Record using the Integrated Import Tool, the following steps should be completed:
1. Click on the **App Launcher** icon (see Figure 1).
2. Go to the **Imported Records** object by using the Search function (see Figure 2).
3. Click on the **New** button (see Figure 3)
4. Select **Timesheet**, **Allowance** or **Pay Transaction** from the available record types, and click on the **Next** button (see Figure 4).
Data import for Assignment records is not currently supported in the Integrated Import Tool, but is still available via the original Import Tool.
Allowance record types enable the import of Allowance Timesheet Items.
When importing Timesheet data, any Allowance Timesheet Items must be imported using the Allowance record type BEFORE importing Timesheet Entries.
5. Populate the following fields (see Figure 5):
1. Populate only the **Imported Record** field with a unique identifier for the data import file.
2. If the data to be imported has NOT been formatted using a Standard CSV Template, please populate the **Import Type** picklist field with the corresponding value (eg. **Enhanced** if using the Enhanced Timesheet Entries CSV Template).
3. If the Pay Transaction record type was selected at step 4, and Pay Multipliers related to the data to be imported should be overridden to 1, populate the **Override Pay Multipliers** field.
6. Click on the **Save** button (see Figure 5).
The values available in the Import Type picklist field may differ, depending on the customisations applied to your Org.
The record tracking fields listed beneath the Number of Imported Records heading are automatically populated and should not be manually overridden.
### Uploaded Data for Import
Once the Imported Record has been created, the data that needs to be imported must be manually uploaded to the record, to enable validation and processing.
To upload data for processing using the Integrated Import Tool, the following steps should be completed:
7. Follow the instructions detailed in QRG Integrated Import Tool - Populate CSV Files to prepare your data for upload and import.
8. From the new Record page (created in steps 1-5), complete the following steps to upload files:
1. Click on the **Add Files** or **Upload Files** buttons to select files (see Figure 6).
2. Navigate to the data file to be uploaded, select the file and click on the **Open** button to begin the upload (see Figure 7).
All data uploaded for import must be formatted in line with the CSV Templates provided, and according to the instructions detailed in QRG Integrated Import Tool - Populate CSV Files.
The Integrated Import Tool has been designed to process complex data, even in large quantities. However, there are still limitations to the amount of data that may be imported within a single record. Please ensure data is broken up into as many logical segments as possible, limiting to between 5,000 and 10,000 (max) rows of data, to avoid processing delays.
Imported Records will allow multiple files to be uploaded, however the Integrated Import Tool will only process data from ONE uploaded file. Please do not upload more than one CSV file for each Imported Record.
3. Wait for the progress bar in the Upload Files window to complete, then click on the **Done** button (see Figure 8).
### Validate and Import Uploaded Data
After creating a new Imported Record and uploading the file containing the data for import, the record must be manually edited to trigger validation and record creation for the imported data.
Follow the below steps to import the uploaded data:
9. Click on the **Edit** button to modify the record (see Figure 9).
The Status of the Imported Record must not be manually edited until successful upload of the data file.
10. Populate the following fields to trigger validation and import of data for the uploaded file (see Figure 10):
1. Select the **Override Standard Import Process** checkbox field.
2. In the **Status** field, select **Ready To Be Processed** from the available picklist values.
11. Click on the **Save** button (see Figure 10).
The Status field must NOT be updated to Ready To Be Processed unless the Override Standard Import Process checkbox is marked True. Failing to select this checkbox before updating the Status of the record will result in processing errors.
### Review Import Status
Once the **Status** of the Imported Record has been updated and saved, the Integrated Import Tool will begin to validate the data contained within the uploaded file.
If data validation is successful, the Integrated Import Tool will create the data from the import file. If data validation is not successful, data from within the import file will not be created and will need to be manually amended before attempting validation again.
To determine whether data validation was successful, the following steps should be completed:
12. Review the **Import Status** field of the Imported Record (see Figure 11).
1. A **Failed** status indicates that data validation was not successful.
2. A **Processed** status indicates that data validation was successful and records have been imported.
13. Review the new CSV file that was automatically attached to the Imported Record upon completion of the validation attempt (see Figure 11).
1. If successful, the CSV will be named **Success Records (\[number of records]).csv**, and will contain a new **Results** column that may contain additional information regarding the successful validation and import of source data.
2. If failed, the CSV will be named **Failed Records (\[number of records]).csv**.
14. Review the **Related Records** of the Imported Record (see Figure 11).
1. If validation was successful, the new records created during data import will be listed in the related lists here.
15. Review the **Number of Imported Records** (see Figure 11).
1. The number populated in the **Records Attempted** and **Successful Records** fields should be equal.
If the data import has been successfully **Processed**, no further action is required.
If data import has **Failed**, the following steps should be completed:
16. Make note of the warnings displayed in the Message and Error Summary fields (see Figure 12).
17. Open the attached **Failed Records** CSV file (see Figure 12).
18. Review the message populated in the **Status** & **Error/Warning** or **Result** fields for each line of data.
1. **Status** & **Error/Warning** fields will always be displayed in the first two columns of the CSV (see Figure 13).
2. **Result** fields will always be displayed in the last column of the CSV (see Figure 14).
19. Correct the data as detailed in the attached Failed file by following the below steps:
1. To open and modify the CSV file:
1. From the related Files records, click on the uploaded CSV file (see Figure 15).
2. Click on the **Download** button (see Figure 16).
3. Open the downloaded CSV file (see Figure 17).
2. Amend the data according to the corrections needed.
20. Replace the existing uploaded CSV data file with the corrected CSV file by following the below steps:
1. Click on the **View All** button beneath the related **Files** records (see Figure 18).
2. Click on the button and select **Upload New Version** to upload and overwrite the original CSV data file with the new CSV data file (see Figure 19).
21. Return to steps **8-14**, and re-attempt validation and processing for the corrected data.
## Field Descriptions
**Error Summary** provides a summary of errors encountered during either data validation or data import.
**Failed Records** details the number of imported records that were not successfully processed.
* The Integrated Import Tool does not support partial data import:
* If any errors are encountered during data validation, data import will not occur and all records will be marked as failed.
* If errors are encountered during data import, any newly created records will be deleted, and updated records will revert to their original values. The number of records that failed to import will be marked as failed, and records that were able to be imported will be marked as successful.
**Import Status** indicates the progress of the data import.
**Import Type** indicates the type of import used to process the Imported Record:
* **Timesheet** Standard or Enhanced
* **Allowance** Standard or Enhanced
* **Pay Transaction** Standard
**Imported Record** is the unique name given to the Imported Record.
**Message** displays the last message generated for the Imported Record (i.e. ‘All records inserted successfully.’)
**Override Pay Multipliers?** indicates whether Pay Rate Multipliers need to be overridden to 1 during the Pay Transaction Import process.
**Override Standard Import Process** when true, the attached CSV data file will be processed by the Integrated Import Tool.
**Record Type** the record type of the data captured in the CSV for import (Timesheet, Allowance or Pay Transaction).
**Records Attempted** details the number of records where creation was attempted during processing.
**Successful Records** details the number of imported records that were successfully created.
## Further Information
| Document | Document Type | Description |
| ----------------------------------------------------------------------------------- | ------------- | ------------------------------------------------------------------------------------------------------------------- |
| QRG Integrated Import Tool - Populate Timesheet CSV Files (Standard) | QRG | How to populate data in the Standard CSV template for Timesheet Entries when uploading to Imported Records. |
| QRG Integrated Import Tool - Populate Timesheet CSV Files (Enhanced) | QRG | How to populate data in the Enhanced CSV template for Timesheet Entries when uploading to Imported Records. |
| QRG Integrated Import Tool - Populate Allowance Timesheet Item CSV Files (Standard) | QRG | How to populate data in the Standard CSV template for Allowance Timesheet Items when uploading to Imported Records. |
| QRG Integrated Import Tool - Populate Allowance Timesheet Item CSV Files (Enhanced) | QRG | How to populate data in the Enhanced CSV template for Allowance Timesheet Items when uploading to Imported Records. |
| QRG Integrated Import Tool - Populate Pay Transaction CSV Files (Standard) | QRG | How to populate data in the Standard CSV template for Pay Transactions when uploading to Imported Records. |
