how to import a spreadsheet into sharepoint list 2010

Just like SharePoint 2007, SharePoint 2010 also provides this functionality in which we can directly import an excel spreadsheet and creates a custom list based on the number of the columns.

How to import? Here is the step by step guide for you:

·         Open your sharepoint site

·         Click on view all site content

·         Create

·         Select the List category from the left

Note: If you do not wants to follow the above mentioned steps then please make some adjustments in your site URL (like the below one)

http://SharePoint2010site/sites/SPAdmin/_layouts/create.aspx

You will be wondering as what exactly we need to do in the URL, it’s very easy

Just append _layouts/create.aspx after the site name. That’s it

·         Okay, continuing the same point

·         As soon as you click on ‘Import a spreadsheet’ then Provide the list name as per your project requirements

·         Click on Browse and select your excel file that you wants to import

·         Select the range of cells that you want to import

·         Click OK

-That’s it-Job Done J Very Easy Right J-

If you face 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.

Backup Restore in SharePoint 2010

Hello Guys, today I am going to share one of my interesting topics in SharePoint 2010. This is an important one that you have to be ‘aware of’ as it belongs to recovery model. Yes, you are absolutely right; I am talking about Backup-Restore methods in SharePoint 2010.

Microsoft SharePoint 2010 has comes up with so many enhancements and backup restore is one of them. I will try my best here to cover the backup-restore based on GUI (Graphical User Interface), STSADM and Powershell so that you will be proficient enough to work on these mentioned methods independently.

Backup Operations

Backup operations are associated with:

·         Site collection

·         Subsite

·         List and Document Libraries

How to take the backup of the site collection:

By using Central Administration

·         Open the central administration

·         Backup and Restore

·         Granular Backup

·         Perform a site collection backup

·         Select the appropriate web application and site collection from the dropdown

·         Provide the filename

·         Start backup

·         You will be redirected to _admin/sitebackuporexportstatus.aspx

·         It shows the status ‘Operation initializing’

·         It will take some time to complete the backup depending on the size of the site collection

·         As soon as the backup completed then the status will change to ‘Operation Succeeded’

·         That’s it and you are done... check the file location and you will see the backup file that you have specified in the above mentioned steps.

By using STSADM command

For site collection backup:

    stsadm.exe -o backup -URL <URL> -filename <filename> [-overwrite]

By using Powershell command

Backup-SPSite -Identity http://SharePointBackuptesting/sites/AMOL2010 -Path <Filename>

How to take the backup of the subsite

By using Central Administration

§  Open the central administration

§  Backup and restore

§  Granular backup

§  Export a site or list

§  Select the appropriate web application, site collection and subsite

§  Provide the filename

§  Select Export Security (If you want to include permissions)

§  Export Versions (by default ‘All Versions’ selected)

§  Start backup

§  You will be redirected to _admin/sitebackuporexportstatus.aspx

§  It will take some time to complete the backup depending on the size of the site collection

§  As soon as the backup completed then the status will change to ‘Operation Succeeded’

§  That’s it and you are done... check the file location and you will see the backup file that you have specified in the above mentioned steps.

By using STSADM command

stsadm.exe -o export -URL <URL to be exported> -filename <export file name>

By using Powershell command

Export-SPWeb -Identity <URL of the subsite> -Path <filename> -IncludeUserSecurity

How to take the backup of the List/Document Library

By using Central Administration

·         Open the central administration

·         Backup and restore

·         Granular backup

·         Export a site or list

·         Select the appropriate web application, site collection and List/Document Library.

·         Provide the filename

·         Select Export Security (If you want to include permissions)

·         Export Versions (by default ‘All Versions’ selected)

·         Start backup

·         You will be redirected to _admin/sitebackuporexportstatus.aspx

·         It will take some time to complete the backup depending on the size of the site collection

·         As soon as the backup completed then the status will change to ‘Operation Succeeded’

·         That’s it and you are done... check the file location and you will see the backup file that you have specified in the above mentioned steps.

By using Powershell command

Export-SPWeb –Identity <Site URL> -Path <Filename> -ItemURL “Lists/Tasks” –includeusersecurity

If you face 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.

Note: Complete Restore Operations will be posted in the next article... so stay tuned…very soon I will provide you the restore information that will be the concluding part of this recovery operations.

