I have a XL file with 1862 users to import into a Joomla component Community Builder.
Member ID, CustomerTitle, First Name, FamilyName, Date Of Birth, Email
I have set up some custom feilds in CB user tab for Member ID.
Attached is the xl file with some sample records.
We need to make the username the full name "First Name + FamilyName"
We need to make the pass word the Date Of Birth so DOB = 06-Sep-30, password would be "06Sep30"
email goes into email field, memberID goes into member ID field, CustomerTitle goes into customer title.