jhorsman/legacy-items.md

## legacy-items.md

      
    Raw
  

              legacy-items.md
            
          
    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.

For a complete list of item types see http://tridion.stackexchange.com/questions/3014/static-ids-in-tridion
For more about template subtypes see the "Template Type" table in http://docs.sdl.com/LiveContent/content/en-US/SDL%20Tridion%20full%20documentation-v1/GUID-E0C35F84-36A5-46B3-8DF9-921CF6E40CB9

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