17 Comments

Summary:

In my article Macs in the Enterprise: A Firsthand Tale, I mentioned the hardship I was having dealing with editing documents directly from a SharePoint site. As a result, I can only perform the most basic of tasks. I can upload and approve documents, but I […]

In my article Macs in the Enterprise: A Firsthand Tale, I mentioned the hardship I was having dealing with editing documents directly from a SharePoint site.

As a result, I can only perform the most basic of tasks. I can upload and approve documents, but I can’t edit a document directly on the server as I can if I’m accessing the library on Internet Explorer and a Microsoft SharePoint-compatible application. It’s kind of a pain downloading and re-uploading documents when the changes are relatively minor. Later this year, Microsoft is planning on adding the ability for Office 2008 to interact directly with SharePoint, so that might help.

That functionality was part of the recently-released Service Pack 2 for Office 2008. Specifically, you can now check out, edit, and check in documents directly on a SharePoint site. I had a few moments today to test it out and here’s my report from an hour or so of testing.

Before I get too far into the SharePoint tools, I wanted to talk about the speed increases. I have a 2006 MacBook with 2GB of RAM. Even running the latest version of Office 2008, my load times were fairly long. I’ve noticed a significant improvement with SP2. I didn’t do any time tests, but they feel about half what they were. They certainly patched in more snappy.

Without getting into the PC/Mac debate too much, I’ll just say how Microsoft has integrated SharePoint within Office 2007 for the PC is amazing — I can even launch workflows on documents. The Document Connection Tool, however, earns an enthusiastic “Eh, well, it’s not bad.” Granted, I can finally edit a document on the site without jumping through a lot of hoops, I still can’t manage workflows and approve documents for publication. It’s not a big omission; I can do those just fine from the browser.

While the Document Connection Tool is a standalone program, you can access it from the File menu in Word and PowerPoint (oddly, I did not see the option in Excel).

crump_wordmenu_doctool

The Open From Document Connection Screen

The first time you launch the program, you’ll be greated with a blank window. Choose “Connect to a SharePoint Site…”

crump_Microsoft Document ConnectionScreenSnapz001

A blank Document Connection Screen

Enter in your SharePoint info.

crump_Microsoft Document ConnectionScreenSnapz003

Entering in your SharePoint information

You can also connect to an Office Live Workspace (an online collaboration tool similar to, but not exactly like, Google Docs). Regardless of which you connect to, you’ll manage your documents in this screen (for Corporate Security reasons, I’m showing the connection to my personal Office Live Workspace, not my company’s SharePoint site).

Microsoft Document ConnectionScreenSnapz001

Managing Documents

You manage documents in either location similarly. The biggest difference is in SharePoint you click “Check Out” to edit a document; in Office Live you click “Edit.” In terms of working with existing workspaces in Office Live, the Document Connection Tool is adequate. When it comes to managing those workspaces, it’s not that great. While I can upload a new document to an Office Live workspace (its version of folders), it doesn’t appear I can create new workspaces or delete documents (the “discard” button is grayed out).

Also, these tools seem to assume you have an Internet connection. There doesn’t appear to be any sort of offline syncing similar to Google Gears — while the press release claims offline document caching, I haven’t seen where the cache files are kept, and the only way I’ve been able to open a cached file is from the Recents menu. However, that’s from testing with Office Live, I didn’t test with my production documents on my SharePoint site.

While the Document Connection Tool is a good first step, there are a few things I’d like to see added: the ability to approve documents and manage workflows on a SharePoint site, and the ability to check out a document from both SharePoint and Office Live for offline editing — or make it clearer where I can find them.

  1. It appears the Sharepoint item is only enabled for one of the full versions. I have the student (i.e. cheaper) version of Office for the Mac and the Sharepoint item is grayed out.

    John

    1. Yes, I have the same issue.

  2. Ambrose Neville Tuesday, July 21, 2009

    This is excellent news. I’ve just been trying it out over the last few minutes, and while it yet doesn’t work over Kerberos sign-in where I work, username/password authentication to our Sharepoint installation works just fine.

    I can’t find much documentation as to how it works. Presumably it’s WebDAV?

    -I’d like to see some of the Sharepoint calendar functionality come in to future versions, but given the name of the app, that may not be the MBU’s intention.

    -I’d also like to see a right click contextual menu listing that allows you to copy the path the file for the purposes of emailing its location, or maybe a button to email a link to the file in a new Entourage email.

    Still, very much a step in the right direction.

    1. I thought kerberos was supported?

      I think you can copy the document path by either going under the edit menu or draging the file to your email.

    2. Same here.
      Entourage is using the Kerberos tickets just fine.
      Oddness…

    3. You can copy the file path by pressing Cmd+C

  3. Microsoft presenta el SP 2 de Office para Mac « Nuevas Tecnologías – View & Play Tuesday, July 21, 2009

    [...] a Mac , toma en cuenta las peticiones de los usuarios y entre ellas destaca herramientas como Document Connection; esta herramienta ayuda mejorar el acceso y navegación de documentos alojados en plataformas [...]

  4. Interesting.
    MS Sharepoint site, MS Document Connection won’t open site with Kerberos.
    If I put in the account and password, it’s fine.
    Too bad – looks pretty cool.
    Any ideas?

    Scott

    1. try using capital letters in the username field USERNAME@DOMAINNAME

  5. Jennifer Gianfrancesco Friday, September 4, 2009

    The Delete option in the file menu does not work.

    If you type in the address to a sharepoint site such as subsite2 as shown below in the navigation pane if you accidentically click on Site which you may not have Contribute permissions to then Sharepoint looses it connection all together and you can no longer connect to Subsite2. You have to add the connection back in. This is very annoying.

    Site — Subsite 1 — Subsite2

  6. Thank you looking for details. It helped me in my responsibility

  7. Upon Further Review: Microsoft’s Document Connection Tool Friday, December 4, 2009

    [...] SP2 for Office 2008, Microsoft introduced a new Document Connection tool, which allows Office 2008 to connect to SharePoint sites very easily. Figuring this tool might be [...]

  8. Upon Further Review: Microsoft’s Document Connection Tool | Technology Nerd Blog Sunday, December 6, 2009

    [...] SP2 for Office 2008, Microsoft introduced a new Document Connection tool, which allows Office 2008 to connect to SharePoint sites very easily. Figuring this tool might be [...]

  9. Can’t delete a file (even if you have full Sharepoint permissions). Can’t create a folder (only a file, through Microsoft Office Word, etc.). Can’t move a file or folder.

    Don Montalvo, TX

  10. Can’t delete a file (even if you have full Sharepoint permissions). Can’t create a folder (only a file, through Microsoft Office Word, etc.). Can’t move a file or folder.
    Don Montalvo, TX

Comments have been disabled for this post