| Column Missing (not required) |
This is a warning and does not require a revision unless the missing column is still needed. This warning occurs when an existing hierarchy is updated with a file that does not contain one or more of the optional columns in the existing hierarchy.
|
| Duplicate entries found
|
A member exists in the CSV file more than once. To fix the error, sort the CSV file by the ID column and review for duplicate members.
|
| Empty entries found
|
Specific information is missing from a required field. To fix the error, review the file for any blank cells in required columns, which are described in the Hierarchy Attributes topic.
|
| Format Syntax Error
|
The specified rows are not formatted correctly (e.g., not valid email address format, ID format is incorrect, the date format is not YYYY-MM-DD, etc.). To fix the error, check the identified rows and fix the format as needed. See Hierarchy Attributes for information on formatting data.
|
| Incorrect format found
|
The file format must be Comma Separated Values (CSV). To fix the error, save the file as a CSV file. If your data contains leading zeros, verify the zeros still exist once the file is saved as a CSV file.
|
| Invalid Header Format
|
The column header has a specific format (must begin with a letter and can only contain letters, numbers, ampersand, and underscore). To fix this error, check all the column headers within the file and revise as needed.
|
| Invalid Parent
|
For a specific member(s), a Parent ID is listed that is not part of the ID column. To fix the error, check the specific rows within the file and make sure the Parent ID is valid and part of the ID column.
|
| Invalid Root
|
There are more than one blank cell within the Parent ID column. There can only be one blank cell within this column, which is the topmost level of your organization and does not have a parent). To fix this error, check the Parent ID column for more than one blank cell and revise as needed.
|
| Missing columns
|
This can be either a warning or an error. If an optional column exists in the hierarchy but is missing from an update file, it is a warning. If it is a required column, this is an error. To fix the error, add the required column(s) back.
|
| Missing Required Data
|
The specified rows are missing required information. To fix the error, check the file and add the required information as needed.
|
| Ragged Hierarchy
|
Currently, the hierarchy file must be balanced which means that all members within all the levels must follow the same lineage (e.g. all agents roll up to a team lead, all team leads roll up to a manager, etc.).
|
| State Date Column Includes Future Date
|
If the Start Date column is chosen, the date cannot be in the future. To fix the error, the Start Date must be revised to a date in the past or today’s date.
|
| Start Date(s) After End Date(s)
|
If the Start Date and End Date columns are chosen, the Start Date cannot be after End Date. To fix the error, any Start Date value(s) greater than, or after the corresponding End Date must be revised to a date which occurs before the End Date.
|
| Timed Out
|
You may have been inactive for some time so your session has timed out. To fix this error, restart the hierarchy load process.
|
| Unknown Error
|
This is a general error that may require help from ForeSee Support. First check your file for general errors as well as try to reload it once more. If you receive the error again, please contact ForeSee Support.
|
| Version Effective in the Future
|
If the Version Effective column is chosen, the date cannot be in the future. To fix the error, the Effective date must be revised to a date in the past or today’s date.
|
