List tools tab was missing after Migration from 2007 to 2010

Hi some after Migration issues discussed . 

Issue : List tools tab was missing after Migration from 2007 to 2010

We found today that one of the User had a site collection with 5 lists . When he clicks on the first list the List tools tab at the top is available . 

However for one of the Lists we don't see the Tab . Thought the list has gone corrupt and was about to create a new list with the Template and move the contents .

But then while troubleshooting we found that if we click on one Item we see the List tools tab . Ahhhh But that is not a resolution . why is it working for others ?. 

It also looked like the permissions were gone but that was wrong. Permissions were correctly set and the user was logged on as an site collection admin.

Then some how we found the solution . 

Resolution : The user had added edited the page when they were on 2007 and added a Content Editor web part without any text on the top of the list as a web part 

Deleted the web part and there you go got the List tools back

My Links missing in SharePoint 2010 after Migration

We have just Migrated to 2010 and get a lot of tickets on this issue .

In MOSS 2007,  we are used to seeing a link in a drop-down box at the top right of our SharePoint sites, called My Links. At first glance, it seems that this functionality has been removed from SharePoint 2010. It’s still there but with a different name (Quick Links) .

How to retrieve the Lost my links from the 2007 site after migration to 2010 ?

Modifying a SharePoint Database is NOT SUPPORTED. Some would even argue running this select query against a database is not supported. Sometimes people want info out of the DB not excuses.

Disclaimer : Take all the required backups before you make any changes

1. So the first thing you need to do is figure out what profile database you need information out of. To do that you go to Central Admin.
2. Now Click Shared Services Administration from the quick launch.
3. From this screen hover over the appropriate SSP name, click the drop down arrow, and choose Edit Properties.
   
   
4. Now find where it says SSP Database. This your Database Name.
5. Now you need to open a SQL Query Window using the SQL Management tools
6. Then run the query below – Remember to replace the Use statement with your database name from step 4

Use SharedServices1_DB

Select

UP.NTName,

UP.PreferredName,

UP.Email,

UL.Title,

UL.URL

From

UserLinks UL inner join UserProfile_Full UP on UL.recordId = UP.recordID

Courtesy - Shane Young  

Ref : http://msmvps.com/blogs/shane/archive/2007/11/21/finding-my-links-in-the-database.aspx.

How do you get My Links back?

Libraries

In a library, go to the Library tab in the ribbon. 
Click the Connect to Office button.  This is the interface to add or remove a link to the library to the list of “My Links”, as well as to manage this list of links.

When you click Add to SharePoint Sites, this library is not only added to your own personal list of links, but it is added to all of your Office suite of applications, on the “Open” and “Save As” screens.

When you click Manage SharePoint Sites, the following screen is displayed, with a list of your whole list of links:

Where is my links on my Mysite ?

Go to your My Site and click on My Content at the top.  Click Site Actions, Edit Page, and click to Add a Web Part.  In the Recommended Items category of web parts, click to add the My Links web part to the page.  There it is!  Right click on the My Links web part title, and copy that URL to the clipboard.

If you want the My Links link to be more obvious and accessible, though?  Yes, there’s a way to do that also, although it still won’t be the same as it is in SharePoint 2007.  It entails adding My Links to the Personalization Site Links in the User Profile Service Application.

1. In Central Administration, click Manage Service Applications.
2. Click the User Profile Service Application.
3. Click Configure Personalization Site.
4. Click New Link.

1. Your URL will look something like that.  In this scenario, I have a web app just for the my sites.  Fill in an owner because that field is required.  Leaving the Audience field blank means that this link will be shown to everyone.

Now, when users are on their My Site, My Profile, My Content, they will see this:

http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=daba3a3b%2Dc338%2D41d8%2Dbf52%2Dcd897d000cf3&ID=66&Web=dbb90e85%2Db54c%2D49f4%2D8e97%2D6d8258116ca0

"E-Mail Notification" option is missing from Advanced Settings

Hi ,

Today i came accross a issue in which the user has some data in access db . Which he imported in Sharepoint as a list .

The user wants to send a notification to the user who is assigned to it .

I tried giving him the option of workflow , Alerts however he wanted something which was OOB and not the same .

He had the functionality working on a different list where he did not have access to.

So i checked and found that there was an option of Email - notification in the advanced settings of the list

This is what I found

Tasks, Project tasks, and Issue-tracking lists can send e-mail to people when items are assigned to them if outgoing mail is enabled.  Other lists can support the same functionality, but you'd have to do something custom.  You could create a notification workflow in SharePoint Designer to handle this.