DanBartels

Going Mac

DanB — Fri, 31 Aug 2012 15:47:11 GMT

On a recent trip to Microsoft, I found myself getting heckled for my trusty notebooks "Vista Basic" sticker. A Toshiba Protege M700 which has served me well, has been upgraded to 4gb ram and an SSD, but shows its age because it has video driver issues with Windows 2008r2 HyperV and doesn't support the hardware virtualization required by the new Windows 8 HyperV. The biggest thing I didn't like about the laptop was the screen resolution, it had a paultry 12.1" screen with a max resolution of 1280x800. I couldn't even run a standard 1024x768 remote desktop window without hiding the task bar.

So while the M700 was still cool for its touch screen, led backlight, and I could get a respectable 4 - 6 hours of battery (with the extra slice) it was time for a change.

Enter the Overkill.

A decade or so ago, mac's started to use Intel processors, and ever since, they have been assembling the "best" of everything. The Macbooks are just that, all the best options available at the time in one package... with quite a price penalty for all the goodies but...

So I picked up a new 15" Mac Book Pro with Retina display... Installed Windows 8 via the Bootcamp Utility that comes pre-installed on the mac side, and now I have a Windows 8 desktop with a 7.2 Experience Index (7.2 comes from the nvidia graphics drivers otherwise it would be a 7.9 from the cpu). That is running at 2880x1800 resolution. Its nearly twice the physical size of the Toshiba, I need to run the Windows fonts around 125 - 150% to be able to read it at arms length, but as my piers and colleagues see this notebook, I am sure to sell a few Macbooks along the way.

Sign-up to try the new Office 365 Preview

DanB — Tue, 17 Jul 2012 15:14:00 GMT

Yesterday Microsoft launched a beta of the new version of Microsoft Office 365.

(Please visit the site to view this video)

http://youtu.be/J-3uK2bRNnE

I found the preivew links were fairly well hidden...

here is a little blurb on whats new http://www.microsoft.com/office/preview/en

While microsoft seems to be avoiding version numbers and naming at all costs... the preivew / beta could represent Office version 15 or perhapse Office 2013; where the current released Office 365 could be considered Office 14.

You can still sing up to demo the current / released version here http://www.microsoft.com/en-us/office365/online-software.aspx...

-Dan

Microsoft DNS for developers - .local wildcard

DanB — Fri, 04 May 2012 14:57:25 GMT

Wouldn't it be great if the internet gods created a DNS top level domain for .local with a wildcard dns a record to 127.0.0.1... If you don't know what that would do, it would make any dns name ending in .local point to your local system... IE myproject1.local and myproject2.local would resolve to your local system without any host file nonsense.

While I don't seem to have any pull with the internet gods these days. It did occur to me that I can affect my only little part of the internet. Here at home I run a domain controller, with that domain controller, I have an DNS server setup so my computers in the domain can resolve each other... If you are like me, then the days of host file editing are over... All you need to do is a couple of clicks away..

Edit your DNS, and add a new authoritative domain in your "Forward Lookup Zones" for "local".

Expand your new "local" zone.

Add a new "a-record" to your zone, use an asterisk (*) for the "host" or "name" and use 127.0.0.1 for the ip address; and bam! All of your PC's will now have anything.local point to their local address.

Big Social Developer Jam - Widget Plug-ins

DanB — Fri, 23 Sep 2011 14:06:53 GMT

Just putting some finishing touches on my Developer Jam item.

Well a bit of background... What is the Big Social?

That's our 2011 Telligent Conference that kicks off next week in Dallas... (http://telligent.com/bigsocial/)

What is a Developer Jam?

During the conference, we will have some development workstations setup for devs to get their hands dirty exploring some new features of our 6.0 Platform.

My Developer Jam session is titled "Create a widget extension plug-in to integrate with an external site"

Widget "plugins" are these powerful little classes that expose the public properties and methods of an existing class to our velocity rendering engine, so you can use your custom class in our widget framework... At my station you will create a plug-in that exposes some prewritten code to extend the platforms capability.

I have one sample, pretty straight forward which pulls in TweetStharps API (wrappered by a custom business logic class); this sample shows how easily you can "pull in" data from external sources...

