DNN 7 makes it possible for customization on the registration kind by way of an easy interface, with intellisense. You simply choose "Custom" for Registration Type Type in Admin - Site Settings - User Account Settings tab and also you can add all of the fields you prefer to your registration form.
In the moment of writing, this doesn't appear to function nicely with custom registration properties (i.e. fields you might have designed oneself by way of the "Profile Settings - Add New Profile Home button beneath on the same tab). If you try and kind a custom property's name around the Registration Fields box, it just will not come up (despite the fact that it's been reported that properties of datatype "Text" do come up).
In an effort to make these properties obtainable for your registration type until a repair is applied to this, you are able to use SSMS (supplied which you have access and knowledge using it) and do the following:
- Go to your DNN database
- Open the "PortalSettings" table for edit and find the record which has the worth "Registration_RegistrationFields" in the "SettingName" field
- You will see that the "SettingValue" field is really a comma-delimited list containing the field aliases of the properties that are to become displayed on the custom registration form. Add the aliases of the own fields within the list.
- Update the table and visit your DNN installation (as the Host user), and click on Tools - Clear Cache
- If every thing goes nicely, you will see that the "Registration Fields" box now contains your properties too, and they'll appear generally on the registration form.
An additional approach to do that would be to use the Host - SQL section on your DNN installation. To find out the present profile properties that are displayed on the custom registration type, sort this in to the Script box and click "Run Script":
SELECT
SettingValue
FROM {databaseOwner}{objectQualifier}PortalSettings
WHERE
SettingName = 'Registration_RegistrationFields'
In order to add one or more fields at the end of the list, you must run something like this (where 'MyField' is your custom field's alias). Remember the comma and use no spaces.
UPDATE
{databaseOwner}{objectQualifier}PortalSettings
SET
SettingValue = SettingValue + ',MyField'
WHERE
SettingName = 'Registration_RegistrationFields'
After you run it, go to Tools and click Clear Cache and you will see your fields on the "Registration Fields" box in the Admin - Site Settings - User Account Settings tab.
If you still need more power and customization with your custom registration page, take a look at the Dynamic Registration module from Datasprings - at the moment of writing this, version 5.0 has just been released for DNN 7.x.
Standard disclaimer: When you do stuff like the above on your database, you do it at your own risk, and I have no responsibility should you damage your database, your computer, or the universe. Always have a backup handy! :)
Until next time!
Best DotNetNuke Hosting Recommendation
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET Hosting. ASPHostPortal.com has ability to support the latest Microsoft and ASP.NET technology, such as: such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. ASPHostPortal include shared hosting, reseller hosting, and sharepoint hosting, with speciality in ASP.NET, SQL Server, and architecting highly scalable solutions. ASPHostPortal.com strives to supply probably the most technologically advanced hosting solutions available to all consumers the world over. Protection, trustworthiness, and performance are on the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.