Monthly Archives: March 2017

Download all Documents in a Library View

The PowerShell below will download all documents in a given SharePoint Document Library view to the local folder.   This can be safely run on end user Windows PC and does not require SharePoint server access or object model.    The design relies solely upon HTTP to discover the list of Document URLs then HTTP to download the binary content.    Simple and straight forward. 

Just edit the URL and GUID number on the first 3 lines and you’re ready to run.   Alternatively, you can supply those values via CMD parameter like this:

.\SPDownloadView.ps1 -url "http://portal/sites/test" -listID "41E5FC8E-D174-4F48-AC3C-79F999A045D1" -viewID "5E9415B3-3C63-48AD-9DC2-A5A282B61790"

Enjoy!shades_smile

Source Code

# Download all files from a SharePoint Document Library view to the local folder over HTTP remotely.  
# No server side requirement, can run anywhere, including end user desktops.
param (
    $url,       # "http://portal/sites/test",
    $listID,    # "41E5FC8E-D174-4F48-AC3C-79F999A045D1",
    $viewID     # "5E9415B3-3C63-48AD-9DC2-A5A282B61790"
    )
# Current folder
$scriptpath = Split-Path $MyInvocation.MyCommand.Path
	
# Open file list
Write-Host "Opening $url"
$ows = "$url/_vti_bin/owssvr.dll?Cmd=Display&List={$listID}&View={$viewID}&XMLDATA=TRUE"
$owsList = "$url/_vti_bin/owssvr.dll?Cmd=ExportList&List={$listID}&XMLDATA=TRUE"
$r = Invoke-WebRequest $ows -UseDefaultCredentials
$rList = Invoke-WebRequest $owsList -UseDefaultCredentials
$xml = $r.Content
$xmlList = $rList.Content
$folder = $xmlList.List.Url
# Client
$client = New-Object System.Net.WebClient
$client.UseDefaultCredentials = $true
# Loop and download
foreach ($row in $xml.xml.data.row) {
    $name = $row.ows_LinkFilename
    $from = "$url/$folder/$name"
    $client.DownloadFile($from, "$scriptpath\$name")
}
Write-Host "DONE"

 

Video

 

References

Custom Web Part – Save settings to SPList (without jQuery)

Ever wanted to code a JavaScript content editor (script editor) web part that saves settings to a list?   Without jQuery?

The library below “wp-settings.js” does exactly that with native XHR (XML HTTP Request) and nested callback to invoke REST API.   The free standing POJO (Plan Old JavaScript Object) design enables us to package into a web part gallery and use freely across any site without preparation work to ensure jQuery, Angular, or other dependent frameworks are loaded.

Look at the “webpart.html” to see example usage pattern:

  • wpsRead()  Get settings (if any)
  • wpInit()  Local web part initialize
  • wpsWrite()  Save settings (UPDATE/INSERT)

 

Cheers!  shades_smile

 

 

Source Code

 

Video

 

Screenshots

image

image

image

 

References

FIXED – Microsoft.Service Bus error 102

While troubleshooting a Workflow 2013 Farm outage I noticed the below event log errors.   The fix was to execute Workflow 2013 PowerShell cmdlets to “sync” the binary front end with SQL database backend.   Similar to how SharePoint Config Wizard does this after CU EXE installation with SharePoint Farms, we may need to run similar “SPFarmUprgade” steps for Workflow 2013 Farms.

Cheers!  shades_smile

 

Resolution

# Update Service Bus Farm Database
$mycert = ConvertTo-SecureString -string "workflow-farm-password-here" -Force –AsPlainText
$mypassword = ConvertTo-SecureString -string "workflow-farm-password-here" -Force –AsPlainText
$sbfarm = Get-SBFarm
Remove-SBHost
Invoke-SBFarmUpgrade -SBFarmDBConnectionString $sbfarm.SBFarmDBConnectionString -CertificateAutoGenerationkey $mycert
Add-SBHost -SBFarmDBConnectionString $sbfarm.SBFarmDBConnectionString -RunAsPassword $mypassword -EnableFirewallRules $false -CertificateAutoGenerationKey $mycert

 

Symptom

Microsoft.ServiceBus – 102

