Guest Mass

Import list of employees

3 posts in this topic

Hello

Can we import a list of employees from an Excel file? or best load it from LDAP (active directory)?

Or is there a quick way of inputing bulk employees?

 

Thanks,

admin likes this

Share this post


Link to post
Share on other sites

Found it myself.

File --> Import ans select a csv

I used CSVDE command to export list of user if my active directory
Example: this will export last name, first name and email
csvde -f output.csv -d "OU=ABC,OU=Users,OU=LONDON,DC=DOMAIN,DC=COM" -r "(objectClass=user)" -l "givenName,mail,initials,sn"

Thanks!

admin likes this

Share this post


Link to post
Share on other sites

Hi, thanks for the follow up, yes you can import from an Excel spreadsheet.  It is best to save the spreadsheet as a CSV file before importing to remove any Excel formatting that can cause problems when importing.

We do not currently support direct import from Active Directory.

Share this post


Link to post
Share on other sites
Guest
You are commenting as a guest. If you have an account, please sign in.
Reply to this topic...

×   You have pasted content with formatting.   Remove formatting

  Only 75 emoticons maximum are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

Loading...