.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Add new fields Profile database

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :SharePoint

I have new "Fields" which is not in the AD of my users. I want to add these new "Fields/ Columns" in the Profile database?

The objective is to create custom page in MOSS to facilitate the HR to update these new fields for the users.

How to achieve this?


View Complete Post

More Related Resource Links

Update Profile Database from text file using BDC



I have a requirement to import the profile properties from a text file in sFTP to update the MOSS Profile Database. The objective is to create a single repository for the Staff Directory in MOSS.

Can I use BDC to connect and update the Profile database?

What is the alternate approach?


Change database fields automatically according to date

Hi, I'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?

My Site - My profile - Edit my profile - required fields

Hi All, I'm having an issue with the Edit my profile page from my sites (my profile page).  When I setup required fields through the User properties setting in central admin and then go back to Edit my profile page and try and submit the form with nothing in a required field I get no error/warning that I must enter something in the required field. For example I've setup a policy to make 'Ask me about' required, I've then went into the User properties to confirm the 'Ask me about' property has the policy setting to 'Required'.  Go back to my edit my profile page and try and submit the form with nothing in the ‘Ask me about‘ field, and the form submits with no error or warning telling me that I've not completed 'ask me about'. Any ideas, am I doing something wrong?    

Putting data from a variables into a compaq sql database row of fields?

Hi everyone,  I have not used database in two years and have forgotten how to set one up completly. I have made a compaq databse 3.5 and have built the columns. I know how to put the data in manualy. I watched the Video on database and it showed how to bind controls to the datbase but it gave no method when you have the data in variables.  What I have is 7 variables some are using arrays and some are made up from data in  the arrays. I need to populate the db with the data in these variables at the time when my applications has the data ready. I have the connection set up and it does open and close the connection but every search I have made has used binding to bind database to a control that has the data in it.  What method would be the best to use performance wise? Could you point me to an example of this method? CurtisAlways Lost in Code, Always mark answers as correct if they answer you question and solve your problem. This way others when searching for similar problems can find the answer faster.

Unable to see Active Directory Groups in the User Profile Database after Profile Import

SharePoint Server 2010 Enterprise RTM. W2K8R2 w/multi-server setup: AD/DNS SQL 2008 WFE APP Claims Mode Web App only using Windows Integrated Auth So, this was never a problem in 2007, and I didn't even realize it was a problem in 2010 until I started to build a solution that utilized my blog article: InfoPath - User Roles in Browser-Enabled Forms Using AD Groups.  I went to utilize the same web method of the same web service, but I noticed that no data was showing up at all.  Typically, the GetUserMembership/GetCommonMembership methods return the specified user's memberships: AD Security Groups, AD Distribution Lists, and SharePoint Sites (not SharePoint Groups, though). My user profile sync is working.  All AD users are pulled in with the proper profile data. "Users and Groups" is selected in the Synchronization Entities section of my Sync Settings. Security groups are working for permissions and audience targeting.  Confirmed my users are affected properly by the use of Security Groups. My query to the GetUserMemberships web method (and GetCommonMemberships) is running (not failing), but it's not returning anything even though my user is in some Security Groups and has explicit membership to multiple sites. The GetUserProfileByName method of the same UserProfileService.asmx web service returns all the regular profile data

Profile EMM fields error when using Mysites cross farm (SP2010 RTM)



I have a question that took me a while already. I set up an evironment at a Customer of mine as following:

2 farms:

Farm 1 (publishing farm (PF)):
Service applications (User profile and metadata services)

Farm 2 (consuming farm (CF)):
Webapplications (my.portal.nl webapplication).

I published all the services on the PF and succesfully made a connection to the service throughout the CF. The mysite host location is created under the my.portal.nl webapp.

Everything seems to work perfect. The only thing that doesn't work is the following: When I open the my site host and want to edit my profile properties all the fields that need keywords or metadata are not reachable. When I put the my site host location on the publishing farm --> IT WORKS....

I get the red error beneath every EMM field that says: "the service is temporarily disabled...."

I believe I missed a configuration step somewhere in de connection part between the webapp and the service app when going cross farm????

I think problem is somewhere in the combination of Cross farm, Managed Metadata and User profile service....

Can anybody help me with this problem??

Thanks in advance!



Search, My Profile fields, and NoCrawl...?


We've implemented User Profile Service Application and the Search Service Application. We've added custom fields to My Profile, and tested searching for them. Search doesn't seem to return any results. It doesn't report on any errors, however I've got one warning that might be related:

MySites has got NoCrawl property set to on.