But it doesn't stop there, to truly integrate, you want to go one step further, to do this I have taken the MSDN Code Gallery sample app (CSASPNETAJAXWebChat) and wrapped the WCF class as a plug-in. This allowed me to re-implement the UI with a couple of Telligent widgets, and create a Chat Application for Telligent Evolution 6.0. This can be easily extended with some business logic to extend the chat to other public API's like IRC or Skype with some minor authentication work and a background service to manage the data flow outside of the ASP.NET page life-cycle.

The widgets themselves would still benefit from a "Long Polling" javascript strategy to make the updating of the web client more efficentthan polling; and the chat contents should probably have a mechanism to get archived into a search-able location (like a forum thread) on a periodic basis, but its a good start to show the integration capabilities of our new platform; come check it out!

-Dan

Telligent Community List Users In Role

DanB — Wed, 17 Nov 2010 17:27:00 GMT

The Telligent Community / Community Server control panel doesn't expose a nice list of users in a particular role, but for auditing purposes its sometimes useful to be able to view all members in a role. If you have access to the database and SQL knowledge, this is fairly straightforward using the cs_Security_UsersRoles table (pre TC5 you would have looked in aspnet_UsersInRoles). However you can also (as a site admin) easily use the v1 rest API's to accomplish this. If your site has rest enabled (if not you will get a 503 error). You can simply log in to your community, and browse to

http://[yourcommunity.com]/api/membership.ashx/users?role=[rolename]

This will present you with an XML list of all the users in the given role; by default the rest API will use a paged list with a page size of 20 items, you can navigate to subsequent pages by appending &pageindex=[page] and or you can increase the items per page using &pagesize=[pagesize]

-Dan

Telligent Evolution 5.5 Export Theme to SQL

DanB — Thu, 13 May 2010 14:11:00 GMT

The Telligent Evolution Platform starting with version 5 has begun to store considerable amounts of the "Theme" configuration in the database. Its is often necessary to take the theme configuration from one environment and apply it to another, or modify it in a "bulk" way (like when copying the theme layout from one theme name to another). The easiest way to transfer a theme layout between two environments is simply a database backup. When a backup however will not work or has undesired side affects, you can use the built in functionality of Telligent Community and Telligent Evolution to export the theme to XML and then re-import; I have had mixed success with this result, and often find myself needing to tweak the the process in some way (Change a theme name, replace a particular control with another, or automatically import new layouts and widget configurations on a new community)...

To make the process of transporting a themes widget layout and configuration easier, I have created a custom control panel page (Attached) named "ExportThemeToSql.aspx". Just drop this page in your /controlpanel/utility folder and navigate to the page directly... From it you can select the theme to export and "click generate" the entire theme configuration from the database will then be transformed into simple SQL statements, which can be run against your other communities or turned into a SQL Patch for your installer. If you are wanting to copy a theme layout to a new theme, you can export the existing theme, and just search and replace the theme name in the SQL script.

There are a couple of limitations with this tool... First off it is designed only to export the "default" widget configurations, it does not export anything "saved contextually" as I am making the assumption that you are applying the scripts to differing environments and those environments would have different contextual ids. Secondly, the new Telligent Evolution Platform 5.5 widget fields "SourceContentFragmentTabId" and "SourceConfiguredContentFragmentId" columns are transfered but don't have their corresponding ids smartly updated, additional logic will need to be added to the import to "repair" these ids should they be required for your theme.

This tool version works with Telligent Enterprise 2.5 and Telligent Community 5.5 only.

Dan

Telligent Community 5.5 Sandbox Fiji Theme Variations

DanB — Mon, 22 Feb 2010 14:58:00 GMT

When working with Telligent Community Sandbox sites, I find it useful to create a couple of theme variations to help illustrate the power of Group and Blog themes, and the differences between the widget "Save as Default" and "Save Contextually" options... I have attached four Blog and Group themes which are variations of the default fiji theme (red, greed, blue and yellow)... You can drop these into your websites theme folder, and run the included SQL script to setup the widget layouts for the new themes.

Install:

Copy the included Themes folder to the root of your Telligent Community 5.5 website (this will place the new theme folders in the correct location)
Run the included SQL script to copy the current Fiji theme widget layouts to the new Theme Variations (without this all the pages for the new themes would not have any widgets)
From a group or blog, when logged into the community as an admin level user, selected "edit this group theme" and choose one of the new themes, and save.

Copying Theme Configuration and Widget Layouts

