Archive

Got trouble Connection PowerShell to SharePoint online? This could be the resolution to your troubles.
I had this myself, or we had it in our Company tenant. This is what the issue was and this is how I fixed it:

When trying to connect to PowerShell for SharePoint Online, using the Connect-SPOService command, we got a error that did not tell us anything.

The error is:Connect-SPOService : For security reasons DTD is prohibited in this document. To enable DTD processing set DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method.

Well, its almost a joke right…
When searching the web for information on this particular, I struck zero…all I could find related to the ISP and the default search provider something. I quickly dismissed them as unrelated.
Then after some time had passed, I found a similar issue, this seemed related and it was a connectivity issue same as mine (If I still had the link I would give credit to where credit is due). This fellow had resolved the issue by adding a missing DNS record.
This made me think, since our tenant has existed since way Before Office 365 existed (BPOS) perheps we were also missing some of the required DNS records?
I checked with my collegues, and apparently we were missing the record as well.

So, if you ever see or get the ‘DTD prohibited’ issue, remember to check the DNS for the following record:

Type: CNAMEAlias: MSOID
Target: clientconfig.microsoftonline-p.net
Info: Used by Office 365 to direct authentication to the correct identity platform More Information

After I added this to DNS, Connect-SPOService works just fine!

Microsoft’s official explaination on the DNS record:What’s the purpose of the additional Office 365 CNAME record?When you run a client application that works with Office 365 such as Lync, Outlook, Windows PowerShell or Microsoft Azure Active Directory Sync tool, your credentials must be authenticated. Office 365 uses a CNAME record to point to the correct authentication endpoint for your location, which ensures rapid authentication response times.If this CNAME record is missing for your domain, these applications will use a default authentication endpoint in the United States, which means authentication might be slower. If this CNAME record isn’t configured properly, for example, if you have a typo in the Points to address, these applications won’t be able to authenticate.

This time I will shed some light on what Microsoft have made available for the Iphone users out there. I’m usng different phones over time, but I have an Iphone and I discovered that there is actually quite a lot you can do from and on the Iphone that is SharePoint Online related (Only focusing on the supported Microsoft realesed here)
In this post I will try to list them all and write a bit about what you can do with them.

This is the list of SharePoint Online related apps available (2014-03-23)

Lets start to show what you can see in the App store where they are all available as free downloads, first one out is OneDrive for Business. This is not a Deep dive into technology or functionality or detailed feature sets, but rather a listing of what is available, see what can be done in the gui, the next step is your own, download the apps and try them out for yourselves.

Good luck!

–

–
1. OneDrive for Business (Formarly known as SkyDrive Pro)

This is as good as they get, you can easily access your personal and shared files at any time (Located in your MySite or other organizational sites within the Office 365 tenant). OneDrive for Business will keep your OneDrive files in synch at all times and available online or offline.
OneDrive for Business or SkyDrive Pro as it was originally called, is the shit, no doubt about it.

–

–
2. Office Mobile for Office 365 Subscribers

These are the classical Office application, do some final Changes or touch ups, create the files you need while on the road without any Computer. This is a complete ‘mini Office’ compatible with Office 365.

–

–
3. SharePoint Newsfeed

SharePoint Newsfeed, follow what is happening in your organizations social and Corporate newsfeeds. This app will make sure that you are up to date at all times.

–

–
4. Microsoft OneNote for Iphone

OneNote…if you don’t use it today, start using it! It is a really really good companion in your daily work, not sure if the App can replace the real application, but you can read and edit your OneNote files in your phone, how cool is that?

–

–
5. Office 365 Admin

For the Office 365 Administrator, or for the partners out there monitoring the Office 365 tenants for customers, this is the best app of them all(except for OneDrive for Business obviously). In the Admin ‘hub’ you can get the status of all the services in your Office 365 tenant. You see all the major services status on the start page, then you can drill down to what is failing, which Component has the issue, and you can read the log from the Microsoft maintenance staff, what they are doing to solve the issue. This is great. If onluy you could add users and reset their passwords as well…but you can’t get Everything. A good monitor/dashboard from Microsoft this anyway.

–

–
6. OWA for Iphone

Well, no need to explain, this is the OWA (Outlook Web App, not Office Web Apps) experience in your Iphone. You get email, calendar and Contacts in your hand. In a familiar format.

–

–
7. Microsoft Rights Management Sharing

