Category Archives: SharePoint

SharePoint 2013 Migrations, Are you having fun yet??

Wow what an incredible couple years SharePoint 2013 is still rockin on premise and online

Time Consuming Steps

However, there were two time consuming steps that didn’t have anything to do with the mechanics of the migration or the technology like moving WebParts, Pages, Items, Documents and creating Site Collections from Sites in Additional Content DBs.

  1. 1.The conversion of the Binary File Format documents to the OpenXML File Format.
  2. 2.Teaching folks why managed metadata is important and the creation of a Global Taxonomy, that includes Navigation

Luckily, there were two sources of information that made this easier but still not painless Waldeks Post – Building Global Navigation in SharePoint 2013 http://blog.mastykarz.nl/building-global-navigation-sharepoint-2013/ (it works) and the WAND Library. Unfortunately, though I have access to the Library the client did not choose to purchase the subscription so we didn’t get to take advantage of the huge library of terms.

WAND has started offering its entire catalog of taxonomies from the cloud, where you have the ability to subscribe monthly and download the parts that your Client needs to either start their taxonomy or fill out their taxonomy.  I have just been through a relatively easy migration 8 Content Dbs and a small 1TB of Content.

Missing Tools for In-Flight Conversion of Site Columns

The largest notable part missing, though metalogix will help you modify Multi-Choice Site Columns to Managed Metadata Site Columns In-Flight, there are NOT ANY migration products that will convert your binary File Format documents to the OpenXML File Format.

The Microsoft tools like Office Migration Planner will not work with a mapped drive using WebDav, but you can still use PowerShell though we found it was actually better to use a staging Farm, Convert all of your Documents using Word Automation Service. then perform a final migration where we modify the columns In-Flight to take advantage of the managed Metadata Site Columns.

This is important, if you want to take advantage of changing the Multi-Choice Site Columns to managed Metadata Site Columns In-Flight. Because if you have not converted all of your RTFs, HTMs, DOCs to DOCX then you will lose the metadata associated with these documents.

I’m not sure why metavis, sharegate, metalogix, tsunami or others do not build document conversion into their products since we need to be moving off the Binary format for many reasons and embracing the OpenXML Format

 

Cheers,

-Ivan

clip_image002 clip_image004 clip_image006 clip_image007 clip_image009 clip_image010


SharePoint 2013 NOTICE: Microsoft Deactivated SP1 Download

UPDATE: 04-22-2014 Reference: Stefan Goßner

The updated version of Service Pack 1 has been released today!

Refer to the information below to acquire the updated Service Pack for your product:

NOTE The KB articles for the re-released Service Pack is different from the recalled Service Pack.

  • KB 2880551 – SharePoint Foundation 2013 SP1
  • KB 2880552 – SharePoint Server 2013 SP1
  • KB 2880553 – Project Server 2013 SP1
  • KB 2880554 – SharePoint Server Language Pack
  • KB 2880555 – SharePoint Foundation Language Pack
  • KB 2880558 – Office Web Apps Server 2013 SP1

Download links for updated SP1:

Customers with Service Pack 1 Deployed

For customers who have previously deployed Service Pack 1, download the updated Service Pack 1 and install over the existing Service Pack 1 running PSConfig or PSConfigUI immediately following.


Customers without Service Pack 1

For customers without Service Pack 1 deployed, download the updated Service Pack 1 package and deploy as per the KB documentation.


MSDN/VLSC/MPN ISO

There is no update to the integrated ISO ("slipstream") from MSDN, VLSC and MPN as it was not affected by the issue.

Reference: see official announcement in Bill Baers blog post.

image

“Notice: We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.” http://support.microsoft.com/kb/2817429

image

“Notice:We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.

A known issue in SharePoint Foundation 2013 SP1 can affect the functionality of the Search WebPart. We encourage you to limit production installations of SharePoint Foundation 2013 SP1 until a fix is available. SharePoint Server 2013 is not affected by this issue.” http://support.microsoft.com/kb/2817439

I would like to thank Andy Williams the Nikon TAM (Microsoft Technical Account Manager), for bringing this to our attention Thursday. Unfortunately, we are affected since we have deployed SP1 to All DEV and PRD Servers. The only good news (I guess) is that our topology consists of Standalone farms for both WAC and WFM.

You may want to also check out Todd’s post http://bit.ly/OjfHAk as he states that Bill Baer has said that the ISO downloaded from MSDN does not have this issue.

 

Cheers,

-Ivan

Technorati Tags: ,

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008

Stay Competive with Business Intelligence in SharePoint 2013 & O’Reilly


