Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
stylenone

...

1. Requirements

Communote

  • Communote Version 2.2.x or higher
  • installed Plugins
    • Sharepoint Plugin
    • Message Queue

...

Info
You get all the needed plugins upon request. Please send us an e-mail request to support@communote.com

 

1.1 Communote Plugins

Please switch to the administration area of Communote and open the overview of available Extensions: Administration > Extensions > Overview

...

  • Integration - Sharepoint
  • Message Queue - ActiveMQ Adapter
  • Message Queue - ActiveMQ Provider
  • Message Queue - Core
  • Message Queue - JMS Adapter
  • Message Queue - Message
  • Message Queue - Service

 

1.2 Content of the delivered package

Please review the contents of the delivered archive with the files listed in the table below.

FileDescription
DeployScript.ps1installation Script for new installations
params.ps1configuration of the installation
Communardo.Common.wspCommunardo solution for common functions
Communardo.Communote.wspCommunote solution for the Web Front End Server
Communardo.Communote.Services.wspCommunote solution for Application Front End Server
CreateTable.sqlSQL script for creating the token Communote database 
Communardo.Communote.EncryptPassword.exeHelper application to create an encrypted password

 

1.3 Availability of SharePoint services

Snap-in: “Microsoft.Sharepoint.Powershell”

...

<SessionStateDatabase> –The database name for the session state service. For example: SessionStateServiceDataBase

1.4 Create a Support Database

The Communote solution requires a small database to temporarily save data – e.g. credentials. Create this database before you start the installation.

  1. Enter a name for the database in CreateTable.sql (change at 2 locations in the script: <DATABASE_NAME>).

  2. execute the script CreateTable.sql on the SQL Server

  3. assign the permissions “owner” (dbo) to the database for SharePoint Application Pool account

  4. Activate the token database for “Windows Authentication” mode (if necessary)

 

2. Installation

2.1 Communote System: Configuring the Message Queue provider

Navigate to the administration area of Communote and configure your Message Queue provider. A configuration guide for the Message Queue provider you can find in our support portal: Communote > Plugins > Message Queue

(info)Write down the user name and password to access the provider for the following installation.

2.2 Communote System: Set password for the system user

By default, no password is defined for the system user “sharepoint.system”. Please navigate to the administration area of Communote and set a passwort for this user to increase the security of your system.

...

(info)Write down the passwort of the system user for the following installation.

2.3 SharePoint: Installation of Communote solution

The next step is to install the Communote solution on your SharePoint system. The included file params.ps1 allows an individual configuration of your installation and should be adjusted to your system requirements.

...

After the installation is done, check if the solution has been installed correctly: Central Administration > System Settings > Farm Solutions

Configuration options

KeyDescriptionExample
solutionPathAbsolute path where the solutions are stored"C:\Deploy\"
communardoCommonSolutionName

Name of Common Solution, Communardo.Common.wsp

You should not change this value.

"Communardo.Common.wsp"
communardoCommunoteSPIntegrationSolutionName

Name of Communardo.Communote.wsp solution

You should not change this value.

"Communardo.Communote.wsp"
communardoCommunoteServiceSolutionName

Name of Communardo.Communote.Timerjobs.wsp solution

You should not change this value.

"Communardo.Communote.Services.wsp"
communotefullPermissionTimerJobSchedule

Schedule for running the syncronisation with Communote

Current values for the timer jobs can be retrieved using the following command: Get-SPTimerJob | sort-object name | format-table-auto

"daily at 04:00:00"
communoteServerUrlURL of the Communote system"http://communote_server:8080"
communoteTokenDbConnectionString to connect to the custom database for Communote

"Data Source=<db_server_name>; Integrated Security=SSPI; Initial Catalog=<db_name_sp_cn>"

<db_server_name> – The name of your SQL Server.<db_name_sp_cn> – The database name that was entered in “CreateTable.sql”.

communoteUserProfileTrackingTimerJobSchedule

interval to check for changes in the user profile (irrelevant for SharePoint Foundation)

How to create a plan fpr a timer job is described here: SPSchedule.FromString(recurrenceValue) - syntax/format for recurrence value

"every 5 minutes"

communoteIncrementalPermissionTimerJobScheduleinterval for the incremental testing of permissions"every 5 minutes"
communoteUser

Communote System User

You should not change this value.

"sharepoint.system"
communotePassword

encrypted password of the system user

Encrypt the password withCommunardo.Communote.EncryptPassword.exe.

"3uyRYippwH6Vae3UcNBCau9ow=="
communoteClientId

Communote ID of your system.

For installations on your own servers use "global" or leave it blank: "".

If you use our online service, please enter your Communote ID that you specified during registration. You also can find the ID in the Communote address: www.communote.com/microblog/communote_id

"global"
Message Queue

You will find your personal configuration data in the administration area of Communote:  Extension > Message Queue Provider

If you are using our online service, please contact our support team and we will share the necessary configuration data.

