Import Transactions screen

Use the Import Transactions screen to import a variety of transaction types.

You can import the following types of transactions:

  • Catalog Item Price Updates
  • Purchase Orders
  • Subcontracts
  • Employee Time Cards
  • Vendor Invoices

To open the Import Setup Data screen, click Administration > Utilities > Import > Import Transactions in the All Tasks pane.

You can import all of the above transactions from Excel (XLSX) or TSV files. In addition, you can import employee time cards from the Daily Field Reports.

To import from Excel, use the import templates. Most import templates contain multiple worksheets, allowing you to import primary records from one worksheet and detail records from the others.

If you have exported data from a Viewpoint legacy product, the import data may be in one or more TSV files. When you import from a TSV file, ProContractor converts the file to Excel before retrieving and validating the data. If errors are found, you can make corrections to the data directly within the Excel file and run the process again.

ProContractor uses specific key fields for each import type to uniquely identify records and prevent duplicates. For example, when retrieving and validating customer data in the import file, the application uses the Customer field value to uniquely identify each customer in the file and prevent duplicate customer records in the system.

For more information, see the following topics:

ProContractor also uses the key fields to link detail records in the import file to primary records. If a detail record does not match a primary record based on key field values, the detail record is marked as "orphaned" during the validation process. You can stop the import and make corrections to the orphaned records directly within the import file. If you continue with the import without correcting orphaned records in the import file, the orphaned records will not be imported. You will have to manually enter the orphaned records into the system.

Note: If you are using Microsoft Office 2007 and the component Visual Basic for Applications is set to Installed on first use, the following error message is displayed when you import:
Excel needs VBA macro language support to complete the action
You may need to minimize ProContractor to see this message. To work around this issue, install the Visual Basic for Applications component.