.NET

Custom code with SharePoint Online and Windows Azure

When I first heard about SharePoint Online at the PDC 2008 I was a bit disappointed that you could not use custom code but had to rely on the built-in functionality and the things you could do with SharePoint Designer (which is quite powerful anyway, especially with jQuery). To read more about SharePoint online, head over to Tobias Zimmergrens blog. But with some clever techniques you can take advantage of the Windows Azure Hosted Services and create your custom code.

Microsoft Office

Create SharePoint 2010 Managed Metadata with Excel 2010

Building the metadata structure in the Term Store Manager in SharePoint 2010 is not the most convenient way. I prefer working with the metadata structure and terms in an Excel document so that I can discuss the structure with colleagues and clients before implementing it. The Term Store Manager allows you to import a comma separated text file containing a Term Set. By default the Excel 2010 Save as CSV does not save in the correct format and for that I have made a Excel 2010 macro enabled template which produces the correct format.

Microsoft Office

NullReferenceException when uploading multiple files in SharePoint 2010

Recently came across a really interesting bug in SharePoint 2010. It’s when you are trying to upload multiple files using the ActiveX control, where you can drag and drop files or select multiple files. I started receiving “Object reference not set to an instance of an object” exceptions from the STSUpld control. The usual Google, ahem, Bing check revealed nothing. Just that I was not alone having this problem (hence this post).

Microsoft Office

Dissecting the Office Web Apps cache in SharePoint 2010

The Office Web Apps, OWA, in SharePoint 2010 is a great way to enhance the SharePoint experience. It allows users without a decent OS or a locally installed Office client to view and edit Word, Excel, PowerPoint and OneNote documents. When you install and correctly configures Office Web Apps (yea, can be a bit of a hazzle if you like me avoid the Farm Configuration wizard) and then enable the required Site Collections feature a cache will be created.

Microsoft

How to make Live Mesh conquer the world...

Today almost everyone have more than one computer; one at work, a few at home, a media center, a PC, a Mac etc, your family members, friends and colleagues have the same. One problem is that a lot of us need access to files on one machine when we are using one of the others. For example I want to access my images when I’m at work sometimes and I do not want to copy all of these images onto my work laptop, when I’m at home I want to have the same favorites and documents that I use at work and so on.

Microsoft Office

Office Labs - Canvas for OneNote

Canvas for OneNote is another new and interesting innovation from the Office Labs team. Canvas for OneNote creates a new way for you to manage your OneNote section and pages in a more “inspirational” and “irregular” way. OneNote is traditionally organized into Note books, sections, groups, pages and subpages - just like a classical book shelf filled with note books. It works really nice if you know in which note book you placed your notes (of course you can search to find it…faster than you search your shelf).

SharePoint

SharePoint 14 delayed until 2010

Not that unexpected, but Microsoft chief executive office Steve Ballmer has confirmed that the new Office 14 clients and servers (read SharePoint) will not be released during 2009. The products will be “generally available” during 2010. Generally available may indicate (I’m always positive) that we have a release for volume licensees and partners in late 2009 and in the shelves during 2010 (just like the previous version). Read SharePoint Daily Special Edition for more information.

SharePoint

How to make SharePoint index Office 2007 files

If you install Windows SharePoint Services 3.0 on a new server you will find that your Office 2007 (.docx, .xlsx etc) files is not indexed as they should but the old binary document (.doc, .xls etc) format is indexed. This is due to the fact that the Office 2007 IFilters is not installed by your WSS installation. To resolve this issue you have to download the Microsoft Filter Pack and install it on your server.

Microsoft Office

Live Mesh, Skydrive and Office Live

Microsoft is currently extremely offensive on their new cloud services targeted to consumers and business users with their Live services. I use a number of them daily with the Live Mesh as the newest addition. A couple of months back I started to move my and my family’s documents to Skydrive, 5Gb free online storage, and I’ve made some efforts to get started with the Office Live Workspace, to have a better place work working with the documents.

Microsoft Office

PDC 2008: Day 2 with Windows 7 and Office Live

