Converting Siebel Web Templates with the SWT to OD Conversion Utility

The SWT to OD Conversion Utility converts Siebel Web Templates to an Object Definition Layout. Converted Web templates are stored in the database.

The SWT to OD Conversion Utility runs as part of the upgrade process. Use the procedures in this topic to manually run the SWT to OD Conversion Utility. The SWT to OD Conversion Utility can also be run manually if you need to run template migration for a few templates i.e., for importing non-existing custom web templates. However, all templates are migrated during the upgrade process.

Running the SWT to OD Conversion Utility

Navigate to the following directory:

Windows: $DbsrvrRoot\common folder

UNIX: $DbsrvrRoot\common folder
Run the following command:
```
java -jar $DbsrvrRoot\common\SWTClob.jar /s $SiebelRoot /c "$ODBCDataSource" 
/t$TableOwner / u $TbloUser /p $TbloPassword /o $SiebelLogDir /d 
$DatabasePlatform/r $RepositoryName /j $WebTemplatesDir /w $WSUSerName /x 
$WorkspaceName /b $ParentWS /i $WebTemplateName
```
Where:
- $DbsrvrRoot is the path of the database server installation.
- $SiebelRoot is the path of the Siebel Server installation.
- $SiebelLogDir is the path to the log directory.
- $DatabasePlatform is the database platform, such as Oracle, DB2UDB, MSSQL, and DB2390.
- $RepositoryName is the Name of the Repository, for example, Siebel Repository.
- $WebTemplatesDir is the directory for Web Templates, for example, $SiebelRoot/Webtempl.
- $WebTemplateName is the list of template names for the incremental migration.
  Note: The physical web template files corresponding to the web template names passed using this parameter should exist in the file system. If not passed, all Web Templates are considered for the incremental migration. Multiple template names should be passed comma separated. for example, /i "Banner,Abcd,Advanced Search".
  
  The following are the optional parameters that are applicable only for the Workspace Environment.
- $WSUserName is the Workspace owner user, for example, SADMIN.
- $WorkspaceName is the new Workspace Name which will be created by the process automatically. for example, dev_xxxx_xxx.
- $ParentWS is the Workspace name under which the $WorkspaceName needs to be created, for example, MAIN.
Review the SWTClob log and verify that SWTClob ran without errors.

Windows: $SiebelLogDir\SWTClob.log

UNIX: $SiebelLogDir/SWTClob.log

For more information about troubleshooting and verifying the results of the Web template migration process, see Using Siebel Tools.