birthdays of the day

This is a forum to suggest new features for mojoPortal. 

This thread is closed to new posts. You must sign in to post in the forums.
8/9/2013 3:33:50 AM
Total Posts 159

birthdays of the day

it would be nice a module that shows a list of birthdays of registered members. you can have a module that shows a list of birthdays of the day?

9/6/2013 3:24:38 PM
Total Posts 537
feet planted firmly on the ground

Re: birthdays of the day

Nice thought, but pretty obscure.  And not hard to develop as a custom feature, if you have included DoB in a custom profile. But it makes me wonder whether we could lower the bar for such things? For example, if the mojo tables were exposed as read-only OData endpoints (restful/queryable URLs), exposing data in Atom XML, then the existing XML/XSL module could be used to put data from any table onto a CMS page in just about any way you could think of. We'd have one URL to fetch the details of people with birthdays today, and an XSLT to put them on a page (*). OK this would mean writing XSLT, and understanding the database structure and web services, but it can all be done in notepad and overall easier than developing custom features which often have to be recompiled for each mojo upgrade, etc. Just thinking aloud really after a couple of Friday night ales ;-)

(* actually that may be challenging with the custom profile properties... perhaps not a good example to start with!)

9/8/2013 4:51:01 AM
Total Posts 159

Re: birthdays of the day

it is true .. I thought if he can put that thing in the form of site statistics or better yet as a module in its own right.

in the registration profile of the members I have included the date of birth. can you help me to develop a module for birthdays of the day?

9/12/2013 7:11:47 AM
Total Posts 537
feet planted firmly on the ground

Re: birthdays of the day

I've put together a "recent birthdays" example, by creating an RSS feed of the data, then using the standard Feed Manager to put them on a page. You can see it here which shows members' birthdays within the last 30 days. The real birthdays are concealed in this example, because these are real people and on this site the profiles are not visible to anonymous users.

The RSS is created with an ashx file that you would drop into the root of your installation. The code is all inline, so everything is in one place and can easily be modified to do whatever you want. The RSS handler is not secured (though of course the page you display it on can be), so care is needed about whether and how you show personal data like this - needs user consent etc.

You could also put the content from this RSS feed on a page with more flexibility using the XML/XSL feature, as the RSS feed is XML. But a bit more work to create an XSLT.

It's a bit rough, and could easily be improved - happy to share if anyone interested.

9/23/2013 2:28:56 PM
Total Posts 159

Re: birthdays of the day

crispin hello, thank you.

if I ask for help in the details of how to do. I would like to do something similar to what you did.

if you want to give you my email

9/24/2013 2:58:22 AM
Total Posts 537
feet planted firmly on the ground

Re: birthdays of the day

Here's the code (VB.Net). Paste this into a file called birthdayrss.ashx and make any modifications needed (for example, my custom DoB property was called 'DateOfBirth' - yours might be different, and will require changes to the SQL statement). You may find problems with the code (esp. the SQL statement) after pasting - it might need removal of blank lines etc. Obviously this best done in Visual Studio so you can check syntax. It needs the connection string in user.config and the style files for browser viewing. Drop the file into the root of your mojoPortal site. You should be able to browse to it and see the results. Then you can add it to a page using the Feed Manager, switching off settings like author and date. Or you could use the XML/XSLT module to display the data in a table, list, etc (obviously requiring some work to write the XSLT).

NB no guarantees this code sample will work for you etc etc.

A separate issue, but I'm finding the behaviour of the Feed Manager puzzling with this feed - on my site it is showing birthdays that are no longer present in the RSS feed, even though I've set its cache duration to 60 minutes and "Show Posts up to this many days old" to 1 day, and cleared the feed cache. One for another post.

<%@ WebHandler Language="VB" Class="RssCustomHandler" %>

Imports System

Imports System.Web

Imports System.Data

Imports System.Xml

Imports System.IO

Imports System.Data.SqlClient


Public Class RssCustomHandler : Implements IHttpHandler

Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest

Dim rssXML As String

Dim dt As DataTable, sql As String

