Friday, October 25, 2013

MOSS 2007 User Profile AD Sync Issue

MOSS 2007 User Profile AD Sync Issue

I face the issue When working on User Profile Sync, Resolved the issue By performing the below steps. so Thought to Share.

  •  User Profile Import Schedule was not running as per configured Schedules
  •  We have to manually run the Incremental crawl which pulled the users from different ADs.
  • Profile Synchronization, Quick Profile Synchronization Jobs were running successfully.
  • There were totally 90000 profiles, pulled from different domains.

  •  Imported User profile details (changes) were not getting published to the web applications.
  •  We were able to see the changes in SSP database in “UserProfileValue“table.
  • On the other hand when we removed the user from site and added him back the changes are reflected in the web application.
                               ·         Ran following commands to get rid of this issue
           stsadm -o sync -listolddatabases 
Resulted in number of GUIDs, so ran following command to delete those GUIDs
stsadm -o sync -deleteolddatabases 

And then        

stsadm -o sync
To check connection between AD and MOSS ran following command     

stsadm -o getproperty -propertyname peoplepicker-searchadforests
If its resulted in NO, then we have to set connection between AD and MOSS using following command
stsadm –o setproperty –pn peoplepicker-searchadforests –pv 

      After that rechecked behavior using stsadm -o sync -listolddatabases and did not get any GUIDs and after that ran Full import which resolved the issues 

      I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

How to Auto forward Emails from Outlook to SharePoint Document Library:

Before in My earlier Organization, we wanted to auto forward outlook emails to one of SharePoint document library. I followed the below steps to achieve this.

Ø  Make sure Target Doc Lib contains Email address and it’s working
Ø  Then go to Outlook and click on New > Contact
Ø  Add Email address of that document library into the Outlook Contacts.
Ø  Save it and now create a rule from Outlook > Tools > Rules and Alerts > New Rule
Ø  Select “Start from a blank rule” option.
Ø  Select Check messages when they arrive > Next
Ø  Select “Condition” for which you want to forward emails to Doc Lib in step 2.
Ø  Then select action “forwards it to people or distribution list” and click on people or distribution list
Ø  Select “Outlook Address book” from Address Book drop down and you will getSharePoint Document Library email address as a contact > Add it
Ø  Click on Next > Finish
   Ø  Now send an email with that condition to check rule.

Please Comment if you need any Assistance.

Export a Discussion topic List item (SharePoint 2007) to excel or PDF

Here is  some  ways  to achieve this GOAL

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

I.e. to enable export to spreadsheet option URL should be http://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” tries following steps.

                       Open Excel
·         Click on DATA tab
·         Select from Web option
·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx
·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to        insert required data to excel.
·         And from Excel you can easily export to PDF