Telligent Evolution Platform Discussion - Recent Threads

Velocity script to return the count of members in a group

davec1225 — Thu, 23 May 2013 20:54:01 GMT

I'm writing a custom widget that is going to return the count of members of a group, my code is below. I'm always getting a count of 0 although I added two members to the group so I know this is incorrect. I've also tried using the $core_v2_groupUserMember.ListEffectiveGroupMembers API call and the TotalCount property of the list , but neither worked. I think it's something to do with the way I'm processing the list but I'm not sure.

Any help greatly appreciated.

#set($groupId = $core_v2_group.Current.Id)

#set($membercount = 0)

#foreach($member in $core_v2_groupUserMember.List("%{GroupId = $group.Id, MembershipType = 'Member' }"))

#each

#set($membercount = $membercount + 1)

#end

<b>Member Count:</b> $membercount

REST API Throwing 500 Error

davec1225 — Wed, 22 May 2013 16:53:54 GMT

First a little background. Our client has multiple sites with a shared user database.

The task that I have is to take users from “site A”, “group A” and add them to “site B”, “group A”

If users have never logged into “site B”, then they do not have an account on “site B”,

they have an account on “site A” and an entry in the shared database. So I can’t simply add them to “group A’” on “site B”,

I need to create a user account on “site B” first.

Using the rest api, I get a 500 error if I try and create a user that exists in the shared database.

If I pass the api a user that doesn’t exist, the user is created. Obviously this has something to do with the user existing in the shared database.

The only information I’m passing are the required fields (Username, Password, PrivateEmail).

There is nothing in either the event log or exceptions log at the time these errors occur. (Management console)

Any insight into this would be appreciated.

Updating user profile fields e.g. "Title" or "Department" etc using c# only

Paul Deehan — Thu, 16 May 2013 10:55:13 GMT

I'm using c# to extract user details e.g. Telligent.Evolution.Components.CSContext.Current.User

I want to update user profile fields, but not all User.Profile.[name] values are shown e.g. I noticed there's no reference to Title or Twitter or Department etc.

Assuming I have to update these fields in this way - may from a SSO cookie - how do I access these profile fields to update them?

Ideally some example code woudl be nice if possible please.

Many thanks.

Activity Story Filters Issue

gcraney — Tue, 21 May 2013 22:25:35 GMT

We are using 6 ActivityStoryFilters. Four use IncludedUsers="All" and two use IncludedUsers="User"

We have been seeing inconsistent results and started running SQL profilers to intercept the stored procedure calls and study the results.

The call we captured that returns the incorrect results has this WHERE clause:

WHERE	1 = 1 
			AND s.StoryId = s2.StoryId 
			AND ( s2.StoryTypeId IN (SELECT CONVERT(UNIQUEIDENTIFIER, Items) FROM dbo.te_SplitString(@QueryAllFilterIds, '',''))  )  OR ( ((s.StoryTypeId = ''0c7e9024-797a-48cb-8c1b-510942f01bae'') AND (sa2.UserId = @QueryUserId)  )  OR  ((s.StoryTypeId = ''18f4cd4e-ae0b-4cba-9a67-443f2395dd94'') AND (sa2.UserId = @QueryUserId)  )  )

After putting in some line breaks to make it readable we noticed it needed another set of parenthesis to really make sense. After changing the clause to the following and running it we received correct results:

WHERE	1 = 1 
			AND s.StoryId = s2.StoryId 
			AND 
			(
				( s2.StoryTypeId IN (SELECT CONVERT(UNIQUEIDENTIFIER, Items) FROM dbo.te_SplitString(@QueryAllFilterIds, '',''))  )
				OR 
				(
					((s.StoryTypeId = ''0c7e9024-797a-48cb-8c1b-510942f01bae'') AND (sa2.UserId = @QueryUserId)  )
					OR  ((s.StoryTypeId = ''18f4cd4e-ae0b-4cba-9a67-443f2395dd94'') AND (sa2.UserId = @QueryUserId)  )  
				)
			)

