Customization internals Part 2

Hello everybody,

today I want to continue few more details about customization internals. In one of my long time ago posts I've described how to create customization file by yourself without Acumatica engine. 

Today I want a bit extend my comment with few more details.

Quite often it is needed to add sql code to your customization. How to do it? Acumatica customizations allows it with usage of projext.xml file. 

Take a loot at following example:

<Customization level="0" description="">
<File AppRelativePath="Bin\Blablabla.Acumatica.dll" FileID="d701b330-7c72-4f51-b1ae-75c4e2c02194" />
<File AppRelativePath="Pages\AP\AP306010.aspx" FileID="b9e88968-7f36-4cfc-9383-caed8363c269" />
<File AppRelativePath="Pages\AP\AP306010.aspx.cs" FileID="a1ce1918-f569-4ced-8a03-b5571dc26abb" />
<Sql CustomScript="#CDATA">
<CDATA name="CustomScript"><![CDATA[
GO
if COL_LENGTH('APRegister','UsrAllocated') is null
begin
ALTER TABLE APRegister add UsrAllocated bit default (1) WITH VALUES
end

GO

if COL_LENGTH('APRegister','UsrSkipped') is null
begin
ALTER TABLE APRegister add UsrPOSkipped bit default (1) WITH VALUES
end


GO
GO

.

.

.

.

</Customization>

demostrated code will create new pages AP306010.aspx, and also will modify tables APRegister with adding there columns UsrAllocated and UsrSkipped. 

Take into account also that sql statement with balues will insert in all records value 1 ( due te statement bit default(1) )

No Comments

Add a Comment