Microsoft Rights Management Sharing. Well…this is what it says, use the App to set IRM protection on files and to open IRM protected files. IRM protected files, and you can access them on your Iphone, who would have thought…?

–

Ok, thats it. These are the Apps on the Iphone that are related in one or many ways to SharePoint Online, or at least to Office 365. They are all written by Microsoft Corporation and they are free to download from the App store.

References

See Appstore in your Iphone, search for Microsoft Corporation and you will find them all.

Use Office templates within your SharePoint Online document libraries. In every organisation, or at least the majority, you talk about templates and you know that you have them, somewhere, but in the end, you and everyone else end up using an existing document and make changes, like you take an agreement from one customer and make changes to the numbers and customer names…would it not be nice if you could get everyone to use the same template? And if a change to the template affected everyone? Wouldn’t that be just smashing eh?

Now I’ll show you the easy steps you have to follow to just get started, We’ll use a simple word template in this example, but you can use any template that you allready have.

Note: In this guide, I will show the quick and easy method, in a later post, I wil show how to use Content Types wich will also allow you to use custom templates, but in a much more controlled way. A link to that post will be added here when that guide has been posted.

Start by locating a word template, or create one, add some info to the header with logo and company name and address maybe, and add something to the footer for example and save the file as a dotx file. Save it locally so that you easily can access it when we want to upload it to our SharePoint online. – I have created a simple letter template for the company DonkeyMind, with their logo and some additional info in it. I’ll use this in my step by step guide below. I saved this as letter.dotx in my ..\documents\DonkeyMind templates\ folder.

In a SharePoint Online site, now do this:

1.0 Upload the template file. This is not the easies thing to do, unfortunately Microsoft has choosen to make it a lot harder in SPO and SharePoint 2013 than it really has to be (Browse button from 2010 has been removed), unknown to me why. But this is how you do it:

1.1 Browse to your document library in SharePoit online, where you want to use your own custom document template.

1.2 Click the tab, Library. This will present the ribbon for you with the settings available for a document library.

1.3 In the ribbon, click on Open withExplorer

Note: The site URL has to be added to the ‘Local intranet sites’ or ‘Trusted sites’ with added logon automatically, if it isn’t, you will get a popup telling you that it will not work otherwise.

1.4 Click ok on the Internet Explorer Security warning

1.5 The library will now open in a Explorer window, in this windows you will see a folder named forms which is a bit greyed out.

1.6 Double-click on the folder forms, now you will see the following list of files

2.11 You may also get prompted for your username/email address for the Office 365 account. Type it in and press Next

Note: This dialog only shows up if you are not logged into your office applications using your Office 365 account

2.12 And Password…Sign in

2.13 The new document opens, based on the template

2.14 When you have types your letter and are done, simply press Save, this will show you the save as dialog with the path to the SharePoint document library at the top

2.15 Select that and type in a filename and save the file

2.16 You are done, use the New Documents button to create your standard letters based on the custom template, again and again.

3.0 Done!

Note: All the same steps apply in SPO as well as SharePoint 2013 onpremise, exept for the ‘add site URL to trusted sites’ issue. In an onprem situation the URL is most of the time already considered Trusted or Local intranet.

This is not as complicated as it may seem, the difficult parts have been taken care of by Microsoft when setting up the ManagedMatadata Service Application for us.

Navigation is part of the Publishing Infrastructure features in SharePoint, so in order to manage Navigation, the Publishing features must be activated. So if you do not already have it activated, lets do so now.
In your SharePoint root site: https://orgname.sharepoint.com (in my case I’m using a separate Site Collection for this https://blksthl.sharepoint.com/sites/donkeymind) do this:
1. Go to Site settings.
2. In Site settings, locate the column Site Collection Administration, click on Site collection features

3. In the list of Site Collection features, scroll down to the one called SharePoint Server Publishing Infrastructure

4. On the far right, click on Activate

5. Wait for it, it will take a little while and then it will to show that it is Active. Scroll to the top while waiting, there you will see the ‘Working on it twirl’…

6. Next step is to go back to Site Settings, and locate the category Look and Feel and there you now have Navigation.

7. Click on Navigation.
8. The Navigation settings will by default be configured to use Structural Navigation

Note!
You have the same choice for both the Global Navigation (Top) and the Current Navigation (Left)
In this guide, we will focus on the global, but in order to manage the current navigation follow the same steps.

9. We want to change the Global Navigation setting to Managed Navigation as below.

