Import Change Event Line Items from a CSV File
Objective
To import the line items for a change event using a Comma Separated Values (CSV) file.
Background
To save time from manually adding line items to a change event, you can download a CSV file from your project, add your line items to that file, and then import it into Procore.
Things to Consider
- Required User Permissions:
- 'Standard' level permission or higher on the project's Change Events tool.
Steps
- Download the Schedule of Values CSV Template
- Add Line Items to the CSV Template
- Upload the Completed CSV Template to Procore
Download the Schedule of Values CSV Template
-
Create a new change event or edit an existing change event.
- Click Import Line Items from CSV at the bottom of the 'Line Items' card.
- Click Download Blank CSV Template.
After completing the steps above, continue with Add Line Items to the CSV Template.
Add Line Items to the CSV Template
- Open the CSV template that you downloaded.
Note: The Sub Job, Cost Code, and Cost Type fields will be pre-populated with the budget code segments that are currently in use on your project. - Complete the following fields on the import template for each line you want to import:
Note: Only lines with values entered into at least one of the following columns will be imported. There are no required fields.
Description. Enter a description for the line item.
Vendor. Enter the company name as it appears in the project's Directory.
Contract. Enter the contract number and title.
NOTE: The required format for this field is "#'Contract Number': 'Contract Title'". For example, a contract with a number of 'SC--001' and a title of 'Test Contract' is entered as "#SC--001: Test Contract"
Qty. Enter the unit quantity for the line item(s).
UOM. Enter the unit of measure (UOM) for the line item(s) (Case Sensitive).
Unit Cost. Enter the unit cost value.
After completing the steps above, continue with Import the Completed CSV Template to Procore.
Import the Completed CSV Template to Procore
- Click Import Line Items from CSV.
- Click Upload File and select your completed template or drag and drop the file into the 'Drag & Drop' box.
Note: If there are any errors in the template a banner will appear preventing you from importing. To review the errors, click Show Errors and make the necessary corrections to the template. - Click Import.
Note: Clicking 'Import' will complete the creation process for the change event. The change event line items' revenue ROM setting will be applied based on the scope that is chosen for the change event before importing.