Corelyzer Data Import Wizard
From CwWiki
Revision as of 17:49, 9 November 2007; Julian (Talk | contribs)
(diff) ←Older revision | view current revision | Newer revision→ (diff)
(diff) ←Older revision | view current revision | Newer revision→ (diff)
To use "Data Import Wizard", please select "Import Data..." from Corelyzer File menu. A user can convert a plain text tabular data file or a Geotek generated data (after pre-processing and data cleaning) to Corelyzer XML data format and directly imported into Corelyzer working session.
Contents |
[edit]
Import Parameters
- File Name
Original input file name. Use "File..." button to select your input file.
- Field Separator
Input what is used to separate each fields in the input file. Commonly used separator might be comma(,) for CSV file. Or Tab(type in \t) delimited file.
- Section Prefix
The prefix used for naming each section
- Start Line Number
In the input file, the starting line number of data values, starting from 1.
- End Line Number
In the input file, the ending line number of data values
- Fields Label Line Number
What is the line number for labels of each value in columns.
- Unit Label Line Number
What is the line number for units of each value in columns. If there is no such line, just input the same line number as "Field Label Line Number"
- Name Column Number
Which column field should be picked used as the name of section. The final section name will be composed with "Section Prefix" and "Name Column Number". A simple comma separated expression is allowed to compose the section name.
- Depth Column Number
Which column will be treated as depth values. Column index starts with 1.
- Select Value Columns
From previous inputs, the field labels will be identified. Then you can check which fields do you want to select to the final dataset file.
[edit]
A Step by Step Walkthrough example
- Import IDEO ODP Database ASCII Data file
Source: LDEO ODP Database search Sample input data file: 763B-ngt.dat Sample output XML file: ldeo.xml
Follow the following steps, and input required parameters
- Step 0: "Input file", "field separator" and "section prefix". For file separator, if it is Tab, input '\t' as the screenshot shows
- Step 1: Start and end line numbers
- Step 2: Label line number and Unit line number. For this example file it does not have unit line, so keep it the same as "Label Line Number"
- Step 3: "Name Column number" and "Depth Column number". The final section name will be using "Name Column number" field and "Section prefix" in step 0. So in this example, the section name that a depth values belongs to will look like "763B-ngt.dat-334.0610", 334.0610 is the depth value with using column index 1 in this step.
- Step 4: Check those data fields that you want to convert. These text values are picked using "field separators" and the label line you selected in step 0 and 2.
- Import a Geotek data file
Source: LacCore
Similar as the previous example. May need to use comma (,) as file separator, Different label and unit line numbers etc.
[edit]
Questions and Answers
A TSV(Tab-Separated-Values) file walkthrough screencast is available [here].
[edit]
Revisions
- Fist revision, implemented in LacCore, 2006 summer
- Nov 2006 minior update to read in LDEO data set file






