Data Inputs
Data can be entered into a project database in many different ways
including:
Whichever entry route you choose the end result is that the project
data is "grouped" into separate datatables, each datatable
storing data of a specific type. So, for example, all triaxial test data
is stored together, geological strata in another datatable and so on.
All the datatables within a project database are related to each
other. The fundamental link between all datatables is the Borehole
Identifier (BH_NUMBER) examples of which are BH1, TP1A etc. Within a
borehole there will usually be data on soil samples - stored in the
SAMPLE datatable. Some samples will have tests carried out on them and
the results are stored in the appropriate detail datatables (e.g. TRIG
& TRIX for triaxial tests) or summary information might stored in
the classification table CLASS.
The full set of datatables and their relationships are described in
the SID Project Database Structure topic.
Direct keyboard entry
You can design the layout of the data entry screen for each
datatable. It is a good idea to remove datafields that you rarely use
and to re-arrange the datafields into the order they appear on your data
entry forms.
Example
screen image.
Importing AGS formatted files
To import an AGS formatted file you must know
the AGS Edition number to which the file was prepared. This can be
either Ed 2 or Ed 3.1 and defines the detailed specification of the file
format. Generally, a single AGS file will contain data that will be
input to several SID datatables. This is handled automatically by SID
according to a LINK table which specifies the correspondence between an
AGS data heading and a SID datafield. This LINK table can be modified by
selecting the Options:AGS links menu option.
Using SID formatted spreadsheets
SID has a function that will format a spreadsheet template for you to
use for data input. This is similar to the direct keyboard entry method
in that each spreadsheet file is linked to a single SID datatable.
However, using spreadsheets may be more familiar to some data input
operators, and also this method allows you to prepare data remotely from
the SID system. To prepare a SID formatted spreadsheet file select the
Data:Datatables option, press the Design button, design your layout and
then press the Spreadsheet button. This action will open Excel with an
empty spreadsheet with column heading matching your datatable design.
Save this template and re-use for each project.
Importing general spreadsheets
To import a general spreadsheet select the Data:Import Data:Spreadsheet
option. After selecting the spreadsheet file and the input SID
datatable, you can configure the LINKS between the spreadsheet column
names and the SID datafields as required. SID automatically links
matching names.
Importing files in standard PC formats
(SLK,CSV,WK1....)
Although you can import datafiles in most common PC formats this will
only work when the data is formatted in the correct SID field order. To
import data in other orders or with only partial data first import the
data into an Excel spreadsheet, save it, and then use the procedure for
Importing general spreadsheets above.
)
){kind=link}