Home | Using Katmandoo | Quick Start Guide | How-to | Task Menu | Table of Contents | See Also | Collapse All

Import Virtual Column and its Validation Rule

Overview

Import Virtual Column Wizard can be used to import Virtual Columns as well as their validation rules.

Click here to read important note on importing data.

Required Column to import data

Following table list required columns for each import options:

Import Option Required columns in the source file
Import Virtual Columns FactorName, FactorCaption, FactorDescription, TablenameOfFactor, FactorDataType,  
CanFactorHaveNull, FactorValueMaxLength
Import Validation Rule of Virtual Columns
for one or more Sub-system		 FactorName, SubSystemName, FactorValRule, FactorValRuleErrMsg

First Page of Import Virtual Column Wizard

This wizard can be activated using [ Task > System > Manage Virtual Column > Record > Import Virtual Column ]. It has following options:
The first page of the import wizard changes as per the selected option (above) but the second page is same for all the options.

Import Virtual Columns

This option can be used to import Location from the source file.
Illustrative snapshot:
First page of Import Virtual Columns (Click it to change its size)
  1. Select the [ Import Virtual Columns ] option.
  2. Select source file to import virtual columns.
  3. Map column names used in spreadsheet with column name of the database.
When [ Save Virtual Column into database ] is clicked after [ Preview ], following messages may appear:
Importing Virtual Column Alias Alert
       
Suggestion: If the aliases in the source file are separated by comma, then click on [ Yes ] otherwise Click [ No ] and correct the alias separator in the  source file
Insert Empty/Blank Validation Rules for Imported Virtual Column

Suggestion: If the source file does NOT have validation rule for any column, click on [ Yes ] which instruct Katmandoo to insert blank/empty validation rules for the imported Virtual Columns for all the Sub-systems in the database.

Import Validation Rule of Virtual Columns for one or more Sub-system

This option can be used to import Validation Rule of Virtual Columns for one or more Sub-system from the source file.
Illustrative snapshot:
First page of Import Validation Rules for Imported Virtual Columns (Click it to change its size)
  1. Select the [ Import Validation Rule of Virtual Columns for one or more Sub-system ] option.
  2. Select source file to import Validation Rule of Virtual Columns.
  3. Map column names used in spreadsheet with column name of the database.
On [ Preview ] following message appears:
Insert Validation Rules of Imported Virtual Column for All the Sub-systems in the database.

Suggestion: If validation rule of the virtual columns in the source file is same for all the Sub-system, click on [ Yes ] which instruct Katmandoo to copy the validation rules of the imported column for all the Sub-systems in the database. Click [ No ] to import validation rules of the Virtual Columns for the Sub-system in the source file only.

Second (Preview) Page of Import Virtual Column Wizard

The default order of columns displayed can be changed by editing the column list of the Misc Group

Import Option Misc Group Name
Import Virtual Columns FactorSetupDatagrid
Import Validation Rule of Virtual Columns
for one or more Sub-system		 ColumnNamesForImportFactorSubSystemDataGrid
Click here for Illustrative snapshot.

See Also