communoteMqClientUserNameuser name for the Message Queue provider"mp.sharepoint"
communoteMqClientPassword

encrypted passwort of the Message Queue Provider

Encrypt the password withCommunardo.Communote.EncryptPassword.exe.

"3uyRYippwH6Vae3UcNBCau9ow=="
communoteMqPortPort for the Message Queue Provider
  • default
    • TCP = 61616
    •  SSL = 61617
"61616"
communoteMqServerNameserver name of the Message Queue Provider"http://mqServer"
communoteMqBrokerUrlList

URLs of the Message Queue Provider

If this parameter is set, the settings ofcommunoteMqPort andcommunoteMqServerName will be overridden.

"ssl://communoteServer1:61617, ssl://communoteServer2:61617"
communoteMqClientCertFileName

path to the client certificate

Important when using SSL-CERT.

"C:\message-queue\activemq\cert\me\client.pfx"
communoteMqClientCertPasswordpassword of the client certificate 
communoteMqClientCertSubjectsubject of the client certificate"CN=sharepoint.system, OU=global.communote.user, O=Communote, L=Dresden, S=Sachsen, C=DE"
communoteMqCertificateServerNameserver name of the client certificate"communote-mq-provider"
communoteMqClientSecurity

Setting the security level

  • NONE (default)
  • SSL
  • SSL-CERT

(see also “Certificates for Message Queue connections”)

""
Settings for Webpart
communoteWebpartSettingsUsePersonalTopicLinker

If set to true the Web Part properties shows the checkbox “Link to personal topic”. Default value: true

(irrelevant for SharePoint Foundation)

$true
communoteSendProfileChangesActivities

If set to true, changes of the user profile create an activity in Communote. Default value: true

(irrelevant for SharePoint Foundation)

$true

 

Example of a minimal configuration:

Code Block
languagebash
titleparams.ps1
$global:solutionPath                                       = "C:\Deploy\"
$global:communardoCommonSolutionName                       = "Communardo.Common.wsp"
$global:communardoCommunoteSPIntegrationSolutionName       = "Communardo.Communote.wsp"
$global:communardoCommunoteServiceSolutionName             = "Communardo.Communote.Services.wsp"
$global:communotefullPermissionTimerJobSchedule            = "daily at 04:00:00"
$global:communoteServerUrl                                 = "http://communoteserverUrl"
$global:communoteTokenDb                                   = "Data Source=DBServer; Integrated Security=SSPI;
                                                              Initial Catalog=CommunoteTokenDB"
$global:communoteUser                                      = "sharepoint.system"
$global:communotePassword                                  = "MlCk+0Wk7Qja+WpMZShLjw=="
$global:communoteClientId                                  = "global"
$global:communoteMqClientUserName                          = "mq"
$global:communoteMqClientPassword                          = "QuyJicppVahea3UjNZauow=="
$global:communoteMqClientSecurity                          = "NONE"
$global:communoteUserProfileChangeTrackingTimerJobSchedule = "every 10 minutes"
$global:communoteIncrementalPermissionTimerJobSchedule     = "every 5 minutes"
$global:communoteSendProfileChangesActivities              = $true

 

3. Update