Examples:

Backup of the List:

PS C:\> Export-SPWeb -Identity http://itweb.contoso.com/sites/SP2010_Backup/dspace -Path C:\SP2010_Backups\documentbkps.cmp -ItemUrl "Lists/Calendar"

Additional notes:

Site collection: http://itweb.contoso.com/sites/SP2010_Backup

Subsite: http://itweb.contoso.com/sites/SP2010_Backup/dspace

Filename: SP2010_Backups\documentbkps.cmp

Item URL means the name of the list that you wanna backup (here the name of the list is 'Calendar')

Note: if your list name contain spaces then you need to use double quotes, otherwise the Windows PowerShell command will return errors.

Backup of the document library:

PS C:\> Export-SPWeb -Identity http://itweb.contoso.com/sites/SP2010_Backup/dspace -Path C:\SP2010_Backups\testlibbkp2s.cmp -ItemUrl test -Force

Additional notes:

Site collection: http://itweb.contoso.com/sites/SP2010_Backup

Subsite: http://itweb.contoso.com/sites/SP2010_Backup/dspace

Filename: SP2010_Backups\testlibbkp2s.cmp

Item URL means the name of the library that you wanna backup (here the name of the library is 'test')

For restore operations, please refer http://sharepointknowledgebase.blogspot.in/2012/06/sharepoint-2010-backuprestore-with.html 

Per-Location View option is missing in SharePoint 2010

In this article, I will describe the issue that I faced while working on Per-Location View options and troubleshooting steps that I have taken to resolve.

Brief details:

You can configure which views are available for specific locations in the site hierarchy. The locations in a site hierarchy for which you can configure the availability of views are:

·         Lists

·         Libraries

·         Folders for lists and libraries.

How to reproduce the issue?

I have created a site by using blank template. Blank site template does not have any default list/libraries created and we can design it as per our project requirements. So afterwards I have created a custom list and tried to configure the per location view settings but here is the mystery begins...As I am not able to see that option under list settings.

How to resolve this issue?

·         Open the sharepoint site in which you are facing the issue

·         Site actions

·         Site settings-site actions (don’t be confused with this repeated word)

·         Manage site features

·         Activate this feature Metadata Navigation and Filtering

·         Go back to the list settings now and check the results JJ

You can see that option is there now and I can see your smiling face J

Important guidelines about this ‘Location per View’ option

1)   You cannot use personal views for per-location views

2)   To configure per-location view settings you must have at least the permissions obtained by being added to the default Designer security group for the site that the list or library is in.

If you have any queries/questions regarding the mentioned information then please let me know. Thank you.

InfoPath does not support customizing the form used for this list.

Is it possible to customize document library forms using InfoPath?

Tricky question right? If you face this error message then several questions will be raised as:

InfoPath does not support customizing the form used for this list.

Is this restricted to this document library only?

Is this a default behavior?

Is it applicable to forms library only? And so on….

But let me tell you-this is a by design and error message won’t be there in the next version. Here is the detail on that:

Refer this link: http://blogs.msdn.com/b/infopath/archive/2009/12/17/customize-a-sharepoint-list-form-using-infopath-2010.aspx?PageIndex=1#comments

You need to look for the command for the detail explanation:

We don't support customizing document library forms in InfoPath. This error should not appear in the final released product.

Laura Harrington (InfoPath Team)

This is restricted to document libraries only and works fine with the SharePoint Lists/custom lists.

If you open any list and refer the same settings then you will get the option to make it enable or not by selecting Yes/No option.

If you have any queries/questions regarding the mentioned information then please let me know, Thank you.

Inline editing in sharepoint 2010

The keyword itself explains the brief meaning about functionality.

Inline Editing: Choose whether an edit button on each row should be provided. This button allows users to edit the current row in the current view, without navigating to the form. Inline editing is only available on views that have their Style set to Default.

If you are missing this option in your document library/in custom lists then please refer the following steps and your issue will be resolved:

·         Open the document library in which you wants to enable that option

·         Settings

·         Document library settings

·         Scroll towards the bottom and you will see the views section

·         Click on All Documents view

·         Scroll towards the bottom and you will see a option named as Inline Editing

·         Mark the check box that says-Allow Inline Editing

·         Click OK and that’s it-you are done

·         Go back to your document library and check the results

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.