10. Scroll down a bit past the Current Navigation setting to the area called Managed Navigation: Term set11. Here you will see your Term Store content

12. Expand the Taxonomy node, and you will see the shared terms and the site collection specific node, in my example: Site Collection – blksthl.sharepoint.com-sites-donkeymind

13. Click on the button Create Term Set and a termset for your navigation will be created.

14. In the Term Store tree you will also see a new node:

15. This is were your navigation entries will be stored. Next we will go to the Term Store Management Tool to start on our new navigation.
16. Before you do, notice the setting below the term windows, these settings will allow you to control what happens when new pages are created.
17. Make changes if you want to, I’ll just leave them as is, I will be creating subsites, not pages.

18. Now, click on the link to the Term Store Management Tool

19. or if you go via Site settings, find the Site Administration Category

20. Click on Term store management
21. In the Term Store Management Tool, you will same as before, see some shared metadata and a site collection node.
22. Expand the site collection node, now you will see the Navigation node we just created.

23. In this example, I will add an entry to the global navigation that is for a subsite I have created, named SubDonkey. It will only be one entry in the navigation and that will open my subsite SubDonkey.
24. Right-click on orgname Navigation

25. Click on Create Term26. Type in the name of the term, use the same name as you want to show up in the Navigation when done, in my case I named it SubDonkey, hit enter
27. A new empty termlabel will show up but simply click on the new term to make it go away.

28. When the new term is selected, you get a list of choices and configurations you can make.
29. You can here type in a description, add a second label, language and some more. Let this page be as it is.
30. Now click on the tab Navigation

31. This brings up a new page of navigation specific settings.

32. In here, I’m making a few modifications.
33. I add a Navigation Hoover Text: Take me to the SubDonkey.34. I set Visible In Menus to: Show in Global Navigation Only (deselect the show in current)

38. Verify your navigational settings for the new node. When done, hit the Save button.

39. Now you are done, go to your rootsite to verify the result.

40. Note the SubDonkey Navigational link with the Hoover Text showing (Mouse is over in image).
41. Repeat the steps 20 to 40 to add more terms and new nodes to your navigation.

Note!
Do not be afraid of trying new things, link to pages, to external sites, you can always delete the node if you don’t like the result.

42. Done!

‘

Note: All the same steps apply in SharePoint Online as well as SharePoint 2013 onpremise, you will need to first configure the Managed Metdata Sevice Application before any of these steps can be performed though.

This is the first in a series of Office 365 and SharePoint Online guides primarily aimed at users and power users, my aim with these guides is to show in an easy to grasp way, how you do a few relatively easy but important tasks in SharePoint Online/Office 365. Tasks that will give you a lot of functionality with relatively little effort. Since a lot have been covered already for SharePoint onprem in blogs and other online documentation like TechNet, but not specifically for Office 365 or SharePoint Onlne, I feel that there is a gap to fill here.

1. Office 365 guide series – Create a new list from an Excel spreadsheet

Create a new custom list from an existing excel spreadsheetThis task is simple if everything goes smoothly, but if you have never done it before, or if you have tried but got stuck on any of the little hickups you may encounter, then this may be the perfect guide for you.

– Start by creating your Excel spreadsheet. Make sure that it is a xlsx file. You may also use an existing spreadsheet with your listdata, copy from an old file, save another format as xlsx.

In the spreadsheet, follow the following rules to get a good result:
– Make sure that you do not have any empty column headers between columns. This will cause all headers to be imported as row 1 instead of beeing headers, new column headers will be created as 1, 2, 3 and so on.
– Keep the spreadsheet ‘clean’, remove empty rows, empty columns and any text above the header row and to the right or under of the table or cell range.
– The first column to the left will be the default edit field in the SharePoint list. Make sure that it has values on all rows.
– For best result, avoid formulas with calculated values.
– Use Excel 2013.

In a SharePoint Online site, do this:
1. Decide on a name for the list, it will be the URL and name of the list.
2. Go to the ‘cogs’/Settings and select Add an app

3. You will now see a list of all available apps (installed)
4. Search for Import or scroll down until you find the app called Import Spreadsheet
5. Click on Import Spreadsheet

6. Type in the Name of the new list
7. Type in a optional Description8. At the File location field, click Browse…
9. Browse to your xlsx file on your computer
10. Click on Import

11. The Import Wizard starts, by default, the Range type is set to Table Range12.Change this to Range of cells13. Click in the Select Range field
14. In the Spreadsheet, select the top left cell and then make sure that you select the entire table of data you want imported
15. It should now read something similar to: Sheet1!$A$1:$G$400 (top left : bottom right)

