process4.biz 7.x Documentation

features description for Process4.biz

DAX_003: DB structure & format of Excel-import file for AX2009

Differences between Axapta 4.0 (old version) and Axapta 2009 (new version):

Axapta 4.0:
Objects are imported to 3 classes with special GUIDs - AX Report a9e6c30d-20db-4ee0-9cc8-d781d768ab83, AX Class 77dd4214-550a-45f6-baeb-02af25b1d4ef and AX Form 832b98e9-10dd-4e92-aa72-53621bdec7f2.

Axapta 2009:
Objects are imported to one class AX Class with GUID 11600853-22ac-4cc4-bc79-ed7553a1cd0b.

Correspondence between columns and properties:

Excel column

1 - A

2 - B

3 - C

4 - D

5 - E

6 - F

7 - G

8 - H

9 - I

10 - J

Column name

ObjectName

LangID

Helptext

ObjectLabel

CalledObjectType

ObjectType

ConfigurationKey

SecurityKey

Path

CalledObjectName

Property Db name

MenuItemName

 

Help

Label

ObjectTyp

MenuItemType

ConfigurationKey

SecurityKey

Formaufruf

ObjectName

Property name

Menu Item Name

 

Help

Label

Object Typ

Menu Item Type

Configuration Key

Security Key

Form call

Object Name

Excel column

11 - K

12 - L

13 - M

14 - N

15 - O

16 - P

17 - Q

18 - R

19 - S

20 - T

Column name

Enabled

SYS Layer

SYP Layer

GLS Layer

GLP Layer

HFX Layer

SL1 Layer

SL2 Layer

SL3 Layer

BUS Layer

Property Db name

Active

SYS

SYP

GLS

GLP

HFX

SL1

SL2

SL3

BUS

Property name

Availability

SYS

SYP

GLS

GLP

HFX

SL1

SL2

SL3

BUS

Excel column

21 - U

22 - V

23 - W

24 - X

25 - Y

26 - Z

27 - AA

28 - AB

Column name

BUP Layer

VAR Layer

VAP Layer

CUS Layer

CUP Layer

USR Layer

USP Layer

HTMLHelpTopic

Property Db name

BUP

VAR

VAP

CUS

CUP

USR

USP

 

Property name

BUP

VAR

VAP

CUS

CUP

USR

USP

 

Name of imported object:

ObjectName (column 1) and ObjectLabel (column 4) are used to create object name in format: ObjectName (ObjectLabel).

Value for enum property availability:

If some of the selected layers (i.e., checked by checkbox in wizard) SYP Layer (column 13) or GLS Layer (column 14) or … USP Layer (column 27) receive values that are not empty and not equal to 0 (zero) - property availability (db name is active), they receive the value Available and modified.

Otherwise (if values of checked layers are empty or “0”) and the value in excel-column Enabled (column 11) is “Yes” (or “Ja”), the property availability (db name is Active) receives the value Available.

Otherwise (if values of checked layers are empty or “0”) and the value in excel-column Enabled (column 11) is not “Yes” (or “Ja”), the property Availability (db name is Active) receives the value Not available.