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:
- Preparing your employee CSV file
- Adding Employees via Bulk CSV Upload
- How to use the Active Directory Sync Agent
*Our support team is available 24x5 via the live chat bubble or support@swipedon.com for any questions or support you may require.