We are on 7.1.5. Is this a known issue? If so, is there a fix planned for future releases?

Thanks!

Error Implementing searchable Content

Cody Beckner — Mon, 20 May 2013 11:23:06 GMT

I have implemented a custom content type that allows for commenting (IContentType, ICommentableContentType). I followed the Polling application example and everything appears to be working properly. I am able to view my content as well as submit comments against it with no (discernible) issues.

However, after adding my first comment, I started seeing the following message showing up in the exception log.

Message: Error while mapping comment [ContentId] 'dbcc55ca-d380-4c51-b7e9-051b9bb324c2'. Message: Content type does not support comments.
Telligent.Evolution.Components.CSException: Content type does not support comments.
at Telligent.Evolution.Api.Services.CommentService.(ObjectState objectState, Comment comment, Int32 userId)
at Telligent.Evolution.Api.Services.CommentService.Get(Guid commentId, Boolean checkPermissions)
at Telligent.Evolution.Api.Content.Comments.CommentContentType.(CommentRenderEventArgs e)
at Telligent.Evolution.Extensibility.Api.Version1.CommentRenderEventHandler.Invoke(CommentRenderEventArgs e)
at Telligent.Evolution.Api.Events.CommentEventExecutor.OnRender(Comment comment, String propertyName, String propertyHtml, String target)
at Telligent.Evolution.Extensibility.Api.Entities.Version1.Comment.Body(String target)
at Telligent.Evolution.Api.Search.SearchIndexDocumentMapper.MapComment(Comment comment)

I have tried everything I can think of to track down the issue, but I can not get the debugger to fire anywhere in my code when attached to either IIS or the Jobs service.

The GUID in the message is the id of my custom content, not the comment, so I am pretty sure that it is something related to my implementation. Any assistance would be greatly appreciated.

Activity Stream Filtering

molarloth — Fri, 17 May 2013 23:35:49 GMT

We are trying to use the Activity Stream filtering options in a web application. We create two ActvitiyStoryFilters, one with IncludedUsers = User and a StoryTypeId, and one with IncludedUsers = All and a different StoryTypeId. We pass these filters into the ActivityStoryListOptions used in the TEApi.ActivityStories.List method.

When we use a single filter with IncludedUsers = All and a StoryTypeId for forum threads, we can retrieve all forum thread items for a group, and we are not given the forum thread replies on those items. If we use single different filter with IncludedUsers = User and a StoryTypeId for a custom comments activity story, we receive forum thread replies only for threads created by the current user. However, when we pass both of these filters to the ActivityStoryListOptions, we receive all forum threads as well as all forum thread replies for every thread, not just the ones created by the current user. This only occurs after a user has created content within the group.

Does creating content in a group somehow tie a user to all of the activity story types for that group? Also, why would applying two filters result in additional items that do not appear in either filter when they are used individually?

Making profile fields read only

Paul Deehan — Fri, 17 May 2013 13:14:18 GMT

How would I go about making profile fields read only? Scenario is, all our users will sign in vias SSO Cookie "CSUser". We don't want them to edit the following profile fields:

Name

Custom Field

We do want them to see the fields and values but not be able to edit them, thus a read only scenario - can't find anything within this community nor via admin control panel.

Using Telligent 7.5.

Many thanks.

Disabling the "request membership" modal pop-up

Paul Deehan — Thu, 09 May 2013 12:11:23 GMT

I've a scenario on a test site I'm developing whereby an anonymous user clicks a link to display a group list. If the anon user clicks one of the group lists they are presented with the access denied screen but prior to that get the request membership modal pop-up. All this does is allow the anon user to enter some text and redirect them within the modal to the register/join page - very odd.

The group is set to be private listed. The everyone role has had all access removed. I therefore would expect the site to work by showing the access denied page (MessageID=31) and NOT the modal pop-up.

