This forum is obsolete

This support forum has been replaced by a news version. You can browse old posts in this forum, but please post your questions to the new forum by clicking on "Support" in the top level menu.

Support Forum
Subject: Support for Core Taxonomy as Categories?
Prev Next
You are not authorized to post a reply.

Author Messages
Steven Webster
Diamond Member

01/10/2013 5:07 PM  
Wondering if you have plans to use the core taxonomy within DNN as categories within UVG?

Steven Webster, An Independant Community for DNN Users
Pengtsen R

01/11/2013 12:23 AM  
This script should help you:

if exists(select * from dbo.sysobjects where id = object_id('{databaseOwner}{objectQualifier}Taxonomy_Vocabularies') and type = 'U')

declare @VocabularyID int
select @VocabularyID = VocabularyID from {databaseOwner}{objectQualifier}Taxonomy_Vocabularies where Name='Module_Categories'

declare @TermId int
if not exists (SELECT * FROM {databaseOwner}{objectQualifier}Taxonomy_Terms WHERE Name='UltraVideoGallery')
Insert {databaseOwner}{objectQualifier}Taxonomy_Terms(VocabularyID, Name, Weight, TermLeft, TermRight) Values(@VocabularyID, 'UltraVideoGallery', 0, 0, 0)
select @TermId = SCOPE_IDENTITY()
select @TermId = TermId from {databaseOwner}{objectQualifier}Taxonomy_Terms where Name = 'UltraVideoGallery'

Delete {databaseOwner}{objectQualifier}ContentItems_Tags Where TermID = @TermID

INSERT INTO {databaseOwner}{objectQualifier}ContentItems_Tags (TermID,ContentItemID) SELECT @TermID, ContentItemID from {databaseOwner}{objectQualifier}DesktopModules where FolderName='UltraVideoGallery'


Pengtsen R
You are not authorized to post a reply.
Forums > Ultra Video Gallery > General Questions > Support for Core Taxonomy as Categories?

Copyright © 2005-2013 BizModules Contact us