The description for Event ID 102 from source Microsoft.ServiceBus cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
An unrecoverable error occurred. For diagnostic purposes, this English message is associated with the failure: ‘Messaging Host Aborted’.
   at Microsoft.ServiceBus.Common.ExceptionTrace.TraceFailFast(String message, EventLogger logger)
   at Microsoft.ServiceBus.Common.ExceptionTrace.TraceFailFast(String message)
   at Microsoft.ServiceBus.Common.Fx.AssertAndFailFastService(String description)
   at Microsoft.Cloud.ServiceBus.MessageContainerHost.MessageContainerHostComponent.Abort()
   at Microsoft.Cloud.HostingModel.ComponentHost.CloseComponent(IComponent component, RequestTracker tracker)
   at Microsoft.Cloud.HostingModel.ComponentHost.Close()
   at Microsoft.ServiceBus.MessageBroker.Backend.OnStart(String[] args)
   at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
Microsoft.ServiceBus.MessageBroker
24680

 

Application Error – 1000

Faulting application name: Microsoft.ServiceBus.MessageBroker.exe, version: 2.0.30904.0, time stamp: 0x5227aa71
Faulting module name: KERNELBASE.dll, version: 6.2.9200.21815, time stamp: 0x56eafa38
Exception code: 0xe0434352
Fault offset: 0x0000000000024650
Faulting process id: 0x2d9c
Faulting application start time: 0x01d29d7381132061
Faulting application path: C:\Program Files\Service Bus\1.1\Microsoft.ServiceBus.MessageBroker.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: bfa8f2cc-0966-11e7-9482-0050569927e2
Faulting package full name:
Faulting package-relative application ID:

 

2017-03-16_11-11-19

References

What’s in that patch? March 2017

NOTE – PDF format updated to include both SharePoint 2013 and 2016 notes.

 

Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at http://sharepointupdates.com/

If you found this helpful, please leave a comment.    shades_smile_thumb_thumb_thumb_thumb[2]

 

Download

What’s in that patch – Mar 2017.PDF

Office 365 – Plan For Change 2017 Recap

Below is a quick recap of the 8 “Plan For Change” messages from O365 Admin Center so far this year.   The cloud moves quickly, if you have Tenant Admin rights please read these to be more familiar with the latest cloud features.    I was surprised to see Site Settings and Site Contents links will be removed from OneDrive.   However, it makes sense to move away from classic SharePoint site to more of a DropBox style cloud first storage service.

Cheers!  shades_smile

MC95315 – Feature update: Changes to Yammer Analytics Dashboard

03-08-2017

We have moved overview and access information from the Yammer Analytics dashboard, to the Office 365 device usage report. As a result, we are removing the Overview and Access sections from the Yammer Analytics dashboard, in 30 days. Other sections, such as Members, Messages, Groups, and Files, will remain in place until there is a suitable replacement for them.

How does this affect me?

You can now use the new Office 365 device usage report to show you the activity overview across the Office 365 services in your organization.

What action do I need to take?

Please click Additional Information to learn more about how to get the Yammer device usage report.
Additional information

 

MC94822 – Feature update: Change to unused anonymous links

03-01-2017

On March 30, 2017, we are adjusting how anonymous access and internal links (people within my organization) are used in SharePoint Online and OneDrive for Business – to improve reliability and manageability. We are standardizing how sharing links are used and registered in the system to offer you the greatest levels of creation, visibility and control.

How does this affect me?

On March 30, SharePoint Online and OneDrive for Business will adjust aspects of anonymous access and internal links (people in my organization) that may impact any links generated before May 2016.

Any links created before May 2016, and not used since, may no longer work and the owner will need to recreate a new anonymous link and share it again with the invitee. If a link had been generated AND used before May 2016, it will continue to work after this change.

If you have any unused links that you want to continue to work, you just need to click on the link before March 30, 2017.
Please click Additional Information to learn more about sharing documents with people outside your organization.
Additional information

 

MC94730 – Intune Company Portal Update for Apple Application Transport Security

02-28-2017

How does this affect me?

You will be impacted by this change if you:
– Use the iOS Company Portal app, and
– Have any IT infrastructure that the iOS Company Portal app communicates with that is not compliant with ATS.
Microsoft will be releasing a new version of the Company Portal app for iOS to meet Apple’s new requirements.

What do I need to do to prepare for this change?

In the next 30 days, ensure that all the network connections you have configured for use within the iOS Company Portal app meet Apple’s new requirements. Some places to check include ADFS configuration, proxy server configuration, and any custom links set in the Admin Console like the support website URL.