I'm using 7.5 upgraded from 7.x.

I found a post regarding anon users and issues upgrading from previous versions - is this potentially a similar issue that I'm having (telligent.com/.../1058130.aspx)?

Ideally I just want to disable this modal. I've tried siteurl_override but whilst I can direct to a custom page it doesn't stop the modal from popping up.

I don't mind this if I am a logged in user, but this is an anonymous user. We want anon visitors to see certain content then point them towards joinging the community rather than requesting membership when they are not a registered user.

I've considered amending setting from the dashboard such as the suggestion here - telligent.com/.../24207.anonymous-posting.aspx

But of course on 7.5 such options are no longer applicable.

Is there a way to stop the request membership modal when I am anon?

Moderate User REST API Endpoint?

Bill Corley — Wed, 15 May 2013 16:56:46 GMT

In Enterprise 3.1, is there a REST endpoint (that I haven't found) for updating a user's moderation level? We have a number of users who are set to User is Not Moderated and we would like to change them all to User is Moderated. And I would like to script it rather than changing them by hand.

Are Extended attributes no longer working in 7.1.5.32650?

molarloth — Tue, 14 May 2013 21:29:20 GMT

My extended attributes aren't getting added to the Telligent DB using the following code... I'm using telligent version 7.1.5.32650. Any idea why ?

options = new ActivityStoryCreateOptions

{

ContentId = e.Content.ContentId,

ContentTypeId = e.Content.ContentTypeId,

LastUpdate = DateTime.UtcNow,

TypeId = new Guid("0C7E9024-797A-48CB-8C1B-510942F01BAE"),

Actors = actors,

ExtendedAttributes = new List<IExtendedAttribute>

{

new TEApiEntities.ExtendedAttribute()

{

Key = "BlogPostContentId",

Value = e.Content.ContentId.ToString()

}

};

_storyController.Create(options);

CSUser via cookie authentication using encryption service

Sergej Kravchenko — Thu, 21 Mar 2013 11:43:22 GMT

Hi there,

I'm working at Precedent and recently we just tarted to test your Telligent Suite which comes with latest hotfix for 7.1 version.

However I've experienced several issues:

1) Using your encryptions service, when cookie value has a space character, your system throws an exception:

"Exception Details: System.FormatException: Invalid length for a Base-64 char array or string."

Taking into account that when we include roles values, you mention in your documentation to always include “Everyone” and “Registered Users” roles, however “Registered Users” role contains space character and your system just couldn’t accept it and throws the exception described above.

You are also mentioning it there - telligent.com/.../1049685.aspx

2) If user is already registered through cookie authentication, profile is never update if we make changes in cookies value, for instance we added a new role and Telligent didn’t update profile, unless you delete a profile and it will be created again once values read from cookie.

3) Currently your system only reads 3 attributes from cookie, and they are: username, emailAddress, and roles, the other fields which are configurable in your Telligent, they are not updated when passed via cookie, for instance “name”, “title”, “department”.

In regards the 1st clause I assume you have an issue in your code, when you are trying to decrypt encrypted values.

I've already implemented a service, which relies on your SymmetricEncryptor and SymmetricDecryptor class, deriving from Telligent.Evolution.SecurityModules assembly.

So before decrypting a value, you should convert a string to byte[] array:

_decryptor.Decrypt(Convert.FromBase64String(encryptedText))

Hope this helps to fix your issue.

Thank you,

Regards,

Sergejs Kravcenko.

SQL Connection timing out on new Group creation

sanjeevn — Fri, 10 May 2013 06:11:36 GMT

Our server’s SQL Connection is timing out often while creating a new Group. So I was investigating where exactly the problem is happening that is causing the timeout. I would appreciate if you could review the detail analysis below and recommend a solution on how we could expedite the SQL database performance.

Basic problem:

The stored proc dbo.cs_Security_EffectivePermissions_Calculate (attached) roughly takes 34 seconds on our server to execute at the time of creation of a new Group. This causes the .NET SQL Connection to timeout.

