Jump to content
Guest Mass

Import list of employees

Recommended Posts

Guest Mass

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,

Share this post


Link to post
Share on other sites
Guest Mass

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!

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 Property guy

could someone PLEASE explain the exact and proper process to import a list of employees into assetmanage software? I have a list of about 200 employees that I'd like to import. The file is in CSV format. It contains Lastname, First name, and phone numbers. The following steps that I have been doing are as follows:

1) File then select "Import"

2) The CSV file is selected. The import data window shows the contents within the file.  I selected "Employees" under 'Import To'.

3)  The window shows the heading contents under the "Source Field Names"  which are Lastname, First name, and phone numbers

4) Trying to select the respective fields for Lastname, First name, and phone numbers under the "Destination Field"...They were all BLANK.

5) Clicked "Ok" but nothing was imported.

Please help. I am testing the software before I purchase for my employer.

Thanks,

 

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...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

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

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×