Modify Transforms.xml File

The necessary installation files are located in the OPPSA\OPPSA-InstallTransformKit folder found on the release media provided. Copy this folder and all contents to the server where the OPPSA application will be installed.

Note: the folder and contents could be copied to any server for modification and preparation of the final windows installer package (.msi). The final install package (.msi) created from the steps outlined below needs to be copied and executed from the server where the OPPSA application will be installed.

Contents of the “OPPSA\OPPSA-InstallTransformKit” folder:

Run.bat – this batch file that calls the MsiTransform.exe with appropriate parameters to produce an .msi executable.
Transforms.xml – The Transforms.xml file contains the properties and values used to create configuration settings for the installer package (.msi).
MsiTransform.exe – this executable uses the OppsaSaasInstaller.msi and Transforms.xml to create the OPPSA installer packager (.msi).
OppsaSaasInstaller.msi – this is an installer package with default configuration values used as a template by the MsiTransform.exe program to generate the final OPPSA installer packager (.msi).
Transforms.xsd – definition of the transforms.xml file for reference purposes.

Locate the Transforms.xml file. Add and modify the transform property values based on your environment configuration. The Transforms.xml properties are used to create a windows installer package (.msi). See Appendix A: Sample Transforms.xml for a sample transform file. The properties are used for web.config settings for communication between OPPSA and Databases.

Note: Be sure to specify all properties and values in the transforms.xml as the installation logic will assume defaults if the property is not specified and could cause runtime errors.

Transform Property	Description
SQLHOSTNAME	Property for Membership DB configuration for ASP.NET membership provider application authentication. Fully qualified server name where new membership database is located.
SQLINSTANCENAME	Property for Membership DB configuration. Specify the name of the SQL Server instance.
SQLSESSIONHOSTNAME	Property for Session DB configuration for load balancer. Fully qualified server name for session database. This could be on the same database server as the membership database or a separate server. Specify existing session DB if load balancing configuration already exists and intend to use for this application as well.
SQLSESSIONINSTANCENAME	Property for Session DB configuration. Specify the name of the SQL Server instance.
USEINTEGRATEDSECURITY	Property to indicate type of trusted connection to use. Values: 0-SQL Server Authentication, 1-Windows Authentication. If using Windows Authentication, remove the user and password properties from the transform file: OPPSA.AUTHSQLLOGIN, OPPSA.AUTHSQLPASSWORD
USEINTEGRATEDSECURITYSESSION	Property to indicate type of trusted connection to use. Values: 0-SQL Server Authentication, 1-Windows Authentication. If using Windows Authentication, remove the corresponding user and password properties from the transform file: OPPSA.AUTHSESSIONSQLLOGIN, OPPSA.AUTHSESSIONSQLPASSWORD
OPPSA.AUTHSQLLOGIN	Property to define the membership authentication DB connection user that will be used by application to connect to the membership authentication DB. If using Windows Authentication, remove this property.
OPPSA.AUTHSQLPASSWORD	Property to define the password for the membership authentication DB connection user that will be used by application to connect to the membership authentication DB. If using Windows Authentication, remove this property.
Oppsa.AspNetMembershipDb	Property to define the name of the membership authentication DB.
Oppsa.AspNetStateDb	Property to define the name of the membership state/ session DB.
OPPSA.WebSite	Property to define the root website for where application service will be created in Internet Information Services (IIS). See Appendix B: Example of Internet Information Services (IIS) Transform Property values for example. This property defines the default website root folder. Add an imbedded note here that states: If installing under “Default Web Site”, remove this property as the installation defaults to this root folder.
OPPSA.AppVirtualDirName	Property to define Application Pool Virtual Directory Name for IIS. See Appendix B: Example of Internet Information Services (IIS) Transform Property values. The application pool is where to set up the account name responsible for running the application. This installation is using the default IIS account. Note: This transform does not provide properties to change the default account.
OPPSA.AppPoolName	Property to define Application Pool Name for IIS. See Appendix B: Example of Internet Information Services (IIS) Transform Property values.
OPPSA.EXPEREENDPOINTADDRESS	URL for the Expere Service Endpoint. Example: `Value="http://labw6412hvm922.wkmnlab.net:8080/Common/WSEndpoint"/>`
OPPSA.AUTHSESSIONSQLLOGIN	Property to define file location for the OPPSA log file. See Appendix C: Using Log Files. Property Value Format: `Value=C:\\ProgramData\\WKFS\\OPPSA\\OPPSA`. (double backslash is required to escape the special character backslash) Default path is: `C:\ProgramData\WKFS\OPPSA\OPPSA`. The Last element of path name defines the prefix of the filename and current date is appended. The filename is constructed as follows: `OPPSA_CurrentDate.log`
OPPSA.ApplicationName	Property to define application name in membership database.
OPPSA.MinPasswordAgeInDays	Property to define the minimum password age in days for OPPSA application users. Determines the period of time (in days) that a password must be used before the user can change it. You can set values between 1 and 999 days, or you can allow changes immediately by setting the number of days to 0.
OPPSA.MaxPasswordAnswerAttempts	Property to define the number of incorrect password attempts allowed before the OPPSA user will be locked.
OPPSA.TargetHostName	Property to define fully qualified name of the host where OPPSA application will be installed. This property is used for URL Rewrite https redirect configuration.
OPPSA.SHOWLEGACYFUNCTIONALITY	Property to define if non-hosted features should be available. For Hosted installations, this value MUST be set to “false".
OPPSA.WebHelpLink	Property to define the URL for WebHelp. Leave this default value in sample transform file for the Help link in the application to access online help.
OPPSA.PolicyLink	Property to define the URL for the Privacy and Policy information. Do not change this property. Tranform default: `Value="http://www.wolterskluwerfs.com/privacy-cookies-policy.aspx"`
OPPSA.SupportLink	Property to define the URL for Support information. Do not change this property. Transform default: `Value="http://www.wolterskluwerfs.com/support/"`