Administrator Information
Creating ACDC Users
Note for Munsys users: Use the Munsys Management Console to create new users and then assign the additional privileges listed below.
Privileges for Administrator Users
To create an ACDC administrator user, the database administrator must grant the following privileges:
GRANT SELECT, UPDATE ON OSX_AP_SETTINGS TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_ATTR_MAP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_ATTR_MVRULECHECK TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_ATTR_RULEMAP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_ERRORS_OBJ TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_FDOLAYER_COLUMNS TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_FDOLAYER_DEF TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_FDO_CONNECTION TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_MENU_GROUP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_LNK_GROUP_OBJECT TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_MENU_MACRO TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_MENU_ORDER TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_MUNSYS_NODE_MAPPING TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_OBJECT TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_PIPE_BREAK TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_SC_LINK TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_SPA_RULEMAP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_EXPORT_RULEMAP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_EXPORT_OUTPUTDEF TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON ACDCSEQ_ID TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_MVID TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_OBJ_ID TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_DWG_ID TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_ATTRMAP_ID TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_GROUP_OBJECT_ID TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_MENU_MACRO TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_MENU_GROUP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_MENU_ORDER TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_SPA_RULEMAP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_ATTR_RULEMAP TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON SEQACDC_EXPORTOUTPUTDEF_ID TO [AdminUser];
Additional privileges for MS SQL Server users:
GRANT EXECUTE ON ALL FUNCTIONS TO [AdminUser];
GRANT SELECT ON ALL LOOKUP TABLES TO [AdminUser];
GRANT SELECT ON ALL SEQUENCES TO [AdminUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL DESTINATION TABLES TO [AdminUser];
Privileges for General Users
To create an ACDC general user, the database administrator must grant the following privileges:
GRANT SELECT ON OSX_AP_SETTINGS TO [NewUser];
GRANT SELECT ON WAE_ATTR_MAP TO [NewUser];
GRANT SELECT ON WAE_ATTR_MVRULECHECK TO [NewUser];
GRANT SELECT ON WAE_ATTR_RULEMAP TO [NewUser];
GRANT SELECT ON WAE_FDOLAYER_COLUMNS TO [NewUser];
GRANT SELECT ON WAE_FDOLAYER_DEF TO [NewUser];
GRANT SELECT ON WAE_FDO_CONNECTION TO [NewUser];
GRANT SELECT ON WAE_MENU_GROUP TO [NewUser];
GRANT SELECT ON WAE_LNK_GROUP_OBJECT TO [NewUser];
GRANT SELECT ON WAE_MENU_MACRO TO [NewUser];
GRANT SELECT ON WAE_MENU_ORDER TO [NewUser];
GRANT SELECT ON WAE_MUNSYS_NODE_MAPPING TO [NewUser];
GRANT SELECT ON WAE_OBJECT TO [NewUser];
GRANT SELECT ON WAE_PIPE_BREAK TO [NewUser];
GRANT SELECT ON WAE_SC_LINK TO [NewUser];
GRANT SELECT ON WAE_SPA_RULEMAP TO [NewUser];
GRANT SELECT ON WAE_EXPORT_RULEMAP TO [NewUser];
GRANT SELECT ON WAE_EXPORT_OUTPUTDEF TO [NewUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON WAE_ERRORS_OBJ TO [NewUser];
GRANT SELECT ON ACDCSEQ_ID TO [NewUser];
GRANT SELECT ON SEQACDC_MVID TO [NewUser];
GRANT SELECT ON SEQACDC_OBJ_ID TO [NewUser];
GRANT SELECT ON SEQACDC_DWG_ID TO [NewUser];
GRANT SELECT ON SEQACDC_ATTRMAP_ID TO [NewUser];
GRANT SELECT ON SEQACDC_GROUP_OBJECT_ID TO [NewUser];
GRANT SELECT ON SEQACDC_MENU_MACRO TO [NewUser];
GRANT SELECT ON SEQACDC_MENU_GROUP TO [NewUser];
GRANT SELECT ON SEQACDC_MENU_ORDER TO [NewUser];
GRANT SELECT ON SEQACDC_SPA_RULEMAP TO [NewUser];
GRANT SELECT ON SEQACDC_ATTR_RULEMAP TO [NewUser];
GRANT SELECT ON SEQACDC_EXPORTOUTPUTDEF_ID TO [NewUser];
GRANT SELECT ON ALL LOOKUP TABLES TO [NewUser];
GRANT EXECUTE ON ALL FUNCTIONS TO [NewUser];
GRANT SELECT ON ALL SEQUENCES TO [NewUser];
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL DESTINATION TABLES TO [NewUser];
ACDC System Tables
Table 8: Configurator Settings
Below is a list of the Configurator Settings available within the Configurator dialog box with their default values as defined in the installation scripts.
| Setting Name | Default Value | Description |
| gAssocBlkSearchBuffRad | 1.0 | Search buffer used to find associated blocks for linear features. * See NOTE below. |
| gAttributeErrorColour | YELLOW | Color of layer to draw attribute error flags. |
| gAttributeErrorLyr | Errors_Attr | Name of layer to draw attribute error flags. |
| gAttributeErrorRadius | 1.3 | Radius of Attribute Error Circles. |
| gAttributeWarningColour | YELLOW | Color of layer to draw attribute warning flags. |
| gAttributeWarningLyr | Warnings_Attr | Name of layer to draw attribute warning flags. |
| gAttributeWarningRadius | 1.3 | Radius of Attribute Warning Circles. |
| gCannotBreakErrorColour | CYAN | Color of layer to draw break failure error flags. |
| gCannotBreakErrorLyr | Errors_Break | Name of layer to draw pipe-breaking error flags. |
| gCannotBreakErrorRadius | 1.4 | Radius of Break Error Circles. |
| gCannotBreakWarningColour | CYAN | Color of layer to draw break failure warning flags. |
| gCannotBreakWarningLyr | Warnings_Break | Name of layer to draw pipe-breaking warning flags. |
| gCannotBreakWarningRadius | 1.4 | Radius of Break Warning Circles. |
| gCommonBlkName | COMMON_BLOCK | Common block used for attributes that will be common for all objects in the drawing. E.g. Contractor name, drawing name etc. |
| gDateFormat | DD/MM/YYYY | Date format: Can be DD/MM/YYYY or MM/DD/YYYY. (Warning changing this setting will reformat any existing date ranges). |
| gDeleteODTables | True | Delete Object Data tables before validation. |
| gDrawingUnits | Meter | Setting for Units in drawing. (Is also referenced at login to the ACDC Schema to determine which default Symbol path to use) |
| gExtentsErrorColour | MAGENTA | Color of layer to draw extent error flags. |
| gExtentsErrorLyr | Errors_Exts | Name of layer to draw extent error flags. |
| gExtentsErrorRadius | 1.6 | Radius of Extents Error Circles. |
| gExtentsWarningColour | MAGENTA | Color of layer to draw extent warning flags. |
| gExtentsWarningLyr | Warnings_Exts | Name of layer to draw extent warning flags. |
| gExtentsWarningRadius | 1.6 | Radius of Extents Warning Circles. |
| gExternalActive | True | Export data to external CSV Files. Set to 'True' if Export External is active, or 'False' if inactive. |
| gExternalFileLocation | $DWGDIR (currently open drawing file directory) |
File path used to specify the external file location. |
| gGeometryCircle | Arc | Circle geometries in FDO are not permitted choose an alternative geometry to represent this shape Polyline (32 segment) or Arc. |
| gGeneralCircleRad | 2.0 | Radius of error circles. |
| gGeometryErrorColour | RED | Color of layer to draw geometry error flags. |
| gGeometryErrorLyr | Errors_Geom | Name of layer to draw geometry error flags. |
| gGeometryErrorRadius | 1.2 | Radius of Geometry Error Circles. |
| gGeometryWarningColour | RED | Color of layer to draw geometry warning flags. |
| gGeometryWarningLyr | Warnings_Geom | Name of layer to draw geometry warning flags. |
| gGeometryWarningRadius | 1.2 | Radius of Geometry Error Circles. |
| gGISType | FDO | The GIS type (available values: FDO or Munsys). |
| gLinearChkTol | 0.02 | Tolerance used to flag linear object end points as errors if they are within this tolerance and fall outside the defined 'gLinearSnapTol' setting. |
| gLinearSearchBuffRad | 1.0 | Search buffer used by linear objects to detect nearby linear objects to snap to. |
| gLinearShortTol | 0.5 | Shortest linear length allowed. |
| gLinearSnapTol | 0.001 | If linear endpoints are within this distance then they are automatically snapped together. |
| gLookupCaseSensitive | True | Setting to determine whether lookup codes validation should be case sensitive or not. |
| gLookupFilter | OBJECT_NAME like 'LU_%' | Query filter used to find lookup tables (do not include ‘where' statement). |
| gMaxXExtent gMaxYExtent gMinXExtent gMinYExtent |
NULL | Defines the extents/boundaries for the drawing that all validated objects must be within. Objects outside this range will fail validation. If all values are set to 0 then ACDC will ignore this setting. |
| gNodeSearchBuffRad | 0.5 | Search buffer used by nodes objects to detect nearby objects. |
| gNodeSnapTol | 0.1 | If a node is within this distance of a linear object it is automatically snapped to that linear object. |
| gODFieldNameMaxSize | 31 | Maximum length of an object data field name. |
| gODTableNameMaxSize | 25 | Maximum length of an object data table name. |
| gPipeLengthBreakTol | 0.5 | Minimum allowable length of a pipe to be created by a 'break' operation. |
| gPipeSearchBuffRad | 1.0 | Search buffer used by block insertion points to detect pipes to snap to. |
| gPolyMinArea | 0.25 | Minimum area of Polygon entities. |
| gProjection | [no default value] | Expected Projection for projects. Drawing projection (Coordinate System assigned in AutoCAD Map using 'mapcsassign' for example MGA-55) |
| gProjectionAttribute | INACTIVE | Common block attribute projection tag. (''ORIGIN'' set to INACTIVE if not defined) |
| gReportFile | $DWGNAME (currently open drawing file name) |
Name of CSV report file used by Validator and Munsys Converter to log errors. |
| gReportFileLocation | $DWGDIR (currently open drawing file directory) |
Directory that the file specified in 'gReportFile' will be saved to. |
| gSCtoPipeSearchBuffRad | 1.0 | Search buffer used to find pipes to which a service connection should be attached. |
| gTempODFieldName | TempField | Name of temporary object data field used to identify valid text and symbols. |
| gTempODTableName | TempTable | Name of temporary object data table used to identify valid text and symbols. |
| gUnknownNodeTypeSymbol | _WJUNC | Name of symbol to use for unknown node types. |
| gVerifyRealSize | Width and Precision (exclude decimal point) |
Setting to manage the way different databases handle real values (See section CONFIGURING ‘gVerifyRealValues’ ) |
| gVersion | 5.2 | Schema Version |
Table 9: System Tables Overview
Below is a list of the The ACDC system tables with a description of their purpose.
| Table Name | Description |
| OSX_AP_SETTINGS | Holds settings information used during the Validation and Conversion processes. |
| WAE_ATTR_MAP | Holds the definition of attributes to be stored for each defined object type. |
| WAE_ATTR_MVRULECHECK | Holds the settings for compound validations processes. |
| WAE_ATTR_RULEMAP | Holds the settings for Attribute validation rules. |
| WAE_ERRORS_OBJ | This table is temporarily populated with errors encountered during the validation process. |
| WAE_EXPORT_FILENAME | XXX (Table is empty) |
| WAE_EXPORT_LNKFILEATTR | XXX (Table is empty) |
| WAE_EXPORT_OUTPUTDEF | Stores which attributes are to be written to the exported CSV file per asset class. |
| WAE_EXPORT_RELATERULE | XXX (Table is empty). |
| WAE_EXPORT_RULEMAP | Contains the Export Rules advising which rule type and parameters are applied to the attributes during export process. |
| WAE_FDO_CONNECTION | Contains the saved FDO connection details. |
| WAE_FDOLAYER_COLUMNS | Contains a definition of all the layers/columns of the saved FDO connections. |
| WAE_FDOLAYER_DEF | Contains layers details for saved FDO connections. |
| WAE_LNK_GROUP_OBJECT | Mapping table linking the objects to the Menu Groups. |
| WAE_MENU_GROUP | Contains the Menu Groups and their respective Menu Names. |
| WAE_MENU_MACRO | Stores the macro (series of commands) which defines the action that should be performed when the menu item is selected per Menu Type. The different Menu Types supported include: 1. ACAD 2. ACAD_ATTRIBUTOR 3. ACAD_MAP 4. ACADMAP_ATTRIBUTOR 5. BRICSCAD 6. BRICSCAD_ATTRIBUTOR |
| WAE_MENU_ORDER | Stores the order in which the object items are displayed within the Menu Groups |
| WAE_MUNSYS_NODE_MAPPING | Munsys node mapping is for Munsys ACDC customers and is used during the conversion process to 'MUNCONVERT' data to determine which symbol is assigned to the node type. |
| WAE_OBJECT | Defines the objects to be Validated/Converted, their geometry types, associated blocks, and destination layers. |
| WAE_PIPE_BREAK | Lists the details of defined snapping rules. |
| WAE_SC_LINK | Defines the layers that contain objects to which service connection can connect. |
| WAE_SPA_RULEMAP | Holds the settings for Spatial validation rules. |
Table 10: OSX_AP_SETTINGS
Below is a list of the OSX_AP_SETTINGS columns and their purpose.
| Column Name | Type | Description |
| OSX_TYPE | CHAR(1) | Reserved for Future use. |
| OSX_CATEGORY | VARCHAR2(10) | Application using this table. Currently supported values are: 1. QIF: For the QIF Translator 2. HAN: For the Hansen integration 3. WAE: For ACDC (Work As Executed) 4. LV_TRANSL: For LandVic Translator |
| OSX_VARIABLE | VARCHAR2(30) | Name of setting used in application |
| OSX_VALUE | VARCHAR2(100) | The value assigned to the setting |
| OSX_DEFAULT | VARCHAR2(40) | Reserved for Future use |
| LU_TABLE | VARCHAR2(30) | Reserved for Future use |
| DISPLAY_GROUP | VARCHAR2(20) | Reserved for Future use |
| IS_EDITABLE | CHAR(1) | Reserved for Future use |
| SHORT_DESC | VARCHAR2(40) | Short description of setting |
| LONG_DESC | VARCHAR2(255) | Long description of setting |
Table 11: WAE_ATTR_MAP
Below is a list of the WAE_ATTR_MAP columns and their purpose.
| Column Name | Type | Description |
| ATTRMAP_ID | NUMBER(10) | Unique Identifier from sequence SEQACDC_ATTRMAP_ID |
| FK_ID | NUMBER(10) | Foreign Key: Referencing column ID in WAE_OBJECT |
| BLOCK_NAME | VARCHAR2(100) | AutoCAD block name |
| TAG_NAME | VARCHAR2(30) | AutoCAD attribute tag name |
| TAG_TYPE | VARCHAR2(30) | AutoCAD attribute tag type |
| MANDATORY | VARCHAR2(3) | Permissible values: 0 = Value not required 1 = Value required |
| DATA_TYPE | VARCHAR2(30) | Type of data expected in attribute. Permissible values: 1. CHARACTER 2. NUMBER 3. DATE See also the parameter 'gDateFormat' in the details of the Configurator Settings |
| DATA_SIZE | VARCHAR2(30) | Length of string for DATA_TYPE = CHARACTER |
| RANGE_MIN | VARCHAR2(30) | Lower limit of a range of numerical value for DATA_TYPE = INTEGER or REAL |
| RANGE_MAX | VARCHAR2(30) | Upper limit of range of numerical value for DATA_TYPE = INTEGER or REAL |
| TAB_FLD_NAME | VARCHAR2(30) | Destination table column |
| CALC_FLD | VARCHAR2(30) | Reserved |
| EXT_OUTPUT_REQ | VARCHAR2(3) | Permissible values: YES = Output to CSV or Table is required NULL = Output to CSV or Table is not required) |
| LU_TABLE_NAME | VARCHAR2(30) | Lookup table that contain values that must be validated against. If Null, do not validate. |
| LU_COLUMN | VARCHAR2(30) | Lookup column that contain values that must be validated against. If Null, do not validate |
| BLOCK_VISIBLE | NUMBER(10) | Determines if the Attribute is displayed or not when the block is placed in the drawing. |
| DESCRIPTION | VARCHAR2(120) | Description that is displayed as a prompt when the block is placed in the drawing. |
| BLOCK_DEFAULT_VALUE | VARCHAR2(120) | A default attribute value assigned to the Block when it is placed in the drawing. |
| DISPLAY_ORDER | NUMBER(10) | The order in which the attribute tag is displayed. |
Table 12: WAE_ATTR_MVRULECHECK
Below is a list of the WAE_ATTR_MVRULECHECK columns and their purpose.
| Column Name | Type | Description |
| MV_ID | NUMBER(10) | Multi-attribute validation unique ID from sequence SEQACDC_MVID |
| MV_DESC | VARCHAR2(100) | Multi-attribute validation description |
| REF_VALUE | VARCHAR2(50) | Reference value to which the comparison applies to. |
| COMPARE_TAG | VARCHAR2(50) | Column value/s to be checked |
| COMPARISON_VALUES | VARCHAR2(500) | Permitted value/s |
| COMPARE_TYPE | VARCHAR2(40) | Comparison Type operator. Permitted values: 1. GT - Greater Than 2. LT - Less Than 3. GTE - Greater than or Equal to 4. LTE - Less than or Equal to 5. EQ - Equal 6. NEQ - Not Equal |
Table 13: WAE_ATTR_RULEMAP
Below is a list of the WAE_ATTR_RULEMAP columns and their purpose.
| Column Name | Type | Description |
| ATTR_RULEMAP_ID | NUMBER(10) | Attribute Rule Map unique ID from the sequence SEQACDC_ATTRMAP_ID. |
| FK_ATTRMAP_ID | NUMBER(10) | Foreign Key: Referencing column ID in WAE_ATTR_MAP. |
| ERROR_TYPE | VARCHAR2(10) | Type of error, either ‘ERROR’ or ’WARNING’. |
| CUSTOM_MESSAGE | VARCHAR2(250) | Custom error message when validation failed. |
| RULE_ORDER | NUMBER(10) | Order in which the rule is applied. |
| RULE_DESC | VARCHAR2(60) | Rule description. |
| RULE_TYPE | VARCHAR2(40) | Rule Type. Permitted values: 1. CHECKLINK 2. COMPARECHECK 3. DISTCHECK 4. FORMATSTR 5. ISINSIDE 6. LINKLIMIT 7. MULTICHECK 8. MVCHECK 9. NODELIMIT 10. RACHECK 11. RANGEEX 12. SUBSTR 13. VALUECHECK |
| RULE_PARAM | VARCHAR2(500) | Parameters against which the values are validated. |
Table 14: WAE_ERRORS_OBJ
Below is a list of the WAE_ERRORS_OBJ columns and their purpose.
| Column Name | Type | Description |
| DWG_NAME | VARCHAR2(150) | Name of DWG being processed. |
| ERR_TYPE | VARCHAR2(20) | Error type. Permissible values: 1. GEOM: For geometry related errors 2. ATTR: For attribute errors 3. BRKP: For pipe breaking related error 4. CONFIG_ERR: For Configuration errors 5. CMMBLK_ERR: For Common Block errors 6. EXTS_ERR: For Database Extents errors |
| MESSAGE | VARCHAR2(250) | Message associated with error. This will be produced as an attribute tag value in the error block. |
| OBJ_IDENTIFIER | VARCHAR2(30) | The error identifier flag. This determines the information that will be recorded in the log file for each error. Permissible values: 1. FLAG_COORD_AND_BLOCK: Record the coordinates and error block name for each error in the log file. |
| OBJ_IDENTIFIER _NAME | VARCHAR2(30) | The name of the created error block. |
| PARAMETER | VARCHAR2(150) | Stores the error information indicated by the value in the ‘OBJ_IDENTIFIER’ column. Information recorded for the different ‘OBJ_IDENTIFIER’ values are: 1. FLAG_COORD_AND_BLOCK: X, Y values of insertion point of the error object. |
| ENTITY_HANDLE | VARCHAR2(20) | Validation error block ID identifier. |
| DWG_ID | NUMBER(10) | Unique DWG ID from Sequence SEQACDC_DWG_ID |
| PROCESS_DATE | DATE | The process date. |
Table 15: WAE_FDO_CONNECTION
Below is a list of the WAE_FDO_CONNECTION columns and their purpose.
| Column Name | Type | Description |
| CONN_NAME | VARCHAR2(128) | Saved FDO connection name. |
| CONN_DEF | CLOB | FDO connection details. |
Table 16: WAE_FDOLAYER_COLUMNS
Below is a list of the WAE_FDOLAYER_COLUMNS columns and their purpose.
| Column Name | Type | Description |
| COLUMN_NAME | VARCHAR2(128) | Name of the columns in the destination table. |
| FDO_LAYER_NAME | VARCHAR2(128) | Name of the destination table. |
Table 17: WAE_FDOLAYER_DEF
Below is a list of the WAE_FDOLAYER_DEF columns and their purpose.
| Column Name | Type | Description |
| FDO_LAYER_NAME | VARCHAR2(128) | Name of the destination layer. |
| TABLE_NAME | VARCHAR2(128) | Name of the destination table. |
| LAYER_DEF | CLOB | Layer details. |
| CONN_NAME | VARCHAR2(128) | Name of the FDO connection in which the layer exists. |
Table 18: WAE_LNK_GROUP_OBJECT
Below is a list of the WAE_LNK_GROUP_OBJECT columns and their purpose.
| Column Name | Type | Description |
| GROUP_OBJECT_ID | NUMBER(10) | Unique Identifier from the sequence SEQACDC_GROUP_OBJECT_ID |
| GROUP_ID | NUMBER(10) | Relates to the Unique Identifier ID column for the table WAE_MENU_GROUP |
| WAE_OBJECT_ID | NUMBER(10) | Relates to the Unique Identifier ID column for the table WAE_OBJECT |
Table 19: WAE_MENU_GROUP
Below is a list of the WAE_MENU_GROUP columns and their purpose.
| Column Name | Type | Description |
| MENU_GROUP_ID | NUMBER(10) | Unique Identifier from the sequence SEQACDC_MENU_GROUP |
| GROUP_NAME | VARCHAR2(100) | Group Name assigned to the menu group item. |
| DESCRIPTION | VARCHAR2(120) | Group Name description. |
| PARENT_ID | NUMBER(10) | The MENU_GROUP_ID of the Parent Group to which the Menu Group is associated to. |
Table 20: WAE_MENU_MACRO
Below is a list of the WAE_MENU_MACRO columns and their purpose.
| Column Name | Type | Description |
| MENU_MACRO_ID | NUMBER(10) | Unique Identifier from the sequence SEQACDC_MENU_MACRO |
| MACRO_DESCRIPTION | VARCHAR2(250) | Macro Description |
| ACAD_OBJECT_TYPE | VARCHAR2(100) | The Object Type to which the Macro is associated to. The permitted Object Types include: 1. CIRCLE 2. INSERT 3. POLYLINE 4. POLYGON 5. SINGLE LINE TEXT (GRAPHICS ONLY) |
| MENU_TYPE | VARCHAR2(100) | Stores the menu type value to know which CAD application The different Menu Types supported include: 1. ACAD 2. ACAD_ATTRIBUTOR 3. ACAD_MAP 4. ACADMAP_ATTRIBUTOR 5. BRICSCAD 6. BRICSCAD_ATTRIBUTOR |
| MACRO_GEOMETRY | VARCHAR2(200) | Stores the Object Type associated to the macro. |
| MACRO_BLOCK | VARCHAR2(200) | Stores the macro syntax (Series of commands and expected options and values) which defines the action that is performed when the menu item is selected. |
Table 21: WAE_MENU_ORDER
Below is a list of the WAE_MENU_ORDER columns and their purpose.
| Column Name | Type | Description |
| MENU_ORDER_ID | NUMBER(10) | Unique identifier from the sequence SEQACDC_MENU_ORDER |
| MENU_OBJECT_TYPE | NUMBER(10) | Permissible values are: 1. 0 indicates a separator line 2. if 1, then refer to WAE_MENU_GROUP. 3. if 2, then refer to WAE_OBJECT |
| WAE_GROUP_ID | NUMBER(10) | Relates to the Unique Identifier ID column for the table WAE_MENU_GROUP |
| WAE_OBJECT_ID | NUMBER(10) | Relates to the Unique Identifier ID column for the table WAE_OBJECT |
| MENU_ORDER | NUMBER(10) | Stores the menu order number where the value 1 indicates that this menu item should be displayed first. |
Table 22: WAE_MUNSYS_NODE_MAPPING
Below is a list of the WAE_MUNSYS_NODE_MAPPING columns and their purpose.
| Column Name | Type | Description |
| MUN_ID | NUMBER(10) | The MUN_ID value for the spatial table i.e. 43 |
| TABLE_NAME | VARCHAR2(30) | The Table name for the Node , i.e. SP_WATNODE |
| NODE_TYPE | VARCHAR2(20) | The Node type description, i.e. CLOSED_VALVE |
| SYMBOL_NAME | VARCHAR2(40) | The Symbol name used to represent the Node, i.e. _WCLVALVE |
Table 23: WAE_OBJECT
Below is a list of the WAE_OBJECT columns and their purpose.
| Column Name | Type | Description |
| ID | NUMBER(10) | Record identifier from sequence SEQACDC_OBJ_ID |
| ACAD_OBJECT_TYPE | VARCHAR2(30) | AutoCAD object type. Permissible values: 1. INSERT for block objects 2. POLYLINE for linear objects such as water and sewer pipes. For multiple valid types, e.g. when a water pipe is to be represented by a LINE or by a LWPOLYLINE in the same drawing, multiple records are inserted in the table as separate records. 3. POLYGON for POLYGON and MPOLYGON objects. For AutoCAD Lite, these are LWPOLYLINE whose property is set as CLOSED 4. CIRCLE for circular objects. 5. SINGLE LINE TEXT for Text objects to be converted as labels - available for GRAPHICS ONLY |
| ACAD_LAYER | VARCHAR2(100) | AutoCAD layer on which the target objects are located. |
| ASSOC_BLOCK_NAME | VARCHAR2(100) | AutoCAD block name. This is the name of the block that contains attribute values for the object. This will be blank for TEXT objects. |
| ASSOC_BLOCK_LAYER | VARCHAR2(100) | AutoCAD layer where a block associated with an object is located. This will be blank for TEXT objects. |
| ASSOC_BLOCK_LOCATION | VARCHAR2(30) | Place where the attribute block belonging to relevant object (e.g. water or sewer pipe) is expected to be found. Permissible values: 1. MID: The block is expected to be snapped to the midpoint of a line or a segment of an LWPolyline. This is also used for blocks. 2. STARTEND: The block is expected to be found at either start or end of a linear object. 3. START: The block is expected to be found at the start of a linear object. This setting provides an added functionality where the application will search for an object at the end of the object under consideration. This can be used to validate that a SC has a block at the start and a main pipe at the end 4. END: This is the reverse of the functionality provided with the ‘START’ setting 5. INSIDE: The block is expected to be inside the circle or the closed LWPolyline object |
| TABLE_NAME | VARCHAR2(50) | Destination table name. |
| OBJ_TYPE | VARCHAR2(30) | Munsys PIPE_TYPE or NODE_TYPE or blank if not applicable. |
| EX_FILENAME | VARCHAR2(250) | Export file name for the CSV file in which attribute values are written to. |
| OD_TABLE_NAME | VARCHAR2(30) | Table name for Object Data (must be 25 characters or less). |
| EXT_OUTPUT_REQ | VARCHAR2(3) | Object attribute will also be written to a separate CSV file |
| DESCRIPTION | VARCHAR2(500) | The menu description as displayed in ACDC Configurator |
| SHOW_LINEARDIR | VARCHAR2(3) | Setting used to toggle ON/OFF the display of linear direction arrows (YES or <null>) |
| GRAPHIC_ONLY | VARCHAR2(3) | Setting to determine if the Attribute is Graphic Only for layers that contain no attribute data. |
| ARROW_SCALE | NUMBER(5,2) | This setting sets the scale for the Linear Direction Arrow. This setting uses the Drawing Units (gDrawingUnits) to determine which folder to use to locate the symbol “darrow.dwg”, and display in either Feet or Meters. |
| STANDARD_SUBGROUP | VARCHAR2(50) | This setting contains the name of the specification against which the objects are verified against, for example: 1. BSPEC: Building Specification 2. DSPEC: Drainage Specification 3. OSPEC: Open Space Specification 4. RSPEC: Roads Specification 5. SSPEC: Sewer Specification 6. WSPEC: Water Specification |
Table 24: WAE_PIPE_BREAK
Below is a list of the WAE_PIPE_BREAK columns and their purpose.
| Column Name | Type | Description |
| PIPE_LAYER_NAME | VARCHAR2(100) | AutoCAD layer name for the linear features that will be snapped to/broken. |
| BLOCK_NAME | VARCHAR2(100) | Name of the AutoCAD block that will snap to/break the linear features. |
| SNAP_RULE | VARCHAR2(30) | Permissible values: 1. SNAP_NEAREST_END: The block will be snapped to the nearest end of the relevant linear feature. 2. SNAP_NEAREST_POINT: The block will be snapped to the nearest point on the relevant linear feature, measuring perpendicular to the linear feature. 3. SNAP_NEAREST_POINT_AND_BREAK: Same as ‘SNAP_NEAREST_POINT’, but the linear feature will also be broken at this location. |
Table 25: WAE_SC_LINK
Below is a list of the WAE_SC_LINK columns and their purpose.
| Column Name | Type | Description |
| SC_LAYER | VARCHAR2(100) | AutoCAD layer name that contains service connections. |
| MAIN_PIPE_LAYER | VARCHAR2(100) | AutoCAD layer name that contains pipes relevant to the service connections. |
Table 26: WAE_SPA_RULEMAP
Below is a list of the WAE_SPA_RULEMAP columns and their purpose.
| Column Name | Type | Description |
| SPA_RULEMAP_ID | NUMBER(10) | Unique Rule Map ID from sequence SEQACDC_SPA_RULEMAP |
| PRI_FKID | NUMBER(10) | Primary Foreign Key: Referencing column ID in WAE_OBJECT |
| PRI_ACAD_OBJECT_TYPE | VARCHAR(30) | AutoCAD Entity Type of Object e.g. LINE, LWPOLYLINE, MPOLYGON |
| PRI_ACAD_LAYER | VARCHAR(100) | AutoCAD Layer the object is drawn on |
| SEC_FKID | NUMBER(10) | Secondary Foreign Key: Referencing column ID in WAE_OBJECT |
| SEC_ACAD_OBJECT_TYPE | VARCHAR(30) | AutoCAD Entity Type of Object e.g. LINE, LWPOLYLINE, MPOLYGON |
| SEC_ACAD_LAYER | VARCHAR(100) | AutoCAD Layer the object is drawn on |
| ERROR_TYPE | VARCHAR(10) | Denotes type of Error, either ERROR or WARN |
| CUSTOM_MESSAGE | VARCHAR(250) | User defined Error message which overrides system Error messages |
| RULE_ORDER | NUMBER(10) | Order in which the rule is processed during validation |
| RULE_DESC | VARCHAR(60) | Rule Description |
| RULE_TYPE | VARCHAR(40) | Contains the Rule Type value advising which rule is to be applied during validation, for example: 1. FORMATSTR 2. SUBSTR 3. MVCHECK 4. MULTICHECK 5. RANGEX 6. VALUECHECK 7. LINKLIMIT 8. ISINSIDE 9. LINKLIMIT 10. NODELIMIT 11. RACHECK 12. CHECKLINK 13. DISTCHECK |
| RULE_PARAM | VARCHAR(500) | Parameters to apply for the rule type defined. |
Table 27: DEPRECATED SQL SERVER TABLES
Below is a list of the tables which have been Deprecated and affect only the MS SQL Server Installations
| Table Name | Description |
| ACDC_SEQ | Table has been deprecated - See Sequence ACDCDSEQ_ID |
| ACDC_SEQ_OBJ | Table has been deprecated - See Sequence SEQACDC_OBJ_ID |
| ACDC_SEQ_DWG | Table has been deprecated - See Sequence SEQACDC_DWG_ID |
ACDC Export Configuration Tables
Table 28: WAE_EXPORT_RULEMAP
Below is a list of the WAE_EXPORT_RULEMAP columns and their purpose.
| Column Name | Type | Description |
| EXPORTRULEMAP_ID | NUMBER(10) | Unique Export Rule Map ID from sequence SEQACDC_EXPORTRULEMAP_ID |
| RULE_DESC | VARCHAR2(60) | Rule Description |
| RULE_TYPE | VARCHAR2(40) | Contains the Export Rule Type which can be applied to the attributes during the export process. |
| RULE_PARAM | VARCHAR2(500) | Contains the Paramaters to be applied for the Rule Type configured where the format parameters are applied to the attributes. |
Table 29: WAE_EXPORT_OUTPUTDEF
Below is a list of the WAE_EXPORT_OUTPUTDEF columns and their purpose.
| Column Name | Type | Description |
| EXPORTOUTPUTDEF_ID | NUMBER(10) | Unique Export Output Definition ID from sequence SEQACDC_EXPORTOUTPUTDEF_ID |
| PRI_FK_OBJECT_ID | NUMBER(10) | Primary Foreign Key from table WAE_OBJECT.ID |
| SEC_FK_OBJECT_ID | NUMBER(10) | Secondary Foreign Key from table WAE_OBJECT.ID |
| FK_ATTRMAP_ID | NUMBER(10) | Foreign Key from table WAE_ATTR_MAP.ATTRMAP_ID |
| TARGET_COLUMN_NAME | VARCHAR2(500) | Export file target column name |
| FK_EXPORTRULEMAP_ID | NUMBER(10) | Foreign Key from table WAE_EXPORT_RULEMAP.EXPORT_RULEMAP_ID |
| COLUMN_ORDER | NUMBER(10) | Order in which the Columns appear in the Export file |
| DESCRIPTION | VARCHAR2(500) | Column Descriptions applied to Export File |
Table 30: WAE_EXPORT_RELATERULE
Below is a list of the WAE_EXPORT_RELATERULE columns and their purpose.
| Column Name | Type | Description |
| EXPORT_RELATERULE_ID | NUMBER(10) | Unique Relate Rule ID from sequence SEQACDC_EXPORTRELATERULE_ID |
| PRI_FKID | NUMBER(10) | Primary Foreign Key from WAE_OBJECT |
| PRI_ACAD_OBJECT_TYPE | VARCHAR2(30) | Primary AutoCAD Object Type of Point, Line, Polygon etc. |
| PRI_ACAD_LAYER | VARCHAR2(100) | Primary AutoCAD Layer Name |
| SEC_FKID | NUMBER(10) | Secondary Foreign Key from WAE_OBJECT |
| SEC_ACAD_OBJECT_TYPE | VARCHAR2(30) | Secondary AutoCAD Object Type of Point, Line, Polygon etc. |
| SEC_ACAD_LAYER | VARCHAR2(100) | Secondary AutoCAD Layer Name |
| RULE_DESC | VARCHAR2(60) | Rule Description as defined in WAE_ATTR_RULEMAP |
| RULE_TYPE | VARCHAR2(40) | Rule Type as defined in WAE_ATTR_RULEMAP |
Table 31: WAE_EXPORT_FILENAME
Below is a list of the WAE_EXPORT_FILENAME columns and their purpose.
| Column Name | Type | Description |
| EXPORT_FILENAME_ID | NUMBER(10) | Unique ID for each Exported File |
| XE_FILENAME | VARCHAR(250) | Export File Name |
Table 32: WAE_EXPORT_LNKFILEATTR
Below is a list of the WAE_EXPORT_LNKFILEATTR columns and their purpose.
| Column Name | Type | Description |
| FK_EXPORT_FILENAME_ID | NUMBER(10) | Foreign Key from table WAE_EXPORT_FILENAME. EXPORT_FILENAME_ID |
| FK_EXPORTOUTPUTDEF_ID | NUMBER(10) | Foreign Key from table WAE_EXPORT_OUTPUTDEF.EXPORTOUTPUTDEF_ID |
| COLUMN_ORDER | NUMBER(10) | Order in which the Columns appear |
ACDC Configuration
Configuring Real Values
Real data types have a maximum specified ‘width’ and ‘precision’ stored in the ‘Configurator’ which determines the accuracy of numerical data and ensures that any input data is not larger than what the destination column(s) allows. However, it is possible that maximum allowable size of these configured real data types exceeds that of the destination column(s).
The Configurator setting gVerifyRealValues helps ACDC to manage the way different databases store real values. This is important because the size of real data values are interpreted differently by FDO sources. For example, dBase (database for managing SHP files) includes the decimal and minus sign in the numeric data size for real values but Oracle and SQL Server do not. It is therefore recommended that the gVerifyRealValues setting is configured for the appropriate database (E.g. Oracle, SQL, SHP), to allow ACDC to accurately perform a Comprehensive Check in ‘Verify Configuration’ (See section Verify Configuration Test Details). This will ensure that the destination column size is not too small for the configuration stored in the Configurator; thus preventing errors when validating drawings.
Real data types that are stored in a database have a specified precision and scale. The precision is the total number of digits to the left and right of the decimal point, and, depending on the database, can include the decimal and any minus sign. The scale is the number of digits to the right of the decimal point. This is recoded in the format Precision.Scale (E.g. 5.3). The following table provides examples of how real values are interpreted by their database.
| ‘Real’ Value | ACDC Configurator | Oracle | SQL Server | SHP File |
| E.g. 5.3 | 12345.123 | -12.123 or 12.123 are valid | -12.123 or 12.123 are valid. | -0.21 or -1.12 or 2.123 are valid. |
| E.g. 7.2 | 1234567.12 | -12345.12 or 12345.12 are valid | -12345.12 or 12345.12 are valid | -1234.1 or -123.12 or 1234.12 are valid |
The Configurator setting gVerifyRealValues provides 3 selectable options to handle the way databases manage real values. Select the Setting Value appropriate to your FDO Source/database, according to how it interprets the data size for real values.
- Width and Precision (exclude decimal point) (E.g. Oracle, SQL Server).
- Width and Precision (include decimal point).
- Width and Precision (include decimal point and sign) (E.g. dBase/SHP).
For more information on data types refer to the respective database documentation (or see links below):
Configuring Log4Net to produce Log File
Log4Net is a highly configurable logging mechanism that it can be used for debugging and troubleshooting.
If system issues are encountered the Log4Net error report logs can be submitted to Open Spatial Support. For the log to work, the location of the output log and the type of debugging must be specified.
To do this, follow the steps below:
- Open the LogConfig.xml located in the install directory in a text editor.
E.g. C:\Program Files\OpenSpatial\ACDC 5.2\DLL\LogConfig.xml - Change the file value (the location of the log output file) to a convenient location outside of the install location.
E.g. file value=" C:\temp\logACDC.txt" - Change the level value from Debug value from OFF (default) to DEBUG (recommended) or another level value as required. The available types are OFF, FATAL, ERROR, WARN, INFO, DEBUG, and ALL. These levels function are hierarchically, so that a debug level set to WARN will log any WARN, ERROR, or FATAL log events.
E.g. level value="DEBUG" - Save the changes and Close
Additional Notes
- Database sequences have been defined to provide a unique numeric identifier (Primary Key) for each record that is converted.
- ACDCSEQ_ID
- SEQACDC_ATTR_RULEMAP
- SEQACDC_ATTRMAP_ID
- SEQACDC_DWG_ID
- SEQACDC_GROUP_OBJECT_ID
- SEQACDC_MENU_GROUP
- SEQACDC_MENU_MACRO
- SEQACDC_MENU_ORDER
- SEQACDC_MVID
- SEQACDC_OBJ_ID
- SEQACDC_SPA_RULEMAP
- ACDC supports stored procedures/functions in Oracle and MS SQL Server databases. For use with ACDC, the stored procedures/functions cannot accept any input variables and must return a value.
- .shp file export process has been improved to ensure the attributes are ordered as per the block, instead of having them ordered alphabetically. This process also now ensures that the attribute fields are the correct type, rather than standardizing to just character.