We plan to release a new version of the Company Portal app in April, ahead of the non-specific Spring 2017 date provided by Apple. However, if Apple should change their timeline, we’ll adjust accordingly to give you as much time as we can.

For links to Apple’s announcements and a tool you can use to evaluate your compliance with Apple’s new ATS requirements, please click Additional Information.
Additional information

 

MC94780 – Changes to In-Place eDiscovery searches and In-Place Holds with Exchange and SharePoint Online

02-28-2017

On July 1, 2017, we are disabling the ability to create new In-Place eDiscovery searches and In-Place Holds (*-MailboxSearch) in the Exchange Admin Center in Exchange Online, as well as the creation of new cases in the eDiscovery Center in SharePoint Online.

Scenarios dependent on these features have been transitioned to the Office 365 Security & Compliance Center. In both cases, you will still be able to edit and run existing searches in the Exchange Admin Center and work with existing cases in the SharePoint eDiscovery Center.

How does this affect me?

You are receiving this message because our reporting indicates your organization is using one or more of these features. Beginning July 1, 2017, we will disable the ability to create new In-Place eDiscovery searches and In-Place Holds (*-MailboxSearch) in the Exchange Admin Center in Exchange Online in addition to the creation of new cases in the eDiscovery Center in SharePoint Online.

You can continue to interact with all existing searches and holds in the Exchange Admin Center, or eDiscovery Center in SharePoint Online. We are only removing the capability to create new searches.

What do I need to do to prepare for this change?

Where possible, discontinue use of existing eDiscovery and Holds using the Exchange Admin Center and eDiscovery Center in SharePoint Online. Start using the Office 365 Security & Compliance Center today.

Please click Additional Information to learn more.
Additional information

 

MC94651 – We are removing the Site settings button from OneDrive for Business

02-24-2017

We are removing the Site settings and Site contents buttons from the OneDrive for Business settings pane on March 6th. This change does not affect classic OneDrive.

The Site settings page was designed to modify settings for a SharePoint site. The majority of these settings, such as creating subsites or modifying site collection administrators, are not applicable to OneDrive for Business.

How does this affect me?

Users in First Release, will no longer be able to navigate to Site settings from the OneDrive for Business settings pane unless they click Return to classic OneDrive.

What do I need to do to prepare for this change?

If you need users to easily navigate to Site settings for OneDrive for Business, you can reset the OneDrive experience to Classic by going to the SharePoint Admin Center > Settings. Under OneDrive for Business experience, select Classic experience. Please click Additional Information to learn more.

Additional information

 

MC92090 – We’re removing Site Mailboxes in SharePoint Online

01-31-2017

Beginning March 2017, new SharePoint Online organizations will no longer have access to the Site Mailbox feature, existing SharePoint Online organizations will no longer be able to create new Site Mailboxes; however, any Site Mailboxes provisioned prior to March 2017 will continue to function.

How does this affect me?

You are receiving this message because our reporting indicates your organization has one or more Site Mailboxes available. Beginning March 2017, your users may no longer create new Site Mailboxes.

In September 2017, we will have a process in place allowing you to transition your existing Site Mailbox site to an Office 365 Group. We will communicate again in June 2017, via Message Center, with more details.

What do I need to do to prepare for this change?

If you are using the Site Mailbox feature in SharePoint Online, you should consider transitioning to Office 365 Groups, to support email-centric collaborative scenarios.

Please click Additional Information to learn more.

Additional information

 

MC94651 New feature: OneDrive for Business sync client updates

01-30-2017

We are rolling out updates to the OneDrive sync client that improve the user experience, administration, and accessibility of syncing files from Office 365. This includes a support syncing Shared Folders and SharePoint Online document libraries as well as a new activity center, and a new standalone sync client for Mac.

How does this affect me?

We have begun rolling this out to existing sync users. The roll out will be complete by February, 2017.

What do I need to do to prepare for this change?

There is nothing you need to do to prepare for this change. Please click Additional Information to learn more, and access the standalone client for Mac.

 

MC81842 – Removing the Office 2013 version of Office 365 ProPlus

01-27-2017

Office 2016 is the recommended version of Office 365 ProPlus and includes all the latest upgrades and new features. As we announced in September 2015, when we released Office 2016, beginning March 1, 2017, the Office 2013 version of Office 365 ProPlus will no longer be available for installation from the Office 365 portal.

How does this affect me?

