People Data Upload

This documentation walk-through the options to extract people data from Active Directory, then upload the data to Indoor Finders. 

• Extract data from Active Directory
  • Follow the first part of option 1 (comand-line tool) or option 2 (PowerShell command) to extract selected people data into a Excel/CSV file.   
    • Recommand using the command-line tool because it is much faster and any domain users can extract the data from Active Directory LDAP.  (The PowerShell option requires Exchange Admin permission).
• Upload people data to the Indoor Finders system.
  • Follow the second part of option 1 (command-line-tool) or option 2 (PowerShell command) to upload the exported people data to the Indoor Finders system via web API.   Admin can setup a scheduled tasks to run it daily.
  • The other options is to send us the exported Excel/CSV file to us so we can process it.  Please contact support to setup the SFTP account.

Option 1: Windows command-line Tool

Windows command-line tools for export employee data and photo from Active Directory, then import into Indoor Finders system.

• Download Link: Active Directory DataSync Tools - AD-Export contain scripts to exports data from Active Directory and then upload the data into the Indoor Finders system via Web API. AD-Export requires a standard AD user account permission to export the data and photo from Active Directory.

Data Export Script:  

• 1-ADExport.bat -- Batch file to execute Active Directory User Data and Photo Export
• ADExportForPeopleFinder.exe – EXE to export people data and photo from Active Directory PeopleExport.csv and Photos.zip. The export exports data from AD, including FirstName, LastName, DisplayName, and Email address, plus any data field defined in the ldap-mapping.txt configuration file.
• Ldap-mapping.txt – If you need additional AD attributes to be included in the export, add the AD attribute name into this configuration file.
• ADPeopleExportSettings.xml – ADExport configuration file, please update the settings according to your Active Directory domains info.

Data Upload Script:

• 2-PeopleUpload.bat – Batch file to upload people data to Indoor Finders instance.
• 3-PhotoUpload.bat – Batch file to upload user photos to Indoor Finders instance.
• DataFileUpload.exe – EXE to upload data to Indoor Finders instance
• PeopleUpload.xml – Configuration files for People Data upload
• PhotoUpload.xml – Configuration Files for Photo upload
• PeopleExport.csv & Photos.zip – Exported files from Data Export.

Scheduled Task: Admin can setup Windows scheduled task to run the batch file 0-SyncNow.cmd, which will call all three batch files of export user data, import user data, and import user photos to Indoor Finders instance.

Option 2: PowerShell Command

PowerShell command to export employee data and photo from Office 365, then import into Indoor Finders system. 

• In order to run Exchange Powershell to extract user data, the account needs to be a member of the Read Only Organization Management permission group.

Install and run ExchangeOnlineManagement Module

• Run Windows PowerShell as Administrator, then install the ExchangeOnline Management module (only need to install once).
       PS> Install-Module -Name ExchangeOnlineManagement
       PS> Import-Module ExchangeOnlineManagement

• Create an encrypted Password on File 
       PS> (get-credential).password | ConvertFrom-SecureString | set-content "c:\passwords\password.txt"

• Connect to Exchange Online
  
        PS>  $Username = "Username@domain.com"
        PS>  $PasswordString = "TheTextOnTheEncryptedOnFile"
        PS>  $SecPasswd = ConvertTo-SecureString $PasswordString;
        PS>  $Credentials = New-Object System.Management.Automation.PSCredential ($Username, $SecPasswd)
   
        PS>  Connect-ExchangeOnline -Credential $Credentials

Option 1: Export User list from Exchange Online & upload to Indoor Finders People Finder

#Export
PS> $MBXs = Get-Mailbox -ResultSize unlimited -RecipientTypeDetails UserMailbox |
 select Identity,DisplayName,PrimarySmtpAddress
 &{foreach ($MBX in $MBXs){
  $User = Get-User $MBX.Identity 
  New-Object psobject -Property @{
                                   Identity = $MBX.Identity
                                   Email = $MBX.PrimarySmtpAddress
                                   DisplayName = $MBX.DisplayName 
                                   FirstName = $User.FirstName
                                   LastName = $User.LastName
                                   JobTitle = $User.Title
                                   Department = $User.Department
                                   PrimaryOfficeLocation = $User.Office
                                   MgrName = $User.Manager
                                   Phone = $User.Phone
                                   MobilePhone = $User.MobilePhone
                                   OtherPhone = $User.OtherTelephone                               
                                   }
    } 
  }| export-csv "C:\DataSync\UserList.csv" -notype

#Import
PS> [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls12;
PS> $wc = new-object System.Net.WebClient
PS> $wc.UploadFile("https://YOUR-DOMAIN-NAME.indoorfinders.com/webapi/PeopleDataUpload.ashx?key=YOU-API-KEY&cleanupAction=delete","c:\DataSync\UserList.csv")

Option 2: Export User and Photo from Exchange Online & Upload to Indoor Finders People Finder

#Export

PS> $MBXs = Get-Mailbox -ResultSize unlimited -RecipientTypeDetails UserMailbox |
 select Identity,DisplayName,PrimarySmtpAddress
 &{foreach ($MBX in $MBXs){
     $wc.DownloadFile("https://Outlook.Office365.com/ews/Exchange.asmx/s/GetUserPhoto?email="+$MBX.PrimarySmtpAddress+"&size=HR240x240","C:\DataSync\Photo\"+$MBX.PrimarySmtpAddress+".jpg")
  $User = Get-User $MBX.Identity 
  New-Object psobject -Property @{
                                   Identity = $MBX.Identity
                                   Email = $MBX.PrimarySmtpAddress
                                   DisplayName = $MBX.DisplayName 
                                   FirstName = $User.FirstName
                                   LastName = $User.LastName
                                   JobTitle = $User.Title
                                   Department = $User.Department
                                   PrimaryOfficeLocation = $User.Office
                                   MgrName = $User.Manager
                                   Phone = $User.Phone
                                   MobilePhone = $User.MobilePhone
                                   OtherPhone = $User.OtherTelephone                               
                                   }
    } 
  }| export-csv "C:\DataSync\UserlistPhoto.csv" -notype

#Zip photos

PS> Compress-Archive -Force -Path C:\IFS\ScheduleTasks\Aerohive\Photo\*.* -DestinationPath c:\DataSync\Photos.zip

#Import

PS> [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls12;
PS> $wc = new-object System.Net.WebClient
PS> $wc.UploadFile("https://YOUR-DOMAIN-NAME.indoorfinders.com/webapi/PeopleDataUpload.ashx?key=YOUR-API-KEY&cleanupAction=delete","C:\DataSync\UserListPhoto.csv")
PS> $wc.UploadFile("https://YOUR-DOMAIN-NAME.indoorfinders.com/webapi/PeoplePhotoBulkUpload.ashx?key=YOUR-API-KEY","C:\DataSync\Photos.zip")

 

Option 3: Secure File Transfer (SFTP)

• Customer can choose to upload the exported data to Indoor Finders SFTP site. Please contact support@indoorfinders.com to setup the SFTP site.