O365 Sharepoint: How to get the GUID of a site

By peter.stilgoe









Browse to your site eg.

https://yourdomain.sharepoint.com/sites/yoursite/yoursubsite/

Then append _api/web

So your complete URL looks like:

https://yourdomain.sharepoint.com/sites/yoursite/yoursubsite/_api/web

Now look for:

<d:Id m:type="Edm.Guid">THIS IS WHERE YOUR SITE GUID IS</d:Id>

Share

categoriaOffice 365, Sharepoint 2013 commentoComments Off dataMay 29th, 2015
Leggi tutto

Sharepoint – set the width of a column in a list or library using Jquery

By peter.stilgoe









<script src="../Scripts/jquery-2.1.4.min.js"></script>
 <script language="javascript">

_spBodyOnLoadFunctionNames.push("AdjustColumnWidth");

function AdjustColumnWidth(){
 $("div.ms-vh-div[DisplayName='Title']").attr("style", "WIDTH: 550px");
 $("div.ms-vh-div[DisplayName='Update notes']").attr("style", "WIDTH: 550px");
 }</script>

Share

Leggi tutto

O365 – Set a the width of a column in a list or library using jslink

By peter.stilgoe









(function () {
  var overrideCtx = {};
  overrideCtx.Templates = {};
  overrideCtx.OnPostRender = postRenderHandler;
  SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideCtx);
})();
function postRenderHandler(ctx){
  var ths = document.querySelectorAll('th.ms-vh2');
  for(var i=0;i<ths.length;i++)
  {
    if("Title"===ths[i].textContent.trim())//This would set the title field to a width of 750px
    {
      console.log(ths[i]);
      ths[i].setAttribute("width","750px");
      break;
    }
  }
}

Share

categoriaJavascript, Office 365, Sharepoint 2013 commentoComments Off dataMay 28th, 2015
Leggi tutto

O365 – Querying office graph

By peter.stilgoe









Graph Query Language (GQL) is a preliminary query language designed to query the Office graph via the SharePoint Online Search REST API. By using GQL, you can query the Office graph to get items for an actor that satisfies a particular filter.

https://msdn.microsoft.com/en-us/office/office365/howto/query-Office-graph-using-gql-with-search-rest-api?f=255&MSPPError=-2147217396

Share

categoriaOffice 365 commentoComments Off dataMay 6th, 2015
Leggi tutto

O365 useful troubleshooting tools

By peter.stilgoe









O365 health readiness & connectivity checks (For end users to run from their PCs) – www.aka.ms/checkmypc

Directory sync troubleshooter (Needs to be run from dir sync server by an admin) – www.aka.ms/dsup

The above tools are available from the O365 admin center along with some other tools https://portal.office.com/Admin/Default.aspx#ToolsPage

Share

categoriaOffice 365 commentoComments Off dataApril 17th, 2015
Leggi tutto

O365: Display content in a accordian in O365

By peter.stilgoe









This JSLink sample will show how to change rendering logic for the whole List View. This sample will read the Title and Description fields’ values and render the fields in an accordion style view.

https://code.msdn.microsoft.com/office/Client-side-rendering-code-ccdb2a0e

Share

categoriaJSLINK, Office 365, Sharepoint 2013 commentoComments Off dataJanuary 29th, 2015
Leggi tutto

O365: Tabbed forms in O365

By peter.stilgoe









This JSLink sample allows you to use JQuery Tabs within your SharePoint List Forms.

https://code.msdn.microsoft.com/office/Client-side-rendering-code-b2eedf92

I had a bit of trouble getting this to work so I had to:

1) I think #4 is a typo

2) Upload my JS file to the master page gallery as a ‘JavaScript Display Template’

In my case changing the new form on a custom list I had to set –

Target control type: Form

Standalone: Override

Target scope: /sites/mysite

Target list template ID: 100 (custom list)

2) Add my jslink property in the webpart to my JS file using the token method eg. ~sitecollection/_catalogs/masterpage/Tabs.js

This is what I had to do to get it working on O365…….

Share

categoriaOffice 365, Sharepoint 2013 commentoComments Off dataJanuary 29th, 2015
Leggi tutto

15 Amazing Features In Office 365 That You Probably Don’t Know About

By peter.stilgoe









15 Amazing Features In Office 365 That You Probably Don’t Know About

Share

categoriaOffice 365 commentoComments Off dataDecember 16th, 2014
Leggi tutto

Best Jquery chart libraries for interactive charts

By peter.stilgoe









Best Jquery chart libraries for interactive charts

http://codegeekz.com/best-jquery-chart-libraries-for-building-interactive-charts/

Share

Leggi tutto

Office 365 – Sharepoint forms after infopath

By peter.stilgoe









Microsoft have announced the end of Infopath forms you can read here.

With this in mind its best to start thinking about building any future forms in upto date technologies:

1) Using the app model rolled out in 2013 / Office 365 using HTML5, CSOM, Jquery, REST

