Import-Export Table

The Import/Export Table provides definitions for all the tables used in the application. This includes the name of the table, the file name that that table is expecting (for loads or gets), and the sequence it will happen in.

Import Definition

The Import Definition is the function where tables are mapped for importing data from a pre-configured source database. The data types, default values, and order of the tables and columns are specified to verify the correct database data type validations. The tables are listed in a hierarchy such that the least dependent tables appear before the most dependent. By default, all TESite tables that require data from other systems have already been provided.

Export Definition

The Export Definition is the function where tables are mapped for exporting data from the TESite database. The data types and order of the tables and columns are specified to enable the necessary data and data type validations.

To Modify Tables/Columns:

Tables and columns can be added, deleted or modified in the tables at any time. The following are the steps on how to modify the tables in Data Piping.

1. Click on the Import/Export Table link. The list of tables that can be populated are listed (click the refresh button at the bottom of the page if they don't appear).
2. Click the name of the table you which to modify. The following fields can be modified:
   • Name: The name given to make the table name clearer (example, EMPLOYEE_BALANCE has a name of "Time Code Employee Balance" to be easier to understand)
   • File Name: The name of the file were the data is stored. Make sure to include the file extension. No need to add the file path. This field will be ignored if the source of the data is not a file.
   • Update Option: field identifies the way that data in the table will be updated. Choose one of the following options:
     • Full/Update/Insert: Marks all data in the table as inactive, then uploads new data into the table. The new data is marked active.
     • Partial/Update/Insert: Leaves all data in the table marked active, then uploads new data into the table. The new data is marked active.
     • Delete/Insert: Deletes all data in the table, then uploads new data into the table.
   • Sequence: Determines the order in which the fields in the table will be loaded.
   • Map: Indicates if that table is mapped to a view.
3. Click Columns tab to define the columns that will be loaded.
4. Click on the name of the column to modify the parameters for the specified column. . The following fields can be modified:
   • The Length field determines the maximum length of data to be loaded into the field.
   • The Default field determines the default value to be entered in the specified field if no data is loaded for this field.
   • The Sequence field determines the order in which the column will be loaded.
   • The Alias field indicates if there is another name for that column.
   • The Lookup table field points to the name of a table in the database
   • The Order By field indicates how you want the data sorted.
   • The Data Type field determines the type of data to be loaded into the field (String, Integer, Date/Time, Decimal/Long).
   • The Precision field is required if the data type is Numeric.
   • The Required field determines whether the field is required in the table.
   • The Allow Modify field determines whether the data in the field can be modified.
   • The Primary Key field determines whether or not the field is a primary key for the table.