DanB — Fri, 17 Jul 2009 14:19:00 GMT

If you are running the new Telligent Community 5 (formerly known as Community Server 5 or CS5) or the new Telligent Enterprise 2 (formerly known as Community Server Evolution 2 or Evo2) and need to move your dynamic theme configurations and changes between two environments, you can use the control panel options.

Under the main site theme, you can export the theme configuration and import it onto the other site, at this point, that process seems to be working successfully...

Importing the site layout however doesn't seem to be working in all circumstances... you may find the this SQL script handy... it assumes both databases are accessible on the same server

Just replace the TARGETDB and SOURCEDB with the actual database names on your server...

truncate table [TARGETDB].dbo.cs_ConfiguredContentFragments

truncate table [TARGETDB].dbo.cs_ContentFragmentTabs

truncate table [TARGETDB].dbo.cs_ContentFragmentPages

set identity_insert [TARGETDB].dbo.cs_ContentFragmentPages on

INSERT INTO [TARGETDB].[dbo].[cs_ContentFragmentPages]
           ([Id],[ThemeTypeId]
           ,[ThemeContextId]
           ,[ThemeName]
           ,[PageName]
           ,[LayoutType])
select [Id],[ThemeTypeId]
           ,[ThemeContextId]
           ,[ThemeName]
           ,[PageName]
           ,[LayoutType]
from [SOURCEDB].dbo.cs_ContentFragmentPages

set identity_insert [TARGETDB].dbo.cs_ContentFragmentPages off

set identity_insert [TARGETDB].dbo.cs_ContentFragmentTabs on

INSERT INTO [TARGETDB].[dbo].[cs_ContentFragmentTabs]
           ([Id],[PageId]
           ,[LayoutType]
           ,[OrderNumber]
           ,[Url]
           ,[Name]
           ,[IsLocked])
select [Id],[PageId]
           ,[LayoutType]
           ,[OrderNumber]
           ,[Url]
           ,[Name]
           ,[IsLocked]
from [SOURCEDB].dbo.cs_ContentFragmentTabs

set identity_insert [TARGETDB].dbo.cs_ContentFragmentTabs off

set identity_insert [TARGETDB].dbo.cs_ConfiguredContentFragments on

INSERT INTO [TARGETDB].[dbo].[cs_ConfiguredContentFragments]
           ([Id],[PageId]
           ,[TabId]
           ,[RegionName]
           ,[Type]
           ,[OrderNumber]
           ,[Configuration]
           ,[ShowHeader])
select [Id],[PageId]
           ,[TabId]
           ,[RegionName]
           ,[Type]
           ,[OrderNumber]
           ,[Configuration]
           ,[ShowHeader]
from [SOURCEDB].dbo.cs_ConfiguredContentFragments

set identity_insert [TARGETDB].dbo.cs_ConfiguredContentFragments off

Dan

Adding a site wide widget

DanB — Tue, 17 Mar 2009 02:42:00 GMT

Starting with CS2008 telligent introduced the ContentFragementList as well as several out of the box widgets. This is pretty much old news, but I thought it would be good to cover a very basic scenario...

User story: An admin of a site wants the ability to add a news flash from time to time, that appears on the right sidebar of all pages on their site..

To accomplish this we will add a <CSControl:ContentFragmentList> to the master.Master in the left sidebar column (above the lcr content region)

Add the following markup to the master.Master just about the LCR <asp:ContentPlaceHolder> : (Update the CssClasses as appropriate for your sidebar)

<CSControl:ContentFragmentList runat="server" Property="SiteSideWidgets">
<ItemTemplate>
<CSControl:ContentFragment runat="server">
<LeaderTemplate>
<div class="CommonContentBox">
<CSControl:ContentFragmentData Property="FragmentHeader" runat="server" Tag="H4" CssClass="CommonContentBoxHeader" />
<div class="CommonContentBoxContent">
</LeaderTemplate>
<TrailerTemplate>
</div>
<CSControl:ContentFragmentData ResourceName="ViewMore" LinkTo="More" runat="server" Tag="Div" CssClass="CommonContentBoxFooter" />
</div>
</TrailerTemplate>
</CSControl:ContentFragment>
</ItemTemplate>
</CSControl:ContentFragmentList>

To make this new ContentFragmentList accessable for editing via the control panel; edit your theme.config file and add the following to your <dynamicConfiguration> section.