Day two is official over. I’m just back from the attendee party at Universal Studios. Keynotes This Tuesday started with a couple of keynotes. I was fortunate and arrived just as they opened the keynote hall and got myself a seat in the front row. After Ray Ozzies intro Steven Sinofsky took over and showed Windows 7 for the first time in public. You can read about the demos on almost every blog, but here are the stuff that caught my attention:

SharePoint

Office System 2007 Service Pack 2 announced

I gladly received the news that the Office team announced Service Pack 2 for Microsoft Office 2007. Not only for the clients but also for the server products (read SharePoint). First of all it’s the support for the different file formats that I long for (ODF for example) and then there is the Outlook performance – both of these are addressed! XPS and PDF will be supported from scratch – no need to install a free plugin (just as it was in the Office 2007 betas).

Microsoft Office

Microsoft Office Labs launched

The Microsoft Office Labs team have now launched their own web site/community at www.officelabs.com. This is a site dedicated to “Concept testing”. This means that we can expect to see some nice productivity enhancements to the Office family and get a chance to take them for a test-drive. The aim of the site is for the Office Labs team to gather information from their “tools” and evaluate the usage of them and get a discussion started.

Microsoft Office

Office Open XML now approved as ISO/IEC standard IS29500

After a lot of turmoil the ECMA Office Open XML document format has been approved as an ISO/IEC standard - IS 29500. The news came out a day earlier than stated, due to a leak which made ISO to go public with the news. The process has not been easy for any part in the process and it has for sure made footprints in the standardization history. A lot of lobbying money as been spent (Politics matter) and a lot of committed people has engaged in verbal and written battles.

Microsoft Office

Microsoft Office binary formats available under OSP

The Microsoft Office Binary File Formats (.doc, .xls, .ppt…) are now available for everyone under the Open Specification Promise, OSP. This is good news for all of you working with the traditional binary format, when for example moving them to the new Office Open Xml, OOXML, file format. The binary file formats have previously been available for download for a long time (under RAND-Z), but now you download them here.

SharePoint

Open linked Office documents in the application instead of in Internet Explorer

I have several time stumbled upon clients who complain that their hyper linked Office documents (Word, Excel, PowerPoint) opens up in the web browser, Internet Explorer, instead of in their respectively Office application. In SharePoint document libraries these problems are solved using a special JavaScript that fires up the correct application, but today I had a client complaining about this problem when having Office documents linked in a Wiki. So I dug up some information from the Microsoft Knowledge Base on this matter and though I should share it (or at least have it written down for future reference).

SharePoint

MOSS 2007 and WSS 3.0 Service Pack 1 is out

Not only the Office 2007 clients got updated to Service Pack 1 today, Service Pack 1 is also out for the Office Server family and Windows SharePoint Services 3.0. Here are some of the downloads… Windows SharePoint Services 3.0 with Service Pack 1 - for new installs Windows SharePoint Services 3.0 Service Pack 1 - for upgrades Windows SharePoint Services 3.0 Language Packs Microsoft Office Servers Service Pack 1 - SharePoint Server, Project Server, Forms Server and Groove Server Microsoft Office Server Language Pack 2007 Service Pack 1 Microsoft SharePoint Designer 2007 Service Pack 1 All are 32-Bit Editions, you can find links to the 64-bits in the instructions.

Microsoft Office

Microsoft Office 2007 Service Pack 1 is here

The Microsoft Office Online now contains links to the Microsoft Office 2007 Service Pack 1. The links are not currently working, but I will keep you updated. Here are the links: Office 2007 Service Pack 1 Visio 2007 Service Pack 1 Project 2007 Service Pack 1 Update: You can find all the updates and changes in this Excel. Let’s hope for a faster Outlook 2007 experience…Update: It feels faster at first glance…

SharePoint

SharePoint, Vista and Office 2007 security problems solved

For the last year I have had really annoying security troubles when working with documents in SharePoint (2003 or 2007, WSS or MOSS) on my Windows Vista machine with Office 2007. Every time I have opened up a document for editing the Office applications have asked me to log in to access the document. I have been able to press Cancel three times, but then the document is opened up in read-only mode.

Microsoft

Microsoft Search Server 2008

