General tab

Field	Description
Import Type	Clickto select the type of data to import. Catalog Item Price Update Employee Time Card - Excel Employee Time Card - Select DFRs Purchase Order Subcontract Vendor Invoice Note: To import employee time cards from a TSV file, select Employee Time Card - Excel as the import type. Note: The import types shown to you in this field are based on user permissions to the corresponding manual entry screens. For example, if you do not have access to the Enter Purchase Order screen, the Purchase Order import type is not listed.
File Location	If you are importing catalog item price updates, purchase orders, or employee time cards from an Excel or TSV file, clickand browse to the file. If you are importing employee time cards fromProContractor Daily Field Reports, this field is disabled.
Posting Group	If you are importing employee time cards, enter the posting group for the import or clickto select the posting groupfrom a Lookup List. The only available posting groups are those associated with companies and pay systems to which you have access.
Select DFRs	If you are importing employee time cards fromProContractor Daily Field Reports, click Select DFRs. The Available Daily Field Reports lookup list appears, displaying all available DFRs. To filter the list of available DFRs based on the pay period of the posting group, select the Include DFRs from the selected Pay Period onlycheckbox. From the lookup list, select the checkbox for each DFR containing data you want to import and click OK.
Allow Duplicate Names	This field is disabled.
Number of Valid Records	Initially displays 0; after you click Get External Data, displays the number of valid records for the import type. Valid records can be imported.
Number of Invalid Records	Initially displays 0; after you click Get External Data, displays the number of invalid records for the import type. Invalid records must be corrected before being imported. A record is invalid if either of the following is true: The record fails one or more validation checks. The record is orphaned. ProContractor lists failed records in the Failed Records taband orphaned records in theOrphaned Records tab.
Clear	Click Clear to clear the File Location, Posting Group, and Allow Duplicate Names fields for the import type and to clear external data. If the external data includes invalid records, ProContractor provides an option to create a Problem Records Excel file. You can use this file to identify the records with errors in the original import file.

Failed Records tab

The Failed Records tab is displayed only if one or more records in the import file failed validation checks. A record may fail a validation check for a number of reasons, including:

• A required field is blank.
• The value in a field is not the correct type of data (for example, a character value is in a date field).

Each row in the grid contains information about a failed record. Use this information to find and correct the record in the import file.

Orphaned Records tab

The Orphaned Records tab is displayed only if a detail record in the import file does not match a primary record in the import file. This match is based on the values in the key fields for the import type.

Each row in the grid contains information about an orphaned record. Use this information to find and correct the record in the original Excel file.