Export a Database to other File Formats

Use the Database > Export > CSV etc. menu option (EXPGEN GX)  to export data to several formats. Either displayed data channels or all data channels may be exported, and the displayed line, selected lines or all lines may be exported. If the output file(s) already exist, they will be overwritten.

To export data to a supported file format:

  1. On the Database menu, select Export and then select CSV etc.. The Export CSV etc. dialog will be displayed.

  2. Using the Format drop-down list, select the export format as one of the options bellow:

    • CSV (Excel)
    • ODDF (USGS)
    • POST PC (USGS)
    • POST UNIX (USGS)

  3. In the Data file name field, specify the name of the data file.

  4. Select an option from the drop-down lists: Channels to save, Lines/Groups to save, Include dummies, Include channels names, and Include line names as data.

  5. Click OK and the data is exported to your selected file format.

Export to CSV etc. dialog options

Format

Specify the format of the file to be exported. Currently supported formats are:

  • CSV (Excel)

  • ODDF (USGS)

  • POST PC (USGS)

  • POST UNIX (USGS)

Script Parameter: EXPASEG.FORMAT

Data file name

Specify the file that will contain the exported data, one record per line.

Script Parameter: EXPASEG.FILE

Channels to save

Select one of the available options:

  • Displayed channels
  • All database channels
  • Select channels from list

Script Parameter: EXPASEG.CHAN ("D", "A" or "L"). For the "List" method, store the list of channels in the EXPGEN.SELECTED value, as comma-separated values.

Lines/Groups to save

Select one of the available options:

  • Displayed line
  • Selected lines
  • All lines

Script Parameter: EXPASEG.LINE

Include dummies?

Include dummies? "Yes" (default), or "No".

Script Parameter: EXPCSV.DUMMIES

Include channel names?

Include channel names? "Yes" (default), or "No".

Script Parameter: EXPCSV.COMMENT

Include line names as data?

If "Yes", the line names will be included as the first "column" of data.

Script Parameter: EXPCSV.LINENAMES

Application Notes

An important capability is the ability to export to Excel-style comma separated value (CSV) ASCII files. This time-saving feature enables you to quickly export your processed data from Oasis montaj and perform specialized analysis or processing in Excel as required.

Note that if channel names are included, they will appear as a comma delimited list in the first line of the CSV file.

If both groups and lines are present in a database, the behaviour is more complicated, because groups tend to have individual channel lists.

  • The "Displayed Line" option: this works for a single group or line, and only the displayed group or line is exported.
  • The "Selected Lines" option: if there are both lines and groups selected, only the lines will be output. If there are only groups selected, then all groups with the same group class as the first group will be exported.
  • The "All Lines" option: if there are both lines and groups present, only the lines will be output. If there are only groups present, then all groups with the same group class as the first group will be exported.

To export to a CSV file:

  1. Make sure the database you wish to export is open in your project.

  2. Select the Database > Export > CSV etc. menu item.

  3. Specify CSV as your export format.

  4. Specify an output file name.

  5. Select whether you wish to export all the channels, only those displayed, or channels selected using the selection tool.

  6. Select whether to export all lines, the selected lines, or the current (displayed) line.

  7. Indicate whether you want to export placeholder (dummy) values and channel names.

  8. Click OK. The system exports the data to the designated file.