Microsoft has announced their new enterprise search setup of server products, which include the Microsoft Search Server 2008 together with an Express version, that are free (currently a release candidate). This new server product is an evolution of the Microsoft Office SharePoint Server 2007 for Search. This is great news since the Search Server (MSS) has great possibilities to integrate to other search engines or data sources (something that you only could do with some heavy BDC programming using MOSS 2007 Enterprise Edition).

SharePoint

Microsoft confirms Office 2007, Vista and SharePoint security problems

The Microsoft SharePoint blog has a new post called “Known issue: Office 2007 on Windows Vista prompts for user credentials when opening documents in a SharePoint 2007 site". The article is a result of many reported support cases on this issue and contains a few possible (I repeat possible) workarounds. We have had this problem ourselves and on several customers. In some cases these workarounds really work, but most of the times not.

SharePoint

Great blog for SharePoint end-users

The net is crowded with SharePoint blogs, including this one, and I have missed one thing - information for the end-users. I think that there is a great void in knowledge for SharePoint users out there,for example how to use SharePoint as an end-user in the most efficient way, how to do the simple stuff such as creating sites or lists etc. Today I stumbled upon “Get the ‘Point” by Suzanne Ross, which has a focus on the SharePoint end-users.

Microsoft Office

Royalty-free specifications for Microsoft Office binary file formats

Yes, you read it right! Microsoft now offers a royalty-free file format program for the Microsoft Office Binary File Format (the old .doc, .xls and .ppt used in previous versions of Microsoft Office). Microsoft Office 2007 is built-upon the Office Open XML file format which is an ECMA International standard, and an ISO proposal (you have all read about it). But some of us still have application and/or customers that heavily rely on the old binary format.

Microsoft Expression

Roadmap for Microsoft products for FY08 and beyond

istartedsomething dug up something interesting from the Steve Ballmer presentation at the Microsoft Show and Tell 2007. It’s a roadmap for Microsoft products for the fiscal year of 08 and beyond! Some things caught my attention: Expression Studio V2 - there will be a new version of the Expression series pretty soon Microsoft Tellme - this can be really cool. Windows Server 2008 Update Release and Service Pack 1 - wonder what nice stuff they have in the pipeline for these releases… Microsoft Surface - it will be a real product and is not just a showcase!

Microsoft Office

XPS soon as a formal ECMA standard

ECMA International has started a technical committee, TC46 - XML Paper Specification (XPS), to “produce a formal standard for an XML-based electronic paper format”. One of the points in the TC46 programme is to consider a submission of the XPS format as an ISO standard. This is really good news to all users of the XPS format and is really vital if XPS is going to be able to compete with the PDF format (which already is an ISO standard, ISO 19005-1:2005/ISO/DIS 32000).

Microsoft Office

Office 2007 file format support for Windows Mobile Office 2007

I previously blogged about the lack of Office 2007 file format support in Windows Mobile 6. Today Jason Langridge revealed that you will not longer need any third party application for this - but instead Microsoft will provide an update to Microsoft Office Mobile 2007 with support for the new Office 2007 file formats (.docx, .xlsx, .pptx). A free update will be available for Windows Mobile 6 and 5 devices and all new shipped devices will have it in the ROM, all starting in Q3 of 2007.

Microsoft Office

Dissecting XPS, part 8 - XPS Tools

This part of the Dissecting XPS series will focus on some XML Paper Specification tools that are available as of today. The success of XPS, vs PDF and others, are really depending on the number of supported devices, operating systems and tools. Right now the XPS support is limitied in applications outside the Microsoft Windows sphere, but there are plans for other operating systems. (Maybe Silverlight will boost this with the CoreCLR).

Microsoft Office

Office 2007 file support on Windows Mobile

DataViz have released a new version of DocumentsToGo for Windows Mobile with support for viewing Office 2007 files (.docx, .xlsx, .pptx etc). This is great, I have not used DocumentsToGo since my Sony-Ericsson p910i days but instead relied on the Office Mobile suite embedded in Windows Moblie 5. The current version only supports viewing of Office 2007 documents as of today, but if you purchase the application you will get free upgrades and the coming versions will support creation and editing of Office 2007 documents.

Microsoft Office

Standardization of Office Open XML