Is this the cause for the Search not finding anything? Can you explain why it seems to be 'best practice' to keep NoCrawl on for the MySites application?

creating profile using an existing database raither than default database of ASPNETDB.MDF


Alternatively, you could create your own custom Profile provider that operates against existing database tables .

Please, i want u to help me out if u have an idea where i can get steps by steps to carry out the above operation.

i know there are various options in creating profile , particularlly the use of web. configuration, the default ASPNETDB,  and XML files, BUT i wish to use an existing database which i prefer.

Need Clarifications on SharePoint 2010 User Profile properties and Sync database security


Need few clarifications on SharePoint 2010 user profile sync. I’ve answered some of them but need confirmation/clarity on this front.

  1. Is there option to disable ‘email address’ import from AD?
    Yes. Can disable that property mapping.
  2. Possible to send mails (user alerts) from SharePoint without the user profile property ‘email address’ mapped?
    Yes. User alert mails from SharePoint will work without ‘email address’ mapped in user profile DB.
  3. In case email address too is imported into SharePoint, can we bulk export them from SharePoint? If Yes, how to security harden that database?
    Not Sure. I believe Farm admin account/sync account has access to do this profile DB.

 Thanks in advance for your advice.<

populate pdf form fields from database or XML


 Hi, I have a web app that stores data in an SQL database. What I want to be able to do is to have a pdf form with fields that I can later populate with the database info. I can either go directly from the database or I can perform an intermediate conversion to XML if that will work better. Can anyone point me towards a tutorial or a step by step explanation of how to get started? I'm pretty much a noob in the pdf world.


Mark B

Restoring a content database from another server/AD does not synch user profile information for new


In my SharePoint 2010 beta environment, I have user profiles synching with Active Directory.  I just restored a content database from a separate environment/domain and logged in with my current account.  When I try to create an alert on a library/item, I get the error:

“You do not have an e-mail address.  Alert has been created successfully but you will not receive notifications until valid e-mail or mobile address has been provided in your profile.”

I went to My Profile and found that the My Profile had the right e-mail address (I guess because this is on my My Site Host).

But when I went to My Settings, it did not have any e-mail address for me (I guess this is because it is at the WSS content database level and the e-mail address hasn’t yet synched from the user profile database).

Does anyone the timer job that synchs the user profile with the My Settings for a site collection in a content database?

Issue is posted to my blog with screenshots here:



Create a pdf document from win form application by fetching fields from database


Assuming i have a winform that has a button called "Create a Quote". Once user clicks it, a PDF File gets created on desktop. The PDF File has a fixed design/structure e.g. the logo is at the top left corner, the headers are fixed, etc. However, the data it self is pulled from a database.

As you see above, Quotation #, Description, Qty, U.P (USD), T.P (USD) records should be fetched from the db and dumped in the pdf template then create the pdf for user.

I haven't done this before. I hope my question is clear enough. Feel free to put useful web links that help me achieve it.

Any help will be appreciated.

User Not Found: Could not load profile data from the database



       i am trying to get the Department of a user , using the following code 

                objWeb = SPContext.Current.Web;

                strCurrentUser = objWeb.CurrentUser.Name;

                objList = objWeb.Lists["MyList"];

                SPSite _site = SPContext.Current.Site;


User not found. Could not load profile data from the database



We have our intranet on MOSS 2007. Some of the users (particularly those who have edited their account names in AD) are getting the above error when they try to 'Edit Details' from 'My Profile' in 'My Site'.

I am not sure how to resolve this issue. Can someone kindly help me please?



Bulk Insert into Access Database not working for template fields in gridview



I have a gridview with 5 columns

4 are fetched from database through select command from table CSDB_MASTER

5th is a template field textbox which consists of value 3 by default

now i have a button down to the gridview with the following code below

everything is being inserted except the value of textbox, when i open my database the field NOC which should be inserted with grv.cells[5].Text i.e, the textbox value is null

Please Help Me Out in this issue


protected void Button1_Click(object sender, EventArgs e)

        OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\masterdb.accdb;Persist Security Info=False;");
        OleDbCommand cmd = new OleDbCommand();
        cmd.Connection = con;

        foreach (GridViewRow gvr in GridView1.Rows)

Bulk insert into access database not working with template fields in gridview


how to insert data into access database from gridview containing template fields

InfoPath metadata fields are null after a SP database migration


Can anyone tell me why this happened?  If I go into each form and submit again the metadata fields populate in my list, however I have several thousand of these and can't do it manually... we are about to migration to 2010 and I'm wondering if this will happen again?  What caused this? Bad form design? How to avoid it in the future?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend