I have a WSS list containing user profile data (Columns: Username, Name, DOB) etc. I need to display the correct user profile from this list using the username of the currently logged in user (Active Directory).
I know the WSS web parts are limited so I'm going to use the RSS feed for the list and filter & transform it through some XSL using the XML web part.
How do I get the username of the currently logged in user and stick it into my XSL?
SharePoint already has an out of the boxy user profile list, which it uses internally to store user data. When you use MOSS, the user data is stored in the sites Shared Service Provider, and a service (timerjob) updates all user info in sites using that SSP.
To store more profile info than WSS does out of the box i suggest you create a new list, that has a person / group field in it. But most info like emailadress etc are already in that (hidden) list.
More info on the hidden user list and talking to it through code here. More info on using the current user in webparts here.
P.S. I suggest looking into the webpart used in the 2nd article, the DataFormWebPart. It is the most versatile webpart out there, that can be bound to any datasource and can be styled using Xsl.