Skip to main content
Procore

Can I import a CSV into a Project Financials tool's bill of quantities if it has blank values?

 In Beta
Note to users participating in the Modernised Commitments User Interface (UI) beta program. The information below details a configuration that is available to Procore users who choose to take part in the opt-in Beta Participant Program for the Modernised Commitments UI. To learn more about this release, see Project Financials: (Beta) Modernised Experience for Commitments.

Answer

No. When importing data into the Bill of Quantities (BOQ) on a client contract, commitment, funding or main contract, the 'Amount' column on each row must include data. If the row does not contain a value in the 'Amount' cell, Procore's import window display an error message. However, you may leave the 'Description' cell blank. To learn more, see below. 

Valid Data Entry

The following is an example that shows valid data entry for the rows in the import template. The example below shows the Commitments tool. However, the import process works similarly in the Client Contracts, Funding and Main Contracts tool.  

Example

The import process is successful when the 'Amount' cell contains a value. 

The following illustration shows you an example of what is imported from a CSV file. The 'Amount' column is required to successfully complete the import process. 

  • In rows 2-4, data has been entered in each 'Amount' cell. This row will be imported.
  • In row 5, the 'Description' cell can be blank, but the 'Amount' column must have a value. This row will be imported. 
  • In rows 6-7, data has been entered in the 'Amount' column. This row will be imported. 
  • In row 8-9, the blank 'Description' and 'Amount' columns will be ignored. 

amount-required-description-blank.png

The following image shows you how the data was successfully imported from the CSV file. 

schedule-of-values-successfully-imported.png

 

Invalid Data Entry

The following is an example that shows invalid data entry for the rows in the import template. The example below shows the Commitments tool. However, the import process works similarly in the Client Contracts, Funding and Main Contracts tool.  

Example

The import process fails when the 'Amount' cell is left blank on a line

The following illustration shows you an example of what is imported from a CSV file. Notice that in rows 2-4, data has been entered in each 'Amount' cell. In row 5, the 'Description' can be blank, but the 'Amount' column must have a value. In rows 6-7, no data has been entered in the 'Amount' column. Blank 'Amount' columns will cause the import process to fail. 

csv-required-data-entry.png

  • To import a line item with a £0 value in the 'Amount' column, you must enter a "0" into the 'Amount' column.
  • To import a line item with a £750 value in the 'Amount' column, you must enter "750" in the 'Amount' column. 
  • To import a line item, the 'Description' column may be blank. 
  • If you have only partial data entry on a row and leave the 'Amount' cell blank, an error message like the one below shows you where the error exists. Notice that the message shows that lines 6 & 7 must be a number value. 
    import-sov-error-message.png