Today I recieved an e-mail from the Swedish Standards Institute, SIS, containing the proposal for the Office Open XML as an ISO standard (ISO/IEC DIS 29500). Office Open XML is today an ECMA standard, TC-45, and ECMA has submitted the standard to the ISO fast-track process Office Open XML. The fast-track means that it can be an international standard by this August, read more on the fast-track process in this post by Brian Jones.

Microsoft

Dissecting XPS, part 1 - The basics

I will in a number of posts try to explain the XML Paper Specification document format, XPS format, that has been developed by Microsoft. I think the XPS initiative is nice from a developer and ISV perspective, since creating and reading XPS documents is easy and supported from various environments. This series of XPS articles will start off with an introduction to the XML Paper Specification and then continue with general support and competitors and then of course some nice introduction on how to use XPS in applications.

Microsoft Office

Preview PDF files in Microsoft Outlook 2007

Previewing files and attachments in Microsoft Outlook 2007 is one of the new killer features that makes my, and hopefully yours, life easier. When installing Outlook 2007 you will get preview functionality for the standard Microsoft applications and images. Previewing files is also integrated into the Windows Vista Explorer. Tim Heuer (mr double-snake error) has together with Foxit software created a PDF previewer. The PDF Preview Handler is easy to set up and is incredible fast in rendering PDF documents for preview.

.NET

A Cheat sheet of Cheat sheets

Here is a list of cheat sheets for the Windows and .NET platform that I frequently use and I think are of great interest. Visual Studio 2005 Keyboard Shortcut References Visual C# 2005 - PDF grayscale | PDF color Visual C++ 2005 - PDF grayscale | PDF color Visual Basic 2005 - PDF grayscale | PDF color SharePoint and Office stuff CSS Reference Chart for SharePoint 2007 (Microsoft Office SharePoint Server 2007 and Windows SharePoint Services v3) CSS Reference Chart for SharePoint 2003 New Office 2007 User Interface - Word | PDF Web and ASP.

SharePoint

Customize the Favorite Links in Windows Vista common dialogs

Microsoft Windows Vista contains new common dialogs, such as the Save As and Open dialogs, which have a new sidebar navigation to the left. The navigation can show the folder tree or your Favorite Links. Windows XP had a similar concept, but not as customizable as in Windows Vista. If you are like me and like to have your files organized and have easy access to them you can customize the Favorite Links really easy.

Microsoft Expression

The year of constant betas

Today I start my two weeks vacation and I thought I should summarize this year. The year of 2006 has been characterized, for me, as the year of Betas and Technology Previews. I have been trying to involve myself as much as possible in the all the goodies flowing out of Redmond. Microsoft has released numerous amount of new applications and upgrades. Internet Explorer 7 The new version of Internet Explorer is the application this year that will have most impact in the short run on users.

Microsoft Office

Installing Office 2007 RTM

After downloading the latest bits of the Office 2007 RTM ISO’s it was time to install it. There are no changes in the installation as I can see at first sight from the latest beta, everything worked fine and smooth and was without much interaction, just the serial key and some optional customization and then about 10 minutes of waiting and I was up and running. Before installing make sure that you remove all betas and updates to them including any add-ins such as the Save as PDF or XPS , otherwise the setup will exit.

Microsoft

About Microsoft Open Office Xml document format

The new Office document format present in the new Microsoft Office 2007 suite is completely new and open and based on XML. This opens up a lot of possibilites for us developers; there is now an easy way to create your own Word or Excel documents from an application. The file format used is called Ecma Office Open Xml format. Previously it has been very difficult or expensive to provide the customers with nice Word or Excel output from an application.

Microsoft

Windows Desktop Search 3.0 RTW

Microsoft has released Windows Desktop Search 3.0 RTW and it’s available for download here (XP x86, other versions are available at Microsoft Download Center). I have been using the beta 2 extensively since the release, and the betas before that. It’s a great desktop search application and integrates incredibly nice with the upcoming Office 2007. Finding e-mails in Outlook 2007, documents on your harddrive or captured images in OneNote 2007 is really easy and fast.

SharePoint

Add Office 2007 icons to SharePoint 2003

