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.

Ok, the last version is almost 9 month old, but now I finally had some time to look through all comments on uservoice and now proudly present the new version.

What’s new?

The major change is: SPSync now supports Office 365 authentication which means, you can finally use SPSync with SharePoint Online and SkyDrive Pro. Just select "Office365" from the authentication list and enter your username (user@customdomain.com or user@customdomainpart.onmicrosoft.com) and your password. Domain is not required.

Also an issue with creating folders is now fixed and it doesn’t matter anymore whether the title of a document library is not the same as the URL of the document library.

A reminder: The "Conflict Handling" is a setting just for conflicts. If you select "Overwrite local changes" it does not mean that a full sync is done. A conflict is if a file is modified locally and remotely. All other files are sync’ing independently from this setting.

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

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”:

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.

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:

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

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.

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.

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:

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).

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

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.

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

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.

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

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.

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:

It was really frustrating. With Windows Phone 7.8 my OneNote synced perfectly fine with SharePoint 2013. Now I have a new Windows Phone 8, but OneNote synced only the sections and then gives an error (e4010647) and shows “Never synced”.

Solution

Ok, I couldn’t find any solution on the Internet, but after some testing with authentication settings I got it: My SharePoint WebApp has “Anonymous access” enabled. However the site collection itself does not allow anonymous access. After modifying the “Authentication Provider” and disabled “Anonymous access” everything is back to normal.

Why? I have no idea…