Hi Nicolai,

Great that you like CMSImport. You requirement is also possible but requires a little bit of coding. CMSImport comes with a small event system you can hook into. If you take a look at the code below. It wires up an event handler when starting the Umbraco application. Then on each record it checks for the role column in the data source. Based on that it will assign the role name to the member.

You can tweak this to your own needs such as correct column name but should work directly when you use it in your project

    public class AutoAssignMemberGroups : ApplicationBase
    {
        public AutoAssignMemberGroups()
        {
            MemberImport.RecordImporting += MemberImport_RecordImporting;
        }

        void MemberImport_RecordImporting(object sender, RecordImportingEventArgs e)
        {
            var member = sender as Member;
            if (member != null)
            {
                //Assuming Roles is the column in the datasource
                string rolesCsv = string.Format("{0}", e.Items["Role"]);

                foreach(string role in rolesCsv.Split(','))
                {
                    //You might want to cache this
                    var memberGroup = MemberGroup.GetByName(role);
                    member.AddGroup(memberGroup.Id);
                }
            }
        }
    }

Best,

Richard

is working on a reply...