Importing Subcategories

You can import multiple levels of subcategories at once using an Excel spreadsheet.

Important:

  • You must create and save the top-level category (see Adding a Category) before importing its subcategories.
  • The subcategory import template is an Excel spreadsheet in .xlsx format. You must have Excel 2007 or later (or another program that can open and save spreadsheets in .xlsx format) on your computer to prepare the import spreadsheet.
  1. Click System Settings, click Document Setup, and then click Categories.
  2. If multiple sites exist, select the site containing the category you want to add subcategories to.
  1. Click a category (the target category for the subcategory import).
  2. Click the Import tab, and then click Download Template.
  1. A prompt asks if you want to include existing subcategories in the downloaded template. If subcategories already exist under the current category and you want to make modifications to them (such as changing titles or adding descriptions) as part of the import, click Yes; otherwise, click No.
  2. When prompted, open the template and enable it for editing.
  1. Prepare the import spreadsheet (see Preparing the Import Spreadsheet below for details).
  2. Save the spreadsheet in .xlsx (Excel 2007 or later) format.

Important: The older .xls (Excel 97-2003) format is not supported.

  1. Back in PolicyTech, click Browse Files, find and select the import spreadsheet file, and then click Open.

Note: If the Import tab for the top-level category is no longer displayed, click System Settings, click Document Setup, click Categories, click the category, and then click the Import tab.

After uploading and analyzing the file, PolicyTech displays the number of issues found.

  1. (Conditional) If there are issues, click Review Issues, and then click Open. See Handling Import Issues below for details on interpreting the ReviewIssues.xlsx spreadsheet and fixing issues in your import spreadsheet and re-uploading it.
  2. When you are ready to continue, click Preview / Begin Import.

The preview lists the detail and status (Added or Changed) of the categories from the uploaded import file.

  1. Click Begin Import.
  2. When you see the Success message, in the category tree on the left expand the top-level target category to see the imported subcategories.

Preparing the Import Spreadsheet

Use the import template to list the subcategories that you want imported under the target category. Follow the guidelines below to add subcategories to the template.

Note: If you want to change reference IDs of existing subcategories using the import template, be sure to specify that you want existing subcategories included when downloading the template. You can then simply cut and paste the values from the Level[X]RefID column into the Level[X]PreviousRefID column.

Important: Be sure not to list a sub-subcategory on the same row as its parent subcategory.

Handling Import Issues

There are three issue levels:

  1. In the import spreadsheet you just opened, click Enable Editing.
  2. Look in the Errorscolumn (column A) for any cells with a fill color (red, orange, or yellow), which indicates that there is a possible issue with the information in that row. Look across in that row for other colored cells, and then point to a colored cell to display the error detail.

Important: Be sure to scan the entire row for colored cells as there may be multiple issues with the same subcategory.

  1. Do one of the following:

Important: Do not make changes directly in the ReviewIssues.xlsx spreadsheet. Make needed changes in your original import spreadsheet using the information in ReviewIssues.xlsx as a guide.

  1. Back in the Import tab click Start Over.
  1. Click Browse Files, find and select the import spreadsheet file, and then click Open.
  2. Do one of the following: