This project is read-only.
1

Closed

aspnet_Profile is not updated with the extended profile info in the import file

description

The import of basic user information from the import file works correctly, i.e., the username, display name, email address, account added to Registered User and Subscriber Roles, and are Activated.
 
But, the aspnet_Profile table used for Managed Profile (user account Profile) is not updated with the extended profile info provided in the import file.
 
Anyway you can fix this and allow a re-import of the data and have the aspnet_profile table to be updated?
Closed Sep 8, 2014 at 12:32 PM by fordnn

comments

dcollet wrote Nov 17, 2012 at 9:53 AM

I have te same issue (DNN 6.x): Firstname, Name, Username, Passwort, Email ist importet correct. But the fields for the userprofil (adress, phone ...) are not stored.

wrote Feb 14, 2013 at 12:10 AM

mdmiko wrote Feb 25, 2013 at 12:40 PM

                    DotNetNuke.Entities.Users.UserInfo objUser = new DotNetNuke.Entities.Users.UserInfo();

                    objUser.AffiliateID = Convert.ToInt32(dr["AffiliateId"].ToString());
                    objUser.Email = dr["Email"].ToString();
                    objUser.FirstName = dr["FirstName"].ToString();
                    objUser.IsSuperUser = (dr["IsSuperUser"].ToString() == "1");
                    objUser.LastName = dr["LastName"].ToString();
                    objUser.PortalID = this.PortalId;
                    objUser.Username = dr["Username"].ToString();
                    objUser.DisplayName = string.Format("{0} {1}", objUser.FirstName, objUser.LastName);                                        

                    //Please uncomment next lines in case you need to generate valid length password
                    //if (objUser.Membership.Password.Length < 7)
                    //{
                    //    objUser.Membership.Password = "C0mpan1" + objUser.Membership.Password;
                    //}

                    //Deprecated
                    //objUser.Membership.Email = objUser.Email;
                    //objUser.Membership.Username = objUser.Username;

                    objUser.Membership = new UserMembership(objUser);
                    objUser.Membership.PasswordQuestion = objUser.Membership.Password;
                    objUser.Membership.UpdatePassword = true;
                    objUser.Membership.Password = dr["Password"].ToString();
                    objUser.Membership.Approved = true;

                    //Initialise the ProfileProperties Collection
                    objUser.Profile.InitialiseProfile(PortalId);
                    objUser.Profile.PreferredTimeZone = PortalSettings.TimeZone;
                    objUser.Profile.PreferredLocale = new Localization().CurrentUICulture; ;
                    objUser.Profile.Country = dr["Country"].ToString();
                    objUser.Profile.Street = dr["Street"].ToString();
                    objUser.Profile.City = dr["City"].ToString();
                    objUser.Profile.Region = dr["Region"].ToString();
                    objUser.Profile.PostalCode = dr["PostalCode"].ToString();
                    objUser.Profile.Unit = dr["Unit"].ToString();
                    objUser.Profile.Telephone = dr["Telephone"].ToString();
                    objUser.Profile.FirstName = objUser.FirstName;
                    objUser.Profile.LastName = objUser.LastName; 

mdmiko wrote Feb 25, 2013 at 12:41 PM

Maybe this modification could work.
To add profile Info, you need to inizialize ProfileProperties Collection

fordnn wrote Jan 13, 2014 at 8:13 AM

Advanced version of module allows to export/import users accounts, profiles properties and roles. Please check it at https://usersexportimport.codeplex.com/.

wrote Sep 8, 2014 at 12:32 PM