Exporting T-Data to a Text File

RockWorks | Borehole Manager | File |
Export | T-Data | T-Data -> Text File (Single Track w Filtering)

This program will export to a text file the borehole ID, T-data interval depths (top, base, middle), XYZ coordinates for the intervals (top, base, middle), date, and "G" value for the interval, for a selected T-Data track, for selected boreholes. This can be used to verify data stored in the database, or to model the data in another program.

Menu Options
Step-by-Step Summary

Menu Options

• Logs: Expand this heading as necessary to select the boreholes whose T-Data is to be exported.
  • Single Borehole: Click in this radio button to export the data for a single borehole only.
    • Log ID: Click on this item to select from a drop-down list the name of the borehole whose data is to be exported. 
  • All Enabled Boreholes: Click in this radio button if all boreholes that are currently enabled in the Borehole Manager are to be included in the export.
• Track: Click on this item to select the track or column in the T-Data (Time Intervals) tables containing the data values (G values) to be exported to the XYZG file.  Expand this heading to access the data filtering options.
  • Date/Time Filter: Insert a check in this box - on the far right side of the current program window - to export measurements for a specific date or range of dates.  If you leave this un-checked the program will output all of the measurements, for all listed dates. 
    • Exact: Click in this button if you wish to enter a specific date for the measurements to be exported.  Enter into the prompt or choose from the calendar the specific date. 
    • Range: Click in this button if you prefer to enter a beginning and ending date to define the range of dates to be included in the export list. Type the dates into the Start and End prompts or pick dates from the calendar. 
  • Spatial (XYZ) Filtering: Insert a check in this box - also on the far right side of the current program window - to activate a data filter based on where the data points lie. Expand this heading to establish the filter settings. 
  • Filter Based on G-Values: Activate this option to establish a data filter based on the measured values, and expand the heading to establish the filter parameters.  (More.)
  • Resample at Regularly-Spaced Intervals: Check this box to resample the data.  (More.)
    Note: The Resampling option will be automatically disabled if anything other than "All Samples" (below) is selected.
• Items to Include: Use these options to define what T-Data values to export:
  • All Samples: Choose this for all T-Data measurements for the selected track and the selected wells to be exported. 
  • Lowest T-Data Value in Each Borehole:  Only the single, lowest T-Data value for the selected track for each borehole is to be recorded for the selected well(s) in the output file.
  • Highest T-Data Value in Each Borehole:  Only the single, highest T-Data value for the selected track for the selected well(s) will be recorded to the output file.
  • Sum Of All IT-Data Values in Each Borehole:  Output the sum of all values for the selected track for the selected well(s) to the exported file.  For non-vertical boreholes, the xyz coordinates for this point will correspond with the midpoint of the last (lowest) T-Data interval in the borehole.
  • Average T-Data Value for Each Borehole:  The average of all of the values for the selected track forthe selected well(s) will be recorded in the output file.  For non-vertical boreholes, the xyz coordinates for this point will correspond with the midpoint of the last (lowest) T-Data interval in the borehole.
• ASCII (Text) File: Use these settings to define the text file details.
  • Output File: Click on this item to type in a name to assign the exported text file. The usual file name extension is ".txt".
  • Delimiter: Click on the button to the right to choose the character(s) which wil be used to separate the columns in the output file (tab, space, comma, etc.).
  • Include Column Titles: Check this box if the first row in the output file should contain the column titles.
  • View in Editor:  Insert a check here if the above-named file, once created, should be loaded automatically into the RockWorks text editor.
    
    

Step-by-Step Summary

1. Access the RockWorks Borehole Manager program tab.
2. Be sure there is T-Data listed for one or more boreholes.
3. Be sure the boreholes to be processed (if more than one) are shown as Enabled in the borehole listing.
4. Select the File | Export | T-Data | T-Data -> Text File (Single Track w/ Filtering) menu option.
5. Enter the requested menu settings, described above.
6. Click the Process button to continue.

The program will extract the selected data from the database, and record the borehole ID, T-data interval depths (top, base, middle), XYZ coordinates for the intervals (top, base, middle), dates, and "G" value for each interval in the output file. If requested the data will be displayed in the RockWorks editor window. 

See also

• Exporting T-Data to the Utilities Datasheet
• Exporting T-Data to CSV
• Exporting T-Data to Shapefiles
  
  

  Back to Exporting Data 

RockWare home page