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

Below is a short PowerShell script that you can use to export data from Active Directory and import 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

__________________________________________________________________Related support articles:

*Our support team is available 24x5 via the live chat bubble or support@swipedon.com for any questions or support you may require.