Assuming you are using something similar to the Hawaii theme, you will already have a <propertyGroup> called sidebar, so add the following <property> to it...

We will leave the default template blank, so when the time comes, the administrator can go into "Site Administration" under the Control Panel, to the "Site Content" / "Site Theme" tab, and in this case, you should see a "Sidebar" tab in the theme editor, and on that page, see the widget box to configure your new site wide widget panel.

Now the site admin, can add a highighted post, or even a "Generic Content" widget, to type an HTML note, all users will see on all pages of the site.

You can find much more detail about these controls at Ben Tied's post on the subject.

http://getben.com/archive/2008/04/18/community-server-2008-how-to-support-widgets-in-a-custom-theme.aspx

Note: even though you have defined this ContentFragmentList in a site wide location, because there are several different theme areas (a blog theme, and hub theme) you will need to add the <property> to a <DynamicConfiguration> <PropertyGroup> for each of these where you want the content to be visible. It is not currently possible to have a ContentFragmentList share its configuration between different themes.

Installing telnet.exe on Windows 2008 Server

DanB — Wed, 21 Jan 2009 04:18:00 GMT

Open a command window and run

servermanagercmd -install telnet-client

and your windows will install telnet for you.

Dan

Using the Telligent.Tasks service to send CommunityServer Emails

DanB — Tue, 09 Sep 2008 15:27:00 GMT

Telligent has a Windows Service job which can be run to offload some of the Tasks / Job processing from your web server... The most common configuration is to use the task server for running the Enterprise Search Indexing jobs, although you could use it to do your Search Barrel Indexing as well...

The second most common item is to use the tasks service to send outgoing emails... Communityserver queues emails into the SQL database by default, and uses a "job" to send them.

The key to using the Telligent tasks service for a job that normally runs under the web site is setting up the CommunityServer "context" in the task service...

This involves copying a few items your cs site folders, into the tasks service folder:

languages folder (and its sub folders)
siteurls.config
communityserver.config
connectionstrings.config
dlls from your web/bin folder

It is not necessary to remove any tasks from your communityserver.config, as the tasks service loads its task list from the tasks.config file...

Finally you need to edit the tasks.config to set up the cs context object for your site.. To the tasks.config file

Add to the \tasks node:

and

and then you should be able to configure the email task by adding a thread to the \tasks\threads node

