SharePoint Formulas and Functions

While working with a SharePoint List, I wanted to add couple of Columns with Formulas and I came across the below url from Microsoft.

“Formulas are equations that perform calculations on values in a list. A formula starts with an equal sign (=).”

“Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. For example, the ROUND function rounds off a number in the Cost column.”

Export and Import a SharePoint List

This was a requirement one of my clients faced few days back. So I thought of writing blog post on it so anybody can refer to it when needed .

Exporting a SharePoint List can be done with the OOB feature given in SharePoint Central Administration.

Central Administration >> Backup and Restore >> Export a site or list

In the above image you can see…
1. You can backup a site
2. You can backup a list
3. It supports of exporting with full security
4. Exporting with the item versioning (Major / Minor / Both / Current)

OK fine exporting can be done through the UI. How about Importing? Time to move on to PowerShell. Prior to that let’s see how to achieve the Exporting through PowerShell.

Export-SPWeb “http://spdev:4422/netassist/” –ItemUrl “Lists/Students” –Path “C":\SharePoint Backup\StudentsList.cmp”

Now the Importing.. (I’ve used a SubSite “network” for the clarity)

PS C:\Users\SPAdmin> Import-SPWeb “http://spdev4422/netassist/network/” -Path "
C:\SharePoint Backup\StudentsList.cmp"

For more info read the TechNet Articles.
Export
Import

Looking back at SharePoint Sri Lanka User Group

2011 was a successful year for the SharePoint community in Sri Lanka. Few of us with the help of Microsoft, started the SharePoint Sri Lanka User Group.  I will never forget the great help and encouragement received from Dinesh Priyankara and Gogula in making this dream come true. Oh! special thanks goes to Wellington Perera. Thanks all who contributed by conducting sessions and to all who attended and making each session a success.

I gave a promise of giving T-Shirts to the first 10 users. Let’s see, what if someone sponsors to give T-shirts to the first 100 users .

Keep on counting… it’s 2012, we have a lot planned for you.

1st Session

2nd Session

3rd Session

4th Session

5th Session

6th Session

7th Session

8th Session

9th Session

Let’s continue…

Yep, It’s more than 6 months since my last blog post. It wasn’t a break!! and on excuse accepted too!! But I was doing a lot of offline contribution to the SharePoint community in Sri Lanka by hosting sessions, doing trainings and providing consultancy. And not to forget the contribution made towards the success of SharePoint Sri Lanka User Group.

I’m back on my blog… Want to continue sharing my knowledge, my experience from projects with the Online Community. Lets continue…

www.iusesharepoint.com

Ah, driving adoption. We know it can be tough to get a team to change its ways. But you don't have to resort to wearing disguises like our SharePoint champion. Use this handy kit to send the message: life is easier with SharePoint 2010.

Want to get your team using SharePoint?

Here are two ways to download and deploy:

Download the Lunch & Learn SharePoint Adoption Kit.
The Lunch & Learn kit contains all the materials you need to promote SharePoint within your organization. The kit includes instructions, templates, videos, quick reference cards and more to help you deploy an internal SharePoint resource site - a place to access SharePoint information and tools, and connect around the best part of the day: lunch. Download this kit to show your team how SharePoint makes life, and lunch, a little better.
Download this handy Adoption Kit.


Build an Adoption Kit that's right for you.
If your organization already has an established learning center, you can download individual pieces to post to and promote the destination that works best for you. These standalone pieces can be used to add interesting and helpful training content to your organization's site and to drive SharePoint learning and adoption. Choose to download one or more of these resources, like webisodes, Show Me How videos, quick reference cards, poster templates, table tents and more.

Download Tips & Tricks

Download Quick Reference Cards

Launch of www.SharePointSriLanka.org

This was a dream came true. Finally on 12th of January 2011 we were so happy to announce the launch of the Sri Lankan SharePoint Forum. The online forum which can be reached at www.SharePointSriLanka.org or www.SharePointSriLanka.com or www.SharePointSriLanka.net. The offline forum which will take place on second Wednesday of every month.

These forums are the official Microsoft Approved forums dedicated to SharePoint and related products. What you see above is the  logo of SharePoint Sri Lanka Forum. This logo has the meaning of collaboration which is the idea behind the product SharePoint. Its represented by the 4 colored people.

For the launch there were over 130 attendees. And there were two technical sessions held. The first sessions which was a the 1st of a series, on SharePoint branding hosted by Abul Azad a SharePoint UX Expert. The second session was on Claim-based Authentication hosted by me.

I’m so happy to be one of the founders of SharePointSriLanka forum. Also my special thanks goes to Gogula (One of the founders of SQLServer Universe and MVP SQL Server) who came up with the idea and was behind me nagging all times till we launch it. How can I forget, Dinesh Priyankara (One of the founders of SQLServer Universe and MVP SQL Server) the BI Guru for being there for me always (even paid for the soft drinks ) and helping in all matters to make the SharePoint Forum a success.

Also many thanks to Dinusha Kumarasiri and Abul Azad for the sleepless nights spent to bring the www.SharePointSriLanka.org up and running. And not to forget the one and only Wela, Wellington Perera, without your support this wont be a success, you know it well buddy.

Okay, this offline forum is not only for SharePoint Experts. We have planned to have two sessions each day, giving a chance for a newcomer to do a session on any SharePoint related technology or product. And the second session will be hosted by a person with more experience on the product.

Now you know, you have a place to publish your articles, blogs, ask questions on related technologies. So guys get registered soon and help make SharePointSriLanka a better place for you.

PDF in SharePoint 2010

This is a step-by-step guide to setup and configure Adobe PDF file search in SharePoint 2010.

Step 1
Download the Adode iFilter from the following url.
http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025

Step 2
Download the pdf icon file. Download a 16*16 gif or a png file. Or else you can download it from the below url. http://www.adobe.com/misc/linking.html

Step 3
Extract the zip file and install the PDFFilter64installer file which you downloaded in Step 1.

Step 4
Open the “Run” window and open Registry Editor running the regedit command.


In Registry editor browse to location \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\14.0\Search\Setup\ContentIndexCommon\Filters\Extension

Step 5
Right Click on “Extension” and add a new Key.

Name it as .pdf.

Step 6
Now add the following GUID as the default key.
{E8978DA6-047F-4E3D-9C78-CDBE46041603}

Step 7
Now is the time to set the icon for pdf files.
Copy/Move the pdf icon you downloaded in in Step 2 to the following folder.
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
Next open “Internet Information Services (IIS) Manager and Stop the service.

This step is required as you are going to amend a file which is currently in use.

Step 8
Browse to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML and open the DOCICON.XML file. (use Notepad). And do a search for the <ByExtension> tag.

Add the line <Mapping Key="pdf" Value="pdficon_small.gif" />
(replace pdficon_small.gif with your icon name)

Save the file.
Start IIS Service

Step 9
Open SharePoint Central Administration. Under Application Management select Manage Service Applications. Open Search Service Application.

Step 10
Select File Types on the left menu. Click New File Type. Enter pdf and click OK.

Step 11
Click on Content Sources and do a Full Crawl (not an Incremental Crawl). After completing job, you know what to do. Do a search.

SharePoint Rocks!!