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.
- Click "File"
- Click "Info"
- 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 support@avepoint.com 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"}