This will use the SMTP server set in your database (its set via the administration section of the CommunityServer Control Panel / Settings / Email Settings; and send your emails to the SMTP server every 5 minutes.

Dan

Web browsers are good, everyone should have one

DanB — Wed, 03 Sep 2008 20:05:00 GMT

Yes, well now it seems like everyone is making one; and many users have two or three... Google has launched Chrome http://www.google.com/chrome the latest development in the browser wars... We have IE8 shaping up (currently in beta 2 form) and Firefox 3 now out; and what seemed like a "nice try" by apple to bring Safari to the Windows world... (Thats all of course failing to mention the exploding mobile browser market)

It sure is hard to remember the good old days, when Microsoft crushed netscape and it looked like for better or worse there was only one browser that mattered. All this competition is good, but it leaves the web developers in the middle, trying to support each browsers peculiarities in order to ensure site visitors a consistent experience.

Dan

CS Membership for the Membershipless

DanB — Wed, 11 Jun 2008 00:57:00 GMT

From time to time I find myself pulling down a live Community Server database for testing. When the database also has a remote membership system it can be very time consuming to try to download and configure both a CS database and a Membership system and keeping those databases in sync.

I have created a SQL script which can create simple membership data for all the membership in a CS database. You set the application name, and script allows you to specify the name of one user which will be added to the system administrator role. It will create the asp.net membership tables and entries as necessary, it auto assigns all other users to the everyone role; and sets any user passwords to "password" (obviously this is just for local testing).

This script builds an ASP.NET 2.0 Membership system, for use by CS2007 and CS2008 databases.

Dan

Integrating Graffiti Logins with an asp.net datastore (like CommunityServer)

DanB — Mon, 05 May 2008 19:17:00 GMT

As announced way back at CSDC 07 (http://kevinharder.com/blog/live-blogging-the-csdc-part-3/) graffiti was designed to be able to integrate directly with an existing asp.net membership store... the key is in the configuration....

So first thing is to get the membership set up... this requires several changes to your web.config on your graffiti site...

You will need a connection string in the <ConnectionStrings> section pointing to the database which has your asp.net auth tables.. it will look something like this...

Since I am using an active community, I will go to the CS site and create the default graffiti roles... (gAdmin, gManager, and gContributor, and add you current admin to the gAdmin role)... Otherwise you need to run the script "Graffiti_ASPNet_Membership_Provider_Data.sql"; this script will try to create a new application so you really only want to run portions of it, ensuring the correct applicationid guid in order to have all logins under a single aspnet forms auth "application".

Next you need to update the "User Provider".

and finally uncomment the included <membership />, <roleManager /> and <profile /> sections of the web.config; be sure to update the applicationName property of each by default graffiti uses "/graffiti" for the application name, by default cs uses "dev" if you want to use existing cs users, you will need the application name that exists in your aspnet_Applicaitons table.

Thats it... you should be able to log into graffiti using your existing cs users... but wait, theres more... we can now do shared authentication / single signon with a few more steps...

First, you will need to specify validation and decryption keys for all the applications you want to share logins... this goes in the web.config under <system.web> (edit the guids a bit for security)

*Note: if you are updating an existing applicaitons machine keys, you should really change the name of the "auth cookie" to prevent existing persisted logins from getting a decryption exception. This will also force all users to re-login...

As infered by the note above, we have to use the same cookie names for our applications... this is done by editing the <authentication> section of the web.config (I typically just link to the existing communityserver cookie, by changing the graffiti web.config as below)

*Note: you could redirect all users to the cs login page by providing an absolute path to the login url, the page will redirect back to the graffiti site properly; this also has the advantage of leveraging the CS registration forms and process.

and finally we need to use the same cookie name for the <roleManager> by editing the cookieName property... again I set the property in graffiti equal to the default cs value ".CSRoles" (without this step, your username will show in graffiti, but if you didn't use the graffiti login form, you would not have any more permissions on the site than anonymous, until you re-logged in).

A few items of interest... at this time it appears that graffiti lowercases all the user names, and uses that for the "ProperName" so CS users without an extended attribute "ProperName" will only see their lowercased user names, a CSModule would be a good way to keep display name in sync with this "ProperName" field. Of course you will have to use the CS membership system to edit your users; but it appears that graffitis "people" page can only be used to edit users in the local graffiti database anyways (likely the only user you will see in graffiti is admin).

Dan

CS REST in Javascript

DanB — Thu, 01 May 2008 03:12:00 GMT

CS Rest Endpoints return XML, but JSON is much cooler for working with the data in javascript, you can get the results back in JSON and actually iterate through collections and such... To convert the data to JSON, in leu of server calls to do this, Thomas Frank has posted a nice JS library to pull this off...

http://www.thomasfrank.se/xml_to_json.html

Dan

Color outside the lines with the CS API

DanB — Wed, 30 Apr 2008 21:31:00 GMT

With the release of CS2008, we have released the REST webservice code for the first time... This webservice has a client API which is used by the server, and actually is in the bin folder of your CS site... CommunityServer.WebServices.dll. Referencing this file in a project will allow you to do things like.

Service rest = new Service("http://localhost/cs");
List<BlogGroup> blogGroups = rest.Blogs.GetBlogGroups();

This is all being documented here at http://api.communityserver.org

There are some places however, where the client api might not yet have an implementation for accessing endpoints on the server. For those cases I wrapped and exposed the communications calls in the dll. Allowing for calls like.

ManualRequest rest = new ManualRequest("http://localhost/cs");
BlogGroupListSerialized blogGroupListSerialized =
rest.Get(rest.Urls.BlogGroupsUrl()).GetResponseObject<BlogGroupListSerialized>();

The methods return strings, which are XML.. So you can use the GetResponseObject to get the related Type, or just use XPath and open the doc as native XML.

A place where we are missing some client api methods for example are things like post extedned attributes or ratings...

RatingListSerialized ratingListSerialized = rest.Get(rest.Urls.BlogPostRatingUrl(blogId, blogPostId));

//rate a post with 4 stars
int responseRating = rest.Put(rest.Urls.BlogPostRatingUrl(blogId, blogPostId, username), "<int>4</int>");

Extended attributes are availabe for "Section" objects, "Post" objects and "User" objects (except for posts in a group / hub)

endpoint urls would be like

/api/blogs.ashx/blogs/{blogid}/attributes returns an ExtendedAttributeListSerialized object which is a list of ExtendedAttributeSerialized objects (Supports GET HEAD and POST)

ExtendedAttributeListSerialized attributeListSerialized = rest.Get("http://localhost/cs/api/blogs.ashx/blogs/10/attributes");

/api/blogs.ashx/blogs/{blogid}/attributes/{attribute name} which returns a <string> (Supports GET HEAD PUT and DELETE)

string attribute = rest.Get("http://localhost/cs/api/blogs.ashx/blogs/10/attributes/abouttitle");

Only site admins can access extended attribute urls. You PUT and POST XML encoded strings... like <string>Hello World</string>

A compiled DLL (DanBartels.CS.REST.Dll) is included as well as the source and some basic unit tests... Assuming you have your CS install available with the sample data at http://localhost/cs

Dan

Online Music - Great Free Service - Pandora.com

DanB — Tue, 26 Feb 2008 14:52:00 GMT

I have enjoyed streaming a vast variety of Internet music for some time... I like the ability to discover new artists and music as well as a nearly infinite selection of styles and artists to suit my mood.

I have to say of all of the services I have tried, Yahoo music did the best. They had a decent selection of downloadable music, but even more content they could stream to you, and I made great use of their "Artist Fan Station" Feature... which let you browse to an artist, and hear similar music, either by that artists or by other artists which were rated highly by people who liked that artist. They made extensive use of their music and artist rating systems to datamine information, the result was very good; Their client software, Vista, and then X64 support was terrible... and left me searching for a new music service..

So I tried URGE, Microsoft's answer... well it worked in X64 and supported plays for sure; even used the same back end data of Yahoo music for the library, but their client was dumb, dumb, dumb... a few celebrity raido stations, bad "similar artist" selections, no access to music that wasn't downloadable; which cut the artist and song selection way down for me... and ultimately I couldn't find any music I wanted to listen to that I didn't already own.

Then came Zune... Well its better, but again their UI is frustrating, you cant really discover anything, unless its new and advertised to you "Clear Channel Style"... So much for broadening your music tastes, or discovering new artists.. and they seemed to do away with the idea of radio stations all together.... And ratings, well I guess I wast sophisticated enough to rate my own music... So there were starts, but I don't know where they came from... The future ui, got worse not better, it got even harder to make your own playlists, apparently if they weren't going to do "stations" then neither should you... If this wasn't pretty much the only way to manage music on my mp3 player, it would be so uninstalled. (just waiting for the USB Mass Storage Driver for the Zune, so it will show up as a drive letter, no wonder why Microsoft doesn't want one out there)...

Then relief finally came my way... A really nice radio station only type of service... Pandora.com... O and its free... You set up your own stations based on artists or songs you like, and it streams away; the music index is based off the Music Genome Project a database of music based on musical styles and characteristic (not marketing and advertising departments)... their client is flash based, and so it runs in your browser... if you find a new song or artist, you can just bookmark it, and head over to Amazon and pickup the Mp3's ... no drm, no hassle, no subscription, and off you go...

If you haven't tried Pandora, I strongly recommend you check it out.

Thanks for the tip Wyatt

Dan

Improve Vista Performance

DanB — Tue, 26 Feb 2008 14:41:00 GMT

Ran across these couple of tips on the Internet the other day, and thought I would pass them along...

First, my own tip, make sure you have the latest video driver installed... chances are pretty good that your video card is the lowest ranked item in your preformance index, its amazing what a new driver can do for the performance and stability of your system (not always a good thing, but in general its a good idea to keep your driver updated).

Second, disk performance... Vista has advanced output caching support for SATA drives... if you have a batter backup, or are on a laptop... Go into device manager, and right click on your disks, select properties, then on the policies tab, mark the "Enable Write Caching" and "Enable Advanced Performance" options.

Lastly, I would recommend disabling the network "auto tuning" feature, its supposed to dynamically adjust the packet size for network performance, but lets face it, our home networks are not what this was targeted at. Its actually hurting your network performance, by trying to tune it... Open an administrative command prompt, and type.... "netsh int tcp set global autotuninglevel=normal"

The attached article also talks about how to disable UAP, the popup asking for administrative permission when you do a task that requires it... I run with UAP enabled, but I realize most people despise it... There is a nice tool out there... Tweak UAC to help kill the feature, if you are in need of that, this should help you get it done (http://www.tweak-uac.com/)

Dan

http://vista.blorge.com/2008/02/25/how-to-fix-three-broken-features-of-vista/

ScriptResource.axd Time Sensative

DanB — Thu, 24 Jan 2008 19:02:00 GMT

In CS 2008 we have our javascript files linked through the scriptresource.axd handler. This is very similar to the webresource.axd handler in that it serves content from within a dll. The gotcha is that the scriptresource handler will throw an exception if the timestamp of the assembly is newer than the current server time... This is not timezone aware.

The result... Your in central time, you compile CS, and deploy it to your server in say pacific time, and vola... you get javascript errors.... why? well the scriptresource.axd will throw an exception because it thinks the dll is invalid because its timestamp is newer than the server time.... the error magically goes away in two hours, because now the server thinks the dll time is ok...

Its important to note, this is not a CS bug, but rather how the Microsoft script handler scriptresource.axd is coded.

To work around the issue, set the time on your development workstation to the same time as your server, before you build.

Dan

Windows Vista SP1 RC1 Released

DanB — Wed, 12 Dec 2007 17:07:00 GMT

Microsoft has made the current release of Vista RC1 available to early adoptors via Windows Update or as a stand alone download (~850mb).

http://www.microsoft.com/downloads/details.aspx?FamilyID=9de6260e-4275-482d-9524-de850c4dd91c&DisplayLang=en

Dan

You may also note a Office 2007 Sp1 was released today

http://office.microsoft.com/en-us/downloads/default.aspx?ofcresset=1

The Vista SP1 Download is a small Zip file with some documentation and a registry script to make it so you can see the SP in Windows Update

reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\VistaSp1 /f > NUL 2>&1
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\WindowsUpdate\VistaSP1 /f > NUL 2>&1

reg add HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\VistaSp1 /v Beta1 /t REG_SZ /d c92ef077-adc4-46ef-b96b-02a42d60ede5 /f

Further, you can get the stand-alone installers at

32 bit - http://www.microsoft.com/downloads/details.aspx?FamilyID=be34577a-e925-48fb-9d6d-50fe9461f808&DisplayLang=en

64 bit - http://www.microsoft.com/downloads/details.aspx?FamilyID=c21c3978-3b7d-4d64-873b-3c9d26982d7a&DisplayLang=en

Kevin Harder Live Blogging the CSDC

DanB — Sun, 21 Oct 2007 14:38:00 GMT

We are having an awesome time at the Community Server Developers conference, developers from around the ~~country~~ world have converged to hear about the future and direction of Telligent development.

Kevin Harder has been blogging the event for those who can only attend in spirit. We have been recording all of the presentations; and hopefully our video blogging champion Ado, will have some downloads soon...

Dan

Check out the live blog at

http://kevinharder.com/blog/archive/2007/10/20/live-blogging-the-csdc.aspx

http://kevinharder.com/blog/archive/2007/10/20/live-blogging-the-csdc-part-2.aspx

http://kevinharder.com/blog/archive/2007/10/21/live-blogging-the-csdc-part-3.aspx

Win2008 RC0 install fails x8007045d

DanB — Mon, 15 Oct 2007 15:20:00 GMT

The current installer locks access to the disk open, so if you did something, like asked it to "format" your disk prior to installing Windows Server 2008, the format process will silently fail, the copy files will silently fail, and you will get a x8007045d during the expanding files portion of the install.

You will need to reboot, choose repair instead of install, click next on the choose OS dialog, then command prompt, and manually format your drive (format c:). You should then be able to continue the installation.

Dan

Amazon Mp3 has arrived (public beta)

DanB — Tue, 25 Sep 2007 16:29:00 GMT

As I speculated based on internet rumors nearly a year ago (http://blog.danbartels.com/archive/2006/12/26/good-bye-yahoo-music-hello-zune.aspx) Amazon has jumped into the online music sales foray... Now you didn't need to be psychic to guess this, it seems to be a natural fit for the e-tailer. While the .89 and .99 cent 256 kbit Mp3 tracks are arguably more expensive that Russian site (AllOfMp3.com and their derivatives) its nice to have a DRM free music choice in the popular Mp3 format.

Check out their selection Amazon.com Mp3

I just hope that now that they have built the marketplace, they find ways to play nice with the independent music scene, I would also love to see a subscription option!

Dan

Extracting ExtendedAttributes via SQL

DanB — Fri, 11 May 2007 22:15:00 GMT

In Community Server, several of our classes derive from the ExtendedAttributes class. This class creates a list of name value pairs on the class, and is picked off by our data layer and stored into two NTEXT columns in the table, PropertyNames, and PropertyValues. This pattern is derived directly from the way that the ASPNET membership system implements this capability in the ASPNET_PROFILE table. It allows you to define, and persist custom key value data with an item in the database without need to make schema changes. Whats good about this, is its easy for a developer to save and retrieve custom pieces of information about the object, whats bad is its stored in an unfriendly way in the database and is very difficult to query against.

SELECT PropertyNames, PropertyValues FROM cs_Sections WHERE ApplicationKey = 'sample'

yieds a result of

PropertyNames
--------------------------------------------------------------------------------------------------------
SectionOwners:S:0:5:CategorizationType:S:5:1:aboutTitle:S:6:12:

PropertyValues
--------------------------------------------------------------------------------------------------------
admin1About Sample

In recently working with this, I wrote a bit of SQL to help extract a value from the PropertyValues column where you know the specific key. I use this in a SQL script to populate a temp table which I can then join against; In this case I am trying to extract the section owner, which happens to be at the beginning of this property value collection, but doesnt need to be...

This SQL will extract the Owner Name and the Primary Key which in this case is a column called SectionID

DECLARE @PropertyString NVARCHAR(50)
DECLARE @PropertyDelimiter NVARCHAR(50)

SET @PropertyString = '%SectionOwners:S:%'
SET @PropertyDelimiter = '%:%'

SELECT
SectionID,

SUBSTRING(PropertyValues,

CONVERT(int, SUBSTRING(SUBSTRING(PropertyNames, PATINDEX(@PropertyString, PropertyNames) + LEN(@PropertyString)-2, 100),0,PATINDEX(@PropertyDelimiter, SUBSTRING(PropertyNames, PATINDEX(@PropertyString, PropertyNames) + LEN(@PropertyString)-2, 100))))+1,

CONVERT(int, SUBSTRING(SUBSTRING(SUBSTRING(PropertyNames, PATINDEX(@PropertyString, PropertyNames) + LEN(@PropertyString)-2, 100),PATINDEX(@PropertyDelimiter, SUBSTRING(PropertyNames, PATINDEX(@PropertyString, PropertyNames) + LEN(@PropertyString)-2, 100))+1,100),0, PATINDEX(@PropertyDelimiter, SUBSTRING(SUBSTRING(PropertyNames, PATINDEX(@PropertyString, PropertyNames) + LEN(@PropertyString)-2, 100),PATINDEX(@PropertyDelimiter, SUBSTRING(PropertyNames, PATINDEX(@PropertyString, PropertyNames) + LEN(@PropertyString)-2, 100))+1,100))) -1)

) as Owners from cs_Sections WHERE PATINDEX(@PropertyString, PropertyNames) > 0

This code basically finds all the rows that have the property, the property is defined as [PropertyName]:[DataType]:[Begin]:[Length] or ( SectionOwners:S:0:5 ) so the first big SUBSTRING, is getting the first integer after the PropertyName:Datatype:, and the second is getting the next integer after the first, which is the length... (the only real assumption in the above code, is that the combined digits of the [begin]:[length] cannot exceed 100... I am grabbing only the first 100 cars after the PropertyString to find the integers in)

While my tests on SQL2005 seem to indicate that this is not a horrible query performance wise, I wouldn't want to constantly be doing this type of string manipulation, So I would only recommend this for reporting, special one off queries, or to use on a relatively infrequent process, like item save, to peel off the custom data and put it in an indexable location.

Show your CS2007 stuff and Win

DanB — Fri, 27 Apr 2007 20:14:00 GMT

Telligent is having a little contest to see who can build the best theme for CS... There are a couple of contests actually, one showcasing our new theme / markup system for full site themes, and another to creatively use the "export" option of our dynamic theme export feature.

The prizes include two MacBooks and Two XBox 360 Elites.

Check out the official page!

http://docs.communityserver.org/wiki/page.aspx/239/community-server-2007-theming-extravaganza/

Dan