How to use Windows PowerShell to export data from Active Directory and import it into SwipedOn

Guide to use windows powershell to export AD data in order to bulk upload your employees

Below is a short PowerShell script that you can use to export data from Active Directory and import it into your SwipedOn web dashboard. 

By using this script, you can export employee records from Active Directory into a neatly formatted CSV file that's ready for upload into our SwipedOn system.


Powershell Script Considerations

  • Export-SwipedOnCSV.ps1.

  • This short script exports contacts from Active Directory into a CSV format suitable for SwipedOn.com.

  • The Select-Object removes '.' from the "first_name" field, or else you will get an "Illegal Character" warning when uploading your CSV.

  • You might have to change the "mobilephone" property in Get-ADUser depending on where you store your phone number values in AD.


Powershell Script 

$UsersOU = "OU=Users,OU=YourOU,OU=Somewhere,DC=company,DC=tld"
$CSVpath = "\\some\folder\swipedon.csv"
Get-ADUser -SearchBase $UsersOU -Filter {Enabled -eq $true} -Properties givenname, surname, emailaddress, mobilephone |
Select-Object @{n="first_name";e={($_.givenname).replace(".","")}}, @{n="last_name";e={$_.surname}}, @{n="email";e={$_.emailaddress}}, @{n="phone";e={($_.mobilephone).replace("+","00")}} |
Export-Csv -Path $CSVpath -Force -NoTypeInformation -Encoding UTF8