SharePoint Exams 70-667 and 70-667 Being Updated for Office 365

 

If you have been preparing for the SharePoint administrator exams, you are about to get a surprise! The exam’s web page has this little tidbit…

70-667 and 70-668 will be updated for SharePoint 2010 SP1 and Office 365 in January, 2012.
http://www.microsoft.com/learning/en/us/exam.aspx?id=70-667

They don’t list a date, so assuming January 1st…take the exam tomorrow or Saturday, or start brushing up on Office 365 and SharePoint Online.

As the web page does not have an updated “Overview” or “Sills Measured”, you may have some extra time. It would not be fair to update the exam on the 1st and not tell us what’s in it.

Post a reply if you have any news on dates…

 

.

SharePoint: Displaying PDFs from a Dropdown Menu

Browsing the MSDN SharePoint forums can really bring up some interesting ideas. Recently there was a question about how to display collections of PDF files in a web page. The question included a link to an article on embedding PDFs in SharePoint 2007 by Sharon Richardson. Sharon’s approach used an <embed> tag.

The <embed> tag’s SRC attribute is not updateable by JavaScript and I did not want a hard coded PDF file. I got to playing around with this and worked up a solution that uses an <IFRAME> and borrows some JavaScript from an article I wrote a while back. The JavaScript was used to convert a Links List into an HTML dropdown list (<SELECT>). Here I will use it to convert a library into a dropdown list and a PDF viewer.

Note: Displaying PDFs in SharePoint requires two things:

• Your users must have a PDF viewer installed that can display PDFs in a browser
• For SharePoint 2010 your server administrator much change “Browser File Handling” from Strict to Permissive for your web application (see here and here)

Another Note: :-)   This can also display pictures from a library! Just change step 4 below to include the proper file extensions.

 

2010? 2007?

This example was tested in SharePoint 2010, but should work just fine in 2007.

 

The result should look something like this:

  

 

Steps:

1. Add a web part part for the document library that contains the PDFs
    
2. Edit the web part and in the properties panel click “Edit the current view”
    
3. In the view page select just one column:  Name (linked to document)
4. Configure the Filter section to select your files (my example just looks for “.PDF”)
    
    
5. Save the view
    
6. Open Notepad and paste the JavaScript from below
    
