Import Text File Data window

Import Text File Data window
This window is a powerful text file data importer that is highly configurable.
Caution:  It is strongly advised that a new layer is created PRIOR to using this feature, and that this new layer is designated as the "import layer".   Doing so will allow for trial and error, until you are familiar with this powerful data importer.  Appending this data to a new layer, will allow it to be deleted and redone, until satisfied with the results without jeopardizing existing mapping data.

Input file data

1. Input file data
Displays the actual data as seen in the input file.

Delimiter type

2. Delimiter type
Choose a data field delimiter.  A delimiter differentiates the fields, so that data items are separated.  Often this is a comma, but choices include:
  • TAB
  • |

Import layer

3. Import layer
Select the layer from this dropdown box to import and append this data to.


4. Profile
Up to 10 profiles may be saved for different data file formats.   To save, select a profile, and type in the name you wish to use.  Note that by default, profiles are named "USER DEF X, where X = 1 thru 10.
This profile will be saved on exit.

UPDATE button

5. UPDATE button
When the extracted data records are changed by the user, click this button to refresh the append data display.

Append data display

6. Append data display
Displays the lines which will be appended.

Data Field assignment

7.  Data Field assignment
There are available, up to 9 data fields for data import.
For each field, as separated by the delimiter, you must designate what TYPE of data field it is, so that it may be properly interpreted upon import.
For each field choose from the following in each of the field 1 - 9 drop down boxes:
  •  IGNORE - ignores the field, not imported.
  • X EASTING - X coord <mandatory>
  • Y NORTHING - Y coord <mandatory>
  • Z (TO BM) - Z coord relative to a benchmark <mandatory>
  • LATITUDE - <optional>
  • LONGITUDE - <optional>
  • ALT(TO SL) - this is the elevation as reported by the GPS, generally relative to sea level. <optional>
  • COMMENT - text comment <optional>
  • LAYER NO. - a layer number assignment <optional>
Click RESET to restore all fields to IGNORE.

Extract data range

8. Extract data range
By default, when this window is opened, all data items in the input data are selected for import.  This can be changed however, by editing the values in the above boxes OR by clicking on the records in the input file data (for selecting multiple records, left click on the first record, and SHIFT + left click on the last record you choose).


9. IMPORT DATA button
Click to import the data. The data will be appended to the layer selected. This button will be disabled, until all mandatory data fields are defined.


10. FINISHED button
Click to exit without importing data.  This will save defined profiles.

Culling Data

11. Culling Data
Some programs generate an enourmouse amount of data such as yield monitors or other systems which record data time-based.  To alleviate this "data overload", you may specify how many to data records to skip before reading data for use.  By default, USE SELECTED is checked and will read in all data that was in the selecte RANGE (see step #1).  You may alternately select the number of records to "skip over".  Note however, the FIRST data line, in always read, and when opening a file that is text data, is considered the benchmark.
As can be seen in the above example, no records will be skipped, and we will real 475 data pts in doing so.
By selecting "Skip every 1" record,  we will now read a record, skip a record, and so forth.  We now will have approximately half the data point read, from the original data range.
The actual data that will be read, is always shown in the field assignment window (STEP #2).   Whenever "CULLING" is updated, so will this window.
You are free to enter how many points to skip.  Some trial and error may be needed to get the best results.  A text file may be re-opened and re-read many times, simply discarding previous data.  Once you are satisfied with the results, use FILE > SAVE or SAVE AS, to create a TileLogic Office TIA file, which may then be edited as if generated by TileLogic.