SPSync 0.9.7 including CLI

SPSync is approaching version 1.0. Today I’m happy to announce that SPSync now works more stable and also includes a new command-line interface.

It should work now with all SharePoint 2013 on-prem and Office 365 sites without any issues during connecting or displaying the “select folder” dialog. As the “SharePoint Url” you can now use more formats and SPSync will try to figure out the site, the library and the authentication method automatically. For example, these formats are all fine:

  • https://YourOnPremisesSharePointOrYourOnlineTenant.com/sites/teamsite1/_layouts/15/start.aspx#/Documents/Forms/AllItems.aspx
  • https://YourOnPremisesSharePointOrYourOnlineTenant.com/sites/teamsite1/Documents/Forms/AllItems.aspx

The most requested new feature is the command-line interface. You can find SPSyncCli.exe in the install folder.
It accepts two parameters. The local folder and a “preview” mode parameter.

You have to configure a sync connection like before with the GUI. After that, you can sync a folder with the following command:

SPSyncCli.exe “C:\Your\Sync\Folder”

If you just want to see, which files will be modified (but don’t want to do it now) you can sync in a “what if” or “preview” mode:

SPSyncCli.exe “C:\Your\Sync\Folder” true

The result looks like this:

image

SPSync now uses a different location for the metadata. It is now directly within the local folder under “\.spsync”. Therefore you might get a conflict message the first time you sync with the new version.

Download the new version here: http://spsync.net

Selective folder sync for SPSync

I’m happy to announce that the top requested feature on UserVoice is now available for testing.

Now you can select which folders in your document library you want to sync. Just click “Edit” on your configuration and then “Save & Select Folders”:

image image

Download version 0.9.6 here: http://spsync.net

SPSync - The OneDrive for Business alternative

I know, the last update is almost a year old... But yes, I’m trying to work on it when I find some free time. So this update brings some important changes.

What's new?

First of all, to add a new sync configuration, the dialog has only a few fields left. SPSync will try to find every other setting automatically for you. Here is the new dialog:

image

As you can see, the advanced configuration dialog can be opened via the link. The automatic detection will only work if you are using NTLM/Basic (On-Premises) authentication or Office 365. For ADFS you need to enter some more info on the advanced dialog.

Another new feature is that you can now configure, whether you want to sync in both directions or only one of them (Local->Remote or Remote->Local) which was a suggestion on UserVoice with a high vote. Also deleted files (local or remote) are now always send to the recycle bin and never get automatically deleted for ever.

With this new version I’ve decided to drop the support for SharePoint 2010 (and before), because of some missing features for the upload/download handling. This is to make the development much easier and better to maintain. That’s also why SPSync requires now .NET 4.5.1.

Last but not least, a lot of bugs are now hopefully fixed. If you find something, please send me an error report and attach the DebugLog.txt from C:\Users\%username%\AppData\Local\SPSync

Download the new version 0.9.5 here: http://spsync.net and leave a comment or drop me a line at: support (at) spsync(dot) net

PS: The next new feature will be to be able to sync sub-folders within a document library as it has already 20 votes on UserVoice.

New Microsoft certifications

As I’ve mentioned here, Microsoft recently had a promotion to get up to 5 free vouchers for some specific exams for Prometric because after 31th of December, Pearson Vue will be the only exam provider.
I decided to try three of them:

I’ve passed all of them, which is especially great for the Azure exam, because that one was really hard.
With the two Office 365 exams I’m now a ”Microsoft Certified Solutions Associate for Office 365” (MCSA: Office 365).

You can find the details how to access my transcript here.

Simple SharePoint Forms Solution

You knew InfoPath? It's dead. So what is your current solution to just create a small/simple form in SharePoint to let users enter some information into a SharePoint list?

The default list forms are not a very good answer if it should be end user friendly or you want to style it.

So I've created a super simple solution and it is open source.

Just create an HTML form with your favorite editor and attach some special "data-" attributes, add a line of JavaScript and put everything into a Content Editor Web Part on your page.

You can find a complete guide at the GitHub project site.

Load Testing SharePoint with Visual Studio Online

I recently discovered that Visual Studio Online includes 15000 "Virtual User Minutes" for load testing each month for free. I've never used the load test feature of Visual Studio before, so I decided to try it to simulate high user loads on our SharePoint farm. Here is a step-by-step guide.

Requirements

  • A Visual Studio Online account
  • Visual Studio 2013 Ultimate (Performance and Load Testing is not included in any other edition)
  • SharePoint Site which is accessible via Internet

Setup

In Visual Studio 2013 go to File->New->Project and select "Web Performance and Load Test Project" in category "Test":

image

This will create an empty "Web Performance Test". To start recording what the test should do, click "Record" and an IE Browser window will open.

image image

Now open your SharePoint site and click around to simulate some browsing. After that click "Stop" to come back to Visual Studio where you will see all requests in your Web Performance Test.

You might not want to record some "SharePoint" noise, so there is a settings page to exclude some stuff. Go to Visual Studio Tools->Options->Web Performance Test Tools->SharePoint:

image

To execute this Web Performance Test as a load test with simulated users, you have to add a "Load Test" to your project:

image