book cover

Stay Competitive

O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Get the information you need from the experts you trust; visit oreilly.com to purchase this book.

Business Intelligence in Microsoft SharePoint 2013

Get 40% off of the print book and 50% off of the ebook version of this book by entering discount code AUTHD.

By Norman P. Warren, Mariano Teixeira Neto, Stacia Misner, Ivan Sanders, Scott A. Helmers

May 2013, ISBN 978-0-7356-7543-8

406 pages, $34.99

footer

© 2014 O’Reilly Media, Inc. O’Reilly logo is a registered trademark of O’Reilly Media

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008

-Ivan

metalogix content matrix resolves errors

I recently posted on my disappointment of metalogix due to the continual system crashes. The crashes have been resolved and occurred in version 6.2.0.1 There were numerous errors removing version 6.2.0.1.

However, all issues have been resolved in version 6.2.1.1 and greater.

metalogix version 6.2.1.1 ROCKS!! Thanks to the folks at metalogix for working with me to get the issues resolved

Creating Managed Metadata Fields in Flight

After resolving the issues I wanted to check out the inflight creation of Managed Metdata Field migrated from SP2007 MultiChoice Field in flight. The new Managed metadata Field was created along with the term set based on the old SP2007 MultiChoice Field.

Screenshot Metalogix Creating the Terms in flight

clip_image001

However, there is an issue that is not handled in Flight if you have any .DOC files (the old Binary format Office Documents) you will lose all of your, metadata.

The workaround for this issue is to first bring over the libraries as they are. Once they are in SharePoint 2013, you can run the following PowerShell Script if you have configured Word Automation Services to Convert the old binary format to the Open File Format DOCX ,

Then create the Managed metadata field and term set use content matrix

$wasp = Get-SPServiceApplicationProxy | where { $_.TypeName -eq "Word Automation Services Proxy" }
$job = New-Object Microsoft.Office.Word.Server.Conversions.ConversionJob($wasp)
 
 
 $web = Get-SPWeb http://intranet.contoso.com/
 $inputFolder = $web.GetFolder("Shared Documents")
 $outputFolder = $web.GetFolder("Shared Documents")
 
 $job.UserToken = $web.CurrentUser.UserToken
 $job.Name = "Convert Docs to Docxs"
 $job.Settings.OutputFormat = [Microsoft.Office.Word.Server.Conversions.SaveFormat]::Document
 $job.Settings.OutputSaveBehavior = [Microsoft.Office.Word.Server.Conversions.SaveBehavior]::AlwaysOverwrite
 
 $job.AddFolder($inputFolder, $outputFolder, $false)
 $job.Start()
 $status = New-Object Microsoft.Office.Word.Server.Conversions.ConversionJobStatus($serviceAppProxy.Id, $job.JobId, $null)
 $status
 $timerJob = Get-SPTimerJob "Word Automation Services"
 $timerJob.RunNow()
 Write-Host $timerJob


.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

ScreenShot of SharePoint 2013 Technical Library using Managed Metadata Columns



clip_image002



 



 



 



 



 



 



 



 



 



ScreenShot SharePoint 2007 Content Type using the Choice Column type



clip_image003





 



 



Cheers,



 



-Ivan



Using Yammer & SharePoint Intranets to Drive Employee Engagement

Using Yammer & SharePoint Intranets
to Drive Employee Engagement 

WEBINAR: Wednesday, December 4, 2013 – 1:00-2:00PM CT

Register Button


Microsoft has gone social in a big way with Yammer – but are yammer you ready for it? A successful social solution must give end users the foundational tools needed to effectively collaborate with coworkers, clients and partners while maintaining control of access, security and content. Each business has a different sweet spot when it comes to creating an engaging social environment that drives collaboration and meaningful dialogue. An enterprise social network’s success is dependent on unearthing your employees’ key motivational drivers, aligning the solution to your company’s culture, your vision for leveraging cloud-based solutions, and tailoring a strategy to fit.

In this session, we will be taking a look at what planning for Yammer success really entails, and the importance of a social maturity assessment, community use case planning and a communication plan. We’ll also discuss the value of a Yammer pilot, or SharePoint social on premises where appropriate.

Presenter Rich Wood is Director of Perficient’s national Microsoft Web & Social Collaboration practice and has been planning, designing and building enterprise solutions for intranets, extranets, and public internet sites since 1997. A veteran of both the SharePoint partner community and Microsoft itself, Rich has deep experience in information architecture, user experience, social collaboration, and enterprise architecture and technology strategy.

