Support

Submit a ticket My Tickets Login
Welcome
Login

Connect HR Export Directly From SharePoint

Are you bringing additional user data to tyGraph that isn't in Entra ID? Previously, you might have been exporting files and sending them to tyGraph Operations manually. However, starting February 2024, there's no need for manual imports. If you store your export anywhere in your SharePoint tenant, tyGraph can retrieve the file and automatically load it into your database.


Steps

Result

Each time tyGraph runs, it will connect to that file and import it automatically. 


Save File in SharePoint

An Excel file (xlsx only) can be saved anywhere within the SharePoint tenant, and tyGraph will retrieve that file each collection cycle. The file can be saved in a secure site or library due to its sensitive information. Additionally, an automated export from an HR system can be set up to save the file with updates, provided it follows the specified format requirements.


Format: The file must contain an "Email" column on the left edge. After that you can include as many attributes you like in any order as long as they fit one of these names.


Copy File Location

Open your Excel File in Desktop after placing it in SharePoint.

  1. Click "File"
  2. Click "Info"
  3. Click "Copy Path"
    The path should look like this:
    https://unlimitedviz.sharepoint.com/sites/tygraphteam/Shared%20Documents/HRIS%20URL%20Import%20Test/HRIS%20Import%20Test.xlsx 


Send Location Path to AvePoint

Email path to [email protected] and title the request. "HR Export Connection Request in Classic tyGraph"


Acceptable Column Names

Email
*Email is required*
Address
OrgLevel01
Attribute01
City
OrgLevel02
Attribute02
ZipPostalCode
OrgLevel03
Attribute03
StateProvince
OrgLevel04
Attribute04
Country
OrgLevel05
Attribute05
CountryCode
OrgLevel06
Attribute06
Continent
OrgLevel07
Attribute07
Organization
OrgLevel08
Attribute08
Department
OrgLevel09 
Attribute09
JobTitle
OrgLevel10
Attribute10
Division


BusinessUnit


ManagerEmail


OfficeLocation




For AvePoint Operations 

Please format the provided URL as follows:


Before

https://unlimitedviz.sharepoint.com/sites/tygraphteam/Shared%20Documents/HRIS%20URL%20Import%20Test/HRIS%20Import%20Test.xlsx


After
{"SiteUrl":"https://unlimitedviz.sharepoint.com/sites/tygraphteam","FolderPath":"sites/tygraphteam/Shared Documents/HRIS URL Import Test","FileName":"HRIS Import Test.xlsx","TokenResource":"https://unlimitedviz.sharepoint.com","DestinationTableName":"tgAppData.HarvestUserProperty_Improvement"}