2) Access apps to create forms allowing you to create fairly complex forms (relationships, joins etc) See an example here

3) Excel surveys are quick easy way to create & report on basic question and answer forms which is now available in O365 –> Onedrive. Read about here

Share

Leggi tutto

Office 365: Onedrive for business – Sync issues

By peter.stilgoe









Office 365: Onedrive for business – Common sync issues

Onedrive for business – common sync issues

Share

categoriaOffice 365 commentoComments Off dataSeptember 14th, 2014
Leggi tutto

Linux VPS performance test

By peter.stilgoe









Ramnode:

CPU model : Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz
Number of cores : 2
CPU frequency : 2600.065 MHz
Total amount of ram : 2048 MB
Total amount of swap : 256 MB
System uptime : 16:00,
Download speed from CacheFly: 87.0MB/s
Download speed from Coloat, Atlanta GA: 12.0MB/s
Download speed from Softlayer, Dallas, TX: 46.6MB/s
Download speed from Linode, Tokyo, JP: 10.9MB/s
Download speed from i3d.net, Rotterdam, NL: 4.08MB/s
Download speed from Leaseweb, Haarlem, NL: 15.1MB/s
Download speed from Softlayer, Singapore: 12.6MB/s
Download speed from Softlayer, Seattle, WA: 93.9MB/s
Download speed from Softlayer, San Jose, CA: 59.5MB/s
Download speed from Softlayer, Washington, DC: 12.2MB/s
I/O speed : 592 MB/s

1and1:

CPU model : AMD Opteron(tm) Processor 6386 SE
Number of cores : 3
CPU frequency : 2800.000 MHz
Total amount of ram : 4096 MB
Total amount of swap : 128 MB
System uptime : 21:22,
Download speed from CacheFly: 11.8MB/s
Download speed from Coloat, Atlanta GA: 2.59MB/s
Download speed from Softlayer, Dallas, TX: 2.77MB/s
Download speed from Linode, Tokyo, JP: 3.46MB/s
Download speed from i3d.net, Rotterdam, NL: 9.04MB/s
Download speed from Leaseweb, Haarlem, NL: 6.42MB/s
Download speed from Softlayer, Singapore: 1.71MB/s
Download speed from Softlayer, Seattle, WA: 3.20MB/s
Download speed from Softlayer, San Jose, CA: 4.18MB/s
Download speed from Softlayer, Washington, DC: 5.07MB/s
I/O speed : 24.6 MB/s

OVH (Located in Europe):

Download speed from CacheFly: 11.8MB/s
Download speed from Coloat, Atlanta GA: 3.99MB/s
Download speed from Softlayer, Dallas, TX: 4.29MB/s
Download speed from Linode, Tokyo, JP: 1.32MB/s
Download speed from i3d.net, Rotterdam, NL: 2.39MB/s
Download speed from Leaseweb, Haarlem, NL: 3.04MB/s

OVH (Located North America):

Download speed from CacheFly: 1.25MB/s
Download speed from Coloat, Atlanta GA: 347KB/s
Download speed from Softlayer, Dallas, TX: 177KB/s

Note: If you are considering a VPS from 1and1, I could not use it for my project, kept getting these errors -

-bash: fork: Cannot allocate memory

You can read about other people having problems with 1and1 VPS’s & resource limits here

Share

categoriaVPS commentoComments Off dataAugust 14th, 2014
Leggi tutto

Sharepoint 2010 Search Refinement Panel: Some refiners tool tips are bank or empty

By peter.stilgoe









Implemented the Sharepoint search refinment panel on a Sharepoint 2010 enterprise search center.

The content for this search center was tagged using both standard Sharepoint column types and some managed metadata columns.

What I noticed was that when you hover over some of the refiners on the refinement panel the tooltip would display as expected eg. ‘Refine by: Form’ but for others the tooltip would display without the term, it would just display as ‘Refine by:’

This seems like a bug to me, the fix for this is to modify the XSLT of the refinement panel webpart, edit the webpart & replace the OOTB XSLT:

<a href="{$SecureUrl}" title="{$RefineByHeading}: {$UrlTooltip}">
<xsl:value-of select="Value"/>
</a>

With the following:

<a href="{$SecureUrl}" title="{$RefineByHeading}: $UrlTooltipAdjusted}">
<xsl:value-of select="Value"/>
</a>  

<xsl:variable name="UrlTooltipAdjusted">
 <xsl:call-template name="format-tooltip">
 <xsl:with-param name="tooltip" select="$UrlTooltip" />
 <xsl:with-param name="string" select="Value" />
 </xsl:call-template>
</xsl:variable>  

<xsl:template name="format-tooltip">
 <xsl:param name="tooltip" />
 <xsl:param name="string" />
 <xsl:choose>
 <xsl:when test="$tooltip != ''">
 <xsl:value-of select="$tooltip" />
 </xsl:when>
 <xsl:otherwise>
 <xsl:value-of select="$string" />
 </xsl:otherwise>
 </xsl:choose>
</xsl:template>

