AD Bulk Users
1. What source can I import from?
You can import from a CSV or SKV file or you can import from SQL server. When importing from SQL place all you users into a single table.
2. Do I need to use all attribute names in my import file?
No you do not need to use all the attribute names just the use those you require. The minimum attributes required to create a user is sAMAccountName and userPrincipalName. Remember your domain may also have a password policy, you may need to include the password property.
3. I want to import into a Subdomain how should the LDAP path look?
Something similar to OU=Sales,DC=subdomain,DC=MyDomain,DC=COM
4. How do I set the Country/Region on the users address tab?
The Country/Region property name is simply 'c' (lowercase), the country/region values are defined by Active Directory so you must insert the correct value. If you want to set the value to United Kingdom the use the country code 'GB', for Germany use 'DE' and so on. You can find a full list of country codes here.
5. Is it possible for the program to create an Organizational Unit?
Yes, AD Bulk Users can create Organizational Units. On the 'Settings' tab you will find a check box called 'Create Oranizational Units' when this is checked OUs will be created if they don't exist. If you have a column in your CSV file (or SQL table) called destinationOU (this is where the user will be created) and the path specified (e.g. OU=Test, DC=Dovestones,DC=Com) doesn't exist then the OU 'Test' would be created. You can read more about this feature here.
6. I am using Exchange 5.5, the Users mailbox isn't being created?
The program only supports Microsoft Exchange 2000, 2003 and 2007 as these are both integrated with Active Directory. There are no plans to add support for Exchange 5.5.
7. Does the ODBC function of the program support MySQL?
Currently only Microsoft SQL supported although MySQL support will be added in a future release.
8. The attribute specified to the directory service is invalid.
This error can be caused by the absence of the sAMAccountName attribute. The sAMAccountName value (users logon name) is required for each and every user.
9. A device attached to the system is not functioning.
This error can be caused by the absence of the sAMAccountName attribute or the sAMAccountName is too long (20 character limit) or the value has an invalid character.
10. How do I install the Exchange 2007 Management Tools?
Installing the Exchange 2007 Management Tools on XP & Vista.
11. How do I install the Exchange 2003 Management Tools?
Installing the Exchange 2003 Management Tools on XP & Vista.
12. How do I configure the database for import?
Your user data needs to reside in one table within a SQL database. The data type for each field should be of type varchar. Below is an example table.