Dim BlogTitle As String = "Born on this day..."

Dim BlogLink As String = ""

Dim BlogDescr As String = "RSS feed of members born today"

' fetch all DoBs here - trying to work out today's birthdays in SQL is a thankless task

' when they are stored in an ntext field without rigorous input validation

' NB this is maybe not sensible if there are large numbers of users, but works fine for my site with about 400

sql = "Select U.UserId," +

" U.LoginName AS PersonName, " +

" CAST(PropertyValueString AS VARCHAR(50)) AS DoB " +

" FROM dbo.mp_UserProperties UP " +

" INNER JOIN dbo.mp_Users U " +

" ON UP.UserGuid = U.UserGuid " +

" WHERE UP.PropertyName = 'DateOfBirth'"

dt = GetDataTable(sql)

If dt IsNot Nothing Then

rssXML = CreateRSSXMLstring(BlogTitle, BlogLink, BlogDescr, dt)

context.Response.ContentType = "application/xml"



context.Response.ContentType = "text/plain"

context.Response.Write("No data")

End If

End Sub

Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable


Return False

End Get

End Property

Private Function CreateRSSXMLstring(title As String, link As String, description As String, dt As DataTable) As String

Dim txtResult As String = ""

Dim DoB As Date, BirthdayThisYear As Date, Age As Integer

Dim itemTitle As String = String.Empty

Dim itemDescr As String = String.Empty

Dim itemLink As String = String.Empty

Dim memory_stream As New MemoryStream ' , datePub As Date

Dim xml_text_writer As New XmlTextWriter(memory_stream, System.Text.Encoding.UTF8)


' add processing instr, like this example from mojoPortal blog rss

' <?xml-stylesheet type="text/css" href="" ?> <?xml-stylesheet type="text/xsl" href="" ?>

Dim uri As Uri = HttpContext.Current.Request.Url

Dim RssStyleHome As String = uri.Scheme + uri.SchemeDelimiter + uri.Host + ":" + uri.Port.ToString

If RssStyleHome.Contains("localhost") Then

' dev location of my styling files - allows the RSS to be viewed in browser

RssStyleHome = RssStyleHome + "/WebSite3"

End If

xml_text_writer.WriteProcessingInstruction("xml-stylesheet", "type=""text/css"" href=""" + RssStyleHome + "/Data/style/rss1.css""")

xml_text_writer.WriteProcessingInstruction("xml-stylesheet", "type=""text/xsl"" href=""" + RssStyleHome + "/Data/style/rss1.xsl""")


xml_text_writer.WriteAttributeString("version", "2.0")

xml_text_writer.WriteAttributeString("xmlns:atom", "")

' metadata


xml_text_writer.WriteElementString("title", title)

xml_text_writer.WriteElementString("link", link)

xml_text_writer.WriteStartElement("atom:link", String.Empty)

xml_text_writer.WriteAttributeString("href", uri.AbsoluteUri)

xml_text_writer.WriteAttributeString("rel", "self")

xml_text_writer.WriteAttributeString("type", "application/rss+xml")

xml_text_writer.WriteEndElement() ' atom:link

xml_text_writer.WriteElementString("language", "en")

xml_text_writer.WriteElementString("description", description)

xml_text_writer.WriteElementString("docs", "")

xml_text_writer.WriteElementString("generator", "mojoPortal custom RSS feed")

xml_text_writer.WriteElementString("ttl", "60") ' time to live, i.e. cache minutes at client

' now add the data

For Each dr As DataRow In dt.Rows

' check whether born in relevant timespan, and add to RSS feed if so

DateTime.TryParse(dr("DoB").ToString(), DoB)

Age = GetAge(DoB).ToString

BirthdayThisYear = DateAdd(DateInterval.Year, Age, DoB)

' can easily adapt this test to show birthdays today or within last week/month etc by changing the number

' for today's birthdays only set this to 0

If Math.Abs((DateDiff("d", DateTime.Now, BirthdayThisYear))) <= 30 Then


itemTitle = dr("PersonName").ToString() + " is " + Age.ToString

