Skip to main content
Procore Support (en-au)

Request a Defect List Import

IMPORTANT! In order to protect the integrity of your company’s data, Procore Employees are restricted from modifying the data that clients submit in all Procore Import Templates. This restriction applies to all data modifications, including correcting typographical errors. If Procore determines that errors are present in any Procore Import Template that you submit to Procore, it will be returned to you for correction. Please note that the import process may take up to 72 hours to process.

 

Objective

To submit a request to have your project's defect list items imported into Procore at the beginning of a project.

Background 

You can import defect list items in bulk for use on a new project. 

Things to Consider 

Prerequisites

Steps 

  1. Download the Defect List Import Template
  2. Format the Defect List Import Template
  3. Validate the Import

Download the Defect List Import Template

  1. Download the Defect List Import Template: import-defect-list.xlsx

Format the Defect List Import Template

  1. Complete the import template.
  2. Suggestions to help expedite your submittal import:
    • Required Column Data:
      • Important! To avoid import errors, do not add empty rows, do NOT add blank columns, do NOT add new data columns and do not delete the header row from the contact import template. 
      • The first line of the table must include the header, which defines the fields in the Excel table and your company's contact database in Procore.
        • The following headers are required and an asterisk (*) denotes that data is required in the row: Item Name*, Defect Item #*, Defect Item Type, Due Date, Location, Cost Code, Program Impact, Program Impact Days, Cost Impact, Cost Impact Amount, Priority, Reference, Created By*, Description, Assigned and Comments.
      • The import process will fail if you modify values in column headers.
      • The import process will fail if you insert new columns, move columns or remove columns from the template.
      • The import process will fail if you change the column header order in the template.
    • Required Row Data:
      • Important! There is no limit to the number of rows you can import. However, rows cannot be blank.
      • Each row in the table corresponds to a defect list item. At a minimum, each record requires a value for the Item Name. Other columns and cells in a single row may be left blank.
      • Each row in the table corresponds to a Defect List line item. 
    • Maximum File Size: 
      • The maximum file size for a Defect List import is 1 MB. 
  3. See below for considerations when filling out the template. 
    Note: An asterisk (*) indicates a required field.
    • Item Name*
      Enter a descriptive title for the defect list item. You can enter up to 255 alphanumeric characters. This is a required field. 
    • Defect Item #*
      Enter a numeric value in this box for each data row. Values in the column are commonly entered in ascending numeric order (for example, 1, 2, 3 and so on). Duplicate values are allowed. However, this field cannot be blank.
    • Defect Item Type
      Enter one item type to categorise the defect list item (for example, Electrical, Instrumentation or Mechanical). For a successful import, types must be added to the Defect List tool before the import process, see Configure Advanced Settings: Defect List: Add Defect Item Types.
    • Due Date
      Enter the date the defect list item must be completed using the MM/DD/YYYY format (for example, 06/01/2016).
      Important! Do NOT enter dates in the M/D/YYYY format (for example, do NOT enter 6/1/2016) or the import will fail.
      Note: If the Excel column is not permitting you to add a leading zero, select the entire column, choose Format > Cells and then create a 'Custom' Number Format named 'mm/dd/yyyy' in the Number tab. See Create or Delete a Custom Number Format in Excel.
    • Trade
      Enter the trade name exactly as it appears in the Company level Admin tool. See Add or Delete Trade Names. Use the pipe (|) symbol as a separator to include multiple trade names (for example, Concrete | Masonry).
    • Location
      Enter the location exactly as you want it to appear in Procore.
      Important! If your project is using multi-tiered locations, you must enter the location exactly as it appears in Procore and separate each tier with the greater than (>) symbol and no SPACES between tiers (for example, Lot 1>Section A).
    • Cost Code
      Associate a cost code with a defect list item. The cost code must be formatted "division - cost code" written with the exact amount of digits as listed in your project or company in Procore. See Edit and Add Cost Codes and Descriptions.
    • Program Impact
      Enter one of the following values for each defect list item. Any entry other than the ones below will result in a blank entry after the import:
      • tbd. Enter this if the impact to the program is currently being assessed. This is short for 'To Be Determined'.
      • n_a. Enter this value to leave the field blank.
      • no_impact. Indicates the defect list item has no impact to on the project program. 
      • yes_unknown. Indicates the defect list item will impact the project program, but the impact is not known.  
      • yes_known. Indicates the defect list item impacts the project program and the number of days by which the project program will be impacted is known. If you enter this value, you must enter a number of days in the 'Program Impact Days' field. 
    • Program Impact Days
      If you entered 'yes_known' in the 'Program Impact' field, enter a number of days by which the project program will be impacted by (for example, 7 or 14).
    • Cost Impact
      Enter in one of the following values as it applies to each defect list item. Any entry other than these will cause the field to be left blank.
      • If the cost impact is "to be determined," enter "tbd"
      • To leave the field blank intentionally, enter "n_a"
      • If there is not an impact to the program, enter "no_impact"
      • If there is an impact on the cost and the amount of time is not known, enter "yes_unknown"
      • If there is an impact on the cost due to the defect list item and the cost amount is known, enter "yes_known"
    • Cost Impact Amount
      If you entered 'yes_known' in the 'Cost Impact' field, enter the dollar amount here. Do NOT include the dollar sign ($) symbol. 
    • Priority
      Enter 'Low' 'Medium' or 'High' to indicate the priority of the defect list item.
      Important! This entry is case-sensitive and must use the initial case (for example, the first letter of the value is capitalised). If this format is not used, the field will be blank after the import. 
    • Reference
      Enter a relevant keyword or phrase to use as an item reference. This is a free-form text field to be used as specified by your organisation. For example, if the item was created at the client's request, enter "client request".
    • Created By*
      Enter the full email address of the user who created the defect list item. Always enter the email address exactly as it appears in the Project Directory.
      Important! Do NOT enter a user name in this field. You must enter an email address. The person must already be added or imported to the Project Directory. This user must also be granted 'Admin' level permissions or higher to the Defect List tool.
    • Defect Manager* 
      Enter the full email address of the user who will serve as the Defect Manager. Always enter the email address exactly as it appears in the Project Directory.
      Important! Do NOT enter a user name in this field. You must enter an email address. The person must already be added or imported to the Project Directory. This user must also be granted 'Admin' level permissions or higher to the Defect List tool. This user must also be granted 'Admin' level permissions or higher to the Defect List tool or a 'Standard' user and granted special permission to act as Defect Manager.
    • Final Approver*
      Enter the full email address of the user who will serve as the Final Approver. Always enter the email address exactly as it appears in the Project Directory.
      Important! Do NOT enter a user name in this field. You must enter an email address. The person must already be added or imported to the Project Directory. This user must also be granted 'Admin' level permissions or higher to the Defect List tool, or a 'Standard' user and granted special permission to act as Final Approver.
    • Description
      Enter additional descriptive information related to completing the defect list item. You can enter up to 255 alphanumeric characters.
    • Assigned To
      Enter the full email address of the person who is responsible for closing out the defect list item.
      Important! Do NOT enter a user name in this field. You must enter an email address. The person must already be added or imported to the Project Directory. This user must also be granted 'Standard' level permissions or higher to the Defect List tool and will be automatically designated as the Action Required by person for the defect list item.
      Important! You can add multiple assignees to this field, but each email MUST be separated by the pipe ("|") symbol.
    • Comments
      Enter in additional comments you may have on the defect list item. You can enter up to 255 alphanumeric characters.
  4. Send the completed template to your Procore point of contact or to imports@procore.com.

Validate the Import

After your Procore point of contact notifies you that the import is complete, do the following:

  1. Navigate to the project's Defect List tool. 
  2. Validate that the imported defect list items are displaying as expected. 

See Also

  • Was this article helpful?