Tuesday, 22 July 2014

SharePoint Scrolling Announcement/ News Scroll for 2010/2013

I been asked to create a scrolling announcement for one of my SharePoint 2010 website and  thought it was straight forward however googling for a while i realised many solution have lots of script to be done and some not working, i finally found an easier way to do the same; i have spend many hours to make this happen, by posting this hope will save some of your time.

How does this work ? This uses Content Query webpart and fetch data from Announcement list (Yes any number of announcements can be scrolled) and will display on the site, Here is a screenshot -


If you like it and would want to implement it here are the  steps -

[I have done this and tested on SharePoint 2010 and IE 11/Chrome]

Step 1.
Create an Announcement list or use the one which is already in the SharePoint list (You can create any list as you wish)

Step 2.
Add a CQWP and fetch the item to display- in my case i set a new field called "Show Scroll" and in the CQWP filtered the items if set to Yes























Step 3.

I have added a new CQWP template as in the article - http://sharepointlogics.com/2014/02/sharepoint-2010-content-query-web-part.html editing the itemstyle.xsl. I have added "MarqueeTitleOnly" as the last template above  -

You can find that in the download code Link here -  http://1drv.ms/1jTqn7J

Find the edited item.xslt where i added a new template in the end, update yours appropriately -






Step 4.

Once after set the CQWP to use the new template you created  - 



That's all, set the CQWP with appropriate width so that it shows a scroll button on the right.

Now you have a kool news ticker/Scroller webpart which picks news from Announcement list and shows it on your HomePage....

Friday, 18 July 2014

How to Import Excel Spreadsheet to Lists in SharePoint 2010 / 2013

 Users asking you they have large data in Excel and want to import it into SharePoint; You might have dealt with it at least once if you are in SharePoint.

The primary option will be to import data onto SharePoint by creating a custom list from the Spreadsheet as said on this link - MS Link; there could  be situation where the list is already present and you want to update the data or not follow this approach and then you might think about the SharePoint Datasheet view

However this approach also have several limitations as the excel sheet values should need to be of the same datatype again SharePoint Datasheet view have some restrictions on columns with "Multiline columns" as  and so on... Now what is the best way, i was trying different things and nothing much was helping me out until I found the MS Access way  :)

Yes if you have MS Access service enabled on your farm you have a better and easy way to bulk upload data onto SharePoint in easy 4 steps, Here are the steps
[I have used MS Access 2010 and SharePoint 2010, Access Service enabled on SharePoint farm]

Step 1.
Open MS Access on your client machine > Select All files > MicrosoftSharePoint foundation ()





















Step 2.
Specify a SharePoint Site > Select  > Linked to the data Source by creating a linked table > Click Next



























Step 3

Select the Table which you want to import data > Click OK



























Step 4

Access will create a table which is linked on to SharePoint and you can easily upload, export or manage any data's and SharePoint list will be synced and updated immediately.



















Hope this helps.... Happy SharePointing....