There are two ways of creating a new table in exTables.
1. Create an empty table
2. Import a table from either excel or a flat-file.
To create a table you have to open a project and a category in the navigation bar. Select the project you want your project to belong to from the projects available to you (1). Next, select a category for the new table (2). Now, a Create Table button will be available (3).
Clicking the Create Table button will open a form where you can select how you want to create the table. This article will not discuss how to Import a Hierarchy from Excel or a Flat-File.
1. Create Empty Table
Select the Create Empty Table option and click Next.
Fill in the table properties and click Save.
Table Display Name: Name of the table that you will see in exTables.
Database Name: Name of the table in the database. Often the same as the display name.
Category: Select the category the table should be stored in.
Audit History: Can either be Normal or Full.
Description: Write a description of the table that will be visible to all contributors of the table.
Contributor Access: Select if contributors should be able to add and delete rows or if they should only be allowed to modify existing rows.
When your new table has been created it will open up and you can use the designer (upper right corner) to create its structure.
2. Import Table
2.1 Select a file to import
Select the Import Table from Excel or Flat-File option and click Next. You will go to this window:
Click Browse to find the file you want to import. Then Select the sheets you want to include in your import (each sheet will be imported in a different table). Finally, click Next.
2.2 Configure column mapping
On the left there is a list of sheets selected for import. You can select the different sheets and change the properties for them. Give the tables different names (exTables name) and select at what index the data starts. Also you can specify if the file contains headers for the columns. These changes will affect the Preview at the bottom so you can confirm that you have selected the correct properties.
The Column Mapping table allows you to change properties of the columns:
Import: Either import (include the column in the import) or ignore (do not include the column in the import)
exTables Name: The name the column will have exTables.
Column Type: Currently only option is Normal.
Data Type: Specify the data type of the column. Options are: String, DateTime, Decimal, Number and Checkbox.
When you are finished, click Verify.
If the import is verified you will see that all sheets are marked as Success. Click Confirm to import the table(s).
If one or more sheets are marked with Error you might need to change data types in your column mapping or fix something in your source data. The error message should give an indication of the problem.