I have tried to import a short user list about 15 times now. I have scaled it back trying to trouble-shoot, but no matter what I do, I can't get it to work. I thought there was problem with my data or setup, but now I am wondering if there is something else. I must be missing something.

I am using build:'2.0.0.26141'; on DNN 5.1.1 Are there any known issues wiht this?

These are some of the errors I am getting. It is all very cryptic. The weirdest is probably the DuplicateUserName error since I only have one existing user and that's the admin.

Thanks!

___

Error attempting to add record:1 Object reference not set to an instance of an object. at DotNetNuke.Entities.Users.UserController.GetCurrentUserInfo() at DotNetNuke.Security.Membership.AspNetMembershipProvider.UpdateUser(UserInfo user) at DotNetNuke.Entities.Users.UserController.UpdateUser(Int32 portalId, UserInfo objUser) at DataSprings.DNN.Modules.UserImport.UserImportProcess.DoUserImport()

___

Created User: JOHNDOE - My Portal
User Status (failed) :JOHNDOE failed w/ status: DuplicateUserName;
Skipping to next record;

___

Error attempting to add record:1 Object reference not set to an instance of an object. at DataSprings.DNN.Modules.UserImport.UserImportProcess.DoUserImport()

HI, based on the error message I'm seeing, it's saying "DuplicateUserName" of JOHNDOE. If you go to host / sql and type in:

select * from {objectQualifier}users where username = 'JOHNDOE'

do you see any data for this user? From this, you can get the UserID. Then type in:

select * from {objectQualifier}userportals where userid = ?

replacing ? with the actual UserID. Is the "IsDeleted" column set to 0 or 1? -- David

I did this, but it didn't return a record, so that user must not exist. It only gave this error once though, most of the tiem I get the 'Error attempting to add record:1 Object reference not set to an instance of an object. at DataSprings.DNN.Modules.UserImport.UserImportProcess.DoUserImport() '

I just tried to add a simple file with only 6 records. It imported one of them, and for all the others it gave this error:

**** Error attempting to add record:1 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserProfile_Users". The conflict occurred in database "DNN_Customer2", table "dbo.Users", column 'UserID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.UpdateProfileProperty(Int32 ProfileId, Int32 UserId, Int32 PropertyDefinitionID, String PropertyValue, Int32 Visibility, DateTime LastUpdatedDate) at DotNetNuke.Security.Profile.DNNProfileProvider.UpdateUserProfile(UserInfo user) at DotNetNuke.Entities.Profile.ProfileController.UpdateUserProfile(UserInfo objUser) at DotNetNuke.Security.Membership.AspNetMembershipProvider.UpdateUser(UserInfo user) at DotNetNuke.Entities.Users.UserController.UpdateUser(Int32 portalId, UserInfo objUser) at DataSprings.DNN.Modules.UserImport.UserImportProcess.DoUserImport()


I'm upgrading to version 2.1 - hopefully that will work better.

I am testing this module for the first time and I am also getting a similar error, I'm only trying to import 2 users, one already exists, the other is a new account.

---------------New Imported User---------------

Records:1
Display Name:Alcon
PortalID:7
Skipping User: XXXXXX. This user already exists within the database for this portal. Choose to overwrite existing users if you would like to update existing users.
---------------New Imported User---------------

Records:2
Display Name:Arrowmid
PortalID:7


**** Error attempting to add record:2 Object reference not set to an instance of an object. at DotNetNuke.Security.Membership.AspNetMembershipProvider.UpdateUserMembership(UserInfo user) at DotNetNuke.Security.Membership.AspNetMembershipProvider.UpdateUser(UserInfo user) at DotNetNuke.Entities.Users.UserController.UpdateUser(Int32 portalId, UserInfo objUser) at DataSprings.DNN.Modules.UserImport.UserImportProcess.DoUserImport()
 

UPDATE: Chad rocks, he suggested that I was creating a password that was too short by specifying the prefix as "xx_" and the suffix length as 1, this would only create a 4 character password when 7 is required. He was right, and also the fact that I had tried to import passwords which were too short, either way it won't work.

Thank you for the quick response, exactly what I had hoped for.

If you're still wondering if you should buy this module, JUST BUY IT! Time is money, this will make you money by saving you time!

Thanks Chad!

Josh