Column to import? - www.DNNMasters.com - Forum - Product Support

Column to import?

Last Post 26 Mar 2011 12:05 PM by DNNMasters. 7 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

ddelforge

New Member Posts:4 Avatar

24 Mar 2011 07:26 PM
Hi, If I just have the username (which is a unike key in DNN system), is it possible to add a role to the account? I try with just an Excel column containing the username but it doesn't work. Do we have to add more columns? The problem is that I just receiving from another program a list of all usernames where I have to add a role. Is it possible? Thanks

DNNMasters

Advanced Member Posts:774 Avatar

25 Mar 2011 07:01 AM
You need at least user name and email (they can be the same). Email is mandatory and you can map it to all other required fields.

ddelforge

New Member Posts:4 Avatar

25 Mar 2011 04:08 PM
Hi, I try like this but nothing work. No role are attributed even when the log said "successfull" and no user receive an email mentionning that he have a new role. Perhaps because I don't understand your program. My scenario is simple: User register on the website and fill in a form. Marketing accept form and give to me a Excel list of UserName accepted. I then have to add the existing role "client" to each user. What could be the steps and options to select in your program to succeed? Thanks for your answer. Dom

DNNMasters

Advanced Member Posts:774 Avatar

25 Mar 2011 05:31 PM
Use the Free file format with fields mapping option to import users adding them to role during the import. But as I said before, you must have an email in order to import/create dnn user account.

ddelforge

New Member Posts:4 Avatar

26 Mar 2011 06:56 AM
Ok, it works. Hard to find his way without an extended documentation. But a problem remains. The user don't receive an email that his account now have access to a new role. I checked the option but, nothing is sent. Normal? Only for user really created?

DNNMasters

Advanced Member Posts:774 Avatar

26 Mar 2011 10:29 AM
I tested again and the emails are sent correctly on user creation. I'm not sure that I correctly understand your case. Are you adding new role to existing users only ?

ddelforge

New Member Posts:4 Avatar

26 Mar 2011 11:12 AM
Yes to existing users only. In fact, a user create an accont by himself and later we give him some new roles.

DNNMasters

Advanced Member Posts:774 Avatar

26 Mar 2011 12:05 PM
OK, I understand now. You need a new functionality that would work like this: Read a usernames or emails list (selectable) and perform one of the available bulk actions on the list. This would be similar to a delete users by importing a list of emails but with extended functionality. We'll add this feature in version 2.0 which is expected within 2 weeks. If you have a user related field in database that would determine new user role you could run this automatically (SQL query based actions) on current version 2.0 RC version. Should you be interested please email support@ with proof of purchase and I'll send you new version.

You are not authorized to post a reply.