Wednesday, September 25, 2013

Pop Up Form For Content Types And Custom Forms

I had a blog post earlier about how to link directly to the new form page for multiple content types, but how do we get that nice SharePoint pop up window that our users are used to seeing?  In my scenario I had created custom InfoPath 2010 forms for each of my content types in my SharePoint 2010 list.  This tutorial provides the syntax to make your links POP!  This is very simple, but is extremely handy if you want to keep the user on the same page and not have to redirect your user to the actual newform.aspx page.

Code Needed:

Javascript:OpenPopUpPage(‘Your URL For The New Form’)

Example

javascript:OpenPopUpPage('/sites/SiteName/Lists/ListName/newform.aspx?ContentTypeID=0x01002069B8F8E3CC074DB7793638F1D8896B’)


My example has the syntax to link directly to that content type's newform, rather than just using the newform.aspx which links to the default Content Type.

Cheers!

Dan

Monday, August 19, 2013

How To Show Related Items Within A Document Set


This tutorial will show you how to activate the document set feature / content type, how to create a Document Set Content Type, How to Add the Content Type to Your Library, and how to show Related List Items within the particular document set.  If you know how to do all of the other aspects of this article, feel free to skip to the end and just read the part under “Display Related Items Within The Document Set.”


(This post assumes that you know how to create a lookup from your list to a field within the Document Set Content Type.  I have a previous post which shows how to use the lookup field required to create the relationship)


Materials Needed:

1.    A Document Library

2.    A List

3.    A relationship between the list and document set (lookup field)

4.    Page Field Filter Web Part

 
Activate the Document Set Feature:

(This requires SharePoint Online for Enterprises or SharePoint Server 2010)

 
1.    Select Site Actions

2.    Select Site Settings

3.    Site Collection Administration

4.    Site Collection Features

5.    Activate Document Sets

 
Create the desired Document Set Content Type

1.    Select Site Actions

2.    Select Site Settings

3.    Select Site Content Types

4.    Select Create

5.    Enter the name of your Content Type

6.    Under Select Parent Content Type

a.    Select Document Set Content Types

                                          i.    (this is only available after activating the feature which we did previously)

7.    Select a group where you would like the Document Set Stored

8.    Select OK

 
Add the Created Content Type To Your Library:

1.    Select the Desired Library

2.    Select Library Tools

3.    Select Library

4.    Select Library Settings

5.    Select Advanced Settings

6.    Select “Yes” Allow Management of Content Types

7.    Select OK

a.    “Add From Existing Site Content Types” Will Now Appear Under Content Types

8.    Select Add From Existing Content Types

9.    Select The Document Set Content Type Which You Created Earlier

10. Select Add

11. Select OK

a.    (There will now be two content types listed under Content Types “Document” & “Your Document Set Name”)

Related List

I have an earlier post “Linking Lists & Editing The Default Display Form” on how to relate the two pieces of content.  In a nutshell though, you will need to have a lookup field which pulls a field from your created Document Set.  I will be using the Title from my Document Set Content Type for my example.

 Display Related Items Within The Document Set:

1.    Navigate To Your Library

2.    Create a New Document Set Item

3.    Open the Document Set Item

4.    Select The Page Tab

5.    Select Edit Page

6.    Select The Zone You Would Like Your Related Items Displayed

7.    Select Add A Web Part

8.    Select The List With Related Items

9.    Select Add A Web Part

10. Insert the “Page Field Filter” Web Part

11. Select The Page Filter Web Part

a.    Select Connections

12. Select “Send Filter Values To”

13. Select Get Filter Values From

14. Select Configure Connection

15. Select the Related Field From Consumer Field Name

16. Select Finish

17. Select Stop Editing

Your Document Set Should Now Display Only The Related Items!!!

 



 

Monday, July 29, 2013

How to Install PowerPivot & Connect to your first SharePoint Lists & Libraries

PowerPivot as a great BI tool offered by Microsoft which can handle millions and millions of records with ease and supports table relationships.  I have been asked why PowerPivot just does not come OOB with Excel and that is because of the particular Hardware & Software requirements which are needed.  If you are not sure what the requirements are, read this MSDN article which outlines exactly what you need.


This post assumes that you have the requirements and are ready to install PowerPivot

To Install PowerPivot for Excel 2010


2.    Select download

3.    Select the download for your current system

a.    X86 is for a 32 bit system & x64 is for a 64 bit system

4.    Run the installer after the download has completed

5.    Open Excel 2010

6.    Select File Tab

7.    Select Options

8.    Select Add-Ins

9.    Next to manage select COM Add-ins from the combo box

10. Select Go

11. Check the box next to PowerPivot for Excel and select OK

You should now have a tab on the ribbon for PowerPivot!

Enable PowerPivot for Excel 2013
 
1. Go to File →Options → Add-Ins.

2. In the Manage box, click COM Add-ins> Go.

3. Check the Microsoft Office PowerPivot for Excel 2013 box, and then click OK. If you have other versions of the PowerPivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the PowerPivot add-in for Excel 2013.

You should now have a tab on the ribbon for PowerPivot!

Connecting To Your First SharePoint List

1.    Open Excel

2.    Select the PowerPivot Tab

3.    Click PowerPivot Window

4.    On the Home Tab

a.    Select From Data Feeds

5.    You will be prompted with the Table Import Wizard

6.    Friendly Connection Name can be anything your heart desires, it is just the display name of the connection

7.    Data Feed URL is what actually enables you to connect to the list

a.    Input your site URL i.e http://domain/sitename

8.    At the end of your site URL you will need to have:

9.    /_vti_bin/ListData.svc in order to connect to the list

10. The final URL should look like this http://domain/sitename/_vti_bin/ListData.svc

11. Select Next

a.    If the connection was successful, you should see a list of your lists and libraries

12. Check the box next to the lists / libraries you would like to create reports on and select Finish

From this step on you can create your Metrics using Pivot Tables & Charts.  There are many great tutorials online regarding how to create the relationships amongst lists & how to use PowerPivot effectively, but I may release an article in the future.


Cheers!

Dan