Move to subtext

After fiddling with upgrade of CommunityServer 2.x for a while, I finally took a plunge to convert to SubText. Its interface and simplicity is much more usable, and the metablog api to publish through Word 2007 is awesome. Hope to put out much more post in near future. I still need to port over the comments from the old site, which I'll be doing in next couple days. If anyone is interested in the SQL to import posts let me know. I already have one, it's raw, but should work for you.

Print | posted on Sunday, October 14, 2007 9:59 PM

Feedback

# re: Move to subtext

Left by David Osborn at 10/15/2007 8:01 AM
Gravatar Looks good, but you may want to modify the background it is a bit hard to read on this post. Let me know if its easy to include pictures with your post using Word 2007 and maybe I'll switch to subtext.

# re: Move to subtext

Left by Steve at 10/16/2007 8:36 AM
Gravatar Definitely post your SQL for your conversion of posts and comments. Did you use BlogML at all?

# re: Move to subtext

Left by Bigyan at 10/17/2007 6:39 PM
Gravatar Steve, here's the script. This is not the final product so you may want to test it out. Also it does not include comments, it basically generates insert for subtext

-- =============================================
-- Declare and using a READ_ONLY cursor
-- =============================================
DECLARE test CURSOR
READ_ONLY
FOR
select

'Insert Into subtext_content(Title,DateAdded,PostType,Author,Email,BlogId,DateUpdated,[Text],FeedBackCount,PostConfig,
EntryName,DateSyndicated) Values('''
+[Subject]+''','''+Cast(PostDate as varchar)+''',1,''Bigyan Rajbhandari'',''email@email.com'',0,getdate(),'''
+Replace(Cast(FormattedBody as varchar(7600)),'''','''''')+''',0,93,'''+
Replace([Subject],' ','-')+''',getdate())'
From cs_posts where postlevel=1
order by postdate



DECLARE @name varchar(8000)
OPEN test

FETCH NEXT FROM test INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
print ''
print @name
END
FETCH NEXT FROM test INTO @name
END

CLOSE test
DEALLOCATE test
GO

# re: Move to subtext

Left by Bigyan at 10/18/2007 11:03 AM
Gravatar Steve, looks like blogML might be a good option to use.

Your comment:





 
Please add 6 and 6 and type the answer here:

Copyright © Bigyan Rajbhandari