SupplierConnect Portal Install and Upgrade Quick Guide

PHP install/upgrade

• PHP 5.4 is compatible with Supplier Connect Response Portal Version 7. It is recommended for security reasons to update to PHP version 7.1

Microsoft Web Platform Installer

• Logon to the machine running the IIS 

• Download and install Microsoft Web Platform Installer 5.0 is not already installed.

Link  https://www.microsoft.com/web/downloads/platform.aspx or Search 'Microsoft Web Platform Installer'

Packages to be installed 

            'PHP 7.1.7 (x86) for IIS Express'

            'Microsoft Drivers 4.3 (x86) for PHP v7.1 for SQL Server in IIS'

            'Windows Cache Extension 2.0 (x86) for PHP 7.1 in IIS Express (Automaitcally selected when PHP is selected)

            'PHP Manager for IIS'

• Click on Products and Search for PHP 7.1

• Search for PHP Manager

• Install the following packages

Configure PHP.ini File

Edit the C:\Program Files (x86)\PHP\v7.1\php.ini

Update the following Settings

* If a semi-colon (;)appears at the beginning of the line, it MUST be removed.

Find the Windows Extensions section of the php.ini file

Add the following 

• extension=php_odbc.dll

Save the php.ini file

Configure Firewall Settings

If the Framework Product Suite web portal web server is separated from the Framework database server by a network firewall (recommended), your firewall may require configuration of the following ports: 

Microsoft SQL Ports

To configure the Firewall Ports, please consult your Microsoft documentation for more information.

Configure ODBC DSN Connection

Install SQL Native Client if not already installed on to the IIS Server.

Framework ECM - ODBC DSN Configuration

1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.

Open

5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:

• Name: FworkSQLECM

• Description (optional): Enter a description for the database connection. For example, Framework ECM.

• Server: Select the SQL Server from the Server drop-down list.
  OR
  Enter the SQL Server name.

 If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS

7. Click the Next button.
8. Select With SQLServer authentication using a login ID and password entered by the user.

9. In the Login ID field, enter: eg. FworkPortalUser

10. In the Password field,enter: eg. P@ssword

Click the Next button.
11. Tick Change the default database to.
12. From the drop-down list select: FworkSQLEcm
13. Click the Next button.
14. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
15. Click the Test Data Source... button.
16. If successful, click the OK button.
17. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
18. Click the OK button. The Data Sources (ODBC) dialog will close.

Framework License - ODBC DSN Configuration

1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.

5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:

• Name: FworkSQLLic

• Description (optional): Enter a description for the database connection. For example, Framework ECM.

• Server: Select the SQL Server from the Server drop-down list.
  OR
  Enter the SQL Server name.

If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS

7. Click the Next button.

8. Select With SQLServer authentication using a login ID and password entered by the user.

9. In the Login ID field, enter: eg. FworkPortalUser

10. In the Password field, enter: eg. P@ssword

11. Click the Next button.
12. Tick Change the default database to.
13. From the drop-down list select: FworkSQLLic
14. Click the Next button.
15. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
16. Click the Test Data Source... button.
17. If successful, click the OK button.
18. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
19. Click the OK button. The Data Sources (ODBC) dialog will close.

Implement Website Files

Copy the Website files to C:\inetpub\wwwroot\SupplierConnect (make sure to backup existing files if they exist)

Folder Permissions for InternetGuestAccount(servername_IUSR) 

Configure Website Files

Edit the file 'C:\inetpub\wwwroot\SupplierConnect\inc_files\config.php' using Notepad.

Modify the following lines with the DSN Name, Username and Password you used to create the ODBC Connection above. 

$dsn = "FworkSQLEcm";    // ODBC connection of database.

$user = "FworkPortalUser"; // username for connecting to the DB

$pass = "P@ssword"; // Password for connecting to the DB 

$footerText = "Copyright Insula Group Pty Ltd";  - You can insert your company name between the quotes

$emailFromAddr = "SupplierConnect@frameworkecm.com.au"; // From email addresses, 

Setting below is used to determine if the Email Receipt checkbox is automatically checked (on) or not checked (off).Setting below is used to determine if the Email Receipt checkbox is automatically checked (on) or not checked (off). Switch between "on" and "off". NOTE: If the response is a call off the checkbox will NOT be checked regardless of this setting.

$emailResponseReceiptOn = "off"; 

Check FrameworkSupplierConnect Portal

Once FrameworkSupplierConnect is installed and configured, the website must be tested.

To access the newly created website: 

1. Open Web Browser.

2. In the URL,enter: http://[servername]/SupplierConnect/response/response.php?sp=

Test SMTP Relay from IIS Server

This requires the telnet client to be installed, to do that, please perform the below commands:

1. Run powershell as an administrator

2. Type: "Import-Module servermanager" without the quotes, press enter

3. Type "Add-WindowsFeature Telnet-client", press enter

Other ways to add this include through dism (cmd line), or via server manager directly.

Open up command prompt and type the following commands:

1. telnet smtp server name/ip/fqnd 25 (specify the server name, and that we want to connect via port 25), e.g. telnet exch-srvr1 25, telnet exch-srv1.domain.local 25, telnet 10.1.1.2 25

2. ehlo domainname.com.au (e.g. ehlo insulagroup.com.au - you can also use helo, depending on your exchange servers configuration)

3. mail from: supplierconnect@domainname.com.au

4. rcpt to: externaluser@externaldomain.com.au (this can be any domain that is not equal to your domain name, i.e. in the case of franchisees/business units that may operate under different names. E.g. Support@insulagroup.com.au)

5. data

6. subject: Test message from IIS Server

7. This is a test message only, no action required

8. . (period will close the command, so just the . then press enter)

9. type "quit" to exit the session.

After the above steps have been completed, you should get a message saying 'ok - message accepted', followed by an email sent to your inbox

If there is an issue in completing this, please review your SMTP relay settings, as well as which machines are allowed to relay. This can be done through exchange management console, or via exchange online.