posts - 380, comments - 634, trackbacks - 117,
Dan Bartels online engineering logbook... Items that I find useful organized for my use, and indexed by google for yours. Here you can find information about Microsoft C# programming, SQL SERVER 2005, Telligent Systems CommunityServer, Dot Net Nuke, Windows Vista / Longhorn, and just about anything else that would compel me to type.

News

What I am Reading:


Professional Community Server

Past books can be viewed on:

Post Categories

Archives

Coding Techniques

Coding Tools

Community Sites

Deal Finders

Friends Businesses

Microsofties

Smartphones

Utilities

my blogmap
Copying Theme Configuration and Widget Layouts

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

::

Comments

No Comments

Leave a Comment

(required) 
(required) 
(optional)
(required) 
 
Powered by Community Server (Commercial Edition), by Telligent Systems
powered by god (with a little help from Telligent Systems - Community Server 2.1)