Master Data Management - Techcello

Cello How-To GuideMaster Data Management

How-To – Master Data ManagementContents1Master Data Management . 31.1MasterData Configuration . 31.2MasterData Configuration Tags . 5Contact Information. 82

How-To – Master Data Management1 Master Data ManagementMost of the systems possess lot of administration screens and building them consumes time. Master data inCelloSaaS facilitates the creation of admin screens with just few lines of code in short span of time. Masterdata is used in building a data entry page for a table by simply mentioning the configuration details inconfiguration file. The data entered through this page will be attached to the specific tenant.1.1 MasterData ConfigurationTo configure master data, the user has to specify the details in a separate configuration file.MasterDataConfiguration.Config.The user needs to specify the configurable settings using appropriate tags and attributes as follows: masterDataConfiguration masterData add name "TenantTypes" entityName "TenantTypes" tableName "TenantTypes"deactivateRecord "false" auditInformation name "TenantTypes" statusColumn "Status" tenantColumn ""primaryColumn "TenantType ID" addedOn "TenantType CreatedOn" addedBy "TenantType CreatedBy"updatedOn "TenantType UpdatedOn" updatedBy "TenantType UpdatedBy" /auditInformation column add name "TenantType Name" fieldId "TenantType Name" displayHeader "Name"displayAs "AsItIs" mandatory "true" /add add name "TenantType AccessLevel" fieldId "TenantType AccessLevel"displayHeader "AccessLevel" displayAs "AsItIs" mandatory "true" /add /column /add add name "TenantRelationTypes" entityName "TenantRelationTypes"tableName "TenantRelationTypes" deactivateRecord "false" auditInformation name "TenantRelationTypes" statusColumn "Status" tenantColumn ""primaryColumn "TenantRelationType ID" addedOn "TenantRelationType CreatedOn"addedBy "TenantRelationType CreatedBy" updatedOn "TenantRelationType UpdatedOn"updatedBy "TTenantRelationType UpdatedBy" /auditInformation column add name "TenantRelationType Name" fieldId "TenantRelationType Name"displayHeader "Name" displayAs "AsItIs" mandatory "true" /add /column /add add name "LocaleNames" entityName "LocaleNames" tableName "LocaleNames"deactivateRecord "false" connectionStringName "CelloSaaSConnectionString" auditInformation name "LocaleNames" statusColumn "LocaleNames Status" tenantColumn ""primaryColumn "LocaleNames Id" addedOn "LocaleNames CreatedOn"addedBy "LocaleNames CreatedBy" updatedOn "LocaleNames UpdatedOn"updatedBy "LocaleNames UpdatedBy" /auditInformation column add name "LocaleNames Name" fieldId "LocaleNames Name" displayHeader "Locale Name"displayAs "AsItIs" mandatory "true" /add 3

How-To – Master Data Management add name "LocaleNames Description" fieldId "LocaleNames Description"displayHeader "Description" displayAs "AsItIs" multiLine "True" maxLength "300" /add /column /add add name "Country" entityName "Country" tableName "Country" deactivateRecord "false"connectionStringName "CelloSaaSConnectionString" auditInformation name "Country" statusColumn "Country Status" tenantColumn ""primaryColumn "Country ID" addedOn "Country CreatedOn" addedBy "Country CreatedBy"updatedOn "Country UpdatedOn" updatedBy "Country UpdatedBy" /auditInformation column add name "Country Name" fieldId "Country Name" displayHeader "Country Name"displayAs "AsItIs" mandatory "true" /add /column /add add name "Language" entityName "Language" tableName "Language" deactivateRecord "false"connectionStringName "CelloSaaSConnectionString" auditInformation name "Language" statusColumn "Language Status" tenantColumn ""primaryColumn "Language Id" addedOn "Language CreatedOn" addedBy "Language CreatedBy"updatedOn "Language UpdatedOn" updatedBy "Language UpdatedBy" /auditInformation column add name "Language Name" fieldId "Language Name" displayHeader "Language Name"displayAs "AsItIs" mandatory "true" /add add name "Language Code" fieldId "Language Code" displayHeader "Language Code"displayAs "AsItIs" mandatory "true" /add /column /add !--Data Scope mater data configuration -- add name "DataScope" entityName "DataScope" tableName "DataScope"deactivateRecord "false" connectionStringName "CelloSaaSConnectionString" auditInformation name "DataScope" statusColumn "DataScope Status" tenantColumn ""primaryColumn "DataScope ID" addedOn "DataScope CreatedOn" addedBy "DataScope CreatedBy"updatedOn "DataScope UpdatedOn" updatedBy "DataScope UpdatedBy" /auditInformation column add name "DataScope Name" fieldId "DataScope Name" displayHeader "Name"displayAs "AsItIs" mandatory "true" requiredErrorMessage "Please enter the dataccopename." /add add name "DataScope SelectQuery" fieldId "DataScope SelectQuery"displayHeader "Select Query" displayAs "AsItIs" mandatory "true" multiLine "true"requiredErrorMessage "Please enter the select query" /add add name "DataScope FilteredSubject" fieldId "DataScope FilteredSubject"displayHeader "Filtered Subject" displayAs "AsItIs" multiLine "true" /add add name "DataScope AccessLevel" fieldId "DataScope AccessLevel"displayHeader "Access Level" displayAs "AsItIs" mandatory "true" requiredErrorMessage "Pleaseenter the access level." regularExpression " [0-9]" regularExpressionErrorMessage "Accesslevel contain only numeric value." /add /column /add add name "EntityDataScope" entityName "EntityDataScope" tableName "EntityDataScope"deactivateRecord "false" connectionStringName "CelloSaaSConnectionString" auditInformation name "EntityDataScope" statusColumn "EntityDataScope Status"tenantColumn "" primaryColumn "EntityDataScope ID" addedOn "EntityDataScope CreatedOn"addedBy "EntityDataScope CreatedBy" updatedOn "EntityDataScope UpdatedOn"updatedBy "EntityDataScope UpdatedBy" /auditInformation column 4

