Importing CO Proposed 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 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 'Client Contract Administration' link under the 'Accounting and Project Management Departments' section. This will refresh the page and show the 'Contract Admin Module Landing Page'.
- Navigate to the CO row in the 'Stats' section.
- Click the number under Total Records for COs.
- Use the Search field to filter the listing.
- Click on the CO record to view the details.
- Navigate to the CO Proposed Items section.
- Click the 'Add / Import Items' drop-down shown on the right.
- Select 'Import From Excel' option.
- Click the 'Choose File' button to select the Microsoft Excel import file.
- After selecting the file, the data will be imported automatically.
Microsoft Excel Import Sample
CO Item Fields (1st Row):
Column Name | Required (*) | Field Type | Comments |
ItemNumber | * | Integer | Examples: 1, 2, 3 |
ItemCode | Text | ||
ItemDescription | * | Text | |
ItemManufacturer | Text | ||
ItemUPC | Text | ||
ItemCatalogNum | Text | ||
ItemQuantity | * | Number | |
ItemUnit | * | Text | Examples: Ea, LS. Must be 10 characters or less. |
ItemUnitPrice | * | Number | |
ItemMCostRate | * | Number | |
ItemLBaseCostRate | * | Number | |
ItemLBurdenCostRate | * | Number | |
ItemEBaseCostRate | * | Number | |
ItemEBurdenCostRate | * | Number | |
ItemSCostRate | * | Number | |
ItemOCostRate | * | Number | |
ItemCostCode | * | Text | Must exist in the system before importing. |
ItemTaxCode | Text | Must exist in the system before importing. Otherwise, leave blank. |
Copyright © 2023 Corecon Technologies, Inc.