NexusDB V3 Manual

Step Three - Field Formats and Advanced Options

On the third and last wizard page, set formatting options, and link table fields with import columns.

The Import to data field list contains the list of fields in the table you are importing to, or a generic numbered name (field 1 etc) if you haven't created a table yet.

The Import from column lists the columns in the text file. If there are column descriptions in the first line of the file, and you chose "Start import on row" to be larger than 1 on the first wizard page, then the descriptions are used, otherwise generic numbered column names are displayed.

To link a field in the table with a column, click the field in the field list first, and then click the column you want to import into the field. If you make a wrong selection and want to remove the column, click the (no import) item at the top of the column list. Check marks appear next to fields and columns that have been selected.

The column preview will display the chosen column and invert its colour. You may select columns by clicking either the Import from column list, or directly in the preview.

The New Table button will bring up the Create Table dialog, with fields, field types and units preset from the values detected in the CSV file. Ensure that text fields are large enough to hold the longest text you have in a column etc. The detection process only looks at the start of a file, so there might be longer text strings in a column than what is detected from the first part of the file. If you successfully Create the table, the new table is now the one being imported into.

Before linking individual fields and creating a new table, you should open the Advanced settings dialog and set the options to match what is contained in the CSV file. Also, to speed up importing, it is a good idea to use a higher number for Records per transaction (recommend 1.000-10.000 ).

To ensure proper handling of date/time formats, make sure to set the date/time options in the Advanced settings dialog, before pressing the "New Table" button on that wizard page.