jan-h
6/16/2016 - 9:45 AM

SDL Tridion / SDL Web Legacy Items

SDL Tridion / SDL Web Legacy Items

legacy-items.md
content_copyfile_download
  • Rendered
  • Source

Used Item types and sub types

Disclaimer: This information is a good start but might not be complete. The tables below contain a list of known legacy item types/subtypes but there are probaby some more.

Check which item types are used and count them. This gives an general idea of technologies used, and specifically if legacy techologies like VBScript are used. A database with any legacy items (even if not published) must not be upgraded to a Tridion CM version without legacy pack. The upgrade will work but later upon browsing the CM (Either through CME or API) errors will appear because the Trdion CM does not understand the legacy items without the legacy pack installed.

Also see this list of item types http://tridion.stackexchange.com/questions/3014/static-ids-in-tridion

Query

SELECT TOP 1000 [I].[ITEM_TYPE]
      ,[I].[SUB_TYPE]
      ,COUNT([I].[ID]) as COUNT
  FROM [Tridion_cm].[dbo].[ITEMS] I
  WHERE VERSION = (SELECT MAX(VERSION) FROM [Tridion_cm].[dbo].[ITEMS] I2 WHERE     I2.PUBLICATION_ID = I.PUBLICATION_ID AND I2.ITEM_REFERENCE_ID = I.ITEM_REFERENCE_ID)
  GROUP BY [ITEM_TYPE], [SUB_TYPE]
  ORDER BY [I].[ITEM_TYPE], [I].[SUB_TYPE]

The query returns something like this

ITEM_TYPE     SUB_TYPE     COUNT
8             0            131
8             1            11
8             2            114
8             3            9
8             4            5
8             5            1
8             6            30
16            0            437950
16            1            41868
32            1            13
32            3            1
32            4            153
64            NULL         46025
128           1            7
128           4            57
1024          NULL         2411
2048          1            3
2048          3            110
2048          4            4
2048          5            6
2048          6            150
2048          7            218

Item types

The query results contain the item types and sub types used in the Content Manager. From here you can derive which legacy items are used.

Component Templates

  • Item type 32, sub type 1: VBScript [Legacy]
  • Item type 32, sub type 2: Jscript [Legacy]
  • Item type 32, sub type 3: XSLT [Legacy]
  • Item type 32, sub type 4: Compound Template
  • Item type 32, sub type 5: XSLT (new)

Page Templates

  • Item type 128, sub type 1: VBScript [Legacy]
  • Item type 128, sub type 2: JScript [Legacy]
  • Item type 128, sub type 3: XSLT [Legacy]
  • Item type 128, sub type 4: Compound Template
  • Item type 128, sub type 5: XSLT (new)

Template Building Blocks

  • Item type 2048, sub type 1: VBScript [Legacy]
  • Item type 2048, sub type 3: XSLT
  • Item type 2048, sub type 4: Compound Template
  • Item type 2048, sub type 5: .NET Assembly
  • Item type 2048, sub type 6: C# Code Fragment
  • Item type 2048, sub type 7: Dreamweaver
  • Item type 2048, sub type ???: XSLT

Other

  • Item type 8 , sub type 0: Schema
  • Item type 8 , sub type 1: Multimedia schema
  • …