s
Contact Login Register
h M

Dynamic User Directory returning Region and Country Text Values as Opposed to EntryID

Dynamic User Directory simple altering of SQL proc to work with DNN 7.4 and higher that stores Region and Country profiles as EntryID numbers

The attached code is a simple way to also include Region and Country Text and Values so you can use them in DUD item list and detail template:

LI.Text as CountryText,LI2.Text as RegionText,LI.Value as CountryValue,LI2.Value as RegionValue

1) make a backup of the stored proc [DataSprings_RetrieveDNNUserProfileData3]

using sql management studio and create it with a backup name

2) copy the following attached SQL data provider file and run it under Host / SQL of your site

3) then go to host/schedule and run the DUD scheduler

4) edit your DUD template and use RegionText / CountryText / RegionValue / CountryValue

 

Friday, June 10, 2016/Author: David To/Number of views (5228)/Comments (-)/ Article rating: No rating
Tags:
RSS

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

  
Subscribe