7. For initial testing you may want to comment out the line that starts with “x[i].parentNode.” (just add two slashes:  “// x[i].parentNode.”) – this line hides the library web part
    
8. Edit the “var LibrarySummaryName = ” line to add your web part’s summary name
   To find the Summary name:
   1. Display the page with the web part
   2. Use the browser’s view source option to display the page’s HTML
   3. Search for “source=” and find the title of your web part (Note be sure to include all of the text including any spaces or periods that might be at the end)
       
9. Edit the height and width attributes of the IFRAME tag to suit your needs (In pixels or percent)
    
10. Save the file as “PDFdrowdown.html” or similar
     
11. Upload the Notepad file to a library (Site Pages, Site Assets, or any library you have for miscellaneous site files)
    Note: You can now click the dropdown on this document and edit the file in SharePoint Designer
     
12. Go to the library with the script file, right-click the filename and click “Copy Shortcut” (you will paste this into the Content Editor Web Part)
     
13. Add a Content Editor Web Part and move it below the PDF library web part (important!)
     
14. Edit this web part an paste the URL just copied into the Content Link box
     
15. You should now be able to test the dropdown and display PDF files in the IFRAME area
     
16. Final steps are:
    1. if you added them, remove the comment slashed added to the “x[i].parentNode.” line
    2. Edit the Content Editor Web Part and change the “Chrome” to none to hide the web part’s title

 

Hide the Toolbar and the Scrollbars!

To hide the scroll bars, just append options to the end of the URL like this:

Before:

    PDFcontrol1.src=url;

After:

    PDFcontrol1.src=url + "#toolbar=0&navpanes=0&scrollbar=0";

Page 8 of this file has other examples of what you can do with URL parameters for PDF files: http://partners.adobe.com/public/developer/en/acrobat/PDFOpenParameters.pdf#page=8

The results should now look like this:

 

 

The JavaScript

<!-- the dropdown list for the libray items -->
<br/>
Select a PDF to view:
<select name="PDFSelect" id="PDFSelect"
  onchange="javascript:LoadPDFtoIFRAME(PDFSelect.options[PDFSelect.selectedIndex].value)">
  <option>Jump to ...</option>
</select>
<br/><br/>

<iframe id="PDFiframe" src=""  height="600" width="400"></iframe>


<script>
// CEWP trick from techtrainingnotes.blogspot.com! 
// techtrainingnotes.blogspot.com/2011/12/sharepoint-displaying-pdfs-from.html

var LibrarySummaryName = "Shared Documents Share a document with the team by adding it to this document library."

function LoadPDFtoIFRAME(url)
{
    var PDFcontrol1 = document.getElementById("PDFiframe");
    PDFcontrol1.src=url
    
    // to hide the toolbar and the scroll bars change the above line to:
    // PDFcontrol1.src=url + "#toolbar=0&navpanes=0&scrollbar=0";
}


//code to hide the links list and populate the select list

//Find the library and hide it
var x = document.getElementsByTagName("TABLE") // find all of the Tables 
var Library;
var i=0;
for ( i=0; i<x.length; i++ ) 
{
  if (x[i].summary == LibrarySummaryName)
  {
    //
    Library = x[i];

    //hide the links list web part (tables in tables in tables ...)
    // Note: while testing, you may want to comment out the next line
    x[i].parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.style.display="none";
    break;
   } 
}

if (Library)
{
  //Copy all of the links from the link list to the select list
  var ToList = document.getElementById("PDFSelect");

  var links = Library.getElementsByTagName("A"); // find all of the links
  for ( i=0; i<links.length; i++ ) 
  {
    if (links[i].onfocus)
    {
      if (links[i].onfocus.toString().indexOf("OnLink(this)") > -1)
        { ToList.options[ToList.length]             = new Option(links[i].innerHTML, links[i].href); }
    }
  }
}
else
{
  alert("Library web part named '" + LibrarySummaryName + "' not found")
}
</script>

 

.

 

 

 

.

December 2011 CU for SharePoint 2007 and 2010 has been released

 

December 2011 CU for SharePoint 2010 has been released

Go here and see the links to the details for what’s included:

http://blogs.technet.com/b/stefan_gossner/archive/2011/12/14/december-2011-cu-for-sharepoint-2010-has-been-released.aspx

 

December 2011 CU for SharePoint 2007 has been released

http://blogs.technet.com/b/stefan_gossner/archive/2011/12/17/december-2011-cu-for-sharepoint-2007-has-been-released.aspx

 

Steve Caravajal says there’s good news for Apple iPad users wanting access to SharePoint BI content:

http://blogs.msdn.com/b/scaravajal/archive/2011/12/19/sharepoint-bi-on-the-ipad.aspx

Follow the link on Steve’s page to the TechNet article with all of the details!

 

And just in case you missed the SharePoint Online November 2011 Update announcement:

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=1002

 

.

SharePoint: Change the color of a web part column

 

Over in my article on color coding lists I got this question:

“Can you post a snippet of code that shows how to apply color to a particular column - the entire column (i.e., column 7)”

Well, here’s two possible solutions. And you can change anything about the column by changing the CSS. Set the text to bold, change the font family or font size, or add borders.

 

Change the color of a web part column using CSS

This is the more elegant solution, but it will not work with Internet Explorer 6, so it will not work for SharePoint 2007, or where you still have IE 6 users.

Note: the line starting with “table[“ and ending with “td + td + td” is all one line.

<style>

table[summary="Shared Documents Share a document with the team by adding it to this
 document library."].ms-listviewtable  tr + tr td:first-child + td + td + td
{
    background:orange;
}

</style>

Steps:

1. Add this style to a Content Editor Web Part
   or edit the page in SharePoint Designer and add it just before the end of the PlaceHoldMain area.
    
2. Edit the text in “summary=” section to add the name of your list web part. To find the name, display the page with the web part in a browser and search for “summary=” and copy the text between the quotes.
    
3. Edit the “td + td + td” to select your column (one td per column)
   If you want to color more than one column, copy the entire selector and adjust the number of td’s. Something like this:  (note the comma)
   
   table[summary="Shared Documents Share a document with the team by adding it to this document library."].ms-listviewtable tr + tr td:first-child + td + td + td ,
   table[summary="Shared Documents Share a document with the team by adding it to this document library."].ms-listviewtable tr + tr td:first-child + td + td + td + td + td  
   {
      background:orange;
   }
   

Change the color of a web part column using JavaScript

This solution should work for all browser versions (crossing fingers…), but you will need to test it in the browsers used by your visitors. This probably could be reduced to one line using jQuery.

Note: the line starting with “var webpartName”“ and ending with “library.” is all one line.

<script>

// from TechTrainingNotes.blogspot.com

// The web part name can be found by viewing the source of the page and
// searching for "summary="
var webpartName = "Shared Documents Share a document with the team by adding it 
to this document library.";

// first column is 0
// in SP 2010 the first column may be check boxes
var columnToChange = 5;

// find the web part's table
var allTables = document.getElementsByTagName("TABLE");
for (var i=1;i<allTables.length;i++)
{ 
  if (allTables[i].summary == webpartName)
  {
    // loop through the rows to change the column
    // set j=0 to include the column heading or j=1 to skip the heading
    var theTable = allTables[i];
    for (var j=0; j<theTable.rows.length; j++)
    {
      // any style attribute of the cell can now be changed
      theTable.rows[j].cells[columnToChange].style.background="yellow";
    }
  }
}

</script>

Steps:

1. Add this JavaScript to a Content Editor Web Part and move the web part below the web part to add the color to
      or
   edit the page in SharePoint Designer and add the JavaScript just before the end of the PlaceHolderMain area.
    
2. Edit the text in “webpartName =” section to add the name of your list web part. Display the page with the web part in a browser and search for “summary=” and copy the text between the quotes.
    
3. Edit the column number to change (var columnToChange = 5; ). The first column is column 0.
   
   If you want to change multiple columns it might be easier to hard code the column numbers. For example, to change columns 2, 5 and 8: (remember to count from zero)
   
   Change:
     theTable.rows[j].cells[columnToChange].style.background="yellow";
   To:
     theTable.rows[j].cells[2].style.background="yellow";
     theTable.rows[j].cells[5].style.background="yellow";
     theTable.rows[j].cells[8].style.background="yellow";  
    
4. To change the color of the column heading, change the FOR counter to zero:
        for (var i=0;i<allTables.length;i++)

 

 

.

Review: Amazon Fire

So what does this have to do with SharePoint, .NET or other technologies I cover in this blog? Three things I guess… I read SharePoint books using an older Kindle, I wrote a book that cannot be ported to the old Kindle (at least not without starting over), and I’m starting to play with portable devices to access SharePoint sites. (If you are in a hurry, scroll down to the SharePoint section or to the final comments…)

 

I bought a Fire!

When I published my first book a number of people asked me why I didn’t have it available as a Kindle edition. The first reason was that I could not find a good way to get a book with hundreds of screen captures, blocks of code and tables into the Kindle format. Amazon offers a service to convert books to Kindle format, but when I sent them my book for a quote, they said they could not do it! I then checked the reviews of other technology books and saw that many of these books available for the Kindle actually got a lot of low ratings because of the issues with Kindle version of the book.

So along comes the Fire… I bought an Amazon Fire to see how it would do with more complex formats, and I’m actually pleased with how it deals with PDFs. The use of finger gestures to zoom in and zoom out make browsing a larger than the screen document pretty easy to do. So my first impression was good!

Then I started using it… and found some issues.

Opening the box…

Inside is a Fire, a charger brick and a little piece of paper that shows you how to turn it on. That’s all there is.  After you turn it on you will find that there is a help document on the “bookshelf”.  You will also need Google or Bing!

Is the Fire a good book reader?

For me, no.

Buttons: The old Kindle had buttons on the side to go between pages. You could hold the device in one hand, read, and click to see the next page. The Fire has no buttons, except for the power button. You have to swipe your finger across the screen. So you will need two hands to read a book and getting finger prints on the screen is unavoidable.

The screen: On the plus side, while the Fire is the same size as the old Kindle, the Fire has no keyboard, so more of the surface is used as the screen. On the negative side is the shinny new screen. The old Kindle has a matte screen that simply had no glare. It looked like paper. The Fire has a high gloss screen that always has reflections of something on it. You are always moving it around trying to move the glare off of the part of the screen that you are trying to read.

The user interface: The old Kindle is a pain to navigate. It took a while to learn which button did what and how to get around the menus. The Fire’s user interface is all touch. Drag this, tap that, guess what to do next. The primary interface for content is a “bookshelf” where you drag your finger to scroll across the books, and then… still not sure… do something to open the item. it seems that I always drag too far. I drag as slow as I can, stop when my item is fully displayed, lift my finger, and… it scrolls to the next item! It’s a game just to select one book. Just for fun I hand the Fire to people and ask them to open a certain book… and they can’t to it the first time!

I have problems (and maybe just me) with most of the user interface. I’m always selecting the wrong item, not able to scroll when I want, and constantly chasing the screen as it often randomly moves from where I just tapped or zoomed. I even have problems with basic “clicks”. I often have to tap a button, even the Fire’s basic back button, two or three times to get it to work.

Is the Fire a good video player?

This is where the new screen really shines, if you can get past the shine/glare problem. The color and brightness are great. Movies really look good! It even has stereo! It has stereo, but both speakers are on the same end of the device.The video is always displayed horizontally, so depending on how you were holding the device when you started the video, both speakers are on the left or both are on the right! Who would have ever thought that was a good idea! Headphones are mandatory if you plan to watch movies.

Movies from Amazon Prime play non-stop with no problems. The user interface for selecting a movie is not well thought out. After scrolling though a bunch of movies, clicking on an interesting one and then going back to browse some more, they take you back to the top of the list. There’s not even a visible scrollbar so you guess how far down the list you were the last time. The movies are frequently randomly are repeated in the list. (to make it look like there are a lot of movies available?) Also, like the bookshelf navigation, I have a hard time getting it to scroll to just where I want without overshooting.

I downloaded the NetFlix app to continue watching a movie I had started on my PC. The user interface is much better than the one from Prime, in fact, very much like the web based version. The only problem… the Fire constantly drops the wireless connection while watching a NetFlix video. It never drops the wireless (or at least it quietly buffers and reconnects) when watching Amazon movies. Hmmm…

(If you plan to watch movies from Amazon, then the cost of the Fire is $200 plus $79 a year for Prime.)

Is the Fire a good web browser?

The Fire’s web browser is not IE, FireFox or anything else you have ever heard of. It’s an Amazon exclusive called “Silk”. See here for more info: http://amazonsilk.wordpress.com/2011/09/28/introducing-amazon-silk/

Well, let’s start with the wireless features. The Fire is very slow to connect to wireless when first turned on. It often drops the connection and often when a web page times out, I find that the connection has dropped. In parts of my house where laptops and cell phones have no problem with wireless, the Fire will not connect. (weak receiver?)

You will always have problems with some web sites when trying to navigate and scroll with any touch device. With a device like the Fire you will often have to zoom in and zoom out, but with the Fire when I zoom the browser zooms and then moves off to some other part of the page. I’m always zooming and then dragging back to where I started.

Other things:

• No support for Silverlight, but Flash is built in
• DHTML popups won’t always go away (JavaScript bugs?)
• Basic navigation is inconsistent – I often have to click the back button two or three times (maybe it does not like me)
• Pages with nested DIVs will not scroll properly when the device is held horizontally (but strangely work just fine when held vertically)
• Downloads go to a Notification list and once an item has been opened once, it disappears from the list. Finding these files is fun… download an app named File Manager and then click on everything until you stumble across /sdcard/download.

Other notes… you may want to do a search on Amazon Silk and privacy as there seems to be some concern about the server side processing of your web requests.

 

Is the Fire good for SharePoint?

Basic browsing: The Amazon Silk browser does a good job on rendering a SharePoint site, as long as the device is held to display the page in a vertical format. When in the horizontal format you cannot scroll down a page!

As pointed out above, I have problems selecting items in the Fire, and this carries into Silk. Trying to select a document’s dropdown list in a library is a real test of patience.

ActiveX Controls and Office Integration: There is no Office on the Fire so none of the Office integration, presence detection, or features like Windows Explorer View (duh) and upload multiple are available.

Silverlight: Silk does not support Silverlight. Attempts to visit a page with a Silverlight control displays the Silverlight download button, which takes you to a blank page. (A file was downloaded, but can’t be opened – also, the file is hidden in a folder that cannot be accessed without downloading a File Manger app.) SharePoint’s pages that use Silverlight will fallback to a non-Silverlight page, but the lack of Silverlight support may be a problem for your pages that depend on custom Silverlight controls.

Microsoft Office Documents: The Fire does not include Word, Excel or PowerPoint. There is an Office compatible view only tool named QuickOffice installed. A full verion of QuickOffice can be purchased and you can buy other Office file viewers from the Amazon Android app store. You cannot open the files directly from SharePoint, but you can download them to the Fire and then open them. After accepting a 10 page license agreement  :-)  from QuickOffice the documents displayed fine, although the fonts, images and word wrap were strange in the PowerPoint files that I downloaded.

Office Web Apps:

Excel: If you open an Excel file with View in Browser or Edit in Browser you will only have access to the content that fits on the screen. There are no scrollbars and you cannot scroll using finger drags. Working with any kind of a popup such as the color picker or the number format is “iffy” at best. If you zoom in to carefully click a ribbon button and that button opens a popup off of the screen, you cannot scroll over to the popup area without the popup closing. (the drag is interpreted as a click)  Bottom line, if the Excel file is small enough to fit the screen and you can do most of your work zoomed all the way out, then you will have some success.

Word: Word documents take a long time to load. A document that loads in less than a second in Internet Explorer takes at least minute, and sometimes just displays a blank area where the document should be. And sometimes it just displays “Script Not Responding” and a button to “Restart Browser”. Clicking this restart button closes all of your browser tabs!

PowerPoint: I could not get PowerPoint to work consistently. It often just displays the “download Silverlight for a better experience” message and then eventually displays the “Script Not Responding” message. When it does work, it is quite slow. It also cannot be scrolled if displayed horizontally.

When I clicked the “Start Slideshow” button and waited, waited, waited and waited, it finally displayed the slides and did a decent job of rendering the animations… except… when displayed vertically the slide was clipped off on the right and when displayed horizontally it was clipped off on the bottom.

 

Is the Fire a good Android?

You will need to ask someone else as I don’t own another Android device and don’t tend to download “apps” and games. My son downloaded Angry Birds and had fun with that. The only app I downloaded was NetFlix. When using NetFlix the Fire constantly drops the wireless connection making watching NetFlix too painful.

 

Nitpicks

• Wireless: I wish I could mark the neighbors’ wireless networks as hidden to reduce the clutter. There is a Save and Forget button, but they don’t seem to do anything.
• Wireless: The Fire is slow to connect to even when reconnecting to the last wireless used
• No camera
• No microphone
• Speakers are of minimal value
• Heavier than the old Kindle
• Fingerprints… cannot be avoided…

  

In Summary…

Is the Fire a good book reader?   Not for me.

Is the Fire a good web browser?  Not for the sites I visit.

Is the Fire good for movies?  Yes, if the glare is not a problem and you only use Amazon Prime as your source of movies.

Is the Fire good for SharePoint sites? No.

What’s the Fire best for?   Buying books and apps from Amazon.   :-)

Should you give a Fire to someone who is not already Android savvy?   Questionable… 

What am I going to do with it?  Give it to someone else as a Christmas present! And maybe borrow it back when I’m ready to test publish my next book.

 

Future…

Do a web search on “Amazon Fire Complaints” and “Amazon Fire Update”. There may be some fixes for the problems I described in the near future.

 

.

Black Friday Certification Prep Deal???

 

I just got an email from MeasureUp.com with a 2 for 1 deal for exam prep materials.  The ad says “Get two practice tests for the price of one!”  Sounds good to me as I have a few exams planed in the next month, but when I click the ad to go to their site, there’s nothing about the deal. Maybe they got the email out ahead of the emails…

In any case, it says Good thru Friday December 2, 2011, so check their site over the next week and see if it shows up.

 

In case anyone from MeasureUp is reading this… my email client displayed this message for your email:  “Potentially dangerous scripts were removed from this message”   :-)

 

