# 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.

Before modifying this file: consult the OPPSA Change Log Entries for for any modifications that would require transform updates and review Configuring Load Balanced Environment.

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. Note: For load balanced environments, the domain name needs to be specified as ‘localhost’. For environments that not load balanced, ‘localhost’ can be used as long as Expere is installed on the same server as the OPPSA application. `Value="http://localhost:8080/Common/WSEndpoint"/>` Example for Environment NOT Load Balanced: `Value="http://labw6412hvm922.wkmnlab.net:8080/Common/WSEndpoint"/>`
OPPSA.AUTHSESSIONSQLLOGIN | Property to define the membership session DB connection user. If using Windows Authentication, remove this property. If using Windows Authentication, remove this property.
OPPSA.AUTHSESSIONSQLPASSWORD | Property to define the password for the membership session DB connection user. If using Windows Authentication, remove this property.
OPPSA.LogFileLocation | 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: `OPPSACurrentDate.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 | Informational: Property to define the URL for the Privacy and Policy information. Do not change this property. This property is automatically set to the following default value and does not need to be included in the tranforms.xml file: `Value="http://www.wolterskluwerfs.com/privacy-cookies-policy.aspx"`
OPPSA.SupportLink | Informational: Property to define the URL for Support information. Do not change this property. This property is automatically set to the following default value and does not need to be included in the tranforms.xml file `Value="http://www.wolterskluwerfs.com/support/"`