Here is a quick instruction on how to install the Microsoft Excel 2007 and Microsoft Word 2007 default icons to your SharePoint 2003 site. First of all you need these two icons, right-click them and choose Save Picture As. Copy the two .gif files into the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES\ folder. Then open the file C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\XML\docicon.xml with your favorite XML editor and add these two lines under the ByExtension element:

Microsoft Office

Open Microsoft Office 2007 documents in Office 2000, XP or 2003

Microsoft just released the Microsoft Office 2007 Beta 2 Technical Refresh (download here) to the masses. One of the interesting parts Microsoft Office Compatibility Pack for Word, Excel and PowerPoint 2007 File Formats, are also updated as B2TR With this download (available in English, Japanese, French, German and Spanish) you can open, edit, save and create Microsoft Office 2007 files using Microsoft Office 200, Microsoft Office XP or Microsoft Office 2003.

SharePoint

Microsoft Office Server System 2007 demo virtual machine

According to Lawrence Liu Microsoft will release a a demo with Microsoft Office Server System 2007 for Virtual Server as a .VMC and a virtual harddisk for Microsoft Certified Partners as a part of the Techinical demonstration toolkit during the next 4-6 weeks. This is great, I guess that it will contain the latest build, and gives us a good opportunity to test and show the new functionlity of MOSS without having to set up new servers or VM’s.

Windows XP

Jensen Harris on Office 2007 Fitt's Law

The incredible Jensen Harris gives you all the details on how to use Fitt’s Law to improve the user interface of your application in the post Giving You Fitts. The article gives you a good insight on how to create a great interface using a mathematical approach instead of just lettting a art/creative director making the job. It explains why the northwest corner (as Jensen told us it should be named) has changed so dramatically.

Microsoft Office

Outlook 2007 feature: Quick Click

The Outlook 2007 feature Quick Click is a really nice feature; a Quick Click is a defined action to be done when you are single clicking a column on a mail item. You can define Quick Clicks in the mail item views for the columns Categories and Flag Status. Right click the column and select Set Quick Click… to change the action. For example; you can define the Quick Click in the Flag column to add a flag with a Tomorrow reminder (default is today).

Microsoft Expression

Summary of Q2 2006 Microsoft betas

For me this second quarter of 2006 has been so interesting with all these beta and CTP products from Microsoft. The summer will be a long wait for the Release Candidates and the autumn a huge and shaky wait for the gold products. Here is a short summary of what i think so far; **Microsoft Expression Graphics Designer**An interesting product which I have big hopes for, I really like, and have just adjusted, to the vector way of doing my graphics.

Windows XP

Do not install Outlook 2003 updates if you have Outlook 2007 beta

Just a friendly reminder to all of you that have the Office 2007 beta installed and still have Office 2003 installed: do not install the Office 2003 updates available through Windows Update. I did - stupid me I had the update service on automatic and when turning off the computer I said ok let’s install the patches. After installing the latest patches, Update for Outlook 2003 Junk Email Filter (KB917149) and a few others, I started to receive the following errors in Outlook:

Microsoft Office

Sending mail with Ctrl+Enter in Outlook 2007

Microsoft Outlook 2007 is great and it has really improved on a lot of things for this version. One of the things that have been messing with me is the possibility to send e-mails using Ctrl+Enter. I have accidentaly sent away a number of emails, maybe due to my thick fingers :-) when pressing Ctrl+Enter. Outlook 2007 issues a warning when you press Ctrl+Enter and allows you to enable or disable this function.

Microsoft

How to read .xps documents

XPS (XML Paper Specification) is an electronic paper format and is competing with Adobes PDF. Since Microsoft is forced to withdraw the function of publishing to PDF from Office 2007 the XPS will be more widely adopted. Read more about it here; Adobe PDF vs Microsoft XPS. Windows Vista will include a XPS reader, but if you already now get XPS files you can download either the WinFX runtime components or the XPS Essentials Pack (beta).

Microsoft Office

I am a 'Windows 3.1 lover' and I use Office 2007!

Jensen Harris, the Office 2007 User Interface guru, writes about what will happen to Office 2007 beta until the final release which contains a number of interesting gems. One of the first stuff I found out when using Office 2007 (Word, Excel and PowerPoint) was that the system menu was gone from the upper-left corner, sorry Jensen I mean Northwest corner, so I could not double-click to shut the application down, and that I had to use the cross in the Northeast (upper-right) corner, introduced in Windows 95.

