Norman version 2
I. Load data file
This main menu item invokes a secondary menu to choose the desired import format. If applicable, a dialogue "Loose data in memory?" is entered to remind you that your data will be lost unless saved (see section II.).
Data files can be searched using the file manager module, consisting of three windows: a file list, a list of subdirectories, and a window with the current path and the default suffix. The third one can be used to enter directly the path, and, or, the requested filename. Use the cursor keys to move around, Tab to switch between windows, and Enter to select. Esc returns you to the "Load data file" menu.
Below are given remarks on individual data formats; if in doubt, please refer to the sample data files provided with your copy of NORMAN (in brackets are given default suffixes):
a) dBASE III (*.DBF)
Use this format to import data from your favourite database or spreadsheet. The first field should be alphanumeric and is assumed to contain sample names. Any additional character fields whose names start with "LOC" or "ROCK" are taken as descriptions of locality and rock type, respectively, but do not have to be present at all. The numeric fields containing the major-element data ought to be named as follows, as the fields with different names will be ignored and zeros will be added if any of these are missing:
SIO2, TIO2, AL2O3, FE2O3, FEO, MNO, MGO, CAO, NA2O, K2O, H2O1000 (or H2OP), P2O5, CO2, F, S
where "H2O1000" or "H2OP" stand for H2O+; the oxides do not have to be necessarily given in this order.
b) ASCII (*.ASC, *.CSV)
The data in the ASCII files can be delimited by spaces, commas, semicolons or Tabs. NORMAN analyses the first line of the specified file and offers a delimiter that seems to be present. The ASCII files without structure (all but *.CSV) should contain 1 to 3 strings for SampleName, Locality and RockType, and then numbers (all in exact order):
SiO2, TiO2, Al2O3, Fe2O3, FeO, MnO, MgO, CaO, Na2O, K2O, H2O+, P2O5, CO2, F, S
One or more parameters in the end of this list can be missing and in that case they will be set to zeros. No comments are allowed in the first row.
As a special case are treated comma-delimited files produced by some spreadsheet programmes (*.CSV). Their first row contains number of columns (or data fields), the next one list of their names separated by commas, the third and following lines contain comma-delimited data for individual samples. This is to provide the compatibility with the text format that can be imported into MinPet. The oxides do not have to be given in an exact order, the first field should be named "SAMPLE", the field containing H2O+ should be "H2OP", the fields containing the major-element data "SIO2", "TIO2", etc. These strings will be converted to upper case, i.e. "SiO2", "sIo2" or "sio2" are equivalent. Fields "RockType" and "Locality" will remain empty.
c) NewPet (*.ROC)
Please refer to the documentation provided with NewPet to see the description of this format. All the data not needed are ignored; both "Locality" and "RockType" fields are imported.