I ran the Profiler tool and captured a trace for the above stored proc’s execution. In the DB Tuning Advisor tool when I analyzed the trace, it couldn’t recommend any way to improve the performance either. So I dug into the “Statement Detail Report” of the tool, and captured the attached report (StatementDetailReport.xml).

The interesting thing here is that the “StatementId = 20” takes 99% of the time in the stored proc. This statement seems to be a “delete permissions” statement, and the temp table that is being joined to also has indexes defined on it. So I am really at a loss as to why the statement would take upwards of 30 seconds to execute.

I also captured the IndexDetailReport.xml (attached) which shows the state of the indexes. The indexes on the Node Permissions table seem to be little too big, but I am not sure if this is normal or not.

Can you recommend some possible solutions that could speed up the DELETE statement to a sub-second speed, like most of the other statements are? I find it hard to believe that despite the indexes this statement takes so long to execute.

Cookie SSO from PHP

NS_wcharliebrown — Fri, 10 May 2013 16:31:39 GMT

I successfully added a new user using the REST API and verified the user exists.

But when I try to authenticate, as that user, using Cookie SSO it fails authentication.

1. Does it require SSL and secure cookies? (We don't have a SSL certificate installed yet)

2. Must the cookie values be encrypted? If so, using what algo and what key?

Here's the code I'm using.

<?php

$data = array(

'username'=> $username

,'emailAddress'=>$email

,'roles'=>'Everyone,Registered Users'

);

setcookie("CSUser" , http_build_query($data) ,time()+86400,'/','naturallyslim.com');

header('Location: http://nstown.naturallyslim.com');

exit();

That creates a cookie named CSUser with a value of username=NS_cb_test&emailAddress=wcharliebrown%40somedomain.com&roles=Everyone%2CRegistered+Users

Show Blog Post REST Endpoint won't update view count

bruno — Mon, 06 May 2013 15:13:18 GMT

Hello.

Is there any way to update the view count (number of views) for a given blog post when using the REST Api? Since the Show Blog Post REST Endpoint won't update it automatically and our access is totally based on the REST Api, how can we resolve this issue?

Thanks.

SPLOG Accounts

viola — Mon, 06 May 2013 23:00:59 GMT

What is the best way to stop these from being created and once they are what is the best way to get rid of them? Is there a script that can be run at the database level to remove them?

Thank you

Activity Message List Widget

viola — Wed, 08 May 2013 19:01:02 GMT

The display of user activity is not consistent. Some users information shows and others do not. What would cause this behavior and how do I fix it?

Thank you

REST API - User rank name and badge

mstaszew — Fri, 03 May 2013 20:10:32 GMT

Telligent 7

In the user XML I can see the number of points a user has, but is it also possible to get the name of the user's rank and the rank badge URL? Nothing's jumping out at me.

Thanks,

Michael

TC 6.1 - How to change the default "friendship" activity message?

sanjeevn — Wed, 08 May 2013 00:36:12 GMT

We want to rename the "Friendship" wordage to "Connections". Hence, all the related messages need to be reworded too. Most areas are easy to change, but I am not sure where I need to change the "Acitivity Message" text...

Currently the wording is - User1 and User2 are now friends.

I want to change this to - User1 and User2 are now connected.

How do I do this?

Plus Sign in Unfiltered HTML Widget

Will Yip — Tue, 07 May 2013 21:29:04 GMT

We started noticing today that a plus sign (+) gets stripped out in the Unfiltered HTML widget. Is there a configuration setting that is stripping it out? I think we started getting this behavior after installing a 6.1 hotfix.

How to determine page content roles against logged in user roles in C#

Paul Deehan — Tue, 07 May 2013 15:12:05 GMT

If I have content that is assigned to a specific role and a user not assigned to that role I will get the access denied page messageid=31 or something like that.

If I wanted to use some c# in a custom widget or as a footer control to a master page to pop-up a modal alert to tell the user they don't have the required role and then soem additional code, how would I access the content assigned role.

I know how to get the user's roles e.g. Roles.GetUserRoleNames[string username], but how can I extract the roles assigned to content?

It's quite specific what I'm after and thus if I can determine the content the user is trying to view is in a different role, then I can alter via a modal pop-up - similar to how a user is informed if they try to access content in a group they require membership to join.

Thanks.

P :)

