Page Comparison

...

Unity is typically installed on a local server at each resort and Aspenware Service installs a test and production version. The test version is pointing to the customer’s test environment and production is pointing to the customer’s live environment. These two instances are usually typically installed on the same server and the server needs to be accessible from Azure if Unity is being used for Commerce or internally if Unity is being used for Aspenware Scanning. If being used for Commerce, the server is typically setup set up in a DMZ.

The instructions below outline the steps needed to install and configure Unity. The install process to install is manual so there is currently no installer. We also occasionally add new settings which would have to be added manually because our auto-deployment process does not update any config or json files which is where all the configuration is defined.

...

Install IIS following RTP’s Server Install guide. These steps outline all the necessary server components to install.
Download and install .NET Core Runtime (https://dotnet.microsoft. com/download). After this install, you may or may not need to restart the server.
SQL Role Security - determine the SQL username and password that will be added to Unity and run scripts to grant select, update, insert, delete privileges. Some customers use an existing RTP username/password and grant these privileges to the RTPOneRole and others want us to create a new role to grant these privileges to. Kevin Aspenware has scripts to create a new role, username and password and the current list of SQL privileges can be found in Last Pass in this note, Aspenware-Unity SQL Security Privileges.

...

Code Block
"DBVersionNumber": "2014.2.0.14", //2016.1.1.7

Set to either, 2014.2.0.14 or 2016.1.1.7 depending on the version of RTP being used. This determines how credit cards are saved into RTP.

Code Block
"SourceTag": "UNITY-PK-", "SourceId": "UNITY-PK",

Used to create the RTP Alternate ID Profile. Update ‘PK’ to whatever makes sense for each resort. Do not change after customers start logging in.

Code Block
"RelativeRoleCode": 1035,

Set value to match the RTP RoleCode for a ‘relative'. This value can be found in RTP admin or the database in the Role table.

Code Block
"PrimaryProfileTypeCode": 102, "AlternateIdProfileTypeCode": 102,

Set value to a newly created ProfileType code in RTP (always set these two settings to the same value). AW recommends creating a new Profile Type rather than using an existing on. After this is created, a new entry in RTP admin needs to be created in Profile Type for Profiles.

Code Block
"SalesChannelCode": 1300,

Set value to the Sales Channel Code being used by the Commerce site.

Code Block
"TempCustomerCode": 3010,

Set Value to the IPTypeCode for the Temporary Customer entry in the IPType table (usually 3010 but some customers are different)

Code Block
"EncryptionToken"

No longer used. This setting can be removed.

Code Block
"RetailInventoryLocationCode": 2500,

Set value to the RTP Inventory Location Code being used for RTP retail inventory sync.

Code Block
"OrderProcessor": "Base",

Set value to Base is using Unity for Order Processing or Connect is using RTPConnect for Order Processing.

Code Block

"RTPConnect": {
  "RTPConnectUrl": "https://unity.aspenwarecommerce.net/rtpconnect/supplierservice.asmx",
  "Security": {
    "SSLEnabled": true,
    "Name": "SupplierServiceSoap",
    "Mode": "Transport",
    "Transport": {
      "ClientCredentialType": "None",
      "ProxyCredentialType": "None"

These settings are only used if the above setting, “OrderProcessor” is set to Connect. If set to Connect, define the RTP Connect URL in the RTPConnectURL field and set SSLEnabled accordingly.

Code Block
"AllowEntitlementPriceOverride": true,

Set value to true if AW Payment Plans are being used. If AW payment plans are not being used, this setting can be left as true or could be omitted from file.

Code Block
"UseAlternateInventoryStoredProc": true,

Set to true if an alternate stored procedure is being used for RTP inventory pool inquires (i.e. AW_proc_publicGetProductInventoryPoolInventory.sql). Set to false (or remove setting) if the standard RTP inventory pool stored procedure is being used.

Code Block

"VoucherProductHeaderCode": "evp",
"VoucherPaymentMethodCode": 10,
"StoredValueProductHeaderCode": "stv",
"StoredValuePaymentMethodCode": 25,
"GiftCardProductHeaderCode": "gcp",
"GiftCardPaymentMethodCode": 501,

These settings are used in conjunction with AW Additional Payments. Define the general product header codes created for AW additional payment functionality along with the RTP Payment Method codes for voucher payments, gift cards and stored value.

Code Block
"UserId": "awuser",

Define an RTP UserID that will be added as the OperatorID for anything created from the site (Customer Manager Profiles, Orders, Transactions, etc.)

Code Block
"CurrencyCode": 1,

Define the RTP Currency Code being used by the site. Typically this is set to 1

Code Block
"PaymentMethodCodeOrder": 4005, "PaymentMethodCodeFulfillment": 9999,

Set PaymentMethodCodeOrder to a newly created AW Clearing Payment Method code from RTP and set the PaymentMethodCodeFulfillment code to the RTP Deposit Applied Payment Method Code (typically 9999).

Code Block
"SupplierCode": "1", "DistributorCode": "4",

If using RTPConnect, set SupplierCode to 1 and DistributorCode to the DisctributorCode being used by RTPConnect for Aspenware.

Code Block
"ShippingFeeProductCode": "999899",

Set to the shipping fee product header code being used by the site (**This setting may not be used anymore)

Code Block
"IPTypeCodeGuestCustomer":3014,

If using AW Guest Check-out, set value to the IPTypeCode for the Guest Checkout Customer Type entry in the IPType table

Code Block
"ActivityBuffer": 10, "ActivityCutoffBuffer": 0,

If selling RTP Activities, these settings are used to determine if the RTP Activity lock has expired. So if the lock expires at 4:30:00 and it's set to 10 secs, then it will consider the lock is expired at 4:29:50 and try to get a new lock. This is to account for the amount of time after the order completes in AW but before it is processed into RTP by Unity.

Code Block
"CanUpdateAlternateIdProfile": true,

Set Value to true. This allows a merged customer in RTP to get an updated Alternate ID Profile value.

Code Block
"ConfigurationSettingCodes": [ { "Name": "SaleLocationCode", "Value": 1000 }

Leave this Value set to 1000. This is used to lookup the RTP Sale Location Code for various purposes.

Code Block

Database": {
  "RTP": { // settings for RTP Database
    "ConnectionString": "Data Source=servernameORIP;Initial Catalog=databasename;Persist Security Info=True;User ID=sqluser;Password=sqlpassword;"
    },
  "Support": {
    "ConnectionString": "Data Source=servernameORIP;Initial Catalog=databasename;Persist Security Info=True;User ID=sqluser;Password=sqlpassword;"
   },
  "Arrivals": {
    "ConnectionString": "Data Source=servername;Initial Catalog=databasename;Persist Security Info=True;User ID=sqluser;Password=sqlpassword;MultipleActiveResultSets=true"
      }

Define database settings. There are three connection strings.

RTP - define RTP database server, database name and SQL userID and password for accessing RTP.
Support - define the same as RTP unless the customer has a ‘Custom’ database that stores validation stored procedures, alternate inventory pool stored procedures, etc.
- Arrivals - define Azure Arrival database server, database name and SQL userID and password for accessing the Arrival database. Get these values from DevOps.

Code Block

"Stores": [ // store specific settings go in a "Store" config (1 to many stores)
  {
    "StoreName": "Peak",
    "SaleLocationCode": 1600,
    "AuditLocationCode": 1600,
    "SalesChannelCode": 1300,
    "ClientCode": 300,
    "DistributorCode": "4",
    "UsePaymentCardTokenTable": "true",
	"EncryptPaymentCardTokenValue": "false"
  }

Define Aspenware Commerce Store settings. There can be more than one Store in this section if there are multiple Stores on the same Nop instance (i.e. Peak Mountain, Peak Highlands, Peak Golf, etc.)

Define values as follows.

StoreName = define CompanyName from Nop Store table
SaleLocationCode - define the RTP Sale Location Code attached to the ClientCode in this same section (look in RTP in Client admin).
AuditLocationCode - define the RTP Audit Location Code attached to the ClientCode in this same section (look in RTP in Client admin).
SalesChannelCode - define the Sales Channel Code being used by the site. The same setting is listed above outside of the Store section so set to the same.
ClientCode - define the Client Code being used by the Store (can be different per Store).
DistributorCode - define the RTP Distributor Code being used by RTP Connect (if using RTP Connect for Order Processing).
UsePaymentCardTokenTable - only used if "DBVersionNumber": "2016.1.1.7". Set to ‘true’ if using Auth.NET or Payeezy.
EncryptPaymentCardTokenValue - set to ‘true’ for Auth.NET and ‘false’ for Payeezy. These settings are not used for Square or Braintree.

Versions Compared

Old Version 6

New Version 7

Key