Home

Ektron CMS200 Setup Manual

1. A successful connection will be greeted with a connection id 5 Once you are able to make a connection type exit to get out of MySQL mysql gt exit Once you have created the database in MySQL you can now build the tables using the script provided by Ektron To build the CMS200 tables you need to run the script provided by Ektron named cms200_mysql_v16 sql 1 At the command prompt type e mysql Ektron CMS200 Setup Manual Version 1 6 81 e the database name e a lt e the location to the SQL script Here is an example of how the line might look C mysqhbin gt mysql CMS200 lt c program files ektron cms200 utilities cms200_mysql_v16 sql x CMS 266 mysql rows in set 6 66 sec mysql gt connect CMS200 Connection id 2i Current database CMS2066 mysql gt exit Bye C nysql bin gt mysql CMS200 lt C Program Files Ektron CMS266 Utili ties cms266_mysql_v16 sql1 _ If the script ran correctly MySQL will give you no feedback It will just send you back to the prompt you ran the script from If MySQL prints out a bunch of information you can assume something went wrong 2 To see if the script ran correctly access the database and request the list of tables created Use the following commands to do this Ektron CMS200 Setup Manual Version 1 6 82 C mysql bin gt mysql A mysql gt connect database name 7 mysql gt show tables ommand Pro C nysql bin gt m
2. Ektron CMS200 Setup Manual Version 1 6 75 Setting Up a MySQL Database Requirements NOTE As mentioned before Ektron CMS200 is compatible with a MySQL database To configure Ektron CMS200 to use a MySQL database you will need to perform a few basic tasks All this is described below e Windows NT 2000 e Stable version of MySQL 3 23 or higher recommended http www mysql org e MySQL ODBC driver 3 51or higher recommended http www mysql org e Ektron CMS200 v1 6 or higher earlier version will not work The latest versions of MySQL databases and drivers can be found at the following Web site http www mysql org Setting MySQL as a Database Type NOTE lt This step may be performed at anytime however you will not be able to use the Ektron CMS200 Web site with the MySQL database until this has been performed Open the setup asp file located in the cms200scripts directory Open the file in a text editor and locate the line DBtype which will be near the middle of the file Set the parameter within the quotes to mysql so it will read DBType mysql Before Dim DSN DBusername DBpassword fileUploadPath imageUploadPath AppConfStr Ektron CMS200 Setup Manual Version 1 6 76 Dim AppPostacceptFile sitePath AppName AppeWebPath AppPath buildNumber PostAcceptorFile Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_Sample sitePath
3. InstallShield Wizard Database Type Database Type Please select a database type MSSOQL requires MSSQOL Server to be installed locally and have the appropriate priveleges to create databases and tables Nesessessesssnsssssensenssnssnscnscnsened Microsoft SOL Server InstallShield lt Back Cancel Click on Microsoft Access then click the Next gt button at the bottom of the screen to continue NOTE For information about Installing a Microsoft SQL Server Database see Installing to a MS SQL Database on page 23 Setting up a MySQL database see Setting Up a MySQL Database on page 76 11 Once you have selected to install an Access database you will then need to specify where you would like to install the database to on the next screen seen below Ektron CMS200 Setup Manual Version 1 6 16 InstallShield Wizard Choose Destination Location Select folder where Setup will install files Setup will install the databases into the following folder To install to this folder click Next To install to a different folder click Browse and select another folder Destination Folder Cie vet ASS Browse InstallShield At this screen either keep the default location of the database or browse for a new folder to install it to Once completed click the Next gt button to continue 12 Once you have specified where to install the database to the next screen
4. Parent Folder Marketing New Folder Name Products Add Close Click the Add button in the Add New Folder screen Click the Close button to go back to the move content screen You will now be able to add content blocks to that folder by selecting it from the drop down list CMS200 Application Marketing New Folder Support Marketing MarketingProducts Repeat the process of adding content blocks to each of the folders by Selecting the folder from the drop down list 2 Selecting the content blocks you would like to move to the selected folder 3 Clicking the Move button in the center of the screen 4 Clicking the Add button at the bottom of the screen You will need to add all content blocks from Ektron CMS100 to Ektron CMS200 before you can proceed to the next screen Once you have finally moved all the content blocks from Ektron CMS100 to Ektron CMS200 click the Next button at the bottom of the screen to proceed to the end of the migration Ektron CMS200 Setup Manual Version 1 6 130 Migration from CMS100 for ASP A CMS200 Migration Utility You have successfully setup your CMS200 database The upgrade utitity has imported all your CMS100 express data to the CMS200 minimum database To complete the upgrade please take the folowing actions You must set the folder permissions within CMS200 You must set the library permissions Copy all your CMS1001 templates to the CMS200
5. Ektron CMS200 Setup Manual Version 1 6 88 MySQL ODBC 3 51 Driver DSN Configuration This dialog helps you in configuring the ODBC Data Source Name that you can use to connect to MySQL server DSN Information Data Source Name JcMS200_MySOL Description JMySaL DSN for Ektron CMS200 MySQL Connection Parameters Host Server Namefor IP localhost Database Name JoMS200 User Password Port if not 3306 2306 SOL command on connect Options that affects the behaviour of MyODBC 3 51 Driver V Don t Optimize Column Width D Pad CHAR to Full Length V Retum Matching Rows I Retum Table Names in SQLDescribeCol I Trace MyODBC J Use Compressed Protocol J Allow BIG Results Tl Ignore Space After Function Names Tl Don t Prompt on Connect J Force Use of Named Pipes J Enable Dynamic Cursor I Change BIGINT Columns to INT J Ignore in Table T No Catalog exp J Use Manager Cursors I Read Options From C my cnt 7 Don t Use Setlocale J Safety Check this if you have problems Tl Disable Transactions Help Test Data Source Cancel 7 Once you have entered all the correct information you can click Test Data Source to test the connection If the information is correct you will see a similar message Ektron CMS200 Setup Manual Version 1 6 MyODBC 3 51 DataSource Test E A x i MySQL ODBC 3 51 Driver 03 51 02 DataSource CM5200_MySQL Connected Succe
6. InstallShield Wizard Select Setup Type Please select your setup type Program will be installed with the most common options Recommended for most users Compact Program will be installed with minimum required options Custom You may choose the options you want to install Recommended for advanced users InstallShield lt Back Cancel At this screen you can choose which type of installation you would like to perform e Typical Recommended this will install all the files for Ektron CMS200 e Compact This will install the minimum amount of files e Custom You may choose the files and options that you want to install Once you have selected which type of installation you wish to run click the Next gt button to proceed 7 After you select the setup type you will then proceed to the following screen Ektron CMS200 Setup Manual Version 1 6 28 InstallShield Wizard Application Path Setup will install CMS200 components into the following folder To install to this folder click Next To install to a different folder click Browse and select another folder Destination Folder oreo Files Ektron CMS 200 Browse InstallShield Cancel At this screen specify the location where you wish to install the Ektron CMS200 components Either keep the default or browse for a new directory Once completed click the Next gt button to proceed 8 After you
7. This message informs you that the new version of Ektron CMS200 will use the old DSN but point it to the new database 16 Once you click OK you will see the next screen This screen informs you that all the site variables are being updated 17 Once the site variables are configured the installation is over and you will be able to access your upgraded Ektron CMS200 Web site Ektron CMS200 Setup Manual Version 1 6 55 Language Update Unlike previous versions of Ektron CMS200 version 1 6 comes installed with complete language support for French and German If you are upgrading from a previous version and are using your old database the translated strings are not include Because of this Ektron has included a utility in the 1 6 installation that will allow you to populate your old database with the translated strings This section will discuss the language upgrade utility and how to use it Upgrading Ektron CMS200 Before you can use the language upgrade utility you must first upgrade your version of Ektron CMS200 to 1 6 For information on this see Upgrading Ektron CMS200 on page 44 During the upgrade if you have opted to keep your previous database proceed with this chapter Accessing the Language Update Utility When the upgrade is complete the language utility will be installed to the following folder C Program Files Ektron CMS200 Utilities When you navigate to that folder you will see a list of
8. lt Dim DSN DBusername DBpassword fileUploadPath imageUploadPath AppConfStr Dim AppPostacceptFile sitePath AppName AppeWebPath AppPath buildNumber PostAcceptorFile Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_MySQL sitePath CMS200Sample buildNumber 1 6 DBusername DBpassword Version 1 6 UseSSL false SSL_Port 443 PostAcceptorFile uploader asp Designate the database type below Vaild values are mysql sql access DBType mysql1 DateFormat dd mmm yyyy hh mm ss AM PM Save the file and then begin using your Ektron CMS200 application Ektron CMS200 Setup Manual Version 1 6 97 Configuring Ektron CMS200 Configuring Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 98 SSL Support In Ektron CMS200 you can now SSL when logging in to your Web site This is an option that can be turned on or off depending on whether you would like to use it When you set up the SSL Certificate properly then configure Ektron CMS200 to use it the login page will be launched in a Secure Socket Layer This SSL support will allow the username and the user s password to be encrypted during transmissions to the server This chapter will discuss setting up the SSL for Ektron CMS200 Setting Up the Certificate If your Web server doesn t already have a certificate installed to it you will need to install one To do this 1 Access the Internet In
9. Ektron CMS200 Setup Manual Version 1 6 134 Migration from CMS100 for ASP NOTE You may need or want to stop the IIS Web Site Service that your accessing prior to changing the Local Path Ektron CMS200 Setup Manual Version 1 6 135 Customizing Ektron CMS200 Customizing Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 136 Language SDK Ektron CMS200 includes a very unique tool to allow customizing your application to over 120 different languages Using a tool supplied by Ektron you are allowed to customize all of the words and phrases necessary After translating all of the strings with the tool you will have the option to set the language active on the Web site This will cause all the current English strings to convert into the selected language The translation of all the strings must be complete in order for the language to be selectable for the site Out of the box Ektron CMS200 already comes with translated strings for e English US e French Standard e German Standard You will be able to set these languages active to your Ektron CMS200 application without using the language translating tool For information about setting these languages active see Active Languages on page 144 In the following instructions you will learn how to access convert and set your new default languages active for your Web site Before You Begin Before using the language translator utility Ektron advises
10. ebusiness the way it should be be aes We se 7 Setup Manual j y r a A a Version 1 6 Ektron Inc 5 Northem Blvd Suite 6 Amherst NH 03031 USA Tel 1 603 594 0249 Fax 1 603 594 0258 http Avww ektron com Copyright 2002 Ektron Inc All rights reserved Version 1 6 January 2002 Ektron CMS200 Setup Manual Version 1 6 EKTRON INC SOFTWARE LICENSE AGREEMENT READ THIS BEFORE LOADING SOFTWARE YOUR RIGHT TO USE THE PRODUCT ENCLOSED IN THIS ENVELOPE OR OTHERWISE DELIVERED IS SUBJECT TO THE TERMS AND CONDITIONS SET OUT IN THIS LICENSE AGREEMENT OPENING THIS ENVELOPE OR USING THIS PRODUCT SIGNIFIES YOUR AGREEMENT TO THESE TERMS IF YOU DO NOT AGREE TO THIS SOFTWARE LICENSE AGREEMENT YOU MAY RETURN THE PACKAGE WITH THE UNOPENED ENVELOPE OR AS IT WAS DELIVERED AND THE UNDAMAGED SOFTWARE ENCLOSED ALONG WITH THE RECEIPT TO YOUR SUPPLIER OR TO EKTRON INC WITHIN THIRTY DAYS FROM THE DATE OF PURCHASE FOR A FULL REFUND CUSTOMER should carefully read the following terms and conditions before using the software program s contained herein the Software Opening this sealed envelope and or using the Software or copying the Software onto CUSTOMER S computer hard drive indicates CUSTOMER S acceptance of these terms and conditions If CUSTOMER does not agree with the terms of this agreement CUSTOMER should promptly return the unused and unopened Software for a full refund Ektron Inc Ektron grants and the
11. OR CONSEQUENTIAL DAMAGES OF ANY KIND UNDER OR ARISING OUT OF OR IN ANY RELATED TO THIS AGREEMENT HOWEVER CAUSED WHETHER FOR BREACH OF WARRANTY BREACH OR REPUDIATION OF CONTRACT TORT NEGLIGENCE OR OTHERWISE EVEN IF COMPANY OR ITS REPRESENTATIVES HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH LOSS 6 Miscellaneous This License Agreement the License granted hereunder and the Software may not be assigned or in any way transferred without the prior written consent of Ektron This Agreement and its performance and all claims arising from the relationship between the parties contemplated herein shall be governed by construed and enforced in accordance with the laws of the State of New Hampshire without regard to conflict of laws principles thereof The parties agree that any action brought in connection with this Agreement shall be maintained only in a court of competent subject matter jurisdiction located in the State of New Hampshire or in any court to which appeal therefrom may be taken The parties hereby consent to the exclusive personal jurisdiction of such courts in the State of New Hampshire for all such purposes The United Nations Convention on Contracts for the International Sale of Goods is specifically excluded from governing this License If any provision of this Ektron CMS200 Setup Manual Version 1 6 iii License is to be held unenforceable such holding will not affect the validity of the other provisions hereof Failure of a part
12. Open the setup asp file located in the cms200scripts directory Open the file in a text editor and locate the line DBtype which will be near the middle of the file Set the parameter within the quotes to sql so it will read DBType sql Before lt Dim DSN DBusername DBpassword fileUploadPath imageUploadPath AppConfStr Dim AppPostacceptFile sitePath AppName AppeWebPath AppPath buildNumber PostAcceptorFile Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_Sample sitePath CMS200Sample buildNumber 1 6 DBusername DBpassword Version 1 6 UseSSL false SSL_Port 443 PostAcceptorFile uploader asp Designate the database type below t Vaild values are mysql sql access DBType access DateFormat dd mmm yyyy hh mm ss AM PM After lt Dim DSN DBusername DBpassword fileUploadPath imageUploadPath AppConfStr Ektron CMS200 Setup Manual Version 1 6 63 Dim AppPostacceptFile sitePath AppName AppeWebPath AppPath buildNumber PostAcceptorFile Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_Sample sitePath CMS200Sample buildNumber 1 6 DBusername DBpassword Version 1 6 UseSSL false SSL_Port 443 PostAcceptorFile uploader asp Designate the database type below Vaild values are mysql sql access DBType sql DateFormat dd mmm yyyy hh mm ss AM PM Sa
13. information into a string that can be used in Ektron CMS200 1 Right click on the UDL file you created earlier 2 Click Rename from the list of options 3 Rename the file MyUDLFile txt 4 You may get a warning message box explaining that changing file extensions may cause files to become unusable This is fine click OK 5 Double click on the file and you will see something similar to the following oledb Ektron CMS200 Setup Manual Version 1 6 109 Everything after this line is an OLE DB initstring Provider Microsoft Jet OLEDB 4 0 DataSource C Inetpub wwwroot CMS200Samp le database CMS200_v1_60_Access mdb Persist Security Info False 6 The following line is the connection string from the file Provider Microsoft Jet OLEDB 4 0 DataSource C Inetpub wwwroot CMS200Samp le database CMS200_v1_60_Access mdb Persist Security Info False This is what will be used when configuring Ektron CMS200 Configuring Ektron CMS200 to use the Provider String Once you have the provider string you will be able to configure Ektron CMS200 to use that 1 Using Windows Explorer navigate to the directory where Ektron CMS200 was installed to By default the directory is C Inetpub wwwroot CMS200Sample 2 Save the txt file under the CMS200Sample directory Open the folder cms200scripts 4 Edit the file setup asp lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildN
14. r Database Help Advanced Database C CMS200_v1_50_Access mdb Select Create Repair Compact r System Database None C Database System Database Options gt gt Ektron CMS200 Setup Manual Version 1 6 116 Migration from CMS100 for ASP 5 Click the Select button in the Database section to select the database the DSN will point to Database Name Directories OK vi 5 min_access2000 mdb c databases CMS200 v1_50 Acce E c Cancel aui cms200 v15 min acc E gt Inetpub Help E gt wwwroot Aa ample I Read Only a ried 4 T Exclusive List Files of Type Drives Access Databases m 7 c DONEIL gt Network i 6 Select the cms200_v15_min_access200 mdb file from the CMS200 databases directory 7 Click the OK button ODBC Microsoft Access Setup 2 x Data Source Name EMS 200_v1 _50_ Access OK Description Cancel r Database Database C cms200_v15_min_access2000 mdb Help E Create Repair _ Compact Advanced r System Database None C Database System Database Options gt gt 8 At the ODBC Microsoft Access Setup window click the OK button Ektron CMS200 Setup Manual Version 1 6 117 Migration from CMS100 for ASP 9 Click the OK button at the bottom of the ODBC Data Source Administrator menu to save and update the settings Once you have installe
15. select it and click the Open button Ektron CMS200 Setup Manual Version 1 6 69 7 Select the green arrow on the toolbar press lt F5 gt or select the execute command from the Query menu to run execute the script Query Tools Window Help J Change Database xecuting Query Ctrl U Ctrl F5 Alt Break amp 8 Display Estimated Execution Plan Ctrl L oreig D P CON 1E Index Tuning Wizard Ctrl I Results in Text Ctrl T t E Results in Grid Ctrl D oe P Results to File Ctrl Shift F fp cox geg Show Execution Plan Ctrl K Show Server Trace Ctrl Shift T eed Ml Show Client Statistics CtrltShift S Foreic 2X1St Current Connection Properties s select from dbo sysobjects t and OBJECTPROPERTY id N IsForeic After the script executes you will see a confirmation message that the command s completed successfully 8 Finally close the SQL Query Analyzer You now have a blank SQL database for Ektron CMS200 Creating New DSN Because you will now be using a MS SQL database you need to NOTE create a new DSN that will point to this new database This can easily be done by going into the ODBC Manager and pointing the DSN to the new MS SQL database For information about creating a DSN less connection to the MS SQL database for Ektron CMS200 see DSN less Connection on page 106 Ektron CMS200 Setup Manual Version 1 6 70 1 Enter t
16. sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200Sample buildNumber 1 6 0 05 DBusername DBpassword Version 1 60 UseSSL false SSL Port 443 Do not edit below her AppPath sitePath amp cms200scripts AppImgPath AppPath amp images application AppeWebPath AppPath amp ewebeditpro2 this path is realtive from the defualt root AppConfStr DSN amp amp DBusername amp amp DBpassword amp amp sitePath amp amp Version _ amp amp Request ServerVariables SERVER_NAME amp amp Request ServerVariables SERVER_PORT amp amp Request ServerVariables HTTPS amp amp DBType amp amp DateFormat AppName Ektron CMS200 S gt Make the following changes to the file e UseSSL true e SSL Port 443 unless you specified another SSL Port lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port oe AppiImgPath Dim DBType DateFormat DSN CMS200_v1_60_MSSQL Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200Sample buildNumber 1 6 0 05 DBusername DBpassword Ektron CMS200 Setup Manual Version 1 6 104 Version 1 60 UseSSL true SSL Port 443 Do n
17. t come with a MS SQL database ready it is possible to convert the Access database to a MS SQL database by using the sql script and data mover included in the CMS200 installation The steps are shown in the next chapter CMS200_v1_50 Access mdb The initial database for Ektron CMS200 is a Microsoft Access database This is the database for the sample Web site It contains users user group and content information e Two users 1 Administrator 1 Editor e Sample Content e Sample Images e Fonts cms200 v15 min _access2000 mdb This is a minimum database for Ektron CMS200 that has minimum e Two users 1 Administrator 1 Editor e Sample Content Ektron CMS200 Setup Manual Version 1 6 61 e Sample Images e Fonts NOTE You do not need Access installed on your system to use the sample database However you do need the MDAC and Jet Drivers listed in the system requirements Ektron CMS200 Setup Manual Version 1 6 62 Setting Up a MS SQL Database As mentioned before Ektron CMS200 is compatible with a MS SQL Database To create the MS SQL database all you need to do is to run the cms200_mssql_v15 sql script that is provided in the installation and a few other basic tasks All this is described below Setting MS SQL as a Database Type NOTE This step may be performed at anytime however you will not be able to use the Ektron CMS200 Web site with the MS SQL database until this has been performed
18. 84 Moving Data with cms200_datamover asp The first option for populating your new MySQL database is to run cms200_datamover asp which is located in the utilities directory You will need to run this from an ASP enabled directory on your web server For example http www YourSite com cms200sample utilities cms200_datamover asp 3 Data Mover for CMS200 Microsoft Internet Explorer Address http Maw YourSite comfcre200sanple utiities cm200_datamcver asp Content datamover for Ektron CMS200 This utility moves content from one CMS200 database to another You must create the new tables in the destination database and create a Data Source Name DSN for that database before running thes utility An example of this would be moving content from an Access database to a MS SQL Server database You would first create a new database in MS SOL Server with the crs200_mssqi_v15 sql script then enter the DSN of the source database and the DSN of the destination database and click Submit to start the move Source DB Type Access MS SQL MySQL Source DSN Source DSN Username Source DSN Password Destination DB Type Access MS SQL C MySQL Destination DSN Destination OSN Username Destination DSN Password Ektron CMS200 Setup Manual Version 1 6 91 Use the following table to properly complete the data mover Field Description Source DB Type Choose the source database type from the list In
19. CMS200Sample buildNumber 1 6 DBusername DBpassword Version 1 6 UseSSL false SSL_Port 443 PostAcceptorFile uploader asp Designate the database type below Vaild values are mysql sql access DBType access DateFormat dd mmm yyyy hh mm ss AM PM After lt Dim DSN DBusername DBpassword fileUploadPath imageUploadPath AppConfStr Dim AppPostacceptFile sitePath AppName AppeWebPath AppPath buildNumber PostAcceptorFile Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_Sample sitePath CMS200Sample buildNumber 1 6 DBusername DBpassword Version 1 6 UseSSL false SSL_Port 443 PostAcceptorFile uploader asp Designate the database type below Vaild values are mysql sql access DBType mysql DateFormat dd mmm yyyy hh mm ss AM PM Save and close this file Connecting to MySQL 1 First locate and open the DOS Command Prompt on your Windows machine NOTE If your DOS prompt opens with a prompt for a drive different than the one MySQL is installed to change to the correct drive Typing the correct drive followed by a colon can do this D gt C 2 From the prompt for the drive in which MySQL is installed use the cd command to switch to the directory where MySQL is installed C gt cd mysql bin This will take you to a prompt for the correct directory Ektron CMS200 Setup Manual Version 1 6
20. The background color of the 3 panels in the library are controlled by this class Ektron CMS200 Setup Manual Version 1 6 159 Images Application Images To change the look of the application through the use of a company logo or personalized logo there are two images that need to be changed The first image is called workarea_logo gif This image is the logo of the application and presently displays the Ektron CMS200 logo It lives in the application folder under the images directory By changing this image the application can be branded to display any other graphic or logo You must use the same size attributes of 155 pixels wide by 77 pixels high Alternate size attributes will cause the application to look wrong The second image that can be changed is navigation_edit gif This also resides in the application folder This image is used for the left bar in the edit content edit metadata edit summary and add content work areas This image can also be changed but must retain the same size attributes of 128 pixels wide by 500 pixels high There is also on image that makes up the blue gray background at the top of the workarea It is called workarea_back gif The size attributes are 50 pixels wide by 77 pixels high This image cannot be less than 50 pixels wide as Netscape will not repeat it correctly Language Images There are a number of language specific Images that are used at the top of the workarea They resi
21. an Access database begin by double clicking on the executable file that was downloaded from the Ektron Web site CMS5200 exe Running CMS200 Setup Once you have double clicked on the executable file for Ektron CMS200 the installation process will begin This section will explain each screen in the process of installing Ektron CMS200 with a MS Access database 1 The first screen that you will see is the splash screen Ektron CMS200 Copyright 2001 ektron Inc Ektron CMS200 Setup Manual Version 1 6 8 2 After the splash screen you will see the following screen InstallShield Wizard CMS200 Setup Welcome and thank you for installing CMS200 The following setup routine will allow you to install and setup your CMS200 site At this screen click Next gt to continue 3 Atthe next screen you are prompted with an option to install or upgrade Ektron CMS200 Setup Manual Version 1 6 9 InstallShield Wizard Xx Setup Type Choose the setup type that best suits your needs Select Installation Options C Upgrade InstallShield lt Back Cancel For this section we will choose Install Once you choose install click the next button to proceed NOTE For information about upgrading Ektron CMS200 see Upgrading Ektron CMS200 on page 44 4 Once you click the next button you will then be taken to the Ektron License screen Here you can view the license agreemen
22. change here and then click the Update button All CMS200 messages can be updated here not just the emails Please remember to remove these from the web site when you are done For more information regarding the language translator utility see Language SDK on page 137 Ektron CMS200 Setup Manual Version 1 6 152 Variables Shown below in the following table is a list of all the variables that you can use to customize your email messages By placing a variable in an email string the corresponding definition will be placed in the email sent to the user Variable Description appCRLF Inserts a carriage return into the message appContentTitle Displays the title of the content block appDeletionDateTime Displays the date and time the content will be deleted from the Web site appChangeDateTime Displays the date and time the new changes will be updated on the Web site appDeclinerFirstName Displays the first name of the user who declined the content block appDeclinerLastName Displays the last name of the user who declined the content block appSubmitterFirstName Displays the first name of the user who submitted the content block appSubmitterLastName Displays the last name of the user who submitted the content block appFolderPath Displays the location of the content block in the folder tree in the Ektron CMS200 Workarea appContentLi
23. chosen a name for the DSN click the Next gt button at the bottom of the page to continue NOTE For information about creating a DSN less connection using an OLE DB connection string see DSN less Connection on page 106 13 After you have configured all the database information you will need to enter the server host name at the next screen seen below Ektron CMS200 Setup Manual Version 1 6 InstallShield Wizard http localhost CMS2005 ample stall Shield The server host name is the path you will be using to access the Ektron CMS200 Web site At this screen you can either accept the default host name or enter your own Once completed click the Next gt button to continue 14 The next screen will assist you in creating a short cut in your start menu in Windows Ektron CMS200 Setup Manual Version 1 6 34 InstallShield Wizard x Select Program Folder Please select 4 program folder Setup will add program icons to the Program Folder listed below You may type a new folder name or select one from the existing folders list Click Next to continue Program Folders Ektron CMS 200 Existing Folders Hi InstallShield lt Back Cancel On this screen specify the folder where you wish to create the start menu shortcut Either accept the default or enter a new folder path Once completed click the Next gt button at the bottom of the screen to continue Q
24. controlled by the TR The TD version controls the text defining the active month The Anchor class controls the month before and after Also cells that aren t used in the month receive their color from this class cal header2 The color that is used behind the days of the week is controlled by this class cal day link The active day or day selected is controlled by this class cal day link2 This class controls all the other days in the month that are not active cal submit The buttons on the bottom of the calendar can be controlled by this class Ektron CMS200 Setup Manual Version 1 6 158 Workarea Classes Class Description workarea This class defines the background color for all the different parts of the workarea History Classes Class Description history list This class is used for 2 attributes The TD controls the active date or the version that is presently published The Anchor class is for the other versions of the content block Login Classes Class Description login The background color of the login and logout screen can be changed with this class Folder Control Classes Class Description folder With these classes you can change the font attributes of the folder control NOTE The font size cannot be controlled by the style sheet it is set by the browser Library Classes Class Description library
25. exe Running CMS200 Setup Once you have double clicked on the executable file for Ektron CMS200 the installation process will begin This section will explain each screen in the process of installing Ektron CMS200 with a MS SQL database 1 The first screen that you will see is the splash screen Ektron CMS200 Copyright 2001 ektron Inc Ektron CMS200 Setup Manual Version 1 6 23 2 After the splash screen you will see the following screen InstallShield Wizard CMS200 Setup Welcome and thank you for installing CMS200 The following setup routine will allow you to install and setup your CMS200 site At this screen click Next gt to continue 3 Atthe next screen you are prompted with an option to install or upgrade Ektron CMS200 Setup Manual Version 1 6 24 InstallShield Wizard Xx Setup Type Choose the setup type that best suits your needs Select Installation Options C Upgrade InstallShield lt Back Cancel For this section we will choose Install Once you choose install click the next button to proceed NOTE For information about upgrading Ektron CMS200 see Upgrading Ektron CMS200 on page 44 4 Once you click the next button you will then be taken to the Ektron License screen Here you can view the license agreement for Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 25 InstallShield Wizard Ektron License Agree
26. have specified the application path you will then need to specify the site path Ektron CMS200 Setup Manual Version 1 6 29 InstallShield Wizard Site Path Setup will install the site files into the following folder To install to this folder click Next To install to a different folder click Browse and select another folder Destination Folder C Inetpub wwwroot CMS 2005 ample Browse InstallShield Cancel The site path is where the necessary scripts to run an Ektron CMS200 Web site are installed to Either keep the default or browse for a new folder Once completed click the Next gt button to proceed 9 If there is already a version of Ektron CMS200 running on your machine in the same location that you specified in step 8 you will receive the following message Question x G A A OOA rad R E AE EE VE E E a a A OEE aA Ea a al a rot be able to complete the instalation Would you ike to enter a Afferent path For your new site a At this message clicking Yes will overwrite the contents in the current CMS200Sample directory clicking No will allow you to specify a new location 10 Once you have clicked the next button you will be taken to the screen where you will choose which type of database to install Ektron CMS200 Setup Manual Version 1 6 30 InstallShield Wizard x Database Type Database Type Please select a database type MSSOQL requires MSSOL Server to
27. stored Once you know all of these you are ready to create an OLE DB connection to your Ektron CMS200 Database Creating a UDL File Whether you are using a Provider string or a UDL file you can use the UDL wizard to create the file or string Once Ektron CMS200 has been installed you are ready to begin Windows 98 ME NT 1 Right click on the Desktop 2 Select New 3 Select Microsoft Data Link to create a udl file Ektron CMS200 Setup Manual Version 1 6 106 Windows 2000 Open Windows Explorer or My Computer Select the folder in which you want to save the UDL file On the File menu click NEW and then click Text Document AWUN Right click on the text file you created in step 3 then click Rename Type the new file name using a udl file extension Press Enter For example MyUDLfile UDL 5 You may get a warning message box explaining that changing file extensions may cause files to become unusable This is fine click OK Configuring The UDL File Once you have created the UDL file you must now configure it to use the proper database and settings 1 Double click on the UDL file to bring up the Data Link Properties Dialog Box MyUDLFile udl 2 When the Data Link Properties menu opens click on the Providers tab E Data Link Properties Provider Connection Advanced All Select the data you want to connect to OLE DB Provider s Microsoft Jet 4 0 OLE DB Provider Microsoft OLE DB Provide
28. the paid purchase price for the defective Products only This limited warranty is only valid if Ektron receives written notice of breach of warranty within thirty days after the warranty period expires In the event of a breach of warranty Ektron s sole responsibility and CUSTOMER S sole and exclusive remedy is correction of any defect or bug causing the breach of warrant either by repair or replacement of the Software In the event this remedy fails of its essential purpose CUSTOMER s sole and exclusive remedy shall be refund of the Purchase Price of the defective Software only This limited warranty is only valid if Ektron receives written notice of breach of warranty within thirty days following the warranty period 5 Limitation of Warranties and Liability THE SOFTWARE AND DOCUMENTATION ARE SOLD AS IS AND WITHOUT ANY WARRANTIES AS TO THE PERFORMANCE MERCHANTIBILITY DESIGN OR OPERATION OF THE SOFTWARE BECAUSE OF THE DIVERSITY OF CONDITIONS UNDER WHICH THIS PRODUCT MAY BE USED NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED EXCEPT AS DESCRIBED IN SECTION 4 ALL WARRANTIES EXPRESS AND IMPLIED ARE HEREBY DISCLAIMED THE REMEDY DESCRIBED IN SECTION 12 SHALL BE CUSTOMER S SOLE REMEDY FOR ANY PERFORMANCE FAILURE OF THE PRODUCTS NEITHER COMPANY NOR ITS SUPPLIERS SHALL BE LIABLE FOR ANY LOSS OF PROFITS LOSS OF BUSINESS OR GOODWILL LOSS OF DATA OR USE OF DATA INTERRUPTION OF BUSINESS NOR FOR ANY OTHER INDIRECT SPECIAL INCIDENTAL
29. this example we will use Access Source DSN Enter the DSN of the source database in this field Source DSN Username Enter the Username for the source DSN if required Source DSN Password Enter the Password for the source DSN if required Destination DB Type Select the database type for the destination database In this example choose MySQL Destination DSN Enter the DSN of the destination database in this field Destination DSN Username Enter the Username for the destination DSN if required Destination DSN Password Enter the Password for the destination DSN if required When you have finished filling out the form it may look similar to the following Source DB Type Access MS SQL C MySQL Source DSN cms200_v16_Access2000 Source DSN Username Source DSN Password Destination DB Type Access MS SQL MySQL Destination pSN CMS200_MySOL Destination DSN Username Destination DSN Password Submit Finally click on the Submit button If successful a listing of all the data that was moved will print out and below that you should see the message Ektron CMS200 Setup Manual Version 1 6 92 The database move has completed successfully Your database should now be populated NOTE If the data did not populate or you received an error please review your data sources and their connection information Moving Data with DBMover exe The second option for populatin
30. you have any type of Microsoft Office application installed on your machine 2 Install a web server such as the Microsoft Personal Web Server or Internet Information Server 3 Set the default document of your Web server to index asp optional Installing Microsoft Data Access Component MDAC Drivers Install MDAC drivers version 2 1 or higher We recommend the latest available from Microsoft To find out which drivers you have installed on your machine you can download the Component Checker tool from Microsoft As of June 2000 all MDAC downloads are located at www microsoft com Data download htm Setting Default Document to Index asp optional Setting the default document can be done using either the Personal Web Manager Console or the IIS depending on which type of platform you are running on i e NT Server Workstation or Windows 98 NOTE You do not need to set Ektron CMS200 as your default Web Application Ektron CMS200 can be used to control a section of the site or used to control the entire site For Windows 95 98 Users with PWS Open the Personal Web Manager Console Select Advanced from the View menu Select the Home directory within the Virtual Directories e O N Enter index asp into the default document field Ektron CMS200 Setup Manual Version 1 6 4 Windows NT 2000 Internet Information Server Open your nternet Services Manager Console Select your Default Web Site icon
31. you have chosen the correct driver click Finish 5 You will then be taken to the following screen Ektron CMS200 Setup Manual Version 1 6 87 MySQL ODBC 3 51 Driver DSN Configuration This dialog helps you in configuring the ODBC Data Source Name that you can use to connect to MySQL server DSN Information Data Source Name j Description Mys0L ODBC 3 51 Driver DSN MySOL Connection Parameters Host Server Namefor IP flocalhost Database Name Jtest User Password Port if not 3306 3306 SQL command on connect Options that affects the behaviour of MyODBC 3 51 Driver V Don t Optimize Column Width D Pad CHAR to Full Length V Retum Matching Rows I Retun Table Names in SOLDescribeCol I Trace MyODBC J Use Compressed Protocol J Allow BIG Results I Ignore Space After Function Names Tl Don t Prompt on Connect Tl Force Use of Named Pipes J Enable Dynamic Cursor I Change BIGINT Columns to INT I Ignore in Table J7 No Catalog exp J Use Manager Cursors Read Options From C my cnf 7 Don t Use Setlocale Safety Check this if you have problems I Disable Transactions Help Test Data Source Cancel From this window you will need to specify e Datasource Name e Database Name e Username and Password if required 6 For demonstration purposes we will name the DSN CMS200_MySQL and point it to the database we created earlier called CMS200
32. you to read the following to understand certain security issues that might arise When you install Ektron CMS200 the language translator will be installed the Program Files Ektron utilities directory When you are ready to use the language translator you will need to move the Ektron CMS200 Setup Manual Version 1 6 137 files necessary to the CMS200Sample directory After you move the files you can access the utility by browsing to the proper page i e http www YourSite com CMS200Sample lang asp Once you are at the page you can perform the tasks that are described later in this section After you have finished using the language translator Ektron advises you to move the SDK files into a directory that cannot be seen to the public i e C Program File Ektron CMS200 This will avoid giving outside users the ability to make changes to your Web site Accessing the Translator To access the language area simply go to URL where you placed the file lang asp an example of this may be http www yoursite com CMS200Sample lang asp When you first arrive at the page you will see the following screen Ektron CMS200 Setup Manual Version 1 6 138 2 Select a message title on the left side Selecting Language To select the language that you want to translate the English strings into select one of the many languages from the drop down box at the top of the page Ektron CMS200 Setup Manual Version 1 6 139 Langua
33. you will want to read before you go any further Once you have performed all the tasks the migration wizard has suggested click Next Configuring the Databases The next window will ask you to provide information about the Ektron CMS100 and Ektron CMS200 datasources Ektron CMS200 Setup Manual Version 1 6 119 Migration from CMS100 for ASP CMS200 Migration Utiltiy Source Database Information CMS100 Express DSN Datasource Usemame Datasource Password Destination Database Information CMS200 DSN E Datasource Usemame CO Datasource Password Once you arrive to this screen use the following table to properly fill out the fields for the Source Database Field Description CMS100 Enter the Datasource Name DSN Ektron CMS100 for Express ASP uses to point to its database DSN Datasource If a username is required to access the Ektron CMS100 Username datasource enter the Username in this field Datasource If a password is required to access the Ektron CMS200 Password datasource enter the Password in this field Ektron CMS200 Setup Manual Version 1 6 120 Migration from CMS100 for ASP Once you have entered the information for the Source Database Ektron CMS100 you will then need to fill out the fields for the Destination Database Ektron CMS200 Field Description CMS200 Enter the Datasource Name DSN Ektron CMS200 DSN uses to point to its database Dat
34. 00Sample directory Open the folder cms200scripts Edit the file setup asp lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_v1_60_Access Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200Sample buildNumber 1 6 0 05 DBusername Ektron CMS200 Setup Manual Version 1 6 108 DBpassword Version 1 60 UseSSL false SSL_Port 443 5 At the line where it says DSN CMS200_v1_60 Access change this to DSN Filename amp lt Path To UDL File gt amp P amp UDLFileName amp UDL An example of this may be lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN File name C inetpub wwwroot CMS200Sample MyUDLFile udl Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200Sample buildNumber 1 6 0 05 DBusername DBpassword Version 1 60 UseSSL false SSL_Port 443 Configuring Ektron CMS200 for the Provider String Converting UDL file to a Provider String Once you have created the UDL file you can convert the
35. 77 3 From here start MySQL by typing mysql a the command prompt C mysql bin gt mysq You should be greeted with the MySQL Monitor Welcome Screen which will give you a connection id and tell you what server version of MySQL you have Shown below is an example of what your screen might look like Microsoft Windows 2660 Version 5 00 2195 lt C gt Copyright 1985 2666 Microsoft Corp C gt cd mysql bin C mysql bin gt mysql Welcome to the MySQL monitor Commands end with 5 or g Your MySQL connection id is 1 to server version 3 23 49 nt Type help or h for help Type c to clear the buffer mysql gt m Once you have connected to MySQL you can now create the database that Ektron CMS200 will use Now let s create a database in MySQL named CMS200 Ektron CMS200 Setup Manual Version 1 6 78 1 At the MySQL prompt enter the following to create the database named CMS200 mysql gt create database CMS200 2 MySQL should respond by stating something like Query OK 1 row affected lt 0 03 sec gt Microsoft Win ows 2666 Version 5 00 2195 lt C gt Copyright 1985 2666 Microsoft Corp C gt cd mysqlN bin C mysql bin gt mysql Welcome to the MySQL monitor Commands end with 5 or g Your MySQL connection id is 26 to server version 3 23 49 nt Type help or h for help Type c to clear the buffer mysql gt create database CMS200 Query OK 1 row
36. CUSTOMER accepts a nontransferable and nonexclusive License to use the Software on the following terms and conditions 1 Right to use The Software is licensed for use only in delivered code form Each copy of the Software is licensed for use only on a single URL Each license is valid for the number of seats listed below the Basic Package Any use of the Software beyond the number of authorized seats contained in the Basic Package without paying additional license fees as provided herein shall cause this license to terminate This is not a concurrent use license Should CUSTOMER wish to add seats beyond the seats licensed in the Basic Package the CUSTOMER may add seats on a block basis at the then current price for additional seats see product pages for current price The Basic Packages are as follows eWebEditPro Licensed for ten 10 seats per URL For purposes of this section the term seat shall mean an individual user provided access to the capabilities of the Software 2 Duration This License shall continue so long as CUSTOMER uses the Software in compliance with this License Should CUSTOMER breach any of its obligations hereunder CUSTOMER agrees to return all copies of the Software and this License upon notification and demand by Ektron 3 Copyright The Software including any images applets photographs animations video audio music and text incorporated into the Software as well as any accompanying written materials the Docu
37. Driver mdb Ektron CMS200 Setup Manual Version 1 6 40 Create New Data Source Driver da Microsoft para arquivos texto txt csv Driver do Microsoft Access mdb Driver do Microsoft dBase dbf Driver do Microsoft Excel xls Driver do Microsoft Paradox db Driver para o Microsoft Visual FoxPro Microsoft Access Driver mdb Microsoft Access T reiber mdb Microsoft dBase Driver dbf hdierncott dB sce WEP Nrivar ABEL TH PP POPPE ES 4 5 Click Finish 6 Enter a Data Source Name ODBC Microsoft Access Setup Data Source Name CMS200_Sited OK Description Database x Cancel Database Help Select Create Repair Compact r System Database PPE Advanced None C Database Sustem Database Options gt gt I Ektron CMS200 Setup Manual Version 1 6 41 7 Click the Select button 8 Explore until you find the proper database then click OK Select Database x Database Name Directories OK 5200_v1_50_Access mdb c databases FS ck Cancel CMS 200 v1 50 Acced a ems200_ 15_min_acce gt Inetpub E gt wwwroot Hap cA MEAN Nee I Read Ony e iziii 4 T Exclusive List Files of Type Drives i Access Databases m c DONEIL x Network 9 Click OK on the ODBC Microsoft Access Setup window Repeat these steps for each Web Site that the server will
38. N INFRINGEMENT MERCHANTABILITY FITNESS FOR A PARTICULAR PURPOSE LACK OF VIRUSES ACCURACY OR COMPLETENESS OF RESPONSES RESULTS LACK OF NEGLIGENCE OR LACK OF WORKMANLIKE EFFORT QUIET ENJOYMENT QUIET POSSESSION AND CORRESPONDENCE TO DESCRIPTION THE ENTIRE RISK ARISING OUT OF USE OR PERFORMANCE OF THE PLUG IN REMAINS WITH YOU EXCLUSION OF INCIDENTAL CONSEQUENTIAL AND CERTAIN OTHER DAMAGES TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW IN NO EVENT SHALL ESKER OR ITS SUPPLIERS BE LIABLE FOR ANY SPECIAL INCIDENTAL INDIRECT OR CONSEQUENTIAL DAMAGES WHATSOEVER INCLUDING BUT NOT LIMITED TO DAMAGES FOR LOSS OF PROFITS LOSS OF CONFIDENTIAL OR OTHER INFORMATION BUSINESS INTERRUPTION PERSONAL INJURY LOSS OF PRIVACY FAILURE TO MEET ANY DUTY INCLUDING OF GOOD FAITH OR OF REASONABLE CARE NEGLIGENCE AND ANY OTHER PECUNIARY OR OTHER LOSS WHATSOEVER ARISING OUT OF OR IN ANY WAY RELATED TO THE USE OF OR INABILITY TO USE THE PLUG IN OR FAILURE TO PROVIDE TECHNICAL SUPPORT OR OTHERWISE UNDER OR IN CONNECTION WITH ANY PROVISION OF THIS LICENSE EVEN IF ESKER OR ANY SUPPLIER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES Due to the complex nature of computer software Esker does not warrant that the Plug in is completely error free will operate without interruption or is compatible with all equipment and software configurations You are advised to check all work performed with the Plug in Do not use the Plug in in any case where significant
39. Right click on the Default Web Site icon and select Properties from the pop up menu Internet Information Services Internet Information Services doneil x Default FTP Site Stopped C WINNT System32 inetsrv jisadmin c netpub issampies c program files common Files system msade c winnt help ishelp C Inetpub webpub C INETPLB WiWWROOT cfdocs CAINETPUBYWWWROOT chide C WINNTiweb printers 4 Click the content blocks tab in the dialogue box that is displayed Ektron CMS200 Setup Manual Version 1 6 Default Web Site Properties Ei xi Directory Security HTTP Headers Custom Errors Server Extensions Web Site Performance ISAPI Filters Home Directory Documents Default htm Default asp Add lisstart asp Remove Enable Document Footer L Browse Cancel Apply Help 5 Select the Add button 6 Enter index asp into the displayed field Add Default Document Ea Default Document Name index asp Cancel 7 Click OK to close this box 8 Click OK again to close the Default Web Site Properties window Ektron CMS200 Setup Manual Version 1 6 Depending on where you install the Ektron CMS200 root directory you will need to make the necessary changes in your Web Server s console to point to the proper directory Ektron CMS200 Setup Manual Version 1 6 7 Installing to an Access Database To install Ektron CMS200 for
40. S200 Setup Manual Version 1 6 2 Before You Install Before you install Ektron CMS200 there are some thing that you ll need to know This chapter gives you a brief summary of the requirements for your system System Requirements The following components are required when developing or viewing an Ektron CMS200 based application Browsers When viewing and editing a Web site developed with CMS200 you can use the following browsers Viewing e American Online s Netscape Navigator versions 3 0 and higher e Microsofts Internet Explorer versions 3 0 and higher Editing e Internet Explorer 4 01 and higher e Netscape Navigator 4 7x and higher Operating System Server MS Windows NT 2000 NT server MUST be running service pack 6 Windows 98 with PWS Hardware Any IBM PC compatible system suggested minimum requirements Pentium 166 MHz or faster with at least 64MB of RAM Web Server Applications Microsoft Active Server Pages ASP 2 0 or Higher Web Server e Microsoft Internet Information Server IIS 4 0 or higher with NT SP6 e Personal Web Server Preparing for Installation Prior to installing Ektron CMS200 you must first perform the following tasks Ektron CMS200 Setup Manual Version 1 6 3 1 Install Microsoft Data Access Component MDAC Drivers version 2 1 or greater NOTE You will not need to install MDAC 2 1 drivers if you have Windows 98 Second Edition or greater and or
41. UseSSL false SSL_Port 443 2 Save settings and close window Repeat these steps for each Web site that you will be hosting What s Next Once you have successfully created the DSNs for each site and configured the setup asp files you will be ready to run each of these separate Web sites from your computer Ektron CMS200 Setup Manual Version 1 6 43 Upgrading Ektron CMS200 Upgrading Ektron CMS200 If you are using a previous version of Ektron CMS200 upgrading can easily be done through the installation program This chapter will provide you with a walk through of the upgrade program and any other steps needed to properly upgrade application Ektron CMS200 Setup Manual Version 1 6 44 Upgrading To Version 1 6 If you already are using a previous version of Ektron CMS200 then you will be able to take advantage of the upgrade that is included in the installation file The upgrade will install all the new files for Ektron CMS200 Version 1 6 This section will explain the steps for a Ektron CMS200 Upgrade Begin by double clicking on the executable file that was downloaded from the Ektron Web site 4 CMS200 exe Running CMS200 Setup Once you have double clicked on the executable file for Ektron CMS200 the installation process will begin Ektron CMS200 Setup Manual Version 1 6 45 1 Once you have double clicked on the executable file the setup process will begin and you will see the follow
42. Web site directory You must maintain yow template directory structure Currently al CMS100 non administrator users are contained ony in the Everyone user group You wil need to add the appropriate user groups and then add the users to these new user groups AI CMS100 administrator users have been added to the Administrator user group Oriy users in the Aministato user group have ibrary permissions Please refer to the CMS200 Migration Utility and CMS200 Application documentation for complete detais When you finish the migration you will get this final confirmation message saying that you have successfully setup your Ektron CMS200 database What s Next Although the use of the migration utility is complete there are stilla few more tasks that will need to be performed including Setting up folder permissions in Ektron CMS200 Setting up library permissions in Ektron CMS200 Moving your Ektron CMS100 templates to the Ektron CMS200 directory and making any updates to them 4 Moving your Ektron CMS100 UploadedFiles and UploadedImages directory from your Ektron CMS100 to Ektron CMS200 directory 5 Setting up user groups Ektron CMS200 Setup Manual Version 1 6 131 Migration from CMS100 for ASP You will want to review the section of the administrator manual regarding setting up folders groups permissions and workflows The section Moving Scripts Directory and Editing Templates on page 132 will explain
43. affected 8 82 sec 3 To make sure the database was successfully created you can type show databases at the mysql prompt mysql gt show databases Ektron CMS200 Setup Manual Version 1 6 79 Microsoft Windows 2000 Version 5 00 2195 lt C Copyright 1985 2666 Microsoft Corp C gt cd mysqlN bin C mnysql bin gt mysql Welcome to the MySQL monitor Commands end with or g Your MySQL connection id is 20 to server version 3 23 49 nt Type help or h for help Type c to clear the buffer mysql gt create database CMS2006 Query OK 1 row affected 0 02 sec CMS 266 mysql in set 6 66 sec This will print out a list of all the MySQL databases Make sure CMS200 appears in this alphabetical list of databases 4 Finally attempt a connection to the newly created database using the connect command mysql gt connect CMS200 Ektron CMS200 Setup Manual Version 1 6 80 Microsoft Windows 2000 Version 5 00 2195 lt C Copyright 1985 2666 Microsoft Corp C gt cd mysqlN bin C mnysql bin gt mysql Welcome to the MySQL monitor Commands end with or g Your MySQL connection id is 20 to server version 3 23 49 nt Type help or h for help Type c to clear the buffer mysql gt create database CMS2006 Query OK 1 row affected 0 02 sec CMS 266 mysql rows in set 6 66 sec mysql gt connect CMS200 Connection id 21 Current database CMS266 1 gt
44. asource If a username is required to access the Ektron CMS200 Username datasource enter the Username in this field Datasource If a password is required to access the Ektron CMS200 Password datasource enter the Password in this field FZ CMS200 Migration Utiltiy Source Database Information CMS100 Express DSN asp_sample1 7 Datasource Usemame JEktron CMS100 Database Usemame Here Datasource Password JEktron CMS100 Database Password Here Destination Database Information CMS200 DSN CMS200_vi_50 Access sts S Datasource Username JEktion CMS200 Database Usemame Here Datasource Password Ektron CMS200 Database Password Here lt Back Newt gt Cancel Once you have entered all the necessary fields for the source and destination databases click the Next button at the bottom of the screen Ektron CMS200 Setup Manual Version 1 6 121 Migration from CMS100 for ASP Inserting Your Ektron CMS200 License Key After you click Next you will then be prompted to enter your Ektron CMS200 license key 2 OMS200 Migration Utitlities CMS200 Application License Key This application wil not validate license key s Please purchase 4 icense key or obtain a trial license key from Ektron you do not have one inser your Ektron CMS200 License Key Here l Insert your license key into the field provided Once completed click the Next button at the bottom of the screen to proceed NOTE You w
45. at database before running this utility An example of this would be moving content from an Access database to a MS SQL Server database You would first create a new database in MS SQL Server with the cms200_mssql_v1 sql script then enter the DSN of the source database and the OSN of the destination database and click Submit to start the move Source osn Source DSN Username Source DSN Password Destination psn Destination DSN Username Destination DSN Password Submit 3 Add the source and destination DSNs to the appropriate fields when the page comes up as well as usernames and passwords if necessary Field Description Source DSN Enter the DSN of the Access database that Ektron CMS200 uses Source DSN Enter a username for the source DSN if necessary Username Ektron CMS200 Setup Manual Version 1 6 74 Field Description Source DSN Password Enter the password of the username of the source DSN if necessary Destination DSN Enter the DSN of the MS SQL Database Destination DSN Username Enter a username for the MS SQL DSN if necessary Destination DSN Password Enter a password for the username for the MS SQL DSN if necessary 4 Select the Submit button You should receive a confirmation message if successful If an error occurs please go back and check your datasources to ensure that they are set up correctly including the names used
46. atabase mover utility is used to move e Moving the Data on page 73 Mover the content from the default Microsoft Access database to a Microsoft SQL e Moving Data into the MySQL Server Database Database on page 90 Database Used when upgrading from a previous Upgrading Ektron CMS200 on Upgrade version of Ektron CMS200 page 44 Macromedia The Macromedia Extension utility is For more information about the Extensions designed for use with Macromedia Macromedia Extensions see the Dreamweaver Ultradev This utility will Ektron CMS200 Administrator Manual allow you to create templates for Ektron Version 1 6 CMS200 in a graphical interface and insert custom commands Migration The migration utility is used to migrate from Migration from CMS100 for ASP on an existing Ektron CMS100 for ASP Web page 113 site to an Ektron CMS200 Web site LangUpdate This utility will populate your old database with German and French strings Ektron CMS200 Setup Manual Version 1 6 112 Migration from CMS100 for ASP Migration from CMS100 for ASP Prerequisites Ektron CMS200 now comes with a new utility for migrating your existing Ektron CMS100 for ASP Web site to a Ektron CMS200 Web site This migration can easily be done with the use of an utility that comes with Ektron CMS200 This chapter will guide you through all the steps of migrating your Ektron CMS100 for ASP site to Ektron CMS200 Before you migrate your Ektron CMS100 for ASP W
47. ayed when there is a problem input box text Before every input box in the application there is usually text explaining what the text box is for This class controls that text title header This class is used under the titlebar when information is going to be listed This is used to control the column headers info Any important information that should stand out gets the info class An example of this class can be seen in the content page when showing the attributes of the content block info header Very similar to the info class this is used for information that should stand out but starts a new section on a page An example is the word metadata or summary on the content block properties page toolbar This class controls the background of the toolbar that is used in the application NOTE Unless you are changing all the icons do not change this class appname Under the logo of the application the words Content Management reside This class controls the look of these words This class should match the titlebar class to maintain consistency Calendar Classes Class Description cal link This class controls the text used for the days of the week Ektron CMS200 Setup Manual Version 1 6 157 Class Description cal header This class controls both table rows cells and links The top row of the calendar is
48. be hosting then click OK to exit the Data Source ODBC Manager Updating Setup asp Some code in the setup asp file will need to be changed so each Web site will have the proper DSN and site path 1 1 Go to the file C inetpub wwwroot NewSite1 cms200scripts setup asp and open it with any web development tool e Change DSN CMS200_Sample_v11 to DSN your new DSN e Change sitepath CMS200Sample to sitepath your new sitepath Ektron CMS200 Setup Manual Version 1 6 42 lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN Insert New DSN Here Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath Insert New Site Path Here buildNumber 1 6 0 05 DBusername DBpassword Version 1 60 UseSSL false SSL_Port 443 An example for this is lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_Site2 Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200_New buildNumber 1 6 0 05 DBusername DBpassword Version 1 60
49. be installed locally and have the appropriate priveleges to create databases and tables Microsoft Access Microsoft SOL Server InstallShield lt Back Cancel Click on Microsoft SQL Server then click the Next gt button at the bottom of the screen to continue NOTE For information about Installing a Microsoft Access Database see Installing to an Access Database on page 8 Setting up a MySQL database see Setting Up a MySQL Database on page 76 11 Once you have selected to install an MS SQL database you will then need to enter information needed to setup the SQL database Ektron CMS200 Setup Manual Version 1 6 31 InstallShield Wizard SQL Server DB Setup stalls held At this screen you will need to enter the Server where you wish to create the database on and a valid username and password for a user with permissions to the SQL server to add the database Once you have entered the information click the Next gt button to continue 12 Once you have specified the SQL Server information the next screen will allow you to create the DSN for the database Ektron CMS200 Setup Manual Version 1 6 32 InstallShield Wizard Please select the datasource you wish to create for this database CMS200_v1_6q InstallShield lt Back Cancel At this screen either accept the default DSN name or edit it to be whatever you like Once you have
50. creen will look somewhat like this 2 CMS200 Migration Utility Please select and move your content to a CMS200 content folder CMS100 Applicaton CMS200 Application Home Page Content Login Information News Events Products Support Syndication Mave Remove As you can see there is a list on the left side with the titles of all the content blocks that existed in the Ektron CMS100 Web site In the middle are buttons to Move or Remove content blocks to and from the selected folder On the right side there is a drop down menu where you can select a folder that you want to move a content block to a button to add a new folder and an Add button at the bottom to permanently move the content to the selected folder Unless you add new folders all the content blocks that you move from Ektron CMS100 to Ektron CMS200 will be in the root content folder The root content folder is symbolized by the in the drop down list You can learn more about content folders and how they work by referring to the Ektron CMS200 Administrator Manual Version 1 6 To move content blocks to the root content folder select all the content blocks in the left hand column that you would like to move Ektron CMS200 Setup Manual Version 1 6 124 Migration from CMS100 for ASP A CMS200 Migration Utility x Please select and move your content to a CMS200 content folder CMS100 Applicaton CMS200 Application Once you have selected the co
51. d Ektron CMS100 Ektron CMS200 and set the DSN to point to the Ektron CMS200 minimum database you are ready to run the migration utility Locating the Migration Utility NOTE By default the migration utility will be installed to the C Program Files Ektron CMS200 Utilities directory 8 cms200_Migra tion exe During the installation of Ektron CMS200 if you specified a different directory for the Ektron CMS200 components to be installed to you will have to navigate to that directory to find the migration utility Once you have successfully navigated to the Ektron CMS200 utilities directory double click on the cms200_Migration exe file This will begin the migration Running the Migration Utility Once you have run the cms200_Migration exe file the migration will begin Ektron CMS200 Setup Manual Version 1 6 118 Migration from CMS100 for ASP Y3 CMS200 Migration Utility Welcome to the CMS200 Upgrade Utiity Wizard This wizard will import your existing CMS 100 express data to the CMS200 application with the standard minimum database It is highly recommended you backup the standard minimum database before you start the wizard It is assumed that you currently have the CMS200 and the CMS100 applications installed Please have your CMS200 license key and al your datasource information available To continue click Next At the first window of the migration you will see important instructions that
52. damage or injury to persons property or business may happen if an error occurs You expressly assume all risks for such use c 2000 Esker Inc All rights reserved Copyright to and in the Plug in remains the property of Esker Inc and as such any copyright notices in the Plug in are not to be removed YOU ACKNOWLEDGE THAT YOU HAVE READ THIS AGREEMENT THAT YOU UNDERSTAND THIS AGREEMENT AND UNDERSTAND THAT BY CONTINUING THE INSTALLATION OF THE SOFTWARE BY LOADING OR RUNNING THE SOFTWARE OR BY PLACING OR COPYING THE SOFTWARE ONTO YOUR COMPUTER HARD DRIVE YOU AGREE TO BE BOUND BY THIS AGREEMENT S TERMS AND CONDITIONS YOU FURTHER AGREE THAT EXCEPT FOR WRITTEN SEPARATE AGREEMENTS BETWEEN EKTRON AND YOU THIS AGREEMENT IS A COMPLETE AND EXCLUSIVE STATEMENT OF THE RIGHTS AND LIABILITIES OF THE PARTIES c 1999 2000 Ektron Inc All rights reserved LA10031 Revision 1 5 Ektron CMS200 Setup Manual Version 1 6 iv Table of Contents WATS In This MANU iw eccctitccteccscdddscucaccestaosaenisccsdaicassancnasis 1 MEELEL p T 2 B fore YOU INSTAl ii riictinnincinnrnaiaasin eiaei 3 System PEQUIRGITIGING sae cece deeseedescaeysseeyexceni erin dezreccdedsextsansadause pecuascyseneedee 3 Preparing for Metalaton sssrin sasanka Rana AANA AAE AARAA 3 Installing Microsoft Data Access Component MDAC Drivers 4 Setting Default Document to Index asp optional c eeeeeeee 4 For Windows 95 98 Users with PWS c ceeec
53. de in the language folders and always start with the word workarea and end with _top The size attributes for these images are 467 pixels wide by 77 pixels high The width of these images can change but the height cannot There are approximately 6 images in each language folder There is an Adobe Photoshop file that is included with this application called workarea_top psd It can be found in the English folder and can be used to make changes By changing both the style sheet and the images Ektron CMS200 can be branded to look the way you would like Include your company logo and company colors and you can have a personalized web based content management solution Ektron CMS200 Setup Manual Version 1 6 160 Additional Information Additional Information Supporting Documents Support Sales You can find more detailed information about Ektron CMS200 in the following documents e Ektron CMS200 Administrator Manual Version 1 6 e Ektron CMS200 User Manual Version 1 6 e Ektron CMS200 Administrator Quick Start Manual Version 1 6 If you are experiencing trouble with any aspect of Ektron CMS200 please contact the Ektron Support Team via their Web Site or by e mail http www ektron com support cfm or support ektron com For questions and answers about purchasing Ektron CMS200 from Ektron contact the sales department by sending an e mail to sales ektron com Ektron Inc 5 Northern Boulevard Suite 6 Amhers
54. ding to the Installing Ektron CMS200 chapter Once that is complete create separate directories for each hosted web site The process is described below Running CMS200 Setup Follow all the steps shown in the previous chapter about running the install which you downloaded from the Ektron site Setting up Directories After you run the install create new Web enabled directories for each of the web sites that will be hosted with Ektron CMS200 1 Go to the inetpub wwwroot directory 2 Create X amount of folders depending on how many sites will be hosted using Ektron CMS200 3 Name each folder uniquely Copy the contents of the CMS200Sample directory into each of the folders created Ektron CMS200 Setup Manual Version 1 6 38 N www SITE1 com home page cms200scripts eWebEditPro database uploaded images uploaded Files Creating DSNs www SITE2 com home page N cms200scripts eWebEditPro database uploaded images uploaded Files When finished copying the data into the directories create unique DSNs for each of the sites Ektron CMS200 Setup Manual Version 1 6 39 1 1 Follow the path Start gt Programs gt Administrative Tools gt Data Sources ODBC 2 Click on the System DSN tab ODBC Data Source Administrator Microsoft Access Driver m CMS200_v1_50_MSSQL SQL Server 3 Click the Add button 4 Select Microsoft Access
55. dows LODBC Data Source Administrator User DSN System DSN File DSN Drivers Tracing Connection Pooling About User Data Sources Add dBASE Files Microsoft dBase Driver dbf dBase Files Word Microsoft dBase YFP Driver dbf Remove Excel Files Microsoft Excel Driver xls FoxPro Files Word Microsoft FoxPro YFP Driver dbf Configure MOIS SQL Server Lerfigue MS Access Database Microsoft Access Driver mdb Visual FoxPro Database Microsoft Visual FoxPro Driver Visual FoxPro T ables Microsoft Visual FoxPro Driver A n ODBC User data source stores information about how to connect to the indicated data provider A User data source is only visible to you and can only be used on the current machine Cancel Apply Help 2 Click on the System DSN tab 3 Click on the CMS200_ v1_50 Access DSN in the list Ektron CMS200 Setup Manual Version 1 6 115 Migration from CMS100 for ASP ODBC Data Source Administrator 2 x UserDSN System DSN File DSN Drivers Tracing Connection Pooling About System Data Sources Add E A OU Microsoft Access Driver rm CMS200_v1_50_MSSQL SOL Server Remove Configure di An ODBC System data source stores information about how to connect to the indicated data provider A System data source is visible to all users on this machine including NT services Data Source Name Description Cancel
56. e active in the setup page and translated the strings in applicationNotLoggedIN asp your Ektron CMS200 application will now be fully translated Ektron CMS200 Setup Manual Version 1 6 145 NOTE This file is already translated for French standard and German standard Simply replace the applicationNotLoggediIn asp file in the cms200scripts directory with the same file in the corresponding language directory under the images folder Assigning a Default Language to a User The administrator also has the privilege to create or edit a user and assign him her a personalized default language To do this follow the steps listed below Browse to your Web site Login as a user with administrator privileges Go to the Administrator Work Area Click on USERS For Adding a User ON 1 Click the add user button at the top of the Actions column 2 Follow all the steps of adding a user you have read in the User Manager chapter 3 There will be a drop down box with the active languages that you can assign to the user Ektron CMS200 Setup Manual Version 1 6 146 icresoft Internet Explorer First Name Last Name Password Confirm Pwd 7 App Default E Mail Address English US I Disable Ma French Standard German Standard gt 4 Select the default language that you want to assign the user from the drop down box 5 Click ADD to save the settings When Editing a User Ektron CMS200 Setup Manual Ver
57. e upgrade to overwrite them with the new files Once you have entered the valid root directory click the Next gt button to continue 8 Once you click next you will be taken to the following screen Ektron CMS200 Setup Manual Version 1 6 51 InstallShield Wizard Choose Destination Location Select folder where Setup will install files Please select your CMS200 site directory Browse InstallShield lt Back Cancel At this screen you will need to enter the Ektron CMS200 Site directory Once you have entered the correct location click the Next gt button at the bottom of the screen to continue 9 After you specify the site directory you will be prompted with the following question Q Add new Sample Site This is not required to update CMS200 to version 1 10 YES to update the current site with the Sample Site templates and database NO to NOT install the Sample Site If you click Yes the current Ektron CMS200 Site will be replaced with the new sample site information If you click No then your current site will remain the same Ektron CMS200 Setup Manual Version 1 6 52 10 If you click the Yes button you will then be prompted with the following question Clicking Yes will backup your current Ektron CMS200 Web site while clicking No will not 11 Once you click a button you will be taken to the host name screen InstallShield Wizard Enter Text Please enter info
58. eb site After About Us has been deleted from the XYZ Web site Each message is called in the presentation layer by its message title Carriage Return Line Feeds are represented by the variable appCRLF These will cause the email to move down one line Ex Ektron CMS200 Setup Manual Version 1 6 151 Before The content was approved appCRLF Thank you After The content was approved Thank you Using the Language SDK to Customize Emails WARNING NOTE Ektron CMS200 provides an SDK to convert Ektron CMS200 to different languages In a nutshell this SDK provides a means for adding versions of the English strings to different languages This SDK can also be used to change the English message in the database The language SDK files are located in C Program Files Ektron CMS200 utitlies folder by default They are e lang asp e lang_englishdisplay asp e lang_entry asp e lang_top asp Please copy these files into a utilities folder underneath the CMS200scripts folder Remember to remove these files from the web site when you are done When you locate the Language SDK choose English US from the dropdown box at the top This will produce a list in the left frame of all the message titles in the database Locate the message title for the email you want to update and click on it The right frame will have an input box for English US Message which will be filled with the current English Message Make the
59. eb site to Ektron CMS200 you will need to at least have the following 1 Ektron CMS100 for ASP installed on your machine Ektron CMS200 installed on the same machine Ektron CMS200 must be using the minimum database in the installation 4 A license key for Ektron CMS200 or a temporary license key Once those are all set you may begin the process of migrating your site to Ektron CMS200 Installing CMS100 for ASP To migrate your Ektron CMS100 for ASP Web site to Ektron CMS200 you must first have Ektron CMS100 for ASP installed on your machine To properly install Ektron CMS100 for ASP if you haven t already follow the steps for installing the application in the Installation Manual for Ektron CMS100 located on the Ektron Web site Ektron CMS200 Setup Manual Version 1 6 113 Migration from CMS100 for ASP Installing CMS200 To install Ektron CMS200 follow the steps provided in Installations on page 2 Backing Up the Minimum Database Ektron recommends that you backup the minimum database before you begin the migration This can be easily done by copying and pasting the initial minimum database from the CMS200 Databases directory to another directory on your system Backing Up Your Active Site Before continuing it is recommended that you back up all of your data including your site templates and database The best way to do this is to make a copy of your site directory and databases if located in different locati
60. eceseeeeeeeeeeeseeeeeeaeeteneees 4 Windows NT 2000 Internet Information Server cccccceeeeeeeees 5 Installing to an Access Database cccccccceeeeeeeees 8 Running CMS200 Setup ensins asinina iin oneh 8 Installing to a MS SQL Database ccccccccceeeeeeeees 23 Runhing GMS200 Setup s ccscs isscecccetiee ep cieier st iaai 23 Installing Ektron CMS200 in a Hosting Environment 38 Running GMS200 Setup isac 0 nv headin ead ea are eee 38 SONG p DIKEClOHSS ses ceesnsa ce avees adtanvebdadecnsatehnalldewiat dave na seadieennanetedeees 38 Creating DSN Skiri iarsan dnt cclaine igen eran tied 39 Updating Sew pase a e ceeesveieleteges ce deesdtesante caaateede peel inactive cede 42 Witt SENG XT eare dd sbeadvadeuiaiaa E T N 43 Upgrading Ektron CMS200 ccccccseeeeeeeeeeeeeeeeeeeeeeeeeeeees 44 Upgrading To Version 1 6 cccccccesssssseeeeeeeeeeeeeseeeeeeees 45 Running CMS200 Setup ccccccccecceseeeeeeceeeeeaeeseceeeeaaeseeeeeesaeeeseaaeeee 45 Language UCN icscinnsissiiainncsinaisaninintianinsatiinisnineciondawnaans 56 Upgrading Ektron GMS200 s 524 sic iusedd ea devvees eveacteded canst ariaa 56 Accessing the Language Update Utility cccccccceceeeeeeeeeseeeeeeeeeeeees 56 Using the Language Update Utility eeeccseeeeeeeeceeeeeeseceeeeseeeeeeeeneaes 57 Ektron CMS200 Databases cccceseeeeeeeeeeeeeeeeeeeeeeeeeeeees 60 Microsoft Access Database
61. er keep the default or browse for a new directory Once completed click the Next gt button to proceed 8 After you have specified the application path you will then need to specify the site path Ektron CMS200 Setup Manual Version 1 6 14 InstallShield Wizard Site Path Setup will install the site files into the following folder To install to this folder click Next To install to a different folder click Browse and select another folder Destination Folder C Inetpub wwwroot CMS 2005 ample Browse InstallShield Cancel The site path is where the necessary scripts to run an Ektron CMS200 Web site are installed to Either keep the default or browse for a new folder Once completed click the Next gt button to proceed 9 If there is already a version of Ektron CMS200 running on your machine in the same location that you specified in step 8 you will receive the following message Question x G A A OOA rad R E AE EE VE E E a a A OEE aA Ea a al a rot be able to complete the instalation Would you ike to enter a Afferent path For your new site a At this message clicking Yes will overwrite the contents in the current CMS200Sample directory clicking No will allow you to specify a new location 10 Once you have clicked the next button you will be taken to the screen where you will choose which type of database to install Ektron CMS200 Setup Manual Version 1 6 15
62. etup Manual Version 1 6 66 1 From Windows Start menu open your MS SQL Query Analyzer Microsoft SQL Server Query Analyzer 2 Select the server that you used to create the Ektron CMS200 database on and enter the type of Authentication that you are using to connect to the SQL Server Connect to SOL Server 4 fe ei Login name Basswood n Ree a a Ektron CMS200 Setup Manual Version 1 6 67 3 Select the new database that was created earlier CMS200_SQL from the drop down list at the top of the sceen ASAREE J lt Details gt 4 Load the sql script by selecting Open File either from the toolbar of the File menu File Edit Query Tools Window e Connect ctrl o K Disconnect Ctrl F4 o Disconnect All IE New Ctrl N Da m Save Ctrl 5 Save As Save All Queries amp Print Ctrl P Recent File List r Exit Alt F4 Ektron CMS200 Setup Manual Version 1 6 68 5 Browse for the file cms200_mssql_v16 sql If you ran the default installation you can find the script in the ProgramFiles Ektron CMS200 Utilities directory Open Query File EIE Look in E Utiities e eE Language_SDK cms200_mssql_v16 s5 cms200_mysql_v16 sql a cmsZ00update_mssql_v1_0 v1_6 sql File name Jems200_mssql_v1 6 sql Files of type Query Files sql x Cancel File format Auto 6 When you have located the sql script
63. files including the language update utility LangUpdate exe mas LangUpdate e xe To run the utility double click on the icon Ektron CMS200 Setup Manual Version 1 6 56 Using the Language Update Utility Once you have double clicked on the icon for the language you will see the following screen w CMS 200 Languages Update Utilty Add New strings Update Changed stings IV English Use the following steps to properly update your database with the translated strings Ektron CMS200 Setup Manual Version 1 6 57 1 First choose the type of database you are using for your Ektron CMS200 Web site Your choices are either MSSQL or MS Access Please select the DSN that points to your version 1 0 database C MSSL MS Access User 2 After you have chosen your database type you must select the DSN of the Ektron CMS200 database from the drop down list Please select the DSN that points to your version 1 0 database MSSQL MS Access CompassTravel ECDCMusic empower_empty 3 Next choose the languages that you wish to populate in your database Since English strings are already installed that option is not available DY tt YEE DE A E A A I S DS B A E IS Y Please select the lanquage s V English JV French V German 4 Finally click the Update button to run the program Update Ektron CMS200 Setup Manual Version 1 6 58 5 When the process is complete you will rece
64. for approval on appSubmittedDateTime appCRLF appCRLF Approvals appApprovalList appCRLF appCRLF Comment appComment Ektron CMS200 Setup Manual Version 1 6 155 Branding Ektron CMS200 Ektron CMS200 is now capable of being branded by a Web Developer Through the use of a style sheet and replacing the Ektron CMS200 default graphics the application can take ona different look that is fully customizable Developers can incorporate a company logo institute company colors and control the look and feel of the entire application Style Sheet The style sheet called global css used for Ektron CMS200 is located in the csslib folder under the cms200scripts directory Using widely accepted Style sheet classes and class attributes the entire application can be changed including colors spacing fonts etc Also upon upgrading or re installation retention of this file will maintain any changes that have been made to the application Ektron CMS200 Setup Manual Version 1 6 156 Class Explanation General Classes Class Description titlebar Located at the top of every page within the application this class is used for page explanations or location explanation While navigating through Ektron CMS200 this page header or titlebar tells the user where they are i e Viewing content in content asp titlebar error This is very similar to titlebar but this one is used for any error messages that are displ
65. for your desired language you will now have the ability to set that language as a default language for the Web site and for a user You will be able to select the language from the application setup area Setting Default Language for Web Site To set the default language for the Web Site follow these steps Browse to your Web site page Login as a user with administrative privileges Go to the Administrator Work Area Click on Configuration gt Setup OP oO NS Once at the application setup page click the edit icon at the top left side of the screen 6 Near the top of the window you will see a drop down box that has all your active languages Ektron CMS200 Setup Manual Version 1 6 144 J fktran M5700 Workarea for Application Administrator Microsoft Internet Explorer lei 65 000 characters 3 Metadata Defin 65000 System E Mail Address I Enable application mail messages 7 Select the default language from the drop down box 8 Click the update button a ApplicationNotLoggedIn asp When setting a language active to your Ektron CMS200 Web site there is one other task you will need to perform In the cms200scripts folder there is a file called applicationNotLoggedin asp This file generates the strings that users will see before they are logged in To completely translate the application you will need to open that file and translate all those strings to the desired language Once you have set a languag
66. formation Server Administrator Console on your Web server 2 Navigate to the computer and Web site that Ektron CMS200 has been installed to 3 Right click on the Web site Ektron CMS200 Setup Manual Version 1 6 99 f E Internet Information Services c program files common Fles system msadc winnt help ishelp C Inetpub webpub C INETPUBIWWWROOT cFdocs C INETPUBIWiWWROOT cFide C WINNT web printers 4 Click Properties from the list 5 Click on the Directory Security tab Ektron CMS200 Setup Manual Version 1 6 100 Default Web Site Properties 6 In the Secure Connections area click on the Server Certificate button Ektron CMS200 Setup Manual Version 1 6 101 Welcome to the Web Server Certificate Wizard ag xj Welcome to the Web Server Certificate Wizard This wizard helps you create and administes server certificates used n secure Web communications between yow server and a chent Status of your Web server Your Web Server doesnt have a certificate installed and you don t have any pending requests Ceitiicate Wizard will help you to create a new cettilicate For this Web Server or attach to an existing certificate To continue click Next 7 Go through the wizard or setting up the certificate for your Web site 8 When you have completed the setup for the certificate click the Web Site tab at the top of the Properties window Ektron CMS200 Setup Manual Ver
67. g the MySQL database is to run the Visual Basic application named dbmover exe which is also located in the utilities directory dbmover exe 1 Double click on the file to open it amp CMs Data Mover Source DSN DSN I User SS Pas DB Type Access MSSQL MySQL C r Destination DSN DSN User Pass SY ODBC DE Type Access MSSL C MySOL C a Close 2 Next from the first drop down list choose the Source DSN Ektron CMS200 Setup Manual Version 1 6 93 amp CMS Data Mover 2 200 v1 51 Arce EMS200 My0 R g 3 Enter a username and password for the source DSN in the proper fields if necessary 4 Next choose Access as the DB Type for the source DSN Ektron CMS200 Setup Manual Version 1 6 94 amp CMS Data Mover Source DSN DSN CMS200_v1_51_Access User Pass Destination DSN DSN Transfer User Pass oce DB Type Access MSSL MySQL C Close 5 Next from the lower drop down list choose the Destination DSN for the database the content will be moved to CA Data Mover Source DSN DSN CMS200_v1_51_Access User Pass DB Type Access MSSQL MySQL C Destination DSN DSN EE User Pass FoodMart 2000 ewebeditpro2 CMS200 v1 51 Access DB Type Access 4 CMS200_MySOL Ektron CMS200 Setup Manual Version 1 6 6 Enter a username and pa
68. ge Message Entry Afrikaans Spanish Paraguas Spanish Peru t Spanish Puerto Rico Spanish Traditional Sort Spanish Urugua Spanish Venezuela Sutu Swahili Kenya Swedish Swedish Finland Once you select the language that you want to translate to you will see the following screen Ektron CMS200 Setup Manual Version 1 6 140 anguage Entry Workarea Microsoft Internet Explorer JAIA F h A J D 3ga ags 2 Select a message title on the left side Here you will be able to access the strings and translate them easily String Icons There are two string icons that are used throughout the process of translations There is an icon for a translated string and one for an un translated string Icon Meaning Ektron CMS200 Setup Manual Version 1 6 141 Translated string Icon Meaning E These icons will show you if you have translated the string or not Un translated string Translating Strings Selecting String To select a string to be translated simply click on the string in the left hand frame After you select the string the following window will now appear Ektron CMS200 Setup Manual Version 1 6 142 F language Entry Workarea Microsoft Internet Explorer O x Fie Edt View Favorites Tods Help x Hek gt OA Gh Aeh ires Gree 9 GSA a RD address http ow YourCampany com CMS200sample lang asp Language Message Entry Bab n fo
69. he ODBC Manager from the Control Panel on your system fe Accessories fey Administrative Tools Adobe GAP SDKs Fn AOL Instant Messenger SM gt i Internet Services Manager Fn Ektron gt Fin Microsoft SQL Server gt RA nivarafh CA Canine Cuik h b 2 Click on the System DSN tab LODBC Data Source Administrator UserDSN System DSN File DSN Drivers Tracing System Data Sources CMS200_v1_50 Access Microsoft Access Driver r 3 Click on the Add button on the right side of the screen 4 Select the driver that best suits your version of MS SQL server PICIOSUIL TUACIU YOO Vive UU Microsoft ODBC for Oracle Microsoft Paradox Driver db Microsoft Paradox Treiber db Microsoft Text Driver txt csv Microsoft Text Treiber txt csv Microsoft Visual FoxPro Driver Microsoft Visual FoxPro T reiber When you have selected the SQL Server driver click the Finish button at the bottom of the window Ektron CMS200 Setup Manual Version 1 6 71 5 The next window asks you to choose a Name Description and choose the SQL Server to connect to What name do you want to use to refer to the data source Name CM5200_SQL How do you want to describe the data source Description SQL DSN for Ektron CMS200 Which SQL Server do you want to connect to Server local X When you finish entering the information click the Next button at the bottom of the window 6 Yo
70. how to move the files and directories needed complete the migration NOTE While moving directories from Ektron CMS100 to Ektron CMS200 you must retain the same directory structure to ensure your links will work correctly Migrating your Templates The following section describes how to setup your site to use Ektron CMS200 instead of Ektron CMS100 Before Migrating your templates you should have Backed up all critical data Setup a new datasource for CMS200 Point CMS200 to ODBC DSN of new database Run the Migration utility that moves the content from the old CMS100 database to the new CMS200 database We would recommend that if this is a live site that you perform your migration on a staged site until ready for deployment PF oN gt Depending on how you chose to migrate your files you will need to make sure that you are using the correct database include paths and the right templates Moving Scripts Directory and Editing Templates We will assume that you have created a copy of your native Ektron CMS100 site and are modifying that as described in the section Backing Up Your Active Site on page 114 The following steps describe what needs to be moved and modified for the new site to function Ektron CMS200 Setup Manual Version 1 6 132 Migration from CMS100 for ASP 1 1 If you have not done so yet make a copy of your active site directory For example c inetpub wwwroot active_cms_site to c i
71. ieee Bledel N 144 ACUIVE Lang agE Siirdus rinrinda aa E 144 Setting Default Language for Web Site sssessseessseessssssessseessen 144 Assigning a Default Language to a Uset 0 eee 146 IMAGES i fetes ee eee cen Le 149 Customizing Ektron CMS200 Emails 00se10 151 IMMFOGUCHION c2cci0 siicevereecdetiees danaeed E 151 Using the Language SDK to Customize Emails cccesssseessssreees 152 VAMADIO S rnrn R eh oes Mia vendigandeeeee ached 153 Listo GMS200 EMANS adasen eannan anie iaaa eiaa 154 Notify Approval Process Complete c ccccceeseseeeeeceeeeseeeeenees 154 Deletion of Content Approved ceccccesceeeseeeeeeneeeeeeeeeeeaeteeeeenees 154 Immediate Deletion of Conte nt ccccesceeesseeeeeneeeeeeeeeseaeeeeeeenees 154 Approved Content Awaiting Go Live Date 154 Approved Content Published Immediately ee eeeeeeeeeeeeeeees 155 Decline Approval REQUCST ceeeeeeeceeeeeeeeeeeeeeeeeeeeeneeeeneeeees 155 Send Approval Message cccccsceceeeseeeeeeeeeeesaeeeeneeeseaeeeeaeeeeaees 155 Branding Ektron CMS200 cccccsssssseeeeeeeeeseeeeeeees 156 Sle SHEE iorsin a E a diene ate aaa 156 Glass ExplanatiOm sassciricniinecininiianaiai aiies aiena 157 General CIAS E Srnci a a eel ee 157 Calendar Classes iniiai draaiers aana hiana danas 157 Workarea ClaSSeSis orrira iniae Ea EE 159 History ClaSSESi iini cavint arden aiaiai i ad inaia iaai eee 159
72. ility when creating this System DSN In the example below we choose cms200_mysql as the data source name for our MySQL database The following steps will describe the process 1 Begin by accessing your ODBC Datasource Administrator console by following the path in Windows Start gt Programs gt Administrative Tools gt Datasources ODBC Ektron CMS200 Setup Manual Version 1 6 84 ODBC Data Source Administrator dBASE Files Microsoft dBase Driver dbf dBase Files Word Microsoft dBase YFP Driver dbf Excel Files Microsoft Excel Driver xls FoxPro Files Word Microsoft FoxPro YFP Driver dbf MOIS SOL Server MS Access Database Microsoft Access Driver mdb myodbe3 test MySQL ODBC 3 51 Driver Visual FoxPro Database Microsoft Visual FoxPro Driver Visual FoxPro Tables Microsoft Visual FoxPro Driver 2 When you arrive to the console click on the System DSN tab Ektron CMS200 Setup Manual Version 1 6 85 ODBC Data Source Administrator 3 From here click the Add button 4 From the list of drivers choose MySQL ODBC 3 51 Driver Ektron CMS200 Setup Manual Version 1 6 86 Microsoft ODBC for Oracle Microsoft Paradox Driver db Microsoft Paradox Treiber db Microsoft Text Driver txt csv Microsoft Text Treiber txt cs Microsoft Visual FoxPro Driver Microsoft Visual FoxPro Treiber MySQL ODBC 3 51 Driver SOL Server YDD a g EPL After
73. ill be unable to proceed if you do not insert a valid license key into the field Library Settings The next screen will ask you for information about your library settings Ektron CMS200 Setup Manual Version 1 6 122 Migration from CMS100 for ASP J3 CMS200 Migration Utility Please confirm the following library type information Library Type Extensions Directory Make Relative images Gil pegipg fuploadedimages ll files ppt pdf xls adede o A hyperlinks oOo O O quicklinks In this screen you will need to specify the Directory that images and files will be uploaded to in Ektron CMS200 Ektron recommends that you use the same directories that you used for CMS100 they are by default the same You will also need to specify whether the paths for the files and images will be relative to the Ektron CMS200 Web site If you are not sure please leave checked When you have finished modifying or confirming the Library information click the Next button to continue Content Settings Once you advance to the next screen you will need to specify where you would like to put the content from Ektron CMS100 to Ektron CMS200 Since Ektron CMS200 allows you to organize your Web content in a folder structure unlike Ektron CMS100 you will need to organize all the content that will be moved to Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 123 Migration from CMS100 for ASP When you arrive to this section the s
74. ing screen InstallShield Wizard CMS200 Setup Welcome and thank you for installing CMS200 The following setup routine will allow you to install and setup your CMS200 site At this screen click Next gt to continue 2 At the next screen you will be able to choose the installation option that will best suit your needs Ektron CMS200 Setup Manual Version 1 6 InstallShield Wizard Setup Type Choose the setup type that best suits your needs Select Installation Options RecencesTecsnsssseed Install InstallShield lt Back Cancel For upgrading choose the upgrade option then click the next button 3 Once you have clicked the next button you will see the following screen Ektron CMS200 Setup Manual Version 1 6 47 InstallShield Wizard CMS200 Setup The following setup routine will allow you to upgrade update or remove your CMS200 site To continue click the Next gt button 4 When you proceed to the next screen you will see an important message about upgrading Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 48 InstallShield Wizard CMS200 Setup IMPORTANT The upgrade will modify the application and script directories These are required changes to use this version of CMS200 You can optionally install the SampleSite Click Next to continue Ektron CMS200 Setup Manual Version 1 6 49 5 After you click the next b
75. ing the name of the new folder click the Add button at the bottom of the screen Once you click the Add button the folder will be created and you can create another folder with the root folder as its parent folder Keep adding folders with the root folder as its parent folder until you no longer need any more When you have complete click the Close button on the Add New Folder window When you close the Add New Folder window you will be able to select any of the folders that you created in the drop down list on the window Ektron CMS200 Setup Manual Version 1 6 128 Migration from CMS100 for ASP E CMS200 Migration Utility Please select and move your content to a CMS200 content folder CMS100 Applicaton CMS200 Application N 7 New Folder Marketing Login Information News Events Products Support Syndication Mave gt lt Remove i Add Next gt Cancel As you can see there are three folders that have been created a root folder a support folder and a marketing folder You may also create sub folders for the folders that you created by 1 Select the folder that you would like to add a Sub folder to in the drop down list tM gt o lt uu Appucauon Marketing New Folder oo 2 2 Click the New Folder button New Folder 3 Name the folder that you want to create Ektron CMS200 Setup Manual Version 1 6 129 Migration from CMS100 for ASP ia Add New Folder aioli x
76. isting folders list Click Next to continue Program Folders Ektron CMS 200 Existing Folders zl InstallShield lt Back Cancel On this screen specify the folder where you wish to create the start menu shortcut Either accept the default or enter a new folder path Once completed click the Next gt button at the bottom of the screen to continue 15 After you click the next button the installation program has all the information needed to properly install all the files and finish the installation Ektron CMS200 Setup Manual Version 1 6 20 InstallShield Wizard Setup Status CMS200 Setup is performing the requested operations Installing C cms200scripts images application btn_save nm gif InstallShield This screen gives you a status on the installation When the bar reaches 100 the installation is complete 16 Once the installation is complete you will see the following screen Ektron CMS200 Setup Manual Version 1 6 21 InstallShield Wizard InstallShield Wizard Complete Setup has finished installing CMS200 on your computer From here click the Finish button and you are ready to explore your new Ektron CMS200 Web site Ektron CMS200 Setup Manual Version 1 6 22 Installing to a MS SQL Database To install Ektron CMS200 for a MS SQL database begin by double clicking on the executable file that was downloaded from the Ektron Web site CMS5200
77. ive a confirmation message notifying you that the process is compete LangUpdate x Update Completed Successfully When you are finished you will now be able to use the selected languages for your Ektron CMS200 application NOTE For information about using these and other languages see Language SDK on page 137 Ektron CMS200 Setup Manual Version 1 6 59 Ektron CMS200 Databases Ektron CMS200 Databases Ektron CMS200 is compatible with three different types of databases e Microsoft Access e Microsoft SQL Server e MySQL Changing databases for your Ektron CMS200 Web site can easily be done using utilities that Ektron provides in the installation This chapter will explain the different types of databases in Ektron CMS200 and how to convert to a MS SQL or a MySQL database Ektron CMS200 Setup Manual Version 1 6 60 Microsoft Access Databases The Ektron CMS200 application contains two Microsoft Access databases One is a sample database which contains sample data for a user to become familiar with the use and integration of the Ektron CMS200 content management tool The other database is a minimum database that you may use to start your Web site from scratch without the sample content and images As discussed earlier in the manual the minimum database is also used for migrating from Ektron CMS100 to Ektron CMS200 Ektron CMS200 has the capability of using a MS SQL database Although the product doesn
78. l gin Clas SES riii edn nd ees eae ie ee 159 Folder Control Classes rrisin feceshde caterers leva dancens faaadccenwioedeees 159 Library Class eS sinri a a ii 159 Lun e206 Se A E T E EA TE ee 160 Applicaton IMAGES enn 160 Language IMAGOS sssecvesascces Cease dade eae innari E EEA 160 Additional Information s ssseeeeeeeseseeeeeeeeeeeeeeeeeeeees 161 Supporting DOGUING MIS ic cccaeseiend cyerasccctcderveccscdeasvescdedesdecucedsevecd dede eased 161 SUP OME ov cetuts saee E E O E E E Ai tewced 161 SOS ss cece viede ds see a a a aN aaa Ea cgnagtesvaieceedles E EA 161 Ektron CMS200 Setup Manual Version 1 6 vii Ektron CMS200 Setup Manual Version 1 6 viii What s In This Manual What s In This Manual In this manual the Ektron CMS200 Installation Manual Version 1 0 you will find information including Ektron CMS200 Minimum Requirements Pre installation Tasks Installing Ektron CMS200 Setting Up a MS SQL Database Creating a DSN less Connection Configuring and Using SSL for CMS200 Ektron CMS200 Setup Manual Version 1 6 Installations Installations In Ektron CMS200 there are many types of maintenance operations that can be performed This chapter will look at all of the different types including e Upgrading to Version 1 6 e Installing to an Access Database on page 8 e Installing to a MS SQL Database on page 23 e Installing Ektron CMS200 in a Hosting Environment on page 38 Ektron CM
79. ment Press the PAGE DOWN key to see the rest of the agreement EKTRON INC SOFTWARE LICENSE AGREEMENT READ THIS BEFORE LOADING SOFTWARE YOUR RIGHT TO USE THE PRODUCT ENCLOSED IN THIS ENVELOPE OR OTHERWISE DELIVERED IS SUBJECT TO THE TERMS AND CONDITIONS SET OUT IN THIS LICENSE AGREEMENT OPENING THIS ENVELOPE OR USING THIS PRODUCT SIGNIFIES YOUR AGREEMENT TO THESE TERMS IF YOU DO NOT AGREE TO THIS SOFTWARE LICENSE AGREEMENT YOU MAY RETURN THE PACKAGE WITH THE UNOPENED ENVELOPE OF AS IT WAS DELIVERED AND THE gt Do you accept all the terms of the preceding License Agreement If you choose No the setup will close To install CMS200 you must accept this agreement InstallShield Once you have read the license agreement and if you agree to the terms and conditions click the Yes button at the bottom of the screen 5 After you have agreed to the license agreement and have clicked the yes button you will then be taken to the following screen Ektron CMS200 Setup Manual Version 1 6 26 InstallShield Wizard License Key Enter Company Name Here Enter License Key Here stall Shield At this screen you will be prompted to enter your company name and the license key that was sent to you via email from Ektron Once you have entered that information click the Next button to continue 6 The next screen that you will see is the Setup Type screen Ektron CMS200 Setup Manual Version 1 6 27
80. mentation is owned by Ektron or its suppliers is protected by United States copyright laws and international treaties and contains confidential information and trade secrets CUSTOMER agrees to protect the confidentiality of the Software and Documentation CUSTOMER agrees that it will not provide a copy of this Software or Documentation nor divulge any proprietary information of Ektron to any person other than its employees without the prior consent of Ektron CUSTOMER shall use its best efforts to see that any user of the Software licensed hereunder complies with this license 4 Limited Warranty Ektron warrants solely that the medium upon which the Software is delivered will be free from defects in material and workmanship under normal proper and intended usage for a period of three 3 months from the date of receipt Ektron does not warrant the use of the Software will be uninterrupted or error free nor that program errors will be corrected This limited warranty shall not apply to any error or failure resulting from i machine error ii Customer s failure to follow operating instructions iii negligence or accident or iv modifications to the Software by any person or entity other than Company In the event of a breach of warranty Customer s sole and exclusive remedy is repair of all or any portion of the Software If such remedy fails of its essential purpose Customer s sole remedy and Ektron s maximum liability shall be or refund of
81. netpub wwwroot active_cms_site_copy 2 2 Move the cms200scripts directory under this directory When finished the directory structure should look something like this c inetpub wwwroot active_cms_site_copy cms200scripts 3 Remove the expscripts directory under the active_cms_site_copy This will save you time troubleshooting templates that are still pointing to the expscripts directory 4 4 You will need to edit all templates and headers that include the CMS100 ektronAPI asp file Do this by editing the include virtual path at the top of each file in your site For example In header txt under the samplesite change the include from lt include virtual expscripts ektronAPI asp gt to lt include virtual cms200scripts ektronAPI asp gt You will need to do this for all files that used this include Most editing tools such as Macromedia ColdFusion Studio or Macromedia UltraDev will allow you to perform a search and replace of a certain string for a group of files You may want to consider this if you have many templates to update with the new include path If you site is accessed as a subdirectory from your domain host name i e www yourdomainname com CMS100Site you will need to either 1 When migration is complete rename your Ektron CMS200 subdirectory to the same name that was used by Ektron CMS100 This will allow all of your content links to function properly or Ektron CMS200 Setup Ma
82. ng Data with DBMover eXe ccseeenceeeeeseeeeeeeeeeneeteeeeeenenes 93 Contiguring SSMU ASD ie es sevecexctd ce seneehdedecetde ca Maven deedh aaia ae 97 Configuring Ektron CMS200 ccccccccceeeceeeeeeeeeeeeeeeeeeees 98 SSL SUPPO cpana 99 Seting Up the Cemiticate sarcina aaia 99 Updating GM S200 c ciccecccccysiees lt dtaesdaetedehenastunaseccebeneeedl ant a cieredeads 103 DSN leSs Connection ccccceesseseeeeeeeeeeeeseeeeeeeeeeeeseneeeees 106 BefOle You Begi essiri ani e 106 Creating amp UDE Pile 102 cctv Aoi aed ee ee ae 106 Windows 98 ME NT cvcs2scccccchaccsecenascsatdedenaaateediahs seavleeedat dvaashe cathe 106 Windows 2000 ccccecesicoctetis es cnediieldea th A need 107 Contigtinng TASUDE File ic s s 2 siceveseeededes sensei stevens ede eigen iciadsie ees 107 Configuring Ektron CMS200 for the UDL File cscceeececeeeeereeeees 108 Configuring Ektron CMS200 for the Provider String ccseeeee 109 Converting UDL file to a Provider String cccesseceeeteeetteeeeeees 109 Configuring Ektron CMS200 to use the Provider String 110 Ektron CMS200 Utilities ccccccsssssseeeeeeeeeeeeeeeeeeees 112 Migration from CMS100 for ASP seeeeeeeeees 113 PYCNOQUISIOS eein E tenets A 113 Installing CMS100 for ASP oi cc celccalons ce eetigeenccessaaeectege ddsanecdeddebdabeandntees 113 Installing GMS200 2 cic skis Aen eae ale ani 114 Backing Up the Mi
83. nimum Database cceseceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 114 Backing Up Your Active Sitesinin iniii 114 Point Ektron CMS200 to Minimum Database ceceeeeeeeeeeeeeneees 115 Locating the Migration Utility censier 118 Running the Migration Utity c ccc ccc thetiteteesd denis taecadiaeseetiiees 118 Configuring the Databases areira a 119 Inserting Your Ektron CMS200 License Key ssseessesssesessssrseens 122 iD FAY Seting S eein ela td 122 COMME SOMINGS yas cca fe cashe ss cececsanenveneecncd ds rina aaa aaie 123 WATS NERE oirisider a a a endian 131 Migrating your Templates cccceeccceeeeeeeeeeeeeeseeeeeeeeseeeeeeeneeneees 132 Moving Scripts Directory and Editing Templates ccceeee 132 T s ng YOUN MIGKANOM 4 xcc ccccccesiesarecetaptanreeneeteereceetneaeedeeateinnen 134 Ektron CMS200 Setup Manual Version 1 6 vi GOING HIV Gs isc A A A ai aiid dein na adsl 134 Customizing Ektron CMS200 cccccceceeeeceeneeeeeeeeeeeees 136 Language SDK inca chitin erase ESA 137 Before You Bagio ereda 137 Accessing the Translator s ccdtie senccetesssaecacee aaceceesstiaterdessinevides Ra AARRE 138 Selec ng PAMQUAQSs ceccess fe adscvvasseechsdees cave stnastecetares bensdev at RETE 139 MNG COWS es sieraed riina evade aiaa 141 Translating SUNOS eein ae E ar Ea 142 Selecting SUING irisscan anakana ae y aAa anaa a AEA NEERA 142 Bip aee e N A E E N E A E N eietaateseeeeaeee 143 Editing SWING iess
84. nk Displays the link to the content block on the Web site Note You will need to be logged in to see the changes appSubmitterDateTime Displays the date and time the content block was submitted appApprovalList Displays the current approval list that the content block will need to pass through AppComment Displays the comments for the content block Ektron CMS200 Setup Manual Version 1 6 153 List of CMS200 Emails Notify Approval Process Complete Because of the logic there are four different emails for notifying that the approval process is complete Deletion of Content Approved Message Title email subject content deletion approved Message Text Deletion of content has been approved Message Title email body content deletion approved Message Text The deletion of the content appContentTitle has been approved The content deletion will occur on appDeletionDateTime Immediate Deletion of Content Message Title email subject content has been deleted Message Text Content has been deleted Message Title email body content has been deleted Message Text The deletion of the content appContentTitle has been approved The content was deleted immediately Approved Content Awaiting Go Live Date Message Title email subject content changes approved Message Text Content changes have been approved Message Title email body content changes approved Message Text The changes to the content appC
85. ntent blocks you wish to move to the root content folder click the Move button in the middle of the screen Ektron CMS200 Setup Manual Version 1 6 125 Migration from CMS100 for ASP E CMS200 Migration Utility x Please select and move your content to a CMS200 content folder lt Remove i You will notice that the content blocks will now appear in the right column and they are no longer in the left column To add the content blocks to the folder click the Add button at the bottom of the screen Ektron CMS200 Setup Manual Version 1 6 126 Migration from CMS100 for ASP 2 CMS200 Migration Utility x Please select and move your content to a CMS200 content folder CMS100 Applicaton CMS200 Application Login Informabon f z Mave gt lt Remove Add Next gt If you would like to create a folder structure to organize the remaining content blocks this can be done by selecting the New Folder button w Add New Folder 5 x Parent Folder New Folder Name Once you select the New Folder button you will see the screen shown above Here you will need to name the folder that you are creating by entering the name in the New Folder Name field In this case lets add a folder named Support Ektron CMS200 Setup Manual Version 1 6 127 Migration from CMS100 for ASP ig Add New Folder A Parent Folder New Folder Name wet o Add Close Once you have finished enter
86. nual Version 1 6 133 Migration from CMS100 for ASP 2 When migration is complete edit all links in content blocks that are referring to the old Ektron CMS100 subdirectory These will need to be modified to refer to the new Ektron CMS200 subdirectory NOTE All directory names used are for example only and you can name them to whatever you prefer Testing Your Migration It is important that you test your site after you have completed all of the required steps for the migration You can do this by going over each page on your site that has content blocks To be thorough access all templates with content in them You can compare from your active site before going live To make it easier to test we recommend that you use a staging URL to access the new site For example www yourdomainname com may point to the native site that is using CMS100 Use a development IP address or domain name and point it to the new site You can even use localhost or 127 0 0 1 to test locally Going Live If you have followed the suggested flow of migration described throughout this manual going live will be a fairly easy task When your site construction and testing are complete you can change IIS to point to your new Ektron CMS200 enabled site This can be done in your IIS Console by 1 Select Properties of the site or virtual site 2 Edit the Local Path to point to the new Ektron CMS200 site directory 3 Save your changes
87. ons You should put this copy in a place where you will be able to modify it and not your active site You can do this however you d like but it is recommended that you make a copy of your active Ektron CMS100 site and modify the copy to use Ektron CMS200 When your migration and testing are complete you should then go live with your new site If you setup IIS to point to your Ektron CMS100 site directory you will be able to simply point IIS to your new Ektron CMS200 site when migration and testing are finished This is the easiest way of migrating because all of your references to your sitepath are assumed to be just So all templates that reference includes will be easier to modify Example www yourdomainname com pointing to c inetpub wwwroot active_cms_site can be changed to point to Ektron CMS200 Setup Manual Version 1 6 114 Migration from CMS100 for ASP c inetpub wwwrootl active_cms_site_copy when you are ready to go live with the CMS200 site Point Ektron CMS200 to Minimum Database Ektron CMS200 is installed with two databases One is a sample database that allows you to get an idea of how a Ektron CMS200 Web site works The other database is a minimum database that has almost nothing in it This is the database that Ektron CMS200 must be pointing to before you begin the migration To do this follow the steps listed below 1 Begin by opening your ODBC Manager in the Administrator Tools section of Win
88. ontentTitle have been approved The content changes will occur on appChangeDateTime Ektron CMS200 Setup Manual Version 1 6 154 Approved Content Published Immediately Message Title email subject content has been changed Message Text Content changes have been made Message Title email body content has been changed Message Text The changes to the content appContentTitle have been approved The content changes went live immediately Decline Approval Request Message Title email subject approval request declined Message Text Content approval request declined Message Title email body approval request declined Message Text Your submitted approval request for the content appConteniTitle has been declined by appDeclinerFirstName appDeclinerLastName Send Approval Message Message Title email subject request for approval Message Text Request for content approval Message Title email body request for approval Message Text The content appContentTitle has been submitted for your approval by appSubmitterFirstName appSubmitterLastName appCRLF appCRLF To locate the content the folder path in your workarea is appFolderPath appCRLF appCRLF The following link will take you to the submitted content block on the Web site appContentLink appCRLF appCRLF Please Note You must login and select the preview icon to view the changes appCRLF appCRLF The content was submitted
89. ot edit below her AppPath sitePath amp cms200scripts AppImgPath AppPath amp images application AppeWebPath AppPath amp ewebeditpro2 this path is realtive from the defualt root AppConfStr DSN amp amp DBusername amp amp DBpassword amp amp sitePath amp amp Version _ amp amp Request ServerVariables SERVER_NAME amp amp Request ServerVariables SERVER_PORT _ amp amp Request ServerVariables HTTPS amp amp DBType amp amp DateFormat AppName Ektron CMS200 amp gt Save and close setup asp and you are all set up to use the SSL support for Ektron CMS200 WARNING If the UseSSL line is set to True and the Certificate is NOT installed to the Web Server you will be unable to log into Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 105 DSN less Connection Other than the standard connection to a database using an ODBC connection Ektron CMS200 also allows you to create a DSNless connection using OLE DB If you are planning on using OLE DB you have two options e Use a UDL file e Use an OLE DB Provider string This section will explain both of these options Before You Begin Before you can access the Ektron CMS200 database via OLE DB you must know the following e The type of data that you want to access e The server where the data resides e The database in which the data is
90. r For Data Mining Services Microsoft OLE DB Provider for Indexing Service Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAP Services Microsoft OLE DB Provider for OLAP Services 8 0 Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for SOL Server 3 Select the driver you wish to use Ektron CMS200 Setup Manual Version 1 6 107 4 Click Next gt gt to move to the Connection tab 5 At the connection tab enter the connection properties NOTE Each driver will require different settings All drivers will require a user name and password 6 Click on the Test Connection button to verify your connection is working correctly Change accordingly if you get an error Select the advanced tab only if you require advanced settings When completed click the OK button to save and close the UDL file Now that you have successfully created and configured a UDL file you have two options e Configure Ektron CMS200 to use the UDL file e Convert the UDL file into a Provider string and configure Ektron CMS200 to use that Configuring Ektron CMS200 for the UDL File Once you have created and configured the UDL file for the to access that file 1 Using Windows Explorer navigate to the directory where Ektron CMS200 for ASP was installed to By default the directory is C Inetpub wwwroot CMS200Sample Save the UDL file under the CMS2
91. r maximum 4 2 Select a message title on the left side Badd sort msg add group permissions add bbrary file msg add Bbrary hyperlink msg add bbrary msg add bbrary quicklink msg add metadata definition mig add new user group msg add new user msg add permissions add permissions msg add subfolder msg add this user to group msg z 4 gt ED Fatp192 160 0 186 048200zenpleflang ertry exp ilomelibre von for matmumBapdatewOdlenqueyelD 100 te item SSS From this window you will have the ability to see what the English version of the strings are as well as translated them to your desired language Translating To complete the translation of a string follow these easy steps 1 Click on the string in the left frame that you would like to translate Insert the translated message in the proper text field Insert the translated comment in the proper text field max 75 characters 4 Click ADD in the upper right hand side of the screen Ektron CMS200 Setup Manual Version 1 6 143 Once you have clicked ADD the icon next to the string that you just translated should change the proper icon NOTE This may take some time to complete Please wait until the utility is complete Editing String If you need to modify an existing string you can easily edit it by selecting it again and making the necessary changes to the text fields Active Languages Once you have translated all of the strings
92. rmation in the field below What is the server host name including subfolder you will be using to access this site If you are unsure please use the default http localhost CMS 2005 ample InstallShield lt Back Cancel At this screen specify the path of the host that Ektron CMS200 will be running on or keep the default Click Next gt to proceed 12 Once you click next you will see the setup status window Ektron CMS200 Setup Manual Version 1 6 53 InstallShield Wizard Setup Status CMS200 Setup is performing the requested operations Installing c cms200scripts ewebeditpro2 clientinstall installnowlr asp 34 InstallShield Once this reaches 100 the installation will be complete 13 If you have opted to not install the new sample site you will be prompted with a message to update the strings in your old database Question Ex Q You will need to update new strings added to the language table required to run version 1 60 Would you like to do this now For information about running this wizard see Language Update on page 56 14 During the setup status you will see the following message Ektron CMS200 Setup Manual Version 1 6 54 Creating Datasource for Sample Site This informs you that the sample site is being created 15 Once the sample site is finished being populated you will see a message like the following Information
93. rogram doesn t do this for you you must go to the location and make all the changes manually by creating the directory and images NOTE You can copy all the images out of the English folder into the foreign language directory and just modify those images to correspond to the proper language Ektron CMS200 Setup Manual Version 1 6 150 Customizing Ektron CMS200 Emails Introduction Ektron CMS200 provides the option of sending email notifications to users informing them that specific actions have taken place or specific actions are requested These emails are stored in and received from the app_messages table in the database Ektron CMS200 does not currently support HTML emails however the current text messages are fully customizable Each email has a string in the table for the subject and one for the body The bodies of the emails often have variables which are between symbols Ektron CMS200 replaces these variables on the fly with the specific information for that particular instance of the email For example appContentTitle in the following sentence would be replaced with it s actual title Before The content appContentTitle has been deleted After The content Home Page Content has been deleted These emails can be customized The variables can be taken out or moved around More text can be added text can be rewritten or reorganized Before appConteniTitle has been deleted from the XYZ W
94. s ccccssssseeeeteeeeeeeeeeeees 61 CMS200 vi 50 ACCESS UMOD ics cecccccccesssacssceieeeceddccttedeaeteensd didindess nae 61 cms200_v15_ Min _aACCESS2Z000 MAD cc ceecsessseeeeeeeeeeeeseseeeeeeeseeeneees 61 Setting Up a MS SQL Database cccccceseseeeeeeeeeeeeeees 63 Setting MS SQL as a Database Type ceccceeeseceeeeeeeeeeeeeeteeteeeeeneeaes 63 Creating An Empty SQL Database noiniaii 64 R nning the SQL Schl cscce ececeenees cadeeadtasecdsagenetevecteegeatadeeebeleadavaneeeees 66 Creating New DSN wcsesinciii iin neta auee edie 70 OVI UNS AE cc E A A E A eat E E eae 73 Ektron CMS200 Setup Manual Version 1 6 v Setting Up a MySQL Database ccc eeeeeeeeeeeeeeeeees 76 FROQUINGIIG ING ccceecs acccneepes dee ceteeeataucetesacncenpessacreadbanitysdadesdensidtesehedadenseeesd 76 Setting MySQL as a Database Type ecccccceeseeeeeeeeeeeeeeeeeeeeenees 76 Connecting TO MYSQL seiesima aaaeaii 77 Creating the Daba incurs tl iiecaianiin teedvn be anette 78 Building the Ektron CMS200 Tables c ccsseceeceeeeeeeeeeeeeeeeeeesaeeeeneees 81 Creating a DSN for the MySQL Database eccccceieeseeeeeteeeeeteeeteees 84 Moving Data into the MySQL Database ceccecceeeeeeseeeeeeeeseteeeeeneees 90 Prior TO MOVING Daltaliscsisccedc cntci dient eccsaieecimie cliente edit ciebin 90 Moving Data with cms200_datamover asp eeeeeeeeeeeeeeeeeeeeeeeeeees 91 Movi
95. sion 1 6 102 Default Web Site Properties 9a x Directory Securty HTTPHeaders CustomEmors Server Extensions Web Site Performance ISAPIFiters Home Directory Documents Web Site Identification Description Def aut Web Sig IP Address Al Unassigned TCP Patt g E Connections c Ure imteg Umiedtc 10 connections Connection Timeout 300 seconds IV HTTP Keep Alives Enabled i Enable Logging Actiwe log format wac Extended Log File Format Properties 9 Set the SSL Port that you want the Web server to use 10 Click the OK button at the bottom of the page when you have completed all the steps Once you have installed the Certificate to the Web server you can now configure Ektron CMS200 to use it Updating CMS200 On the Web server where Ektron CMS200 is installed to navigate to the setup asp file which by default gets installed to the following directory C Inetpub wwwroot cms200sample cms200scripts Once you arrive to the file open it in any Web development tool Once the file is open look about halfway down the file for the line of code that says Use SSL Ektron CMS200 Setup Manual Version 1 6 103 lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port oe AppImgPath Dim DBType DateFormat DSN CMS200_v1_60_MSSQL Designate the database type below Vaild values are mysql
96. sion 1 6 147 1 From the user folder click on the username of the user you wish to edit ment View Users in A Everyone Bae in Administrator Edit 2 Click the edit button for the user that you wish to edit 3 Follow all the steps of editing a user you have read in the User Manager chapter 4 There will be a drop down box with the active languages that you can assign to the user Ektron CMS200 Setup Manual Version 1 6 148 tran MS2700 Werkaree for Applic ation Administrator Microsoft Internet Explorer Username admin First Name Application Last Name Administrator Password CO Confirm Pwd pe User Language AppOstaut wd E Mail Address F Disable E Mail Emails for this apy 5 Select the default language you want to assign to the user 6 Click the update button to save the settings i Images Since most of the buttons in Ektron CMS200 are strictly pictures they will not need to be changed However there are some images that do require translated since they contain words When a new language is set active Ektron CMS200 calls the images that are being used from a different directory For example when you have English US set active the images are called from expsripts images english But when another language is set active like German the images will now be called from expscripts images german Ektron CMS200 Setup Manual Version 1 6 149 The language translation p
97. ssfully to mysqld 3 23 49 nt NOTE Click OK to close this box If you receive an error check your connection information If problems persist refer to your MySQL Documeniation for troubleshooting 8 Finally click OK at the DSN Configuration window to save and close the changes With the creation of the DSN for the Ektron CMS200 MySQL database complete you are now ready to move the content from the default MS Access database to this one Moving Data into the MySQL Database With all the previous tasks completed successfully you are ready to populate the database with data There are currently two options for doing this The first option is to run an Active Server Pages file named cms200_datamover asp and the second option is to runa Visual Basic application named dbmover exe Both options port the sample Microsoft Access database to the newly created MySQL database Prior To Moving Data NOTE Before you move the data from the Access database to the MySQL database you will need to be sure the following requirements are met 1 There is a system DSN that points to the Ektron CMS200 Access database titled cms200_v16_sample_access2000 This DSN is created when Ektron CMS200 is initially installed Ektron CMS200 Setup Manual Version 1 6 90 2 There is a second system DSN that point to the Ektron CMS200 MySQL Database which we created earlier in Creating a DSN for the MySQL Database on page
98. ssword for the destination DSN in the proper fields if necessary 7 Next choose the DB type for the Destination DSN CMS Data Mover 8 Once you have entered all the necessary information for the CMS Data Mover click Transfer to initiate the move el 9 If the transfer is successful you will see the following message dbmover Exi NOTE If the data did not populate or you received an error please review your data sources and their connection information Ektron CMS200 Setup Manual Version 1 6 96 Configuring Setup asp The last step is to open setup asp file again and locate the line DSN CMS200_Sample Change the line so the DSN variable is equal to the name of your MySQL Data Source Shown below is an example NOTE Also be sure that the DBType field is equal to mysql Before lt Dim DSN DBusername DBpassword fileUploadPath imageUploadPath AppConfStr Dim AppPostacceptFile sitePath AppName AppeWebPath AppPath buildNumber PostAcceptorFile Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_Sample sitePath CMS200Sample buildNumber 1 6 DBusername DBpassword Version 1 6 UseSSL false SSL_Port 443 PostAcceptorFile uploader asp Designate the database type below Vaild values are mysql sql access DBType access DateFormat dd mmm yyyy hh mm ss AM PM After
99. t NH 03031 USA Tel 1 603 594 0249 Fax 1 603 594 0258 http www ektron com Ektron CMS200 Setup Manual Version 1 6 161
100. t for Ektron CMS200 Ektron CMS200 Setup Manual Version 1 6 10 InstallShield Wizard Ektron License Agreement Press the PAGE DOWN key to see the rest of the agreement EKTRON INC SOFTWARE LICENSE AGREEMENT READ THIS BEFORE LOADING SOFTWARE YOUR RIGHT TO USE THE PRODUCT ENCLOSED IN THIS ENVELOPE OR OTHERWISE DELIVERED IS SUBJECT TO THE TERMS AND CONDITIONS SET OUT IN THIS LICENSE AGREEMENT OPENING THIS ENVELOPE OR USING THIS PRODUCT SIGNIFIES YOUR AGREEMENT TO THESE TERMS IF YOU DO NOT AGREE TO THIS SOFTWARE LICENSE AGREEMENT YOU MAY RETURN THE PACKAGE WITH THE UNOPENED ENVELOPE OF AS IT WAS DELIVERED AND THE gt Do you accept all the terms of the preceding License Agreement If you choose No the setup will close To install CMS200 you must accept this agreement InstallShield Once you have read the license agreement and if you agree to the terms and conditions click the Yes button at the bottom of the screen 5 After you have agreed to the license agreement and have clicked the yes button you will then be taken to the following screen Ektron CMS200 Setup Manual Version 1 6 11 InstallShield Wizard License Key Enter Company Name Here Enter License Key Here stall Shield At this screen you will be prompted to enter your company name and the license key that was sent to you via email from Ektron Once you have entered that information click the Next bu
101. ttom of the screen If the DSN is good you will receive a message that the test completed successfully If not edit the DSN and make sure that everything is set up properly 10 To finish click the OK button at the bottom of the screen and close the ODBC Manager Once the database has been created the script has run and the ODBC connection has been made you are ready to run the data mover which will move the content from the default Access database to the new MS SQL database Moving the Data The next step in setting up a MS SQL database is to run the data mover that also gets installed with Ektron CMS200 The data Ektron CMS200 Setup Manual Version 1 6 73 mover will move everything that is in the current Access database to the MS SQL database To do this 1 Move the file cms200_datamover asp from the c Program Files Ektron CMS200 Utilities directory into an asp enabled web directory An example is C Inetpub wwwroot CMS200Sample 2 Call the datamover asp file from the web server via your browser i e http localhost cms200sample cms200_datamover asp F Data Mover for M5700 Microsoft Internet Explorer Ble gdt Yew Favorites Jods teip Heak e gt OD Al Ash rvoe Grey AA AO Adress E To Content datamover for Ektron CM8200 This utility moves content from one CMS200 database to another You must create the new tables in the destination database and create a Data Source Name OSN for th
102. tton to continue 6 The next screen that you will see is the Setup Type screen Ektron CMS200 Setup Manual Version 1 6 12 InstallShield Wizard Select Setup Type Please select your setup type Program will be installed with the most common options Recommended for most users Compact Program will be installed with minimum required options Custom You may choose the options you want to install Recommended for advanced users InstallShield lt Back Cancel At this screen you can choose which type of installation you would like to perform e Typical Recommended this will install all the files for Ektron CMS200 e Compact This will install the minimum amount of files e Custom You may choose the files and options that you want to install Once you have selected which type of installation you wish to run click the Next gt button to proceed 7 After you select the setup type you will then proceed to the following screen Ektron CMS200 Setup Manual Version 1 6 13 InstallShield Wizard Application Path Setup will install CMS200 components into the following folder To install to this folder click Next To install to a different folder click Browse and select another folder Destination Folder oreo Files Ektron CMS 200 Browse InstallShield Cancel At this screen specify the location where you wish to install the Ektron CMS200 components Eith
103. u will then be asked to enter information about the authentication for the DSN at the next window Enter the necessary information and click Next to continue 7 At the next window you will need to change the default database to the one that you created earlier JV Change the default database to V and drop the stored procedures Make any other adjustments at this screen if necessary then click Next to continue 8 At the next window choose which ever options you would like for the DSN then click Finish Ektron CMS200 Setup Manual Version 1 6 72 9 You will then see a confirmation message with all the options a settings you chose for the datasource ODBC Microsoft SQL Server Setup A xi 4 new ODBC data source will be created with the following configuration Microsoft SQL Server ODBC Driver Version 03 80 0194 Data Source Name CMS200_SQL Data Source Description SQL DSN for Ektron CMS200 Server local Database CMS200_SQL Language Default Translate Character Data Yes Log Long Running Queries No Log Driver Statistics No Use Integrated Security Yes Use Regional Settings No Prepared Statements Option Drop temporary procedures on disconnect Use Failover Server No Use ANSI Quoted Identifiers Yes Use ANSI Null Paddings and warnings Yes Data Encryption No B OK Cancel To verify that the data source was set up and configured properly click the Test Data Source button at the bo
104. uestion Setup needs to move the content to your new MSSQL database This will need to be done prior to using the product with this database Would you like setup to perform this now 15 After you click the next button the installation program has all the information needed to properly install all the files and finish the installation Ektron CMS200 Setup Manual Version 1 6 35 InstallShield Wizard Setup Status CMS200 Setup is performing the requested operations Installing C coms200scripts images application btn_save nm gif es InstallShield This screen gives you a status on the installation When the bar reaches 100 the installation is complete 16 Once the status is 100 complete you will see the following information box Click Yes to move the sample site content to the MS SQL database Clicking No will not move the content and you will need to perform this manually 17 Once the installation is complete you will see the following screen Ektron CMS200 Setup Manual Version 1 6 36 InstallShield Wizard InstallShield Wizard Complete Setup has finished installing CMS200 on your computer From here click the Finish button and you are ready to explore your new Ektron CMS200 Web site Ektron CMS200 Setup Manual Version 1 6 37 Installing Ektron CMS200 in a Hosting Environment To install Ektron CMS200 in a hosted environment first install Ektron CMS200 accor
105. umber Version UseSSL SSL_Port AppImgPath Dim DBType DateFormat DSN CMS200_v1_60_ Access Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200Sample buildNumber 1 6 0 05 DBusername DBpassword Version 1 60 UseSSL false SSL_Port 443 5 At the line where it says DSN CMS200_v1_60 Access change this to DSN Provider lt string gt An example of this may be lt Dim DSN DBusername DBpassword AppConfStr Dim sitePath AppName AppeWebPath AppPath buildNumber Version UseSSL SSL_Port AppiImgPath Dim DBType DateFormat DSN Provider Microsoft Jet OLEDB 4 0 DataSource C Inetpub wwwroot CMS200Sample database CMS200_v1_50_Access mdb Persist Security Info False Ektron CMS200 Setup Manual Version 1 6 110 Designate the database type below Vaild values are mysql sql access DBType DateFormat dd mmm yyyy hh mm ss AM PM sitePath CMS200Sample buildNumber 1 6 0 05 DBusername DBpassword Version 1 60 UseSSL false SSL_Port 443 Ektron CMS200 Setup Manual Version 1 6 111 Ektron CMS200 Utilities To assist in further configuring and expanding Ektron CMS200 s functionality several utilities have been included in the installation Utility Description More Information Database The d
106. utton you will be taken to the setup type screen seen below InstallShield Wizard Setup Type Choose the setup type that best suits your needs With your current configuration you can Upgrade or CMS200 Please select one of the following options Receseectteceecessced C Remove InstallShield lt Back Cancel At this screen choose which type of setup you would like to perform Click Upgrade then click the Next gt button at the bottom of the screen to continue NOTE For information about removing Ektron CMS200 see Uninstalling Ektron CMS200 on page 164 6 Once you click the next button you will be asked the following question Ektron CMS200 Setup Manual Version 1 6 50 Q Do you want to stop your WW Service Otherwise you may need to reboot at the end of installation Click Yes to stop your WWW Service and continue or click No to continue without stopping the service 7 After you choose yes or no you will then be taken to the following step in the upgrade program InstallShield Wizard Choose Destination Location Select folder where Setup will install files Please select the program s application root directory c Program Files Ektron CMS 200 Browse Installshield lt Back Cancel At this screen you will need to enter the directory where the Ektron CMS200 Components were installed to in your previous version This will allow th
107. ve and close this file Creating An Empty SQL Database First you must create an MS SQL database To do this follow these steps 1 From the Windows start menu open your MS SQL Enterprise Manager Microsoft SQL Ektron CMS200 Setup Manual Version 1 6 64 Select the server that you want to add the database to ey Console Root H E Microsoft SQL Servers E J SQL Server Group Sy RSE H Databases J Data Transformation Ser J Management rn Ga neckectine 3 Right click on the database folder and select New Database Console Root Microsoft SQL Servers EMG SOL Server Group Dal E Pener All Tasks New Window From Here Refresh Help 4 Enter a name for the database e g CMS200_ SQL General Data Files Transaction Log El Name Joms200_sau Database Status Unknown Quwner fl Inknawnl 5 Click the OK button at the bottom of the window The page will be refreshed and you will see the database you just added on the right side of the screen Ektron CMS200 Setup Manual Version 1 6 65 6 Close the Enterprise Manager Running the SQL Script The sql script that is provided with Ektron CMS200 will create all the necessary tables in the newly created MS SQL database for Ektron CMS200 The script is in the c Program Files Ektron CMS200 Utilities directory as cms200_mssql_v16 sql To access it and run it properly follow these steps Ektron CMS200 S
108. will allow you to create the DSN for the database Ektron CMS200 Setup Manual Version 1 6 17 InstallShield Wizard Please select the datasource you wish to create for this database CMS200_v1_60 InstallShield lt Back Cancel At this screen either accept the default DSN name or edit it to be whatever you like Once you have chosen a name for the DSN click the Next gt button at the bottom of the page to continue NOTE For information about creating a DSN less connection using an OLE DB connection string see DSN less Connection on page 106 13 After you have configured all the database information you will need to enter the server host name at the next screen seen below Ektron CMS200 Setup Manual Version 1 6 InstallShield Wizard http localhost CMS2005 ample stall Shield The server host name is the path you will be using to access the Ektron CMS200 Web site At this screen you can either accept the default host name or enter your own Once completed click the Next gt button to continue 14 The next screen will assist you in creating a short cut in your start menu in Windows Ektron CMS200 Setup Manual Version 1 6 19 InstallShield Wizard y Select Program Folder Please select a program folder Setup will add program icons to the Program Folder listed below You may type a new folder name or select one from the ex
109. y to enforce any provision of this Agreement shall not constitute or be construed as a waiver of such provision or of the right to enforce such provision If you fail to comply with any term of this License YOUR LICENSE IS AUTOMATICALLY TERMINATED This License represents the entire understanding between the parties with respect to its subject matter Esker Active X Plug in Active X controls under Netscape Use License IMPORTANT READ CAREFULLY Use of the Esker Active X Plug in is subject to the terms and conditions below BY INSTALLING COPYING OR OTHERWISE USING THE PLUG IN YOU AGREE TO BE BOUND BY THE TERMS AND CONDITIONS BELOW IF YOU DO NOT AGREE TO THESE TERMS AND CONDITIONS DO NOT INSTALL COPY OR USE THE PLUG IN The Plug in is provided to you as an end user as is without technical support No rights are granted to you in this license for commercial use or redistribution of any kind Should you desire to redistribute the Plug in or include it with other software packages please e mail Esker at axplug in esker com to find out how you may do so DISCLAIMER OF WARRANTIES TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW ESKER AND ITS SUPPLIERS PROVIDE TO YOU THE PLUG IN AS IS AND WITH ALL FAULTS AND ESKER AND ITS SUPPLIERS HEREBY DISCLAIM WITH RESPECT TO THE PLUG IN ALL WARRANTIES AND CONDITIONS WHETHER EXPRESS IMPLIED OR STATUTORY INCLUDING BUT NOT LIMITED TO ANY IF ANY WARRANTIES OR CONDITIONS OF OR RELATED TO TITLE NO
110. ysql Welcome to the MySQL monitor Commands end with or g Your MySQL connection id is 23 to server version 3 23 49 nt Type help or h for help Type c to clear the buffer mysql gt connect CMS266 Connection id 24 Current database CMS206 mysql gt show tables app_messages approval_status_thl approval_thl content content_edit content_folder_thl content_history content_meta_thl edit_meta_thl folder_to_template_thl fonts history_meta_thl language_t ype library libt ype max_entries metadata_type permissions_thl save_meta_thl save_thl settings templates_thl user_to_group_thl usergroups in set 1 sec If the script ran correctly MySQL will output a list of the 25 tables that were created seen above Once the tables are all created in the MySQL database you will be ready to move the content from the existing database to this one Ektron CMS200 Setup Manual Version 1 6 83 Before you can do that however you must first create a DSN for the MySQL database that we just created Creating a DSN for the MySQL Database You will need to have a data source setup for each database one for the Access 2000 database and one for the MySQL database To create the second data source you will need a utility to connect to a MySQL database through an ODBC connection It can be found at http www mysql com downloads api myodbc html Use the MySQL driver installed from the MySQL ODBC ut

Ektron CMS200 Setup Manual

Contents

Download Pdf Manuals

Related Search

Related Contents