free geoip Migrating From .Text to Community Server 2.0 - protected virtual void jaysonBlog
in

jaysonKnight.com

Welcome to my corner of the internet

protected virtual void jaysonBlog

A conduit to the voices in my head

Migrating From .Text to Community Server 2.0

Generally speaking, this post will only apply to those folks who either A) used .Text .95 as their blogging engine before migrating to CS 1.x (and are looking to upgrade to 2.0) or B) ran their CS site in “single” blogger mode (and are also looking to upgrade).  At first I thought I was the only one who experienced these issues, but I’ve seen some reports of the same behavior over on the CS.org forums.  There is the potential for either (or both) of the following behaviors:

  • All comments show up under the blog owner’s name instead of the name the commenter left.  If you’re coming straight from .Text to 2.0 this will be obvious on all posts.  If (like myself) you went from .Text to 1.x, stayed on 1.x for a while, then went to 2.0, you’ll need to check your posts from prior to the date you migrated from .Text to CS.  While I haven’t nailed down the specifics as to why this happens, it appears there was a change from CS1.x in the way CS2.0 scans usernames in the cs_posts table.  A simple query will clear this up (end of this post).
  • This one is a little harder to explain, but will be very obvious after the upgrade if you’re experiencing it.  On the aggregate page, there might be a hole in the dates of posts, i.e. you might see 3 posts you made recently, then it jumps to posts you made some time ago.  This one is more likely to affect bloggers who were in single blog mode in CS1.x, and the reason is that the IsAggregated bit (3) wasn’t flipped for the PostConfiguration table.  Again, the fix is trivial.

Fix for the first bullet:

UPDATE [database_name].dbo.cs_posts
SET PostAuthor = 'Anonymous'
WHERE ApplicationPostType = 4 AND PostDate < 'date_you_migrated_from_.Text'
GO
UPDATE [CS_2.0].dbo.cs_posts
SET UserID = 1001 -- your anon UserID might be different
WHERE PostAuthor = 'Anonymous' AND ApplicationPostType = 4 AND PostDate < 'date_you_migrated_from_.Text'

Fix for the second bullet:

UPDATE cs_posts 
SET PostConfiguration = PostConfiguration + 2 
WHERE PostID IN (SELECT p.PostID FROM cs_Posts p, cs_sections s WHERE s.sectionid = p.sectionid AND s.applicationtype = 1 AND p.ApplicationPostType = 1 AND p.PostConfiguration & 2 = 0)

These are the only 2 issues I’ve seen crop up (besides all out failures of course), which for a migration of this magnitude is pretty impressive IMO.  It’s worth mentioning that a migration tool to go straight from .Text to CS2.0 will be released soon.  In the interim you must upgrade to 1.1 first (you can skip 1.0), then upgrade to 2.0.  This can be done in about an hour or so.  Anyone who has already migrated from .Text to CS2.0 feel free to share your experience here, and of course if anyone needs any assistance feel free to contact me.  Happy migrating.

Sidenote:  I’ve had a couple of people contact me about my CS test site.  Seeing as 2.0 has been released (and 2.1 is still a few months off…Scott is targeting some time in May), I took it down.  As we get closer to a 2.1 release I’ll put it back up for beta testers.  If you need to see a demo of CS2.0 in action, you can go here.

Share this post: Submit Migrating+From+.Text+to+Community+Server+2.0 to Technorati | Submit Migrating+From+.Text+to+Community+Server+2.0 to del.icio.us | Submit Migrating+From+.Text+to+Community+Server+2.0 to digg.com | Submit Migrating+From+.Text+to+Community+Server+2.0 to reddit.com | Submit Migrating+From+.Text+to+Community+Server+2.0 to DotNetKicks | Add Migrating+From+.Text+to+Community+Server+2.0 to Live Bookmarks
Only published comments... Mar 13 2006, 03:13 PM by Jayson Knight

Comments

 

Keyvan Nayyeri said:

This is much appreciated. As you said yourself, many many folks asked for this on Cs forums in recent months.
March 14, 2006 6:45 AM
 

Jason Haley said:

March 14, 2006 1:38 PM
 

protected virtual void jaysonBlog { said:

As there isn&rsquo;t really any clear documentation on how to upgrade to Community Server 2.0 from .Text,...
April 12, 2006 2:35 AM
 

Community Server Daily News said:

news of the day a grab bag for what&#39;s happening in Community Server We&#39;ll start today&#39;s news
July 11, 2006 1:20 PM
 

Sirsha Development Resources Blog said:

As Jayson mentioned (thanks for the ego-boost, man!), I used .Text far beyond any rational shelf-life

August 17, 2006 6:11 PM

Leave a Comment

(required)  
(optional)
(required)  
Add

About Jayson Knight

Jayson Knight was clueless to the computer programming world until he took a C++ class in college. The rest is proverbial history. He has been building applications targeting the .Net framework for 7 years, focusing mainly on internet technologies and database driven web application development.

Most recently he left the world of Corporate IT to finish up his degree in Chemistry, with an eye on Medical School and an Anesthesiology residency program. Read this post for more information.

He is also a Community Server MVP: Community Server is the software that runs this site, plus many others on the web. For more information, check out http://csmvps.com.

When he finds time to pry himself away from his computer and university studies, he can be found on the mountain bike trails when it's warm, and on the ski slopes when it's cold.

Copyright © :: JaysonKnight.com
External Content © :: Respective Authors

Terms of Service/Privacy Policy