How-To – Master Data Management add name "EntityDataScope EntityID" fieldId "EntityDataScope EntityID"displayHeader "Entity" displayAs "AsItIs" mandatory "true" requiredErrorMessage "Please enterthe entity name." /add add name "EntityDataScope BridgeCondition" fieldId "EntityDataScope BridgeCondition"displayHeader "Bridge Condition" displayAs "AsItIs" multiLine "true" /add add name "EntityDataScope DataScopeID" fieldId "EntityDataScope DataScopeID"displayHeader "DataScope" displayAs "DDL" mandatory "true" parentTable "DataScope"parentIdColumn "DataScope ID" parentValueColumn "DataScope Name"parentStatusColumn "DataScope Status" requiredErrorMessage "Please select the datascope." /add /column /add /masterData /masterDataConfiguration 1.2 MasterData Configuration TagsIn order to configure master data, user should know the list of tags used. masterData tag –MasterDataElement: This tag is used to configure the masterdata. The attributes of this tag should be usedwith the add tag. The following are the attributes related to this tag:AttributesDescriptionColumnUsed to get the columns of the entity. Value of this attribute shouldbe MasterDataColumnElement nameEntityNameSpecifies the entityname which is used to bring out CelloSaaSfeatures like Data model extension,tracking, etc.TableNameSpecifies the name of the tableConnectionStringNameSpecifies the name of the connection string. If it does not exist,CelloSaaS considers Application connection stringCreatePrivilegeSets create privilege to add a masterDataUpdatePrivilegeSets update privilege to update the masterdataDeletePrivilegeSets delete privilege to delete the masterdataViewPrivilegeSets view privilege to view the masterdata list and detailsThe following elements help in configuring the complete masterdata based on the user requirements. Allthese elements should be configured under masterData tag.5

How-To – Master Data Management1. auditInformation tag – AuditFieldInformation:This tag is used to audit masterdata entity. The followingare the attributes related to this tag.AttributesDescriptionStatusColumnAttribute is used to identify the audit status of the column. The value for thisattribute is any valid string.For example, statusField ”Status”TenantColumnSpecifies name of the column where tenantId will be storedprimaryColumnSpecifies name of the primary columnUpdatedBySpecifies the user who had lastly updated the masterdata entity row. The value forthis attribute is the username who had lastly updated the rowUpdatedOnSpecifies the date in which the masterdata entity row lastly updated. The value forthis attribute is the date string specifying when the row got updatedAddedBySpecifies the user who added the masterdata entity row. The value for this attributeis the username who had added the rowAddedOnSpecifies the date in which the masterdata entity row got added. The value for thisattribute is the date string specifying when the row got added2. column tag - MasterDataColumnElement: This tag is used to define the list of columns that should getbound with the gridview. The attributes of this tag should be used with the add tag.Following are theattributes related to this tag.AttributesDescriptionNameAttribute used to uniquely identify a column from other columns. The value for thisattriute is any valid string.FieldIdSpecifies the field Identifier which is used to bring out the customizationDisplay HeaderSpecifies the column header name. The value for this attribute is any valid string.Display TextColumnSpecifies what text to be displayed to the user for the column. The value for thisattribute is any valid string.Display AsSpecifies how the column should get displayed to the user. The value for this attributecan be any one of the following:AsItIs – To display a textbox control6

How-To – Master Data ManagementParent TableDDL – To display a drop down list controlCheckBox – To display a checkbox controlRadio – To display a Radio button controlDate – To display a date controlPickupList – To display a pickup list which has beed added in pickup list configurationUsed to specify whether the column got any key relation with some other table.Thevalue for this attribute is any valid database table name which got a key relation withthis columnParent valueColumnSpecifies to which parent table column the field got the key relation.The value for thisattribute is the column name which got the key relation with this columnParent TenantcolumnSpecifies name of the parent column where tenantId will be storedParent StatuscolumnSpecifies name of the parent status columnIt specifies whether user have to provide input for the column or can be left emptyMandatoryTrue: specifies that user have to provide input for the columnFalse: specifies the column can be left emptySpecifies whether the text field is multiline text field or singleline text fieldMultiLineTrue: specifies that the column is a multiline text fieldFalse: specifies that the column is a singleline text fieldMaxLengthRequired ErrorMessageSpecifies the max length for text boxSpecifies the error message that should be displayed to the user when therequired/mandatory column left blankThe value for this attribute is any valid stringPickupListIdSpecifies Pickuplist id which has been created in pickuplist management7

How-To – Master Data ManagementContact InformationAny problem using this guide (or) using Cello Framework. Please feel free to contact us, we will be happy toassist you in getting started with Cello.Email: support@techcello.comPhone: 1(609)503-7163Skype: techcello8

How-To - Master Data Management 1 Master Data Management Most of the systems possess lot of administration screens and building them consumes time. Master data in CelloSaaS facilitates the creation of admin screens with just few lines of code in short span of time. Master data is used in building a data entry page for a table by simply .