Campbell Scientific LNDB LoggerNet Database Software - Manual (Page 27)

LNDB
7.2 Import From
The Filename field is used to indicate the file from which data is to be
imported. Only table-based data files are supported and can be imported. Press
the browse button (…) to browse to the desired file.
7.3 Import Into
The Database Table combo box is filled with all tables from the selected
database. Select the table into which the data should be imported.
7.4 Data File Columns vs. Database Table Columns
After a file is selected, the list of data fields from the file is placed in the list
view under the heading Field From File. After a database table is selected, the
list of column names from the database table is placed in the list view under
the heading Database Column.
The data file fields and database columns are matched up. Data file fields that
do not have a corresponding database column have an attached note indicating
that the "Database column is missing". Columns in the database table that do
not have a corresponding data file field have a note indicating that the "Column
does not exist in file".
7.5 Import Requirements
A file can be imported if all the data file fields have a corresponding database
table column. This means that there can be extra database columns that do not
have a corresponding data file field. If there are data file fields that do not have
corresponding database columns, a bold note next to the import button
indicates "Fields from the file are not compatible with database table
columns". In this case, the data file cannot be imported into the database table.
No check is made to validate the columns units, process, or data type. If the
data type is not compatible, the insert will likely fail and you will be notified of
the failure.
7.6 Import
Once the data file and database table are selected, press the Import button to
begin importing data. Data import will begin if the file is compatible with the
selected database table as described above.
21