xml_text_writer.WriteElementString("title", itemTitle)

' link to user's profile, assuming link is website base address

' if it's not, could use HttpContext.Current.Request.Url properties

itemLink = link + "/ProfileView.aspx?userid=" + dr("UserId").ToString()

xml_text_writer.WriteElementString("link", itemLink)

'rss spec requires a guid

xml_text_writer.WriteElementString("guid", itemLink)

' author?

xml_text_writer.WriteElementString("author", String.Empty)

' conceal real date of birth for this demo

'itemDescr = dr("PersonName").ToString() + " was " + Age.ToString + " on " + "32nd of Movember (real date concealed)"

' replace with this to show the real DoB

itemDescr = dr("PersonName").ToString() + " was " + Age.ToString + " on " + BirthdayThisYear.ToString("M")

itemDescr += ". Click the link to view more details about " + dr("PersonName").ToString() + "."


' wrap in CDATA just in case we want to include markup etc



' for some kinds of feed pubDate could come from the data

' for this example, just set to today

'DateTime.TryParse(dr("pubDate").ToString(), datePub)

'xml_text_writer.WriteElementString("pubDate", datePub.ToString("R")) ' RFC1123Pattern

xml_text_writer.WriteElementString("pubDate", DateTime.Now.ToString("R"))

' category tag

xml_text_writer.WriteElementString("category", "birthdays")

xml_text_writer.WriteEndElement() ' item

End If


xml_text_writer.WriteEndElement() ' channel

xml_text_writer.WriteEndElement() ' rss



Dim buffer As [Byte]() = New [Byte](memory_stream.Length - 1) {}

buffer = memory_stream.ToArray()

txtResult = System.Text.Encoding.UTF8.GetString(buffer)


Return txtResult

End Function

Private Function GetAge(DateOfBirth As Date) As Integer

' get the difference in years

Dim years As Integer = DateTime.Now.Year - DateOfBirth.Year

' subtract another year if before the birth date in the current year

If DateTime.Now.Month < DateOfBirth.Month Or (DateTime.Now.Month = DateOfBirth.Month And DateTime.Now.Day < DateOfBirth.Day) Then

years = years - 1

End If

Return years

End Function

#Region "DAL"

Private Function GetDataTable(SQLCommand As String) As DataTable

Dim DT As New DataTable

Dim CONNECTION_STRING As String = ConfigurationManager.AppSettings("MSSQLConnectionString")


Using conn As New SqlConnection(CONNECTION_STRING)

Using com As New SqlCommand(SQLCommand, conn)

Using sqlAdpt As New SqlDataAdapter(com)



End Using

End Using

End Using

Catch ex As Exception

'LogSqlException(SQLCommand, ex, params)

End Try

Return DT

End Function

#End Region

End Class

1/1/2014 1:56:54 PM
Total Posts 18439

Re: birthdays of the day

fyi, in the next release we will have a built in DateOfBirth property in the user profile and included by default in mojoProfile.config. It will have a dedicated field in the mp_Users table making it easy to query, so it will be much easier to build a custom birthdays list feature if you want one.

This new property implemented now in the source code repository.



1/1/2014 2:48:50 PM
Total Posts 537
feet planted firmly on the ground

Re: birthdays of the day

Great news, thanks Joe.

I was having frequent bother with the previous way of capturing DoB, with users able to enter unparsable dates with these settings:

   <add name="DateOfBirth"

(though I expect I could have put a regex validator on).

Now I'll be able to migrate (and clean) the legacy data into the new field, and know it is definitely a date.

2/22/2014 1:16:11 PM
Total Posts 537
feet planted firmly on the ground

Re: birthdays of the day

Hi Joe

Finally getting round to implementing this using MSSQL. I've pushed the dates into mp_users.dateofbirth and deleted the rows from mp_userproperties but I cannot get the values to show in the user profiles. I see the property, but empty, for users where I know there are values. I have used the default profile property in my custom profile as follows: 

    <add name="DateOfBirth"

Am I missing something? Or is it not quite wired up right?

You must sign in to post in the forums. This thread is closed to new posts.