This MSDN article takes the prize!
http://msdn.microsoft.com/en-us/library/office/jj966282(v=office.15).aspx
http://msdn.microsoft.com/fr-fr/library/office/jj966282(v=office.15).aspx
http://msdn.microsoft.com/de-de/library/office/jj966282(v=office.15).aspx
and a whole bunch more! https://www.google.com/#filter=0&q=jj966282+site:microsoft.com
.
The Cincinnati SharePoint User Group will now be meeting on the 4th Thursday of each month. The next meeting is 3/27/14.
Please register if you will be attending: http://www.meetup.com/TechLife-Cincinnati/events/171195112/
Topic: OneShell | Managing SharePoint Anywhere with Windows PowerShellTopic: Using PowerShell, and a web service call or two, to Administer SharePoint Office 365
Description: With the growing adoption of Office 365 and SharePoint Online and the continued prevalence of SharePoint on-premises, it’s becoming more difficult to manage both environments Scriptamatically™. While SharePoint Online does have native support for Windows PowerShell, there are very few cmdlets to manage the sites and site contents. SharePoint on-premises gives us well over 700 cmdlets, but it still doesn’t answer every situational scenario – leaving gaps in functionality which can be filled by scripters.
In this demo-heavy session, focused on both the developer AND the administrator – you’ll see how you can use OneShell to manage both scenarios (on-premises and Office 365). Demonstrations will focus on building OneShell for both target environments, and by the end of the session you’ll be ready to start Managing SharePoint Anywhere with PowerShell.
Speaker:
Ryan Dennis is a SharePoint Subject Matter Expert with Blue Chip Consulting Group in Central Ohio. Ryan is a Microsoft Certified Solutions Expert with experience in all versions of SharePoint. An accomplished blogger and speaker, he has worked on large-scale SharePoint solutions in the public, non-profit, and private sectors. He focuses primarily on SharePoint architecture, automation, and middle-tier development leveraging out-of-the-box features.
Ryan has worked on projects ranging from large scale Intranet deployments to secure extranets as well as public-facing Internet site deployments. Ryan has a passion for automation, whether it is automating business processes through forms and workflow; or automating deployment, migration and configuration using Windows PowerShell.
And of course... there will be food, door prizes and networking!
We've got books, gadgets and toys!
You always find the most interesting things while looking for something else…
I just ran across an interesting white paper from Microsoft on Shredded Storage in SharePoint 2013. What made it really interesting is that is has a nice history of file storage in SharePoint, starting with the Web Storage System in SharePoint 2001 through Shredded Storage in 2013.
Overview of Shredded Storage in SharePoint 2013
Download it here: http://www.microsoft.com/en-us/download/details.aspx?id=39719
.
I just got the email below from Rob Dreyer of the Cincinnati PowerShell User Group. Cool stuff!
Mark your calendar! April 17th 2014 at MAX Technical Training in Mason, Ohio.
For more information and to register for the event (free!): http://www.meetup.com/TechLife-Cincinnati/events/154731982/
Hello Everyone,
I have some amazing news – our first meeting in 2014 will be extra special. Throughout 2014, Dr. Ferdinand Rios, the CEO of SAPIEN Technologies, Inc. is touring around the world. Last week, I received word that on Thursday April 17th he will be coming to MAX! I nearly fell out of my seat when I heard.
And, if you haven’t tried PrimalScript or PowerShell Studio, now is the time!
Check out the links below for more details. Thanks, Ferdinand!
Free Software Upgrades: http://www.sapien.com/blog/2014/02/13/2014-versions-out-march-15-buy-now-and-save/
Free PowerShell Training: http://www.sapien.com/blog/2013/12/23/sapiens-full-powershell-video-catalog-now-on-you-tube/
Let’s plan to give him a warm welcome. We’ll be hosting the event at MAX, but I will also provide remote access using GoToMeeting for those who cannot attend. I’ll send meeting information out as we get closer to the event. Hope to see you soon!
I recently had a request for a PowerShell script that could be run as a Windows scheduled task to download a file each night to a network share. As is typical, there's more than one way…
This is a ".Net approach" as it does not use any PowerShell cmdlets (beyond New-Object). The following will work from all versions of PowerShell and SharePoint 2007 – 2013, but not Office 365. It will work from any client PC as long as you have permissions to access the file. Why not Office 365? O365 requires an authentication cookie. (When I get some time I'll post an O365 version.)
$fromfile = "http://yourserver/sites/yoursite/shared%20documents/yourfile.xlsx" $tofile = "c:\somedirectory\yourfile.xlsx" $webclient = New-Object System.Net.WebClient $webclient.UseDefaultCredentials = $true # or # $webclient.Credentials = …
$webclient.DownloadFile($fromfile, $tofile)
This approach must be run from a SharePoint server and uses the Get-SPWeb cmdlet to access a site. As it is much more complicated, why would you ever use it? To do more complex things! Things like getting all of the files from a library and then downloading them (in a foreach loop), ZIPing the file(s) before download or otherwise manipulating the files before download.
The following will work from the SharePoint 2010 and 2013 Management Shells (but not for Office 365). Why not Office 365? The following needs to be run on the SharePoint server, and you are not allowed to do that with O365.
$fromsite = "http://yourserver/sites/yoursite" $fromfile = "yourlibrary/yourfile.xlsx" $tofile = "c:\test\yourfile.xlsx" $web = Get-SPWeb $fromsite $file = $web.GetFile($fromfile) $filebytes = $file.OpenBinary() $filestream = New-Object System.IO.FileStream($tofile, "Create") $binarywriter = New-Object System.IO.BinaryWriter($filestream) $binarywriter.write($filebytes) $binarywriter.Close()
.
Years ago I wrote a little article on how to find SharePoint GUIDs for SharePoint 2007. Later I wrote one on how to find the same GUIDs using PowerShell.
Now, here's how to find GUIDs for just about anything using SharePoint 2013's REST web services! The following will work for both on premises and SharePoint Online / Office 365.
---
SharePoint 2013 includes a REST service to access sites, lists and items. In the data that's returned is an ID that is the GUID for the item.
Accessing REST is quite easy as you only need to type it into the address bar of your browser! REST does not work around security, so you will still need to authenticate to your site.
In the examples below "yourdomain" will of course be replaced with your domain name. If using Office 365 it might look like "http://companyname.sharepoint.com.
If you get a result that looks like this…
… you can either use the View Source feature of the browser to see the XML or change the way the browser displays XML. For Internet Explorer: Tools, Internet Options, Content tab, Feeds and Web Slices Settings and then uncheckmark "Turn on feed reading view",
Visit your site, login and then edit your URL to look like this:
https://yourdomain.sharepoint.com/sites/yoursite/yoursubsite/_api/web
Scroll down to the content section and look for the ID element.
See the references at the end of this article for even more examples.
The current site collection:
/_api/Site
Web and Site Features and their GUIDs:
/_api/web/Features
/_api/site/Features
Lists:
/_api/web/Lists
A single list (by name):
/_api/web/Lists/getbytitle('tasks')
All list items:
/_api/web/Lists/getbytitle('tasks')/items
A single list item:
/_api/web/Lists/getbytitle('tasks')/items(12) (Item with the ID of 12)
List items by criteria:
/_api/web/Lists/getbytitle('tasks')/items?$filter=Status eq 'Not Started'
All list columns, including both display name and internal name!
/_api/web/Lists/getbytitle('tasks')/Fields
Especially note these two elements:
<d:InternalName>PercentComplete</d:InternalName>
<d:Title>% Complete</d:Title>
The current user:
/_api/web/CurrentUser (No GUID here, but there are other goodies!)
There's a lot more that you can do with SharePoint 2013's REST services!
.
InfoPath 2013 and InfoPath Forms Services in SharePoint 2013 are at the end of life…
See here: http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/
Supported until 2023, but no new versions.
So what will you use for forms?
.
Update 1/31/14: InfoPath 2013 is the last InfoPath!
I'm surprised how often people in my SharePoint end user and developer classes don't know what InfoPath is, or if they do, where it can be used in SharePoint. Any discussion of InfoPath leads to a discussion of the future of InfoPath and if it is going away, what the alternatives are. What follows are some of my class notes…
Andrew Connell says "I do not use InfoPath any more & I do not recommend people use InfoPath going forward." http://www.andrewconnell.com/blog/my-thoughts-infopath-2013-the-future-of-infopath Read all of the comments!
The Office SharePoint blog: "InfoPath is our integrated forms solution for the foreseeable future"
Options to Create Forms in SharePoint 2013 http://blogs.office.com/b/sharepoint/archive/2013/03/04/options-to-create-forms-in-sharepoint-2013.aspx
MSDN: "In this release, InfoPath 2013 has not introduced new functionality or scenarios."
http://msdn.microsoft.com/en-us/library/office/jj229830.aspx#odc_off15_ta_WhatsNewforO15Developers_InfoPath
Glen Furnas at sharepoint-community.net: "Simply put, InfoPath is a multi-purpose product that’s been put to use in a wide variety of ways, and no single alternative will ever replace it in all its roles."
http://sharepoint-community.net/profiles/blogs/alternatives-to-infopath-exploring-the-options
Owen Runnals: "In the end I feel custom ASPX pages are the safest bet since they've worked since SharePoint 2007."
http://owenrunnals.blogspot.com/2013/01/the-future-of-custom-forms-in.html
ASPX Forms
maybe Microsoft LightSwitch: http://msdn.microsoft.com/en-us/library/vstudio/jj969620.aspx
Microsoft Access 2013 / Access Apps (but no workflow support)
Nintex Forms: http://www.nintex.com/en-US/Products/Pages/NintexForms.aspx
K2 smartforms: http://www.k2.com/platform/forms, http://www.k2.com/blog/k2-smartforms-vs-microsoft-infopath
.
As you probably know, I'm a senior instructor at MAX Technical Training. As I'm starting my ninth year at MAX this week I thought I should plug a few of my upcoming classes!
You can attend these classes at our Cincinnati area training facility in Mason Ohio or attend remotely from anywhere in the world.
SharePoint 2010 Development
MS-10175 Developing and Customizing Applications for MS SharePoint 2010 (aligns with exam 70-573)
January 6-10
Do you have a governance plan? A real governance plan?
MA-1040 SharePoint Governance, Planning and Oversight (one of my favorite topics and one I often present on at SharePoint events.)
January 16-17
Are you ready for SharePoint 2013 development?
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions (aligns with exam 70-488)
February 10-14
MS-20489 Developing Microsoft SharePoint Server 2013 Advanced Solutions (aligns with exam 70-489)
January 27-31
If you are interested in SharePoint 2013 Developer Certification then you will also need exams 70-480 and 70-486…
MS-20480 Programming in HTML5 with JavaScript and CSS3 (aligns with exam 70-480)
January 20-24
MS-20486 Developing ASP.NET MVC 4 Web Applications (aligns with exam 70-486)
February 17-21
When you register… tell'm that Mike sent you and you might get an extra donut or something
Just a random thought at the start of a new year… Is VB.Net dead? Deprecated? Just not interesting to Microsoft Learning?
It seems the newer 204** series Microsoft MOC classes only cover C# (and JS / HTML5). I've also been reading that C# is the only language option in most of the newer certification exams.
On the other hand, it looks like Visual Studio is still treating VB as an equal to C#. There are no new VB and C# language features in VS 2013, but VB is still there. The VB team blog says "We are actively working on the next versions of Visual Basic and C#" (*).
What about VBScript? As of Internet Explorer 11, VBScript is considered deprecated. (MSDN article)
This will be entertaining to watch as many of my web and SharePoint class attendees are still working in VB shops!
Mike