Now the refiners should display in all tooltips as expected in the refinement panel.

When googling this I could only find a single person blogging about this which suggests the problem may only occur in very special circumstances, however if you are facing the issue the above will fix it.

Thanks to: http://www.itidea.nl/index.php/empty-tooltip-in-refinement-panel/

Share

categoriaSharepoint / MOSS / WSS, Sharepoint 2010, Sharepoint Search, XSLT commentoComments Off dataNovember 21st, 2013
Leggi tutto

XSL: How to combine multiple onclick events in XSL

By peter.stilgoe









How to combine multiple onclick events in XSL:

<xsl:attribute name="onclick">
   <xsl:value-of select='concat("javascript:window.open(","&apos;",link,"&apos;,&apos;newwin&apos;,&apos;left=50,top=150,width=812,height=450,toolbar=No,location=No,scrollbars=No,status=No,resizable=No,fullscreen=No&apos;);")' />
	_gaq.push(['_trackEvent', 'Feature Image', 'click', '<xsl:value-of select="ga_id"/>']);
</xsl:attribute>

Share

categoriaSharepoint / MOSS / WSS, Sharepoint 2010, xsl commentoComments Off dataSeptember 25th, 2013
Leggi tutto

Sharepoint 2010: How to allow duplicate column display names

By peter.stilgoe









Through the Sharepoint GUI if you try & enter a display name for a column that already exists, you will get an error message saying a column already exists with that name, choose another name.

To get round this once you are on either the fldnew.aspx or fldedit.aspx page, enter the below in the address bar of your browser:

javascript:g_FieldName={};alert('ok');

This will disable the validation on that page & allow you to create column names with the same display names as existing columns.

Not that you should ever want to! But can come in handy when trying to carry out remedial things done on the platform before your time!

Share

categoriaSharepoint 2010, Sharepoint Columns, Sharepoint How To commentoComments Off dataAugust 27th, 2013
Leggi tutto

Sharepoint 2010: How to copy a Sharepoint page with all webparts included

By peter.stilgoe









How to copy a Sharepoint page with all webparts included:

1) Open the site in SharePoint Designer 2010 & browse to the ‘Pages’ library

2) Create a ‘Temp’ folder

3) Right click the page you want to copy and select ‘Copy’

4) ‘Paste’ the page into the ‘Temp’ folder

5) Rename the page & copy it back to your ‘Pages’ library

Now open the page in your browser, you should see an exact copy of your original page inclusing all webparts.

Share

Leggi tutto

Sharepoint: How to create a url to force a document to download instead of open

By peter.stilgoe









In Sharepoint if you need to create a URL to a document or image and force it to download instead of displaying, use a URL like:

http://spsite/_layouts/download.aspx?SourceUrl=http://spsite/Images/image1.jpg

Share

categoriaSharepoint / MOSS / WSS, Sharepoint 2010, Sharepoint How To commentoComments Off dataFebruary 22nd, 2013
Leggi tutto

Stock trading: Always trade your plan

By peter.stilgoe









- Market in confirmed up trend

- Breakout from solid base with 40%+ increase in volume

- Quarterly earnings 25% +

- Return on equity (ROE) 17% +

- Relative strength rising

- Qtrs rising sponsorship 3+

- Tight hard stop loss $2

- Dont trade in 1st 15 minutes of market opening

- Leave emotions at the door

Share

categoriaStockmarket commentoComments Off dataFebruary 2nd, 2013
Leggi tutto

Sharepoint 2010: Bulk edit Sharepoint list items using Powershell

By peter.stilgoe









Change a single Sharepoint list item (with a known ID):

$SPAssignment = Start-SPAssignment
$SPWeb = Get-SPWeb http://yourintranet/sitename -AssignmentCollection $spAssignment
$SPList = $SPWeb.Lists["Contacts"]
$SPItem = $SPList.GetItemById("982")
$SPItem["Company"] = "New value"
$SPItem.Update()
Stop-SPAssignment $SPAssignment

Change multiple Sharepoint list items (with a known field value)

$SPAssignment = Start-SPAssignment
$SPWeb = Get-SPWeb http://yourintranet/sitename -AssignmentCollection $spAssignment
$SPList = $SPWeb.Lists["Contacts"]
$SPItems = $SPList.Items | Where { $_["Company"] -eq "Old value" }
foreach($item in $SPItems){
$item["Consultant"] = "New value"
$item.Update()
}
Stop-SPAssignment $SPAssignment

Share

Leggi tutto

Sharepoint 2010 – Solution stuck on Retracting

By peter.stilgoe









On our Sharepoint 2010 Dev farm we we’re trying to remove solutions from Central Admin & they were just stuck on ‘retracting’

Turns out the the Sharepoint Timer Service had stopped, start the Sharepoint Timer Service and your solutions should start to retract as expected.

Share

categoriaSharepoint 2010, Sharepoint Timer Jobs commentoComments Off dataOctober 8th, 2012
Leggi tutto
  • cosmical