Import Wizard

Chapter 1

Data Grid Import

Data can be imported easily via any Rintagi screen if the data is contained in a data grid. This eliminates the need for re-entering a large volume of data from a spreadsheet or text file.

Solidity logo

By clicking the Solidity logo icon at the top of each data grid, several more controls will become visible. See below:

Solidity logo

When the Choose File button is clicked, a screen popup requesting the selection of an Excel spreadsheet with an “.xls” extension will appear.

Solidity logo

The format and order of the data inside the selected spreadsheet can be viewed by clicking the Solidity logo icon. This data is obtained automatically from the logical schema established in the Data Tier setup described in Volume 2.

Solidity logo

When a spreadsheet is selected the available worksheets appear as a dropdown list. Select one of the worksheets and indicate the starting row excluding the header. (At least one row of header is required; therefore, the starting row must be greater than or equal to 2). Next press the Solidity logo

A success message will appear and an example is shown below:

Solidity logo

If some contents require password override, just make sure it is a column displayed as dropdown-list, combo-box, radio-button or list-box and the reference table has a column named “OvrideId” as smallint nullable. This OvrideId column should obtain values from the table “Ovride” as below.

Solidity logo

Chapter 1

Import Wizard

Rintagi provides an Import Wizard to facilitate the importation of large volumes of data via a spreadsheet. Because there will be no data entry, a screen for a data grid import is unnecessary.

First verify that the tables and columns are available in the Data Tier as described in previous volumes. Then use Wizard Column to describe the required import wizard. A mandatory field called “ImportFileName” must be present on the designated table for tracking the filenames in each row of data imported. This field should be nvarchar(30) and nullable. Rintagi will assume and automatically fill this column upon import.

Wizard Column

Command: Client Tier -> Wizard -> Wizard Column

Solidity logo

Schema Characteristics Description
Wizard Type The type for this wizard. Available selection is Excel(.xls) for now.
Master Table The wizard uses this master table to receive the import data.
Wizard Title The unique title for this wizard (50 characters or less).
Program Name The unique program name for this wizard (50 characters or less).
Default Worksheet When importing a spreadsheet use this default worksheet name or order unless another is specified.
Default Start Row The default start row of the worksheet (between 1 and 10,000).
Default Overwrite Check this if the default for this import wizard is to overwrite.
Overwrite Read-only Check this if the overwrite option for this import wizard is not user changeable.
Column The column to be imported.
Tab Index The order of the columns in integer form (usually numbered in intervals of 10).
Column The column to be imported.
Tab Index The order of the columns in integer form (usually numbered in intervals of 10).