Once you have generated a template, you can use one or more tabs to create simple classes. The filename of the Excel file defines the application's name. The name of the sheet tab defines the name of the class.
If you wish to create an extension class, the sheet tab name must contains the string EXTENDS followed by the Display Name of another class (sheet tab name). The class before EXTENDS is the extension of the class specified after EXTENDS.
Example: Class 1 EXTENDS Class 2
If you wish to create an external class, the sheet tab name must be prefaced with EXTERNAL. By default, external classes will be imported with a local server and use the same database as the OnBase database the class is being imported into. The Table Name that the class will be linked to by default is hsi.<classname>. You can configure the specifics of the external class once it has been imported.
Association classes cannot be created using ACE.
The following attribute settings, represented by columns, can be configured for a class using ACE. Full descriptions and requirements are documented in the Creating Attributes section of the documentation.
Each column must have a unique name.
Each row represents a new attribute:
|
Column |
Description |
|---|---|
|
Display Name |
This is the name of the attribute. A value for this cell is required. Each attribute name must be unique within a class. Note:
When configuring an extension class, the attribute names cannot be the same as the attribute names on the base class. |
|
Data Type |
This is the data type that the attribute will use. Any of the Data Types available for attribute configuration can be used. If this cell is left blank, the data type will be alphanumeric by default. You can use a short notation to identify the data type. You can use the first letter or letters that identify a data type. For example, you can use the letter a to define a data type as alphanumeric. For a floating point data type attribute, you would need to use the letters fl for the notation because there is more than one data type that starts with the letter f. For more information about available data types, see Creating Attributes. |
|
Related Class |
If the attribute uses the relationship data type, specify the name of the related class you want to associate the attribute to. This is required if the Data Type is configured as a relationship. |
|
Length / Precision |
If you are configuring an Alphanumeric attribute, you must specify a value for length. The minimum value is 1. The maximum value is as stated in the Alphanumeric data type description. If you are configuring a Decimal or Floating Point attribute, you can set the Precision, adhering to the precision requirements described the Decimal of Floating point data type descriptions. |
|
Description |
This the description of the attribute. The cell is optional. |
|
Data Set |
If you want a data set associated with the attribute, you can create a list of comma separated values. Alternately, you can define the name of the data set, followed by a comma separated list of values belonging to it. Example: Data Set Name: value1, value2, value3 Note:
If a name is not specified for the data set, the name is automatically set to the DisplayName of the attribute that the data set is attached to. |
|
Default Value |
You can specify the value you want to be the default value for the attribute in this cell. This cell is optional. |
|
Index |
When applicable, you can specify the index type you want to use. Options are None, Allow Duplicates, or Unique. If no value is specified, it will default to None. This cell is optional. |
|
Filters |
This cell can contain a comma separated list of values that are name of filters that the associated attribute will be placed on as a Filter Column. If this cell is left blank, the attribute will not be placed in any filter as a Filter Column. This cell is optional. |
|
Views |
This cell can contain a comma separated list of values that are name of views that the associated attribute will be placed on. If this cell is left blank, the attribute will not be placed in any view. This cell is optional. |
|
Sections |
This cell defines sections within a view. An attribute can only be in one section per view. If you have multiple views defined for an attribute, you can specify a section for each view using a comma separated list that corresponds to the comma separated list of views. Multiple sections on a single view can be configured by specifying a section for an attribute that corresponds to a view. |
|
Primary Attribute |
When the value of this cell is True, this attribute defines the relationship path for relationship attributes, which will display on views and filters, that reference the primary attribute's class. For example, a relationship attribute with a related class of Employee and a primary attribute set as Name on the Employee class would have a relationship attribute path of Employee.Name. Note:
Only one primary can be set per class. |