Can you post what format/fields you are currently using when you try to import?
Thanks Brandon
I attached a zip file with a csv file I tried to import. I suspect I do something wrong.
Fredi,
We did not receive any attachment for the CSV file. Are you sure you attached on? Here are some things to consider:
1. Are your credentials correct? From the description we can't tell which screen you made it to before the error.
2. The CSV can be in any format as long as all *like* fields are in the same columns. All user names should be in the same column, all passwords should be in the same column, etc. Then you will be allows to map which column goes to which value. Unmapped columns are ignored.
3. There are some required fields that need to be mapped to some column in your CSV such as: Sam-Account-Name, Password, Organizational Unit (for AD account only). And for Exchange accounts you need Alias, Name, SamAccountName, Password, Database, OrganizationalUnit, UserPrincipalName. If any of these values is bad that user will not be imported and you will receive a notification. The remaining users will be imported.
4. If your CSV does not have all of the required information you can type in some manual values to fill out the rest of the needed information.
--HTH
Steve
Hi,
I'm looking for your CSV file too ...
May i ask for sample CSV , it will help me a lot !
For example Password is in clear or it could be encrypted ?
Regards
David
Here are some cuts from two sample CSV files that we know will work. This first excerpt is for importing into AD. No exchange:
Sam-Account-Name,Password,OrganizationalUnit,Given-Name,Surname,Initials,Display-Name
user1,Password1,,Name1,Surname1,A,Name1 A. Surname1
user2,Password2,"OU=test,DC=root1,DC=forest1,DC=local",Name2,Surname2,B,Name2 B. Surname2
user3,Password3,,Name3,Surname3,C,Name3 C. Surname3
user4,Password4,,Name4,Surname4,D,Name4 D. Surname4
user5,Password5,,Name5,Surname5,E,Name5 E. Surname5
user6,Password6,"OU=test,DC=root1,DC=forest1,DC=local",Name6,Surname6,F,Name6 F. Surname6
user7,Password7,,Name7,Surname7,G,Name7 G. Surname7
user8,Password8,,Name8,Surname8,H,Name8 H. Surname8
user9,Password9,,Name9,Surname9,I,Name9 I. Surname9
user10,Password10,,Name10,Surname10,J,Name10 J. Surname10
Note that the first three columns are mandatory but if organizational Unit is empty the application will use the default organizational unit.
Here is an excerpt for importing via Exchange:
Alias,Name,UserLogonName,Password,Database,OrganizationalUnit,FirstName,LastName,Initials
alias1,user1,userLogon1,New!Password_1,Mailbox Database 0898926375,"CN=Users,DC=exchange10,DC=root,DC=local",FirstName1,LastName1,A
alias2,user2,userLogon2,New!Password_2,,,FirstName2,LastName2,B
alias3,user3,userLogon3,New!Password_3,,,FirstName3,LastName3,C
alias4,user4,userLogon4,New!Password_4,Mailbox Database 0898926375,,FirstName4,LastName4,D
alias5,user5,userLogon5,New!Password_5,,"CN=Users,DC=exchange10,DC=root,DC=local",FirstName5,LastName5,E
alias6,user6,userLogon6,New!Password_6,,,FirstName6,LastName6,F
alias7,user7,userLogon7,New!Password_7,,,FirstName7,LastName7,G
alias8,user8,userLogon8,New!Password_8,Mailbox Database 0898926375,,FirstName8,LastName8,H
alias9,user9,userLogon9,New!Password_9,,"CN=Users,DC=exchange10,DC=root,DC=local",FirstName9,LastName9,I
alias10,user10,userLogon10,New!Password_10,,,FirstName10,LastName10,J
Note that the first six columns are mandatory but if organizational Unit and Database are empty the application will use the default organizational unit and mailbox database. You can select the mail box database from existing ones listed in the tool so you don't need to know the names of those databases while creating the file.
--HTH
Steve
Thanks for those samples, its very useful !
Another question about password, is it possible to import hash passwd ( i.e sambantpasswd from ldap ) ?
Regards
David
tsang,
You cannot import encypted passwords. The passwords must be clear text.
--HTH
Steve
Fredi,
Can you go into Settings and set the logging level to Verbose then try your operation again. Then you can send us a log segment from:
<All Users Profile>\Application Data\SolarWinds\UserImportTool\UserImportTool.log
Also, please let us know at which step you got the error. The will tell us what is going on.
--HTH
Steve
Thanks Steve
I wil try to follow your instructions in a week or so as I do not always have access to the server.
Run "csvde -f test.csv" (no quotes of course) from the command line for active directory.
This will get you a dump of your current active directory. I just narrowed it down to one my template user and copied that. I got rid of any columns that I didn't want to modify.
Here are the fields that I kept. The I just mapped them in the import tool.
| givenName | sn | memberOf | DN | objectClass | Common Name | pwdProperties | dc | cn | description | ou | displayName | primaryGroupID | sAMAccountName | member | userPrincipalName | Password |
Here are the mappings that worked for me.
Derek
