Cortex | Administration | Project Import Templates
Manage project import templates (Administration)
Only users who are set up as administrators in Cortex have access to this feature.
Use the Project import templates option to create and edit project import templates to meet your company's needs. As the name implies, these templates are used to import projects into Cortex Project The templates determine which fields are imported for projects and their items (Items are similar to estimate items in Sage Estimating. They display in the bottom pane of the single project page when viewing elements.).
All fields is a factory project import template that includes all the fields in the system. Administrators cannot remove fields from this template or delete it, but they can:
- Reorder the fields in the template.
- Make a copy of the template and then edit the copy.
Warning. When you set up a project import template, be sure to include every field that would ever be populated for the project type associated with the template. If you omit fields that will contain values for the project, your team is at risk of losing data when they re-import projects using the template.Example(An estimator imports an office project that contains a value for the Number of boilers field. Later, you set up a template for Commercial office projects, but do not include the Number of boilers field in the template. When the estimator generates the project import template for the project using the Commercial template, enters their changes in the Excel project import template, and imports it into Cortex Project History, the Number of boilers field is removed from the project in Cortex Project History because that field does not exist in the project import template file.)
Tips
- Project import templates align with the available views in the Edit view list when editing project attribute (field) values.
For example, suppose you have a project import template named Required fields only that contains only the required project fields. The Edit view list (located in the Edit Project window) contains a view named Required fields only. When you select the Required fields only view, the corresponding required field values are available for editing in the Edit Project window.
- Cortex ensures that any new or existing fields you make required are automatically added to all your project import templates.
How do I?
Open the Administration module
Click
and select Administration from the menu. The Administration module opens in a new browser tab.
Create a new project import template
- In the Administration module, click Project import templates in the options list.
- Click Add.
- In the Import template name box, enter a name for the template. (Required)
- On the Project tab, drag fields between the Available list and the Selected list to select the fields you want to import for the project. Your selections determine the rows that appear on Project sheet in the project import template. (Note that Cortex includes required fields automatically in all of your project import templates. You can't remove required fields from project import templates.)
Cortex Project History uses the same groups (General, Financial, Project, and so on) you see in the lists to group the fields on the Project sheet in the template.
Expand and collapse field groups and use the Search box at the top of the list to help locate specific fields.
Drag fields up or down in the Selected list to determine the order of the field rows on the Projects sheet in the template.
- Click the Items tab, and use the same process to select the fields you want to use for importing items. Your selections determine the columns that appear on the Item sheet in the template.
Drag fields up or down in the Selected list to determine the order of the field columns on the Item sheet in the template. Note that you cannot remove Description from the Selected list because the item description is required for creating items during the import.
- Click the Auto-create items tab. From the list, select the element browse view (hierarchy ) (Uniformat, MasterFormat, Discipline, etc.) you want to use to automatically create items rows in the template.
How does this work?
When you download a blank copy of the template, the system creates an item row on the Item sheet for every combination of code values in the selected hierarchy, from the top node of the hierarchy down to the terminal node.
- The Active option controls whether the template appears in the list of project import templates when users select Download import template on the
menu.
When you are ready to make this template available to other users, select the Active option. If this template is still under development and you do not want other users to be able to access it, clear the Active option.
- Click Save to save your changes and keep working in the template or click Save & close to save your changes and return to the Import templates page.
Copy a template
- In the Administration module, click Project import templates in the options list.
- Select the template you want to copy, and then click Copy. (For example, you can copy the All fields template, which includes all the fields in the system. On the Project tab of the All fields template, the fields appear in order by group and in alphanumeric order within each group. On the Items tab, all the fields appear in alphanumeric order.)
- In the Import template name box, enter a name for the template. (Required)
- Add and delete fields on the Project tab as needed. (Note that Cortex includes required fields automatically in all of your project import templates. You can't remove required fields from project import templates.)
- Change the order of the fields on the Project tab as needed.
- Add and delete fields on the Items tab as needed.
- Change the order of the fields on the Items tab as needed.
- Select a different element browse view on the Auto-create items tab, as needed.
- Click Save to save your changes and keep working in the template or click Save & close to save your changes and return to the Import templates page.
Edit a template
- In the Administration module, click Project import templates in the options list.
- Select the template you want to edit, and then click Edit.
- Modify the fields on the Projects and Items tabs, as needed. (Note that Cortex includes required fields automatically in all of your project import templates. You can't remove required fields from project import templates.)
- Select a different element browse view on the Auto-create items tab, as needed.
- When you finish editing the template, click Save & close to save your changes and return to the Import templates page.
Delete a template
- In the Administration module, click Project import templates in the options list.
- Select the template you want to delete, and then click Delete.
- To confirm that you want to permanently delete the template, click Delete again. Cortex Project History deletes the template.
Change the order that the templates appear on the download import template list
- In the Administration module, click Project import templates in the options list.
- The Import templates page lists the import templates in the order that they appear on the download import template list.
Drag and drop templates in the list as needed to position them in the desired order.
Download a project import template
Use the following procedure to download a project import template so you can review and test it.
- In the Administration module, click Project import templates in the options list.
- Select the import template you want to download and click Edit.
- Click
(Download import template) in the top right corner.
Cortex opens the import template in Microsoft Excel.
Import source files
In prior versions, Eos Cortex required users to transform their external data into a rigid Eos-supplied Excel workbook structure. The new Import source profiles page in Admin offers users a tool to read and import conforming Excel workbooks in their native structure. Contact your Eos consultant or our support team for guidance in implementing this new time-saving feature.