How do you display different content for a page when user is not logged in

mwada — Tue, 05 Mar 2013 18:45:45 GMT

How do I display different content on the homepage when the user is not logged?

Out of the box, both logged in and not logged in version of the homepage display the activity stream, blog posts, and the group list. When an user is not logged in, I just want to display some message about my webdsite and the register box.

help with glowPopUpPanel

richard451 — Wed, 20 Mar 2013 23:02:52 GMT

I'm looking for a sample of a widget using the glowPopUpPanel function. I'm trying to create a simple widget that displays a popup when the user is on Internet Explorer. Is there some sample code that can get me started?

This is for 6.1 of community.

In-Process API: ActivityStoryFilters SQL Exception

gcraney — Wed, 01 May 2013 20:23:04 GMT

I receive what looks to be a SQL Exception when I try to list activities using more than one item in the Filter parameter for ActivityStoryListOptions. The error I am receiving is: "Incorrect syntax near the keyword 'AND'.

Incorrect syntax near the keyword 'AND'.

Incorrect syntax near ')'"

Here is my code:

using TEApi = Telligent.Evolution.Extensibility.Api.Version1.PublicApi;

var activityStoryFilters = new List<ActivityStoryFilter>(){

new ActivityStoryFilter()

{

IncludedUsers = "User",

StoryTypeId = new Guid("DF443F7C-229D-4759-A316-79607CFA3AB0")

new ActivityStoryFilter()

{

IncludedUsers = "All",

StoryTypeId = new Guid("66E7036F-4099-47FB-B505-90A7AE407782")

}

};

ActivityStoryListOptions options = new ActivityStoryListOptions()

{

ContainerIds = groupIds,

SortBy = "Date",

SortOrder = "Descending",

PageSize = 100,

PageIndex = 0,

Filters = activityStoryFilters,

UserId = userId //required when filters including 'User' are used

};

PagedList<ActivityStory> activities = TEApi.ActivityStories.List(options);

When I use that same code but do not add the second filter, it returns results as expected. We are on Telligent 7.1. Please advise on how to properly utilize this filter parameter that takes a list of activity story filters.

Activity message for custom content is not getting displayed in the Activity Stream

mwada — Wed, 10 Apr 2013 22:34:42 GMT

I have created a custom content type in my application and I would like to add an custom activity message whenever an user creates this content type. My custom content type class inherits IContentType and is associated with Groups. Currently the aspx page that creates the content is under the site group (I added the page under the site-wide content management page). I also created a custom Activity Story Type class that inherits IActivityStoryType. This class is pretty much similar to the one in the sample polls application.

I do see records being added to the te_ActivityStream_Stories table in the database but it doesn't get displayed in the activity stream. How can I go about debugging this? Is there some setting I need to enable for the custom activity message to be displayed?

Loading custom stylesheets based on group extended attribute

Robert Miller — Mon, 15 Apr 2013 22:13:35 GMT

We would like to load additional CSS overrides within a group based on an optional group extended attribute specifying the group's "category" within the overall community. Each category will be comprised of one or more groups, so our intention is to define the CSS rules once in an external table and share the styles amongst all of the groups in the category. Is it possible to do this and have the CSS load after the dynamic theme styles (dynamic-style.aspx) or would we have to modify the dynamic-style.aspx page itself to merge the theme styles with our custom styles?

FYI, we're currently using TC6.1 but intend to upgrade to 7.x this spring or early summer.