Use this conversion utility if you have already used the installer to upgrade Knowledge Center to 12.1 and now need to convert the data from a Usage Tracking 3.6.1 installation.
The existing tracking data is converted from Usage Tracking into Knowledge Center data by connecting to the Usage Tracking data source and pulling the data into the Knowledge Center data source. To make this connection, you can provide a web.config file from Usage Tracking, or you can supply the connection string that the current version of Usage Tracking uses to connect to its data.
When you upgrade Usage Tracking:
All user tracking data is converted.
Any custom reports are converted and are available in the Reports Management application in Knowledge Center. See the Reports Management guide for more information.
Users with administrator permissions in Usage Tracking are converted to Managers in Knowledge Center.
Users with reporting permissions in Usage Tracking are converted to Reporters in Knowledge Center.
All other users are preserved, with one exception. If you used NT authentication for Usage Tracking, and there are users, including reporters, who have never taken any content, the users must be recreated in Knowledge Center.
All content must be republished in the new version of the Developer. You can publish content directly to the Knowledge Center server. See Publish Content in the Content Development guide for more information.
To upgrade Usage Tracking with the conversion utility, navigate to the installed files for Knowledge Center. In a default installation, the path is: C:\Program Files\User Productivity Kit\Knowledge Center\Web Server\KData\bin. This path may vary based on your installation. Launch the UsageTrackingConversionWin.exe file. During conversion, you proceed through these screens in the utility.
Knowledge Center: You must log in and establish a connection to the Knowledge Center server to which you want to convert the Usage Tracking data. Select or add the server to the list, and then enter the login credentials for the account with sufficient rights (Admin or Manager).
Get Usage Tracking Database Connection String: You can provide a web.config file from Usage Tracking, or you can supply the connection string that the current version of Usage Tracking uses to connect to its data. If you select the Get the connection string from the Usage Tracking Web.config file option, click the Browse button and navigate to the location of the Web.config file in the current Usage Tracking installation. If you select Enter the connection string manually, choose System.Data.OracleClient. Enter the connection string in this form: Data Source=<Oracle_sid>; User ID=<username>; Password=<password>. Supply the Oracle_sid, username, and password for the server on which the Usage Tracking database is installed.
Usage tracking Conversion settings: Specify a location in which to save the conversion log file. You can also choose to log the failed records only.
Conversion Progress: Displays the progress of the conversion. When conversion is completed, you can choose to open the log file when you click Finish.