Skip Ribbon Commands
Skip to main content
Home
February 05
Hide Quick Launch in SharePoint 2013

This is an updated entry for hiding the Quick Launch menu from displaying on certain pages, such as the homepage of a site. You can do this without using SPD or messing around with the whole "CSS slapjack" game. The Content Editor Web Part can do it all for you!

  1. Create a CEWP and name it "Hide QL 2013".
  2. Edit the CEWP, adding a space in it, then click on the "Edit HTML Source" under the "HTML" button, under "Format Text".
  3. Insert this code:
<style>
#DeltaPlaceHolderLeftNavBar { DISPLAY: none }
#contentBox { margin-left: 0px }
.CustomQLArea { DISPLAY: none }
</style>

Save it and you're done!

June 25
Adjusting Fomatted Time on A Custom Display Form To The Correct Time Zone - SharePoint 2013

​Recently I had a client ask if we could modify DispFom.aspx for a calendar on SharePoint 2013 to remove fields that they didn't want their users to see. I said, "That's easy! We'll just make a custom display form and relink the list to that." Went into SPD2013, created a new DispForm, went into Advanced Edit mode. SPD 2013 no longer has Design View, but I understood the code well enough to find the offending rows and removed them. Saved, set form as default and done!

Well, we ran into this issue mentioned in an earlier post where the date-time format gets UGLY. Fixed that, but then the client notices something else: the time is off by 5 hours. Time shows up correctly on calendar, but when we look at the custom display form, it is off. What gives?!

Looked at Central Admin to see if the time zone setting was off, but sure enough, it was the correct time zone (they are in Central Standard Time in the US, which is supposed to be 6 hours from GMT.)

Did quite a bit of research on this, and from what I can see, the Formatted Time goes to GMT time, regardless of any settings you put in. There doesn't seem to be any way to influence the MSXML code, so you have to alter the source. Calculated Column time!

I created a column called AdjustedTime.  You can name it whatever you want, however...

Make sure not to use spaces when naming your calculated column, as that adds the _x0020_ space tag into the internal name. Remember that capitalization matters here for column names. Also, it keeps whatever name you initially give it permanently, so don't rename it after you've created it, or you'll have a hard time figuring out the internal column name! SPD 2013 no longer has a functioning Data Source Details Pane, so you'll have to use IEDevToolbar (F12 on IE) to look on the default DispForm.aspx page...

The formula I used is as follows:

=([EventDate]-0.2083)

Here's a useful chart to add or remove hours in your calculated column:

  • 1 Hour =  0.0416
  • 2 Hours = 0.83
  • 3 Hours = 0.125
  • ​4 Hours = 0.166
  • 5 Hours = 0.2083
  • 6 Hours = 0.25
  • 7 Hours = 0.2916
  • 8 Hours = 0.33
  • 9 Hours = 0.325
  • 10 Hours = 0.416
  • 11 Hours = 0.4583
  • 12 Hours = 0.5
  • 13 Hours = 0.5416
  • 14 Hours = 0.5483
  • 15 Hours = 0.625
  • 16 Hours = 0.66
  • 17 Hours = 0.7083
  • 18 Hours = 0.75
  • 19 Hours = 0.7916
  • 20 Hours = 0.83
  • 21 Hours = 0.875
  • 22 Hours = 0.916
  • 23 Hours = 0.9583
  • 24 Hours = 1

I then place this field into into the "Format Time" MSXML code and VIOLA! works again. Example:

<xsl:value-of select="msxsl:format-date(@Adjusted, 'MM/dd/yyyy')"/>, <xsl:value-of select="msxsl:format-time(@StartDate, 'hh:mm tt')"/> 

NOTE: One caveat is that any calendar events that do not have a specific time (all day events) do NOT convert, and so the time is off for these by whatever adjustment you made. LAME... at least the timed events show up properly again...

Well, I hope this saved you some serious headaches. Happy SharePointing!

March 12
Formatting Phone/Fax Numbers in InfoPath

​Here's a very helpful blog post, for those that work with InfoPath 2010. Good for formatting phone/fax numbers on forms. Instead of just rewriting the author's post, I'll just link you to it here:

http://digitalmacgyver.wordpress.com/2012/02/02/custom-rule-for-telephone-field-in-infopath-201-form/ 

Some things to note:

When copying the code listed there, be sure to change the quotation marks from directional quotes (“)(”) to straight quotes("). It can be frustrating not knowing why the code is not working...

Here's the important bits of code, with quotes modified already, for quick reference:

  • string-length(translate(., "()- ", "")) = 10
  • string-length(translate(., "()- 0123456789", "")) = 0
  • concat("(", substring(translate(., "()- ", ""), 1, 3), ") ", substring(translate(., "()- ", ""), 4, 3), "-", substring(translate(., "()- ", ""), 7, 4))

 Happy SharePointing!

January 17
Changing the Ribbon Color using CSS

​Here's a simple but helpful bit of CSS code. Many companies want their branding all over, including the Ribbon background. here's the code snippet that can be overwritten with CSS to alter this color:

BODY #s4-ribboncont {

background-color: <VALUE> !important;

}

Just be sure that this loads last, either by putting it in the masterpage or its own CSS reference.

Happy SharePointing!

September 27
Adding Multiple Parameters to A Custom URL

​OK, so here's a quick one for today:

Let's say you want to redirect a link back to the page that you came from. For example the user clicks into a detail page, and they should be returned to the main page after closing the detail page. So we add a "?Source=" parameter into the URL:

