Importing Punchlist Items From Microsoft Excel
How To Prepare The Microsoft Excel Import File
- Open a blank Microsoft Excel Spreadsheet or download the sample file referenced below.
- The first row (column names) should be labeled as shown in the table. Be sure to include the required fields. Field names do not contain any spacing within the word or before and after.
- Insert data starting at Row 2.
- Make sure the Punchlist Item # (ItemNumber column in spreadsheet) does not exist for that particular project. For example, if there are 12 existing punchlist items (i.e. 001 --> 012) for project # GC-001, the ItemNumber column should start out with '013' without the quotes.
- Make sure the sheet name that contains the data is labeled Sheet1.
- Save the file in Excel 97-2003 format (*.xls).
- Close the file otherwise Corecon can not import the data.
Steps To Import the File
- Click the 'Projects' icon on the left menu.
- Select the Project in the 'Quick Select' section. This will then refresh the page and show the 'Current Project Home' page.
- On the 'Quick Links' tab, click the 'Quality Control (QC) and Safety' link under the 'Project Management and Field Staff' section. This will refresh the page and show the 'QC and Safety Module Landing Page'.
- Navigate to the Punchlist Items row in the 'QC Stats' section.
- Click the blue 'Actions' button on the far right.
- Click 'Import From Excel' option from the drop-down menu.
- Click the 'Select Excel File' button to select the Microsoft Excel import file.
- After selecting the file, the data will be imported automatically.
Microsoft Excel Import Sample
Punchlist Item Fields (1st Row):
Column Name | Required (*) | Field Type | Comments |
ItemNumber | * | Text | If Punchlist Items already exist (i.e. 001 thru 010) for the Project, please use the next available Item Number (i.e. 011) when uploading. |
Description | * | Text | |
InspectionDate | Date | Inspection Date (along with Inspectors) must exist in the system before importing. | |
ResponsibleCompany | Text | The Company referenced must exist in the Contact Management module before importing with the name matching exactly. Otherwise, the Punchlist Item will not be imported. This field can also be left blank. | |
ResponsibleContact | Text | Like the Company reference, the Contact must exist in the Contact Management module and match the Display Name exactly. Otherwise, the Punchlist Item will not be imported. This field can also be left blank. | |
Location | Text | ||
DueDate | Date |
Copyright © 2023 Corecon Technologies, Inc.