16. Now you click on Import
17. You may now get a logonprompt from Excel, enter the emailaddress for the SPO account and click next
18. Enter the account password and click on Sign in
19. Excel will now create the list and start importing the data, you will see a little progressbar at the bottom of the Excel application.
20. When the import is done, the new list will open and you will see the columns from the top

Note: You may note sometimes that a ‘mailto:’ has been added to the email column values.
This is added in excel but hidden when a cell is formatted as an email address. In the example above, note that the first row has the value of ‘Email’ which made the list field be formatted as single line of text instead of email.
The trick is most of the time to make sure that all fieldvalues in a column are consistent in format. One cell with a different format will cause the entire column to get a different formatting.

21. Done!

– You may now want to add a link in the left hand navigation to the list. Check the url in the addressbar of IE and copy it.
– Click on EDIT LINKS
– Click on +Link
– Type in the Text to display (will be seen in the navigation), for example ‘Contacts’ and paste the URL into Address
– Click OK
– Try the link out to make sure
– Done! (Again)

Error list

1
You get ‘The specified file is not a valid spreadsheet or contains no data to import’
When: When you browse to your Excel spreadsheet and click Import
Fix: Add site URL to trusted sites in Internet Explorer, it has to be in either trusted sites or Local Intranet sites.

2
A new header row is created instead of the headers I got (Column1, Column2, Column3…) and the headers becomes values if the first datarow
When: You have one or many empty headers in your cellrange
Fix: Remove all columns with blank headers, or add a value to them, this is only within your cell span.

3
If you get the error, ‘An unexpected error has occured. (-2147467259)’
When: Something is wrong with the SPO User session you have open
Fix: Sign out of your SPO session, close all IE windows, Close Excel – logon again to SPO, Add app…same procedure as last time.

4
Very large files, field data types get wrong, you expect Single line of text but get Multiple lines of text
When: The cellrange probably contain one or more ‘special’ values that is interpreted by excel/SPO as something else than it is.
Fix: With large files, create a new excelfile with only header and one row, make sure that the header row or the data row do not contain any value or characters out of the ordinary. Then, copy paste the rest of the rows in quick edit or datasheet view.

5
The wrong Column becomes the default edit column with the ‘…’ for the edit dropdown meny.
When: The column you want to use for default edit is not the first from the left.
Fix: First column will be the default edit field with the …make sute the Cell range starts with the top left cell.

‘

Note: All the same steps apply in SPO as well as SharePoint 2013 onpremise, exept for the Excel logon prompt and the ‘add site URL to trusted sites issue. In an onprem situation the URL is most of the time already considered Trusted or Local intranet.

Wow! Skydrive Pro, what a great invention! (I know, It has been out there for a while already…)
I assume that you all know what Skydrive Pro is all about, but to just real short sum it up, SkyDrive Pro is:
A client application that allows a user to keep files synchronized between his device and his online SharePoint document library.

Now, the thing is, that apparently, you are not really supposed to run Skydrive pro unless you with that mean to it against anything but Office365…seems like this was meant to be but is slowly turning toward not meant to be…
I do realize that Office 365 is the future for Microsoft, but when such a great feature is available, and it must be a rather easy task to get the functionality dynamic so that you can connect to any webfolder, it is a shame that the support for running Skydrive Pro as a SharePoint onprem has so little support.

* The App model with the possibility to connect to SharePoint 2013 Onprem
** A Desktop integrated application that connects to SharePoint 2013 Onprem
*** The App model with the possibility to connect to SharePoint Online/Office 365
**** A Desktop integrated application that connects to SharePoint Online/Office 365

So, if you want to make use of your internal onprem SharePoint 2013 farm for Skydrive Pro, you have to rely solely on Windows 8x or Windows Phone (Available in the Office hub)

The Skydrive pro desktop klient is available in Office 2013 versions as well, except for the Office 2013 for Windows RT

ASP.NET Ajax client-side framework (ScriptResource.axd) failed to load.The status code returned from the server was: 500
Status: 50 The request is not supportedAn unknown error occurred while processing the request on the server
asp.net ajax client-side framework failed to load
or

Greetings SharePoint geeks!

The problemThis post is purely created from a little peice of reality. I just experienced this issue myself in a SharePoint setup published externally thru TMG.