REGISTER TODAY!


View past Perficient webinar slide shows and replays

facebook twitter rss_feed

Perficient, Inc. is a leading information technology consulting firm providing business-driven technology solutions to Global 2000 and other large enterprise clients throughout North America. www.Perficient.com


Cheers,

-Ivan

Technorati Tags: ,,

October 2013 Internet Rollup: SharePoint & IIS

News – SharePoint Technologies

Event Receiver Doesn’t Work in Sandboxed Solution

SharePoint Conference 2012 sessions now available on Channel 9

SharePoint Conference registration is now open!

  • This is what you’ve been waiting for. Registration for SharePoint Conference 2014 is now open to the public through the Registration page of the SharePoint Conference website. Don’t miss out as the biggest SharePoint Conference on the planet takes over the Venetian Hotel and Resort in Las Vegas, Nevada from March 3-6th. This is your chance to get an all-access pass to everything that the conference has to offer, from the best sessions to the latest and greatest technology, to unbeatable access to Microsoft pros and industry experts, and much, much more. http://blogs.office.com/b/sharepoint/archive/2013/09/18/sharepoint-conference-registration-is-now-open.aspx

Start working social with Yammer

New languages, stores, and offerings for Office and SharePoint apps

Create SharePoint 2013 development environments quickly on Azure

NEWS – Microsoft Internet Information Server

New features in ARR (Application Request Routing) 3.0

Application Request Routing (ARR) is a proxy-based routing module that uses HTTP headers, server variables, and load balance algorithms to determine how to forward HTTP requests to content servers. The release of ARR 3.0 in July 2013 contains a few new features, as well as bug fixes. The following information describes the new features and how to use them, as well as general information about ARR 3.0 http://blogs.iis.net/erez/archive/2013/09/16/new-features-in-arr-application-request-routing-3-0.aspx

Microsoft Premier Support UK – Site Home – TechNet Blogs

Documents – SharePoint Technologies

eDiscovery Flow Across SharePoint, Exchange, Lync, and File Shares

Test Lab Guide: Configure an Integrated Exchange, Lync, and SharePoint Test Lab

Social feature support for SharePoint Server 2013

Discover SharePoint

Design Sample: Corporate Portal with Host-named Sites for SharePoint Server 2013

Enterprise search architectures for SharePoint Server 2013

NEWS – Microsoft Internet Information Server

Prepending www to 2nd level domain names

Updating my HTML Application for Configuring your WebDAV Redirector Settings

Let’s fix production troubleshooting

How to Create a Blind Drop WebDAV Share

Require Client Certificates in IIS 7.5

Certificates on the rebound

Downloads – SharePoint Technologies

Security Update for Microsoft SharePoint Enterprise Server 2013 (KB2817315)

Security Update for Microsoft SharePoint Foundation 2010 (KB2810067)

Security Update for Microsoft Office SharePoint Server 2007 (KB2760589) 64-Bit Edition

Security Update for Microsoft Office SharePoint Server 2007 (KB2760589) 32-Bit Edition

Downloads – Microsoft Internet Information Server

IIS DownloadCENTER

  • This is your single source for finding Microsoft Internet Information Services tools, samples, extensions, filters and modules created by Microsoft and the IIS community. http://www.iis.net/downloads

 

Cheers,

-Ivan

SharePoint 2013 Migrations with metalogix verse MetaVis

One of the larger disappointments I have had this summer is the number of crashes using the new Content matrix from metalogix seems to deliver when moving simple WebApps and Site Collections from SharePoint 2007 to SharePoint 2013. I mean simple like having a single Custom Site definition, a few Custom WebParts, with lots of ECM using Choice Site Columns and Custom Content types and all Branding is already deployed

Its almost embarrassing except that I designed and deployed all of the hardware from the SAN Configuration to the F5 Load Balancers and all hardware in between. In addition, I scripted the entire build for DEV, UAT, and PRD and luckily we rocked during the last two migrations one using of all tools Bulk List migrator from Bamboo Solutions and the last time using metelagix SSMM.

I guess my concern is: though metalogix is now one of the dominant players in SharePoint the quality of the migration tools from them seem diminished. I have multiple crashes per day, failure to move simple pieces of content like list items and documents, where it will now take three iterations per job in order to finally get it right.

As much as I dislike having to learn additional tools as there is never enough time I will begin testing MetaViz this weekend and I am greatly saddened that I would have to do so. But on with the show, I realize it makes sense to have a common interface for all of the metelogix products, I would only beg them to not do so at the cost of the value of the products in their own right.. I will let you know how this all works out in the next few weeks. As we have an end date of March 2013…