.

10 Reasons Not to Brand SharePoint

 

I wrote a magazine article! While that was fun, I’m really surprised at the follow up it received. It’s gotten some interesting comments via Twitter, a discussion over at LinkedIn and even a couple of articles about the article! Some folks strongly agree, some strongly disagree and one even thinks it’s funny. As long as I got people interested in the topic, I‘m happy!

 

So do me a favor… I’d love to know what my “regulars” think of the article. Take a look at it and post your comments there, here or any where. I’d love to know what you think either way.

http://www.sharepointpromag.com/article/sharepoint-server-2010/branding-sharepoint-141137

 

Twitter comments:

http://twitter.com/#!/search/%2210%20reasons%20not%20to%20brand%20sharepoint%22

http://twitter.com/#!/search?q=%23SPRebrand

http://twitter.com/#!/kerriabraham

 

The LinkedIn discussion:

http://www.linkedin.com/groups/10-Reasons-Not-Brand-SharePoint-43166.S.78580029?qid=b4fadd71-ea5a-49a1-bba6-86ecb14d0844&trk=group_most_popular-0-b-cmr&goback=.gmp_43166

 

Even some articles about the article:

http://sharepointsemantics.com/2011/11/why-you-should-not-brand-your-internal-microsoft-sharepoint-sites/

