Skip to content

Instantly share code, notes, and snippets.

@jhorsman
Last active November 7, 2018 09:55
Show Gist options
  • Save jhorsman/ea710455b86df711b5aea971ccd54b83 to your computer and use it in GitHub Desktop.
Save jhorsman/ea710455b86df711b5aea971ccd54b83 to your computer and use it in GitHub Desktop.
SDL Tridion / SDL Web Legacy Items

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 8: Razor Custom mediator
  • Item type 2048, sub type 9: ??? possibly custom XSLT mediator
  • Item type 2048, sub type 10: XsltTemplate (the native Tridion XSLT template)

Schemas

  • Item type 8 , sub type 0: Schema
  • Item type 8 , sub type 1: Multimedia schema
  • Item type 8 , sub type 2: Embeddable schema
  • Item type 8 , sub type 3: Metadata schema
  • Item type 8 , sub type 4: Protocol
  • Item type 8 , sub type 5: Virtual folder
  • Item type 8 , sub type 6: Parameter schema
  • Item type 8 , sub type 7: Bundle schema

Components

  • Item type 16, sub type 0: Component
  • Item type 16, sub type 1: Multimedia component
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment