OrgChart User Guide

OrgChart supports importing both Excel spreadsheets and CSV files.

In order to import a file, the file must contain the following fields:

• PersonID – Unique identifier for each person or position (typically an employee number or ID)
• SupervisorID – Unique identifier for each person’s (or position’s) supervisor
• Name – Employee name
• Title – Employee title
• Department (Recommended but not required) – A person’s department (e.g. Engineering or Marketing)

You can include an unlimited number of additional fields to your data file (for example, location, email address or mobile phone).

OrgChart can automatically format assistants in your charts. You can either use the Assistant Wizard to create rules to format assistants or you can add an 'IsAssistant' field to your data. If you add an 'IsAssistant' field:

• Set the field name to 'IsAssistant'
• Set the value to 0 or 1 (1 indicates the person is an assistant)

Main Article: Working with Photos

You can include employee photos in your charts. Photos can either be referenced using a 'Photo' field or can be dynamically referenced using the using a Formula. See the Photos topic for more details.

Use the following example to create a data file. The column names do not have to match those shown below.

In the example above, Sandra Chen and George Lopez report to Steve Smith and Arnold Osborne reports to Sandra Chen.

The following example includes a static photo reference and the 'IsAssistant' flag.

You can use the File Manager to upload data files from your computer. You can also use an FTP or SFTP client to upload data files to your account.

Any directory (in your account) can be used for storing data files;however, using the 'Data' directory is recommended.