The wizard will guide you through some configuration options. Set the load to 250 users as shown below for a test running one minute will cost you 2500 virtual user minutes. So keep in mind that the free plan of Visual Studio Online gives you 15000 virtual user minutes per month. Be careful with the constant loads settings, because all virtual users will submit the first request as fast as possible, so the result may not reflect real usage scenarios. For more users use the "Step" pattern to start with a few users. They will automatically increase over time.

image

I set the test mix model to "Based on sequential test order" because there is only one test in my project which every virtual user should run. In the next step add the existing test to the load test.

I leave Network Mix, Browser Mix and Counter Sets untouched. In Run Settings I set the "Load test duration" to 10 which means, every virtual user will execute the test in a loop for 10 minutes.

image

With these settings, your "Virtual User Minute" budget of 15000 in Visual Studio Online will decrease by 2500 (250 user * 10 minutes).

Run in the Cloud

Now add a .testsettings file (Local.testsettings already exists) via Add->New Item and search for test:

image

Give it a name like "CloudTestSettings". A wizard will open where you can select "Run tests using Visual Studio Team Foundation Service" (what is now "Visual Studio Online" as of November '13).

image

Make sure, your newly created .testsettings file is the active one by right click on it and select "Active Load and Web Test Settings":

image

Ok, that's basically all you have to do. If you already know some values and want to visualize threshold violations, you can open the load test and add threshold rules to one ore more counters. For example to the average page load time.

image

To run the load test, just click "Run Load Test":

image

After the test is completed the result panel show all the details about the test. You can add counters to graphs and see a summary and details. I'm interested in the page response times, so I switch to only one graph layout. Here you can see all the different pages and there response times.

image

You can download the report to Excel to analyze it even further.

Can't connect to SharePoint on Windows Phone 8

I have just installed a new SharePoint 2013 machine and restored an existing (2013) ContentDb to this machine. Everything works fine except: I cannot connect to it on my Windows Phone 8 anymore.

image

However, this worked perfectly well before the move. I tried a lot to figure out, what the problem was. Result: The Certificate Authority (or better the issued certificate) is the reason.

 

 

 

 

The new CA I've also created is on Windows Server 2012 R2. The old CA was on Windows Server 2012. And R2 adds automatically a "CRL Distribution Point" extension to all issued certificates. My CA is private so Windows Phone had no chance to connect to any URL specified within the extension.

Solution

Disabling the CRL Distribution Point extension for all issued certificates (or make the URLs available for your phone). Here are the steps:

Open your CA, edit the properties of the root node, go to the "Extensions" tab and uncheck "Include in the CDP extension of issued certificates:

image

How to fix scrolling (and other) issues in Chrome on SharePoint 2010

Today I looked deeper into the issues our users have with SharePoint 2010 in Chrome. It seems that Chrome does not always (strange…) executes "onload" within the body tag. However, SharePoint needs to execute one important javascript function there to enable scrolling, the ribbon and some other stuff (also the "ExecuteOrDelayUntilScriptLoaded" function)

Solution

We are already using jquery so this one is the best solution:

   1:  jQuery(document).ready(function () {
   2:      if (window.chrome) {
   3:      	jQuery("body").removeAttr("onload");
   4:      	if (typeof (_spBodyOnLoadWrapper) !== 'undefined') {
   5:  		        _spBodyOnLoadWrapper();
   6:      	}
   7:      }
   8:  });

 

Special hint: Do not use "$" in "global" javascript files for jQuery, but instead the explicit "jQuery" object, because in some library types (e.g. Picture Library) the $ has a different meaning in SharePoint.

UPDATE:
Added "if (window.chrome)" to check for Chrome, because InfoPath Workflow Init Forms are not working as expected if the _spBodyOnLoadWrapper is not executed within the real body onload. So they are not working in Chrome.

Delete project from tfs.visualstudio.com

Just a short reminder for me, how to delete a project from tfs.visualstudio.com, because there is no UI to do that:

Open a Developer Command Prompt and type:

tfsdeleteproject /force /collection:https://xxx.visualstudio.com/DefaultCollection "YourProjectName"

Access Services 2010: There was an error modifying list schemas

I have an Access 2010 database published to SharePoint 2010. It is a large database, but it is working fine... as far as Access can be fine. I made a lot of changes and added some more columns to one of the tables. I published the database again and everything worked ok.

To make a backup, I saved the database as a local database. Now if I try to publish the same local database to another site in SharePoint I get the following error message:

There was an error modifying list schemas. Failed to rename the field 'ID' on the SharePoint list 'xxx'

Even though the compatibility checker said everything is ok.

Bing doesn't seem to find a solution, so I tried Fiddler (by the way: great new website) to test what exactly is going on during the publishing process.
And here we have the detailed error message (click to enlarge):

AccessBlog

So what exactly is "_OldID2" and why is there a column I cannot see within the Access Client? And why are there too many columns of some type?

I tried to hide all columns, but modifying the view on the list does not seem to have something to do with it. Then I switched the columns back on and see one column which is not my column and I've never seen it before: "_OldID" Wow, why is Access/SharePoint complaining about _OldID2, but all I can see is "_OldID"?

The Solution


Well, it's really simple: Unhide and then delete the "_OldID" column. That fixed it and it can now be published again. Thank you Access for being such a great tool… not.