To Import Assay Data

  1. On the Geochem Import menu, select the Import Assays item. The system displays the Import ASSAY Data dialog box.

  2. Select the data source. To select the file to be imported, click the Browse button and select the import file. Note that, if you leave the import template blank, the default template (_chassay.i3) will be created in your project directory.

  3. Select the Lab ID and Assay method parameters from the drop-down lists.

  4. To add new Lab ID and Assay method items, type the new information in the appropriate box, and the drop-down list will be automatically updated. To manage the list by adding or deleting items, click the Lab IDs or Assays buttons to display the appropriate dialog. User defined pick lists are stored in the %USERPROFILE%\Documents\Geosoft\Desktop Applications \etc folder. For more information, click the Help button on the dialog.
  5. Specify the weight of your samples, and then using the Browse button, you can locate a channel attribute file (CSV). For more information, see Setting ASSAY Attributes.

  6. Select Yes or No, from the Convert negatives? drop-down list. (No, the default value imports the data as is, if Yes is selected then if the detection limit is set for the channel, any value less than the detection limit (including those less than 0.0) is replaced with a value equal to one-half the detection limit.

  7. Click the Next button. The system displays the Create New Database dialog.

  8. Specify a file name for the import database. Note that the default database file name is derived from the input file name.

  9. Click the OK button. The new database is displayed in the background of your project, and the Geochemistry Import Wizard dialog box is displayed in the foreground.

  10. This dialog box is used to specify how the data in the file is formatted. Select the file type.

  11. In the middle section, specify which line in the file contains the data headings, which line contains the data units, at which line to begin importing data, and the number of lines to display in the preview window.

  12. Click the Next button. The system displays the second Import Wizard dialog box. Select the type of character or white space used to separate the column text. The system draws lines in the preview window to show where data columns end.

  13. Click the Next button. The system displays the third Import Wizard dialog box. This dialog box has Channel type, parameters and a preview window area.

  14. The Import Wizard scans your data to determine the type of data with which you are working (i.e. Channel Type). It is a good idea to review your data to ensure that the wizard selected the correct channel types.

  15. The Parameters box displays the name, type of data, and the data format of the column highlighted in the preview window. To edit the channel parameters, select the channel in the preview window and specify the parameters in the appropriate fields. The message below the preview window indicates how many channels remain unspecified. Each channel must have a name to continue the import process. The import routine will replace negative values (assumed to be the lower detection limit) with a positive value at half the lower detection limit (or negative value).

  16. When you are finished naming the channels, click the Finish button. The data will be imported into the assay database and a spreadsheet window is displayed, indicating that the import process is finished.