Data Types and Database Formats - Import and Display in Oasis montaj

Data types and database formats are different and you should be aware of the differences when using the system. Data types refer to the actual numerical (ASCII or binary) representation of your import or export data. Database formats refer to the way in which you want to display your data in a Spreadsheet window. The sections below describe the basic formats for each.

Import and Export Data Types

Oasis montaj provides numerous data types for importing, working with and exporting data. The available data types you can use are:

Data Type	Meaning
Byte	Signed 8-bit integer (-126 to +127, -127 is dummy).
Ushort	Unsigned 16-bit integer (0 to +65534, 65535 is dummy).
Short	Signed 16-bit integer (-32766 to +32767, -32767 is dummy).
Long	Signed 32-bit integer (-2147483646 to +2147483647, -2147483647 is dummy).
Float	32-bit floating point number (-1.0E+32 is dummy).
Double	64-bit floating point number (-1.0D+32 is dummy).
String	Null terminated string.

Database Formats

Oasis montaj provides different formats for importing data into the database. After they are imported into the database, you can alter the way in which they appear on the screen by editing the Channel format.

When importing data, your XYZ data must be in one of the following import formats:

Import Format	Meaning
Normal	Decimal number (i.e. 4 or -0.00123).
Exponent	Exponent number (i.e. 4.0E+00 or -1.23E-3).
Time	Time in HH:MM:SS.SS format.
Time	Time in HH:MMSSSS format.
Time	Time in HHMMSSSS format.
Date	Date in YYYY/MM/DD format.
Date	Date in DD/MM/YYYY format.
Date	Date in MM/DD/YYYY format.
Date/Time	ISO 8601.
Geo	Geographic map coordinate in DEG.MM.SS.SS format.
Geo	Geographic map coordinate in DEG:MM:SS.SS format.
Geo	Geographic map coordinate in DEG.MMSSSS format.
Geo	Geographic map coordinate in DEGMMmmmm format.
Geo	Geographic map coordinate in DEGMM.mmmm format.
Geo	Geographic map coordinate in DEG.MM.mmmm format.

Oasis montaj Display Types

Oasis montaj provides a variety of formats for displaying data in the database window. These are a subset of the import formats. Note that the display format only effects how the data is displayed — it does not change the actual format in which the data is stored.

The available formats you can use are:

Display Format	Meaning
Date	Date in YYYY/MM/DD format.
Exponent	Decimal number with exponent and sign (i.e. 4.0E+00 or -1.23E-3).
Geo	Geographic map coordinate in DEG.MM.SS.S format.
Normal	Decimal number (i.e. 4 or -0.00123).
Time	Time in HH:MM:SS.SS format