Beginning March 1, 2017, your users will no longer see Office 2013 as an option for download through the Office 365 portal, and admins will no longer have the option under Software download settings in the admin portal to choose to enable Office 2013. In addition, we will no longer provide feature updates for this version, nor provide support.

What do I need to do to prepare for this change?

We recommend you install Office 2016 as soon as possible to have the latest and greatest features and support. Please click Additional Information to learn more.

Additional information

Change the Oil – SharePoint Windows O/S

SharePoint runs best with regular health checks and preventative maintenance.   Often we overlook the Windows Server O/S as a key component.   Applications only run as fast as the host operating system.   A well tuned Windows Server O/S gives SharePoint the best opportunity to perform for end users.    Change the oil regularly and users will have the best experience possible.

Cheers!  shades_smile

imageImage result for oil change driveway

CLEANMGR.EXE

Native to Windows, this utility is part of the “Desktop Experience” category and can remove Windows Update, Recycle Bin, and temp files which may not be needed.  Convenient and good start point to release storage.

 Image result for cleanmgr

CCLEANER

Will do all of the above and more by removing temp files specific to certain applications.   Registry keys can also be scanned fro issues and auto repaired to improve lookups.   Windows Start Up, Browser plug-ins, Schedule Tasks, and many other settings give an overall O/S performance boost.   No other utility offers more benefit from one download.

 Image result for ccleaner

SPCACHECLEANER

The local XML file cache for SharePoint server can become out of sync with Config DB.   Purging this folder occasionally for a new re-population can help all servers in the farm stay in sync.    This procedure also confirms health of the SPTimerV4 service and database connectivity.

 Image result for spcachecleaner

DEFRAG

Local drive read/writes can slow over time as files become fragmented.   The modern usage with Virtual Machines (VM) and Solid State Drives (SSD) can vary but often a “Quick” defrag or SSD “Optimize” can yield disk I/O performance gains.

 Image result for defraggler

CHKDSK

When machines suddenly halt (power off, VM failure, etc.) drives and file sectors can become corrupted.  Occasionally running CHKDSK can help scan for any issues to provide assurance there are none and attempt to repair before future disk writes make repair less available.  Running “CHKDSK C: /F’ can help mitigate risk after and ensure a healthy drive.

 Image result for chkdsk

SYSTEM FILE CHECK

SFC allows admins to scan for and restore corrupt Windows system files.   Similar to the above, this ensure the O/S has current and working files for all needed features.   Recent forced power off or system power halts can corrupt drive data.   Running “SFC / SCANNOW’ can help mitigate risk after and ensure a healthy O/S.

 xscannow_2-650x329.png.pagespeed.gp jp jw pj ws js rj rp rw ri cp md.ic.M_WD0UF_RD

A/V UPDATE

Current definition and engine binary ensure your system is well protected against common attacks.   Secure systems experience less downtime, data loss, and performance reduced by malware and attacks.   Keep bad users out and provide more resources for good users.

A/V EXCLUSION

SharePoint Server has certain folders with frequent disk I/O (i.e.  search index) where excluding the AV checker can significantly improve performance.   Not scanning these temp files allows the product to quickly move through items, catalog, and index for users.    NOTE – There are subtle differences based on product version (SP 2010/2013/2016) which need to be adjusted to match your farm.

VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2)

Our next step in this series is cloud hosting.  Each of the local source components has a Microsoft cloud destination equivalent.   Here is the mapping:

  • SQL Express > SQL Azure
  • WebAPI > Azure Web App
  • Angular SPA > Office 365 SharePoint Content Editor

In the video below I walk through all of these steps to migrate the local “todo” CRUD application created earlier to be fully hosted in Microsoft’s cloud.    From there, we have a fully operational business application running on Office 365 with all custom code hosted in Azure.

Enjoy! shades_smile

 

 

Video

VIDEO – code JS todo CRUD on Breeze & SQL Express (part 2 of 2) from Jeff Jones on Vimeo.

Enable NPM behind corporate proxy

Running “npm install” on an enterprise workstation can often trigger an avalanche of errors.   Running the below commands helps point NPM at the corporate proxy server to resolve the issue. 

Cheers!    shades_smile

 

 

Commands

npm config set strict-ssl false
npm config set registry "http://registry.npmjs.org"
npm config set proxy=http://proxy.company.com:8080
npm config set https-proxy=http://proxy.company.com:8080

 

Screenshot

image

 

Reference

Return to Top ▲Return to Top ▲