http://sharepoint-geek.com/2011/11/03/interesting-arguments-against-branding-internal-sharepoint-sites/

 

.

SharePoint Saturday Cincinnati is ... well this Saturday!

 

Cincinnati’s first SharePoint Saturday is in three days! Are you registered yet? If not, go here now: http://www.sharepointsaturday.org/cincinnati/default.aspx

With twenty different presentations you can’t miss!

 

I will be giving two presentations:

  SharePoint Governance... It may not be what you think it is...

and

  SharePoint 2007, 2010 and Office 365 for Site Owners and Power Users

 

 

                                Tweet it! (#SPSCincinnati)

                                     Blog it!

                                         Be there! 

                                             and Learn!

                                                                and remember… it’s FREE!

.

SharePoint Online Service Update – Cool things coming to Office 365/SharePoint Online!

 

See here for details:

http://www.office365blog.co.uk/2011/10/important-information-for-coming.html

 

BCS!

SharePoint Online will now have BCS! The lack of BCS is a real problem for many people wanting to try out the “cloud” and especially when the only custom code is via a sandbox solution.  But sadly, this is for Enterprise (“E” plan) subscriptions only.

 

Windows Phone 7 "Mango”  (the latest update to Windows 7 Phone) connectivity!

This gives access to Windows 7 Phones to SharePoint lists and libraries. This is for both “E” and “P” plans.

 

Recycle Bin: deleted site self-recovery

SharePoint 2010 got this with Service Pack 1. Now SharePoint online users can “undelete” a site!

 

Browser support for Internet Explorer 9

Now who would of  thunk of that?

 

Browser support: Chrome

Welcome Google!

 

 

.

SharePoint: Create an Alert from Anywhere

 

Users typically create an alert from a list’s ribbon or an item’s dropdown or ribbon. Regardless of where they click they get directed to /_layouts/SubNew.aspx, which is the Alert creation page. (Would you have guessed that a page named SubNew was used to create alerts?) As long as you know how to setup (or copy) this URL you can create a link to create an Alert from anywhere.

In this article we will see how to:

• Create our own links to create a new Alert
• Add these links to pages
• Add these links to Quick Launch
• Display the Alert page in a dialog box

 

Alert URLs

The URL to SubNew looks like this for a list or library level alert:

http://intranet/sites/Training/_layouts/SubNew.aspx?List=%7BE7735F69%2D5542%2D4B8F%2D9426%2DD7757EAFABD9%7D&Source=http%3A%2F%2Fintranet%2Fsites%2FTraining%2FShared%2520Documents%2FForms%2FAllItems%2Easpx&IsDlg=1

And like this for an item or document level alert:

http://intranet/sites/Training/_layouts/SubNew.aspx?List={E7735F69-5542-4B8F-9426-D7757EAFABD9}&ID=1&Source=http%3A%2F%2Fintranet%2Fsites%2FTraining%2FShared%2520Documents%2FForms%2FAllItems%2Easpx&IsDlg=1

http://intranet/sites/training	the path to your site
?list=	The Globally Unique ID (GUID) for the list or library (See below)
&Source	Optional – if provided, the user will be redirected to this page when the OK or Cancel button is clicked in the Alert page. (Ignored with used with &IsDlg=1)
?ID=	The internal ID for the list item or document (See below)
&IsDlg=1	2010 only – used to hide the navigation parts of the master page when a page is displayed as a dialog box (See below)

 

Notes:

List GUID: Each list and library in SharePoint (actually, just about every object in SharePoint) has a unique ID based on a GUID. This ID can be found in may URLs (example: List Settings or Library Settings) and can also be found by using PowerShell, the SharePoint API or tools like this or this.

SharePoint is not consistent in the formatting of a GUID. In some cases all of the letters must be lower case, in others they must be uppercase and in some it does not matter. As you can see in the two examples above, the GUID is sometimes escaped and sometimes is plain text. In the Alerts URL it does not seem to matter which form is used.

     Escaped:   %7BE7735F69%2D5542%2D4B8F%2D9426%2DD7757EAFABD9%7D

     Not escaped:   {E7735F69-5542-4B8F-9426-D7757EAFABD9}

List item ID: Every list item has a unique integer ID. This ID unique to the list and is never reused in the same list. (Add items 1, 2 and 3, then delete 2 and add one more. The new one will be 4. 2 will never be reused.) You can display the ID by simply adding the ID column to a view.

IsDlg: Setting this to 1 does not make the page display as a dialog, rather it tells the master page to hide most navigation elements. You can test this by going to just about any page other than your Home.aspx page and adding ?IsDlg=1 or &IsDlg=1 to the end of the URL.

http://intranet/sites/Training/Shared%20Documents/Forms/AllItems.aspx?IsDlg=1

See here for more about IsDlg and even how to display dialog boxes from Quick Launch.

 

Adding an Alert URL to a page

Using a SharePoint Rich Text editor (in a Wiki home page (home.aspx), a Content Editor Web Part or a Rich Text multiline column in a list) just click the Insert tab of the ribbon, click Link and paste in the URL for the Alert.

    

 

Adding an Alert directly to HTML:

Create an anchor tag (<A>) and add the URL for the alert. Example:

<a href="http://intranet/sites/Training/_layouts/SubNew.aspx?List={E7735F69-5542-4B8F-9426-D7757EAFABD9}&ID=1&Source=http%3A%2F%2Fintranet%2Fsites%2FTraining%2FShared%2520Documents%2FForms%2FAllItems%2Easpx"> Alert me! </a>

Note: Do not include the “&IsDlg'=1” unless you will displaying the alert page as a 2010 dialog box.

 

Adding an Alert to Quick Launch (or a Links list)

Too easy… just an a new link to Quick Launch using the URL copied from the Alert page.

 

Adding an Alert to Quick Launch (or a Links list) that displays as a SharePoint 2010 dialog box

See this article for more details and examples of SharePoint 2010 dialog boxes: http://techtrainingnotes.blogspot.com/2010/12/sharepoint-opening-2010-dialog-box-from.html

You will need to combine some JavaScript for the dialog box with the Alert’s URL to create the Quick Launch link. The following must be typed as all one line! Also note the use of single quotes (‘) around the URL.

JavaScript:var options=SP.UI.$create_DialogOptions();
options.url='/sites/Training/_layouts/SubNew.aspx?List=%7BE7735F69%2D5542%2D4B8F%2D9426%2DD7757EAFABD9%7D';
options.height = 400;
void(SP.UI.ModalDialog.showModalDialog(options))

Notes:

• Set options.url to your Alert URL, but remove the &Source= section (unless you want to send the user to a new page after creating the alert)
   
• If the alert page is in the same site collection, set options.url to a relative address:
    relative:     /sites/Training/_layouts/SubNew.aspx?List
    absolute:  http://intranet/sites/Training/_layouts/SubNew.aspx?List
   
• Quick Launch has a limit of 255 characters for the URL. To save space:
• Use relative URLs
• Do not use “&Source=” when using “&IsDlg”  (Ignored with used with &IsDlg=1)
• Use an un-escaped version of the GUID
   
• You can set the options.height and options.width to what ever looks best.

   

 

The results:

   

 

.