This project also includes building a One World taxonomy  and is takes getting a lot of people together to mostly agree on the majority of the terms your business will be using. We did a great Job in 2008 with the Global Communications Group in charge of technical Publications, Translation and more, now we just have to do the same for the rest of the company and support multiple languages with follow the sun data centers. So its all kinds of fun and march is not very far off.

I am sure I will be sending out another Blog or two this week but just in case you don’t have a chance to read those have a Very Happy Halloween

Cheers,

-Ivan

SharePoint 2007, 2010, 2013 Property Promotion and Demotion

Property Promotion and Demotion

Over the next couple of weeks I will be building a SharePoint 2007, SharePoint 2010, and SharePoint 2013 VMs.. Then using Office 2010 and Office 2013, moving documents between the three SharePoint Environments while using 2 separate content types with several site columns on all 3 environments. I will be making video logs and posting them on Youtube.

The only reason I am doing so is because I see so many people on the forums still have a very difficult time of getting there metadata to either promote top SharePoint or Demote into the documents correctly and I have not had an issue with this since SharePoint 2007 and Office 2003. The funny part is when I ask a forums guest if they have downloaded the 250 files he receives from his employees with the correct metadata embedded in the properties of the document the only reply I receive is it used to work in SharePoint 2007. the first video should be out no later than the end of the week with the second to quickly follow. At the end I am going to break property promotion and demotion on purpose, just for fun…

 

Cheers,

-Ivan

SharePoint Confernce 2014 March 3-6 Las Vegas NV #SPC14

Connect with us

 

SharePoint Conference 2014
Save the Date!

Mark your calendars for March 3-6 as SharePoint Conference 2014 heads to Las Vegas, Nevada. Check out the new website at www.sharepointconference.com to find out what awaits you at the world famous Venetian Hotel and Resort.

 

This year’s conference will be better than ever, with powerful content designed for Office & SharePoint IT Professionals, Developers, and Executives.

Immerse yourself in tracks covering topics from Deployment, Security, Architecture, Enterprise Social, Enterprise Content Management, Internet, Business Intelligence, Search, Office 365 and much more!

Registration for SharePoint Conference will open next month.

In the meantime, get a glimpse of what awaits you at www.sharepointconference.com.

 

Follow us on Twitter. Stay in the conversation with the official #SPC14 hashtag. Not on Twitter? Connect with us at facebook.com/wwspc.

Microsoft SharePoint Conference 2014 Team | spc@microsoft.com

You are receiving this message as a result of submitting your email at
www.sharepointconference.com. You can un-subscribe or update your profile at any time.

Just received this email and I thought you would like to know

-Ivan

SharePoint 2013 Power View Multidimensional Models SQL 2012 SP1 CU4

Hi All,

This is a post is a compilation of posts from Microsoft The reason I am created the compilation along with providing the link for everyone is the SQL Product Group has been doing an amazing job of pushing the envelope and providing us more & more features in the BI Space for use use with SharePoint 2013 Scorecards and Dashboards.

With this release, multidimensional models support analysis and visualization by using Power View in SharePoint mode. No special configuration of your multidimensional models is necessary. There are however some differences in how multidimensional model objects are displayed in Power View compared to other client tools such as Microsoft Excel and Microsoft Performance Point. This release does not support analysis and visualization of multidimensional models by using Power View in Excel 2013.

SQL Server 2012 Service Pack 1 Cumulative Update 4, released May 31st, provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update 4 contains a few additional enhancements to the “Power View for Multidimensional Models — Preview” that was previously released November 29 2012 and based on customer feedback.  This functionality helps customers maximize their existing BI investments by enabling their use with the latest BI end-user tools and adds greater modeling flexibility to the BI Semantic Model. Customers need to upgrade their Analysis Services instance and the Reporting Services add-in for Microsoft SharePoint Server (2010 or 2013) with this Cumulative Update to create Power View reports against their existing cubes.

As everyone knows Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View reports are presentation-ready at all times because they are always connected to your data. Users can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. Power View operates on a BI Semantic Model that resides in Analysis Services databases or PowerPivot workbooks.

With the SQL Server 2012 SP1 CU 4, Power View can consume data from multidimensional models. Now Power View users can connect to both the tabular and multidimensional formats of the BI Semantic Model. This is achieved through native support for Data Analysis Expressions (DAX) in Analysis Services multidimensional models, ensuring optimal performance and functionality.

Reference:

Understanding Power View for Multidimensional Models

-Ivan

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008


clip_image009