Skip to main content

User profile property values maintained in SSP tables in MOSS 2007

The user profile properties values are stored in SSP tables in MOSS 2007.

The values can be found in UserProfileValue table in SSP
The values are stored for each of the Record ID. Each RecordID corresponds to one user.
Also in the table, the values are given for each PropertyID
The mapping of PropertyID and its corresponding description can be found in the table PropertyList.

Note - it is not advisable to manipulate the SSP DB's.
Labels:

Comments

Post a Comment

Popular posts from this blog

Cannot open SharePoint 2010 Approval task form from Outlook

When trying to click on Open this task from Outlook 2010, it brings an error - " Outlook cannot open a new form. The form contains schema validation errors" Element '{ http://www.w3.org/1999/xhtml}div ' is unexpected according to the content model of parent element '{ http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields}Body '. As given in the error message, the issue is with the Body column of the workflow tasks list. For the approval workflow, there would be a tasks list. In the workflow task list, the Body column is Enhance Rich multi-line column. Change the setting to Plain text, instead of enhanced rich text. After that do an iisreset.
7 comments
Read more

How to link to Download a copy option in Office 365/SharePoint 2013

At times it is required to have the option to save a copy of a document uploaded in SharePoint document library, in a page or a webpart. The url to get the save option for a doc is - http:// site /_layouts/download.aspx?SourceUrl= url-of-document-in-library Change the bold text with the actual url, i.e., with the site url and the url to the doc in the doc library. For example, if the site is www.contso.com and the doc "Test" is uploaded in SiteAssets library, the url to save a copy would be - http://contso.com/_layouts/download.aspx?SourceUrl=http://contso.com/SiteAssets/Test.docx
1 comment
Read more

How to open list form aspx pages in edit mode in Office 365

In case you are not able to open the list forms from the ribbon, to customize the New/Edit/View forms, the same can be done from the gear icon   As seen in the figure below, the Form webpart control is disabled in the ribbon To open, say New form in edit mode, in the url, replace 'AllItems.apsx' with 'NewForm.aspx' Then go to the gear icon in the ribbon and click on the Edit page. Now the NewForm.aspx can be customized.
Post a Comment
Read more