http://www.myspsite.com/pages/mainpage/details.aspx

http://www.myspsite.com/pages/mainpage/details.aspx?Source=/pages/mainpage.aspx

So the user is returned to the main page. But what if you are doing this in a custom dataview Web Part url link, where there is already a parameter, such as ?ID={@ID} ? Normally you would add an amperstand (&), but SharePoint is looking for a semicolon (;) and it will break your XSL. But if you use a semicolon, it disregards whatever you put after it. The solution is to put in the HTML code for an amperstand, which looks like this:

&amp;

So your link code should look something like this:

http://www.myspsite.com/pages/mainpage/details.aspx?ID={@ID}&amp;Source=/pages/mainpage.aspx

This fulfills both of our requirements. Happy SharePointing!

August 07
Modify a Calendar List Dataview to Show Only Date

Here's a new issue with Custom Date Fields. The previous tip works for most lists EXCEPT the Calendar list. To set the date only on these views, follow the steps outlined below:

  1. Open the page in SharePoint Designer 2010.
  2. Change that Datasheet view to XSLT by clicking on List View Tools > Design > Customize XSLT > Customize Entire View.
  3. Right-Click the Date and Time field, then click "Edit Formula".
  4. ​Here's ths string to use in the formula: 

    ddwrt:FormatDate(string($thisNode/@StartDate),1033,1)

Setting a "1" sets Date only, and "3" is Date with day only. Not sure why "2" doen't work...

Full article found here:

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/3ab366a0-af2a-4270-9870-98eaa58c2eba

Happy SharePointing!

August 07
SPTechCon Boston 2012

Wow this conference just keeps getting better. Many companies like Axceler are right in Boston, and many MVPs turn out for this.

Of course learning details about SharePoint 2013 (or 15) was huge.​ We actually have it in our office and have been testing it but it was great to hear what Andrew McConnell had to say.

 

SPTechCon2012.jpg

June 19
UPDATED: Fix Date and Time Formatting on Custom Display Forms

Creating custom display forms for Sharepoint 2010 lists is a regular thing for me, so I get annoyed when I flip them and they come out looking like this: 2010-07-06T22:00:00Z

It should look like this: 7/7/2001
 
I fixed this by doing the following in SharePoint Designer 2010:
 
Replace the XSL line with this and insert the date field tag into where @StartDate is:
<xsl:value-of select="msxsl:format-date(@StartDate, 'MM/dd/yyyy')"/>

Some people also wanted to know how to keep the time too, with a nice format also. The solution is quite similar to the previous method shown, with a few changes. Just add this after the Custom Date code of the previous post to display the formatted time. Code is as follows:

Replace the XSL line with this and insert the date field tag into where @StartDate is:
<xsl:value-of select="msxsl:format-time(@StartDate, 'hh:mm tt')"/>
 
So your final code may look something like this:
 
<xsl:value-of select="msxsl:format-date(@StartDate, 'MM/dd/yyyy')"/>, <xsl:value-of select="msxsl:format-time(@StartDate, 'hh:mm tt')"/>
 
 

Explanation of fields is found here:

http://msdn.microsoft.com/en-us/library/ms256467

June 12
Better Performance for Windows XP Mode on Windows 7

​This is related to SharePoint due to the fact that we use VMs to connect to VPN clients to isolate the software environment and to meet some clients' VPN security stipulations. It is also done so we can have our tools, like SP Designer 2010, readily available to us without loading unnecessary amounts of software on their servers.

I personally use the Windows 7 XP Mode as my VM, and why not? It's free and well integrated into my OS. We use a customized VHD and attach that, and off we go. However, I've been having some trouble with the perfomance of my VM.

My VM has the issue of being really sluggish, with the performance in the VM hitting 100% constantly. I have a 2.8Ghz triple core processor (overclocked to 3.21Ghz) and 8.00GB of RAM, and I have 1 core dedicated to that VM with 3.00GB allocated, so hardware is definitely not the issue. Hardware Virtualization for my CPU is present and enabled, and my main machine’s Task Manager Performance chart never goes higher than 33%. I looked around the web after pulling my hair out all day and found this tip:
  • Turn off / Hibernate all running virtual machines
  • Open C:\Users\Your_Username\AppData\Local\Microsoft\Windows Virtual PC\Options.xml with Notepad
  • Add this somewhere between the Preferences tags:
    • <virtual_machines>
      <enable_idle_thread type="boolean">true</enable_idle_thread>
      </virtual_machines><br/>
  • Save the file
This allows your virtual machine to use more of the host’s resources, thus increasing the performance. A very clear difference!

In addition you could set the virtual machine's performance options to best performance (in XP, right click My Computer in Start Menu, choose Properties > Advanced > Performance.)
 
I found this great tip here:
 
This made my VM 1000% better! As always, use this at your own risk, but now I don’t have to type and wait for my VM to catch up… :)

 

 

May 17
A Peek at SharePoint 15

Next week I'll be across the country at Microsoft campus getting a sneek peek at Office 15 including ​SharePoint 15. This will be my first trip to Microsoft so I am looking forward to it. We became Microsoft partners over a decade ago so its overdue. I finally get to rub elbows with the Microsoft Smufties (as they are called). As soon as I am allowed to post details of what is in SharePoint 15 (according to my NDR) I will post them here.

-Ed G

1 - 10Next


Designed and Implemented by
Vermont SharePoint consultants
a Gold Certified Microsoft SharePoint Consulting Firm