Microsoft Office

Outlook 2007 Business Cards

Microsoft Outlook 2007 introduces a new view for the contacts called Business Cards. It’s a view, much like the old Adress Cards view, but the business cards view lets you customize how the different contacts look - just like a business card. You can customize the business cards and give each one a unique look. This can make finding contacts easier, if the business cards resembles the real ones. Nice looking e-mail signaturesWhen sending messages you can attach your business card to the message, as a signature, which attaches a .

Microsoft Office

Ed Bott: What do you think of Office 2007.

Ed Bott’s Microsoft Report blogs about What do you think of Office 2007 so far? I’ve been using it, mostly OneNote, Outlook and Word, since the release of the latest beta, and I like the most of it. The Ribbon bar and the User InterfaceThe most significant change is the user interface and I like what I see. I took a while for me to be aquainted with the new shortcuts and the Ribbon bar, I am a keyboard user.

Personal

I wish I had OneNote 2007 when I was a student!

As Microsoft OneNote 2007 will be a part of the Office Home and Student 2007 suite OneNote will and can be used by students. And it’s a great tool for that! I remember when I studied for my M.Sc. and all the notebooks and pens I used, making notes was very important for me and helped me remember things better. And it still is, I have used OneNote for a few years and been satisified with that, but the new OneNote is so great.

Windows XP

Outlook 2007 Instant Search and Windows Desktop Search

I have installed the Office 2007 beta, including Outlook 2007, and I wanted to enable the Instant Search functionality and followed the instructions in the dialog that popped up in Outlook. It said that I had to go and download the Windows Desktop Search Beta 3.0 Engine Preview, read about it in Microsoft Help and Support. I did, but I had a previous version of Windows Desktop Search installed. There was no warning and when I tried to search in Outlook I recieved a message saying that Outlook cannot perform your search.

Microsoft Office

OneNote 2007 beta and Windows Desktop Search

When starting OneNote 2007 beta you will get a warning that informs you that OneNote 2007 requires Windows Desktop Search to fully support Instant Search and Searchable images and audio. This warning will pop up until you install the Windows Desktop Search 3.0 or until you edit the registry, which then will inform OneNote to use Slow Search. Here is how to modify the registryCreate a new text file called onenoteindex.

Microsoft Office

Built-In Calculator in Office OneNote 2007

The new Office OneNote 2007 has a built-in Calculator, really nice stuff! To try it out, just write a mathematic formula in a page and end with an equals sign followed by enter or space, for example:3+2=This will result in a row like this:3+2=5 It is quite powerful, it can handle operations like: +, -, /, * parenthesis so you can do formulas like this (3+3)*3=18 ^, for example 10^3=1 000 sqrt(n) for square root sin(n), asin(n), cos(n), acos(n), tan(n), atan(n) mod for modulus And I’m sure there are more…

Microsoft

Microsoft Office 2007 Preview

So, Microsoft Office 2007, applications and servers, are finally here for download at http://www.microsoft.com/office/preview/beta/getthebeta.mspx. Expect some huge downloads; Microsoft Windows SharePoint Services is at 75 MB and the SharePoint Server at 1.000 MB. The Office Suite and programs is a tiny download of 2.049 MB. That would be a massive hive of 3.5” disks :-). I think a lot of bandwidth will be used on the backbones tonight, and this is just a faint hint of what will happen in a few weeks when the new public Vista beta will arrive.

Windows XP

Concerned about the Microsoft Windows Presentation Foundation and the new UI looks

I’m a bit concerned about all the new user interfaces and layouts that will appear when application developers starts taking use of the Windows® Presentation Foundation (formerly code named “Avalon”). This “tecnology” is awesome but it has it’s drawbacks. With the WPF you can create applications that are really neat looking and have high usability, just take a look at Microsoft Expression Interactive Designer. I saw a really nice demo, on a Microsoft Partner event, of a medical journal application looking like a “medical journal” - not the old fashioned MDI interface with a File, Edit… menu.