Can't find what you're looking for? Contact us by email or phone, or start a live chat with a ContractComplete representative.
The importer tool is useful for anyone who already has their unit price contract designed in a spreadsheet. It can save you time by importing both provisional items and line items into ContractComplete. This article discusses how to use the tool effectively.
The first step is to download the latest version of the spreadsheet template. We suggest making a habit of doing this regularly because the spreadsheet does sometimes need to change as we add new features to ContractComplete. This can be done by using the "Import" button on the contract editor page (although this button is on the contractor editor page, provisional items are imported here as well).
For the most part, importing line items is pretty straightforward. In many cases, the columns in typical unit price contracts line up 1-to-1 with the columns in the importer spreadsheet. Simply paste the columns from your spreadsheet into the columns in the template. Description and budgeted unit price columns are optional.
The challenge is that there is no natural way to represent a hierarchy in a spreadsheet. Fortunately, ContractComplete is able to take advantage of the Item Number column to determine the hierarchy. Using a decimal numbering system will allow ContractComplete to interpret the hierarchy from the flat spreadsheet. For example, we can infer that item 1.1.2 is likely a child of item 1.1.
Provisional item import works almost identically to line items import. Establishing folders can be done using the numbering system as in the figure below. When you upload your spreadsheet you will be given the option to import provisional items, line items, or both simultaneously.
Check your inbox for your video. Please ensure you have noreply@contractcomplete.com added to your safe senders list.
We will contact you within 1-2 business days to set up a demo.
We will contact you within 24hrs.
Please check your email and verify your account.
Copyright © 2022 ContractComplete. All rights reserved.