ReleaseUpdateDB41_Administration.updateEPWebSiteParameters Upgrade Script

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB41_Administration

Method

updateEPWebSiteParameters

Description

This function copies data from the DEL_WebSite and DEL_EPParameters table to the EPWebSiteParameters table.

Affected Modules and Tables

Affected Modules

Administration

Affected Tables

EPWebSiteParameters

DEL_WebSite

DEL_EPParameters

Remarks

The DEL_WebSite has many company specific rows. The DEL_EPParameters has one row per company. The EPWebSiteParameters has many company neutral rows. The data from the DEL_WebSite table will be copied directly into the EPWebSiteParameters table and specific fields from the DEL_EPPParameters table will be duplicated across each entry. The EPWebSiteParameters table has the new CompanyIndependent field. This field indicates whether a website is associated with a company. The DEL_WebSite has the CompanyId field that contains the company ID of the company that the website belongs. As such, this field should never be empty and the CompanyIndependent will be set to No for all data that is transferred. Transfer all fields from the DEL_Website table. Transfer the EnableEncryption, EncryptionExpirationInterval, ImageResize, ImageSizeSmall, ImageSizeLarge, and ImageRatiomation fields from the DEL_EPParameters table.

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

EPWebSiteParameters

Deleted Tables or Fields

Table

Field

DEL_EPParameters

DEL_WebSite