People Import

People can be imported into ITRP using UTF-8 or UTF-16LE encoded comma-separated values (CSV) or tab-separated values (TSV) files.

Detailed information about the data that can be specified in the columns of a People import file can be found in People API - Fields.

CSV example

Primary Email,Source,Source ID,Disabled,Name,Organization,Job Title,Support ID,Cost Per Hour,Manager,Site,Location,Information,Locale,Time Zone,Time Format 24h,VIP,UI Extension,Custom Data
chess.cole@widget.com,,,0,Chess Cole,"Widget North America, Information Technology",IT Manager,430239,200.0,ed.turner@widget.com,Widget Manufacturing Center,Room 305,"Experience & Interests:
- ISO 20000-1, ISO 20000-2 (ITIL)
- ISO 17799",en-US,Central Time (US & Canada),0,0,,
ed.turner@widget.com,,,0,Ed Turner,"Widget North America, Information Technology",CIO,430201,500.0,,Widget International Headquarters,Room 409,,en-US,Eastern Time (US & Canada),1,1,,
tom.peterson@widget.com,,,0,Tom Peterson,"Widget North America, Information Technology",End-User Support Specialist,430243,100.0,chess.cole@widget.com,Widget Manufacturing Center,Room 309,"Experience & Interests:
- Windows 7, Vista, XP, Mac OS X
- Word, PowerPoint, Excel, Outlook, FrontPage
- Apple iPhone
- Microscan barcode readers",en-US,Central Time (US & Canada),0,0,,

download CSV

Updating existing people

Apart from specifying the ITRP ID or the Source and Source ID columns to find an existing record, ITRP is also able to match existing records using the Primary Email value.

This means that when the given Primary Email address matches one of the People in the current Account, all the fields of that person will be overwritten with the values provided in this import file.

Directory Service integration

Visit the Directory Services page for more information about how the Import API can be used to import employee information from Microsoft Active Directory or other LDAP directory services.