If you have already installed an older version of our Communote solution, please perform the following steps to install the new verion.

  • At first you have to delete the following solutions (http://CentralAdministration/_admin/Solutions.aspx):
    • Communardo.Communote.wsp
    • Communardo.Communote.Services.wsp
    • Communardo.common.wsp
  • If the table ChangedSite does not exist in your custom database, delete the database an create it with the script: CreateTable.sql
    • create the new database as described in section 1.4
  • Then install the new version of the Communote solution
    • As described in the installation instructions: Customize the values in params.ps1 and execute DeployScript.ps1 in PowerShell

 

4. Configuration

4.1 Communote System: Configuration of Communote

Configure how can Communote reach the SharePoint Server

...

To simplify this process, select the option for automatic activation of new users in the administration of Communote. You find the settings under Administration > User Management > Settings: “New users are automatically activated”.

 

4.2 Configuration of SharePoint

Activate the Communote Feature

...

  1. set the farm property communoteMqClientSecurity to “SSL-CERT”

  2. Upload the certificate with a password for the user “sharepoint.system” to  each SharePoint Server

  3. Store the path to the certificate in farm property communoteMqClientCertFileName

  4. The password for the certificate will be stored in farm property communoteMqClientPassword

 

4.3 Logging

 

  • The log entries are written to the Communote Solution SharePoint logs 
  • use log level “verbose” to log more information
  • The log level can be set in the Central Administration of SharePoint

 

4.4 Troubleshooting

The Communote WebPart isn't available for the Share Point System account

...

  1. Login to Share Point
  2. Open in the same window following URL http://<SP_SERVER>/_vti_bin/communardo.communote/communotemanagement.svc/GetUserInfo
  3. The result should look like in this way:

    Panel
    bgColor#FFFFFF
    borderStyledashed

    {"login":"yourLoginName",
     "firstName":"yourFirstName",
     "lastName":"yourLastName",
     "email":" yourEmailAddress ",
     "lang":"en",
     "userFound":"False"}

  4. The e-mail address must be filled, otherwise the authentication against Communote will not work. If the address does not exist, do the following:
    1. Check whether the email address for those users is available in Active Directory.
    2. Check if the "User Profile Synchronization" runs error-free. Please take a look at: http://technet.microsoft.com/en-us/library/ee721049.aspx

 

5. Using the Web Part

5.1 Add the Communote Web Part

You can add the Communote Web Part to any page in SharePoint to display the message stream of Communote.

  1. open a SharePoint site where you want to insert the Web Part
  2. Edit Page: Click to edit icon at top of the page > insert tab
  3. Click the button “Web Part”
  4. from the category “Custom”, select the “ Communote” 
  5. Click on “Add” button 

 

5.2 Customize the Communote Web Part

The web part can be flexibly configured. The most important parameters can be set via a form (see following figure). Other settings can be configured via the “Additional parameters” in the Web Part.

...

The following table shows the list of all available parameters.

Parameter namePossible valuesDefault valueDescription
Editor (ed)
edShowCreatetrue/falsetrueShow the editor area for creating new notes
edInitLines1 ... 502The initial height of the editor
edShowTopicChoosertrue/falsetrueShow the topic selection, is used for adding new notes
edTopicList A comma separated list of topic aliases, shown in the topic chooser Default: all writeable topics of the user
edPreselectedTopic A preselected topic for writing
edShowTagtrue/falsefalseShow the tagging function for notes
edShowTagFieldtrue/falsefalseShow the tagging text field for notes (Communote Version 2.2)
edAddDefaultTags A comma separated list of tags that are added to the notes by default
edShowUploadtrue/falsefalseShow the file upload function for notes (Communote Version 2.2)
Message Stream (msg)
msgShowMessagestrue/falsetrueShow the message stream
msgShowEdittrue/falsetrueShow the note action link “edit”
msgShowReplytrue/falsetrueShow the note action link “reply”
msgShowDeletetrue/falsetrueShow the note action link “delete”
msgShowLiketrue/falsetrueShow the note action link “like”
msgShowFavortrue/falsetrueShow the note action link “bookmark”
msgShowAuthorImgtrue/falsetrueShow the author images at notes and anwers
msgMaxCount0 ... 5010The count of notes that are loaded at once
msgShowViewsall/following/me/favoritesallThe available views for the message stream (comma seperated list)
msgViewSelectedall/following/me/favoritesallWhen multiple views are provided a special view can be preselected
msgFollowButtontrue/falsetrueShow a button to follow a single topic
msgHomeButtontrue/falsefalseShow a button to open the full application in a new window
Filter (fi)
fiShowFiltertrue/falsetrueShow the note filter area
fiShowSearchtrue/falsetrueShow the keyword search
fiShowTopictrue/falsetrueShow the topic filter
fiShowTagCloudtrue/falsetrueShow the tag cloud
fiShowAuthortrue/falsetrueShow the author filter
fiPreselectedSearch To initialize the text search filter with a predefined string
fiPreselectedTopics To initialize the topic filter with a comma separated list of topic aliases, shown in the topic filter (default: all readable for the user) Default: all readable topics for the user
fiPreselectedTopicIds Like fiPreselectedTopics, but with the database id of topics
fiPreselectedTagIds To initialize the tag filter with a comma separated list with the database id of tags
fiPreselectedAuthors To initialize the author filter with a comma separated list of user aliases
fiPreselectedAuthorIds To initialize the topic filter with a comma separated list of the database id of users
fiPreselectedNoteId To initialize the note filter with the database id of a note
fiTopicPageSize1 ... 5010The count of topics per page the user can filter by (topic filter)
fiAuthorPageSize1 ... 5014The count of authors per page the user can filter by (author filter)
Activities (ac)
acShowtrue/falsetrueShow activities in the message stream (Communote Version 2.2)
acShowFiltertrue/falsetrueShow the activity filter (Communote Version 2.2)
Miscellaneous
utcTimeZoneOffset-720 ... +8400Sets the timezone offset in minutes

 

5.3 Synchronization of SharePoint permissions on a topic in Communote


A single Communote topic can be assigned to a SharePoint site via site settings. The assigned topic gets access permissions from the site, so that permissions for this topic must be maintained only in SharePoint. The assigned topic is by default displayed in a web part, when it is inserted into the site.

...

Communote synchronized existing groups with groups of external systems periodically. Is there a group, which isn't  in Communote, they group will be created. Hence the permissions that are defined in SharePoint, can be transferred during synchronization, you must give this group permissions explicitly.

 

6. Activities

In SharePoint you have the option of activating activities, which are then automatically displayed as a message in Communote. Activities of an user are triggered events which are displayed in Communote by a message. The activity describes the action that the person has performed with or on an object. A user activity can be for example the creation of a calendar entry.

...