It is not entirely easy to troubleshoot, with quite a few components involved, however, I managed in the end and I will here also give you a few hints on how to go about t-shooting something like this.
Anyway, the circumstanses look like all or some of these:

– An internal SharePoint webserver (sp01)
– A TMG 2010 Server connected to the internal network and the internet, used for many more services than SharePoint
– A Web Application, CollabSite, published using a Firewall policy (from the SharePoint publishing wizard)
– A MySite Web Application also published using the same wizard but a separate policy.
– Both sites are configured to only use https/SSL with a certificate issues by an internal CA.
– An external DNS record pointing both URLs to the eexternal interface of the TMG server.
– Internal DNS records also Points to the external interface of the TMG

When connecting to the sites, mysite.domain.com or collabsite.domain.com from a client on the internet. The site prompts for authentication, the site loads…almost…a popup appears that states:

‘asp.net ajax client-side framework failed to load’

The dialogbox popup

Most of the site loads, you see the blue banner at the top but nothing more.
Reloading the site does not give you the popup again, but soads the site without any of the AJAX functionality, like the ribbon and buttons in the top right area. The ribbon will on some pages show up but it only shows the ‘working on it’ twirl instead of the tools/buttons you would expect.

I will here describe why this happens and how you fix it. But first, I will give you a short version…

Long version
First we look at what is requested and what is delivered. I use IEs built-in F12 Developer Toolbar, IE later than IE9 will have a Network tab and this allows you to trace the traffic. Same thing if you use Firebug/Fiddler or Wireshark, whatever is available. Browse to the failing site, press F12 and select the Network tab. Here you click on the ‘Start Capturing’ button

This causes IE to collect and show all traffic coming to and from the browser.

The two /ScriptResource GET statements are what fails. This is all that is needed to stop all AJAX functionality, now we know that it has to do with something we do not get down to the browser ok, but why is that, how do we fix it? We need more info to be able to answer those questions.
We can get a bit more info from IE still, select one of the GET lines and click on ‘Go to detailed view’ to see more about the issue.

We get some more info here but not really something that tells us what is going on.

I now tried the same thing from a client on the inside, I added an entry to the local hosts file and added the url and pointed it directly to the IP address of the SharePoint Web Server. With this setup the problem is gone. What this tells me is that the problem is most likely something to do with TMG and how that is configured. Lets take a look.
Logon to the TMG server, make sure that you have permissions to manage TMG.

Since the site at least loads, we have toi assume that https and the publishing in general works as expected. It can’t be all bad.
You will find the logs by clicking on ‘Logs and reports’ in the left pane on TMG.

First add a filter, it should include a filter for:
‘Log record type’ = Firewall or Web Rule
‘Log time’ = Live
‘Action’ != Connection status
‘URL’ contains collabsite (Something that will identify the traffic to your site)

Now, you need to start a Query.
Click on start Query, Then go to your browser with the failing site and refresh the site again.
This should give you something like this in the TMG log

You get a few more pieces of info, but still no real answer to what is wrong…now..it is time.
Now we give up and ask a friend like I did or Google/Bing up this blog post.
Apperantly, this is due to SharePoint ‘offering’ these scriptresource.axd files, which by the way are files that do not exist, they are virtual…anyway, the files are offered in a compressed form, and when TMG is not configured to use compression, it can’t handled files beeing offered in a compressed format, at least that is a more or less accurate explaination to the what happens.
To soolve the issue, yup, it is easy.

Note! DO not make any Changes to the TMG if it is used in production, most Changes made will or can affect the functionality of other applications than SharePoint. Do this when it fits.

In TMG, go to the system node in the leftpane

Locate the Filter named Compression Filter and right click, Enable. It has to be enabled in order for TMG to ‘undersdtand’ compressed files…

Now, make sure that the filer shows an enabled state

You might Think that the Compression filter is now enabled…but no. You have to apply the Changes to TMG first, do this by clicking on the Apply button

The Apply/Discard buttons show app after you have made any change to anything in TMG. Obviously, Discard does nothing and does a reset on all Changes you have made, Apply makes it real. The Changes are commited.

Now. You should be ok. Check again in the browser. To be 100% sure, Close the browser and start a new one, browse to the address and logon if you have to.
Click on F12, Networking, ‘StartCapturing’ and refresh the browser.

Now, as you can see, the ScriptResource.axd files load ok with a 200 back from IIS. Test functionality and you will see that you have full AJAX functionality restored!