This page last changed on Feb 20, 2011 by jclark@atlassian.com.

You can use the SharePoint Link macro {sp-link} to put a link on a Confluence wiki page, pointing to a SharePoint list, document or list item. When someone clicks the link, the SharePoint list or document will open. The macro supports most SharePoint list types.

On this page:

Usage with the Macro Browser

The 'Macro Browser' is a graphical menu that allows you to view the list of available Confluence macros and add them to the current page or blog post.

To insert the SharePoint Link macro into a page using the Macro Browser,

  1. Go to the Confluence page or blog post where you want to display the SharePoint link.
  2. Click the 'Edit' button. The page or blog post opens in edit mode.
  3. Click the Macro Browser icon on the toolbar.
  4. The macro browser window opens. Find the 'SharePoint Link' macro:
    • Scroll through the list of macros, or
    • Start typing the macro name into the search box at the top right of the macro browser window. Macros with a matching name will appear in the main pane.
  5. Click the macro to access its parameters and preview the macro output.
  6. Enter the macro parameters. See the parameter descriptions below\.
  7. If you would like to preview your changes, click 'Refresh'.
  8. Click 'Insert' to add the macro to the page.

Usage with the Wiki Markup Editor

Quick guide to the SharePoint Link macro
Using the simplest form of the macro, all you need to enter is the name of your SharePoint list or document library, and optionally the path to a document. The SharePoint Link macro will create a hyperlink on your page, pointing to the SharePoint location or file specified.
  • Enter the following text onto the Confluence page to link to a list:
    {sp-link:LIST-NAME}my hyperlinked text{sp-link}
    

    Or enter the following text to link to a specific document:

    {sp-link:LIBRARY-NAME/DOCUMENT-NAME}my hyperlinked text{sp-link}
    
  • Replace the text 'LIST-NAME' with your own values for your SharePoint list name, or replace the text 'LIBRARY-NAME/DOCUMENT-NAME' with your SharePoint document library and file name.
  • Replace the text 'my hyperlinked text' with the words that you want displayed as a hyperlink on the Confluence page.

In the example below, we link to a specific document in a SharePoint document library. The library name is 'documents' and the document name is 'checklist.docx'.

What you need to type Hyperlink created
{sp-link:documents/checklist.docx}a good checklist{sp-link} a good checklist

Parameters

Parameters are options that you can include in Confluence macros to control the content or format of the macro output. The table below lists relevant parameters for this macro.

Parameter names are different in the macro browser and in wiki markup. Below we show the macro browser parameter names in bold text, and the equivalent wiki markup parameters in (bracketed) text. If we do not show any parameter name for the wiki markup, then you should leave out the parameter name and simply include the parameter value as the first parameter, immediately after the colon (:).

Parameter Default Description
listname
(listName)
No default The first parameter may contain either the name of a SharePoint list, document library or the path to a document within a document library ('listName'). The listName may also be prefixed with a SharePoint site alias, separated by a colon (:). If a site alias is not specified, the default SharePoint site is used. The text 'listName' is optional.

The following example creates a link to the SharePoint document library called 'documents'. The linked text is 'my link text'. When someone clicks this link, their browser will open the SharePoint document library in the SharePoint web interface:

Here is another example, where the parameter name 'listName' is explicitly specified. The results are the same as the previous example:

In the following example, we link to a specific document 'checklist.docx' within the library:

This final example shows how we can specify a specific SharePoint site in order to identify the location of a document:

Specifying the full path to your list

You must give the full path to the list (or library). In the above example, we have assumed that the list is located at the root (top-level) SharePoint site. However, if the list is in a SharePoint site called 'mySubSite' that is a child of the root site collection, you might specify the following:

|

Linking to a document folder

To link to a folder 'my folder' within a document library, add a double forward slash(//):

Office Integration

If you are using Microsoft Office integrated with SharePoint, the {sp-link} macro will make use of this integration. When someone clicks on the link created by the macro, it integrates with MS Office in the same way as SharePoint. You can check documents in and out of SharePoint and edit the document from within the Office application.

In oder for the Office integration to work, you must be using Internet Explorer as the browser when accessing the Confluence page.

Diagram: Office integration with the SharePoint Link macro

Examples of List Types

Below are some examples of the list types supported by the SharePoint Link macro.

Document Libraries

See the examples given above.

Links

Linking to a list of links:

Calendars

Linking to a calendar:

Tasks

Linking to a list of tasks:

Issues

Linking to a list of SharePoint issues:

Discussions

Linking to a list of SharePoint discussions:

Custom Lists

Linking to a custom SharePoint list:

RELATED TOPICS

Using the SharePoint List Macro
Working with Macros
SharePoint Connector User's Guide


Document generated by Confluence on Feb 20, 2011 21:50