Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. Login to the computer using the login information on top of the computer keyboard.
  2. First, turn on the instrument. To do this press the button on top of the device screen and hold it for a few seconds (Figure 1).

Image Modified

Figure 1. Bruker pXRF Handheld instrument


         3. Click on Bruker RemoteCtrl in the computer screen (Figure 2). You will use this program to control the device from the computer while measuring your samples. 

Image Modified

Figure 2. Bruker Remote Ctrl program

...

4. Go to File Connect. A window will appear that will show the device number Ex.  900G7838. Select it  and click Ok (Figure 3).

Image Modified

Figure 3. Connecting the device to the computer.

...

Figure 6. pXRF initial screen. Left: X-ray is not active. Right: X-ray is active

Exporting Data

  1. Click on  Image Modified in the bottom left of the main screen. After you click on Utilities the following window will appear on the screen (Figure 7). 

Image Modified

Figure 7. Utilities Window.

...

Data File Destination Location: \ARCHIVE\Data\Backup-dd-mm-yyyy

Image Modified

Figure 8. Backup Data.

 

5. After you have selected the file destination folder click on 

...

After you backup the data go to Bruker Instrument Tools icon in the computer's initial window (Figure 9).

Image Modified

Figure 9. Bruker Instrument Tools program

 

Image Modified

Figure 10. Connect the device to Bruker Instrument Tools.


  1. Go to Device Image Modified Connect Image Modified  Select 900G7838 Image Modified  and click Connect (Figure 10 & Figure 11).

Image Modified

Figure 11. Connect window.

...

11. Save the file to Uservol  K_Inorganic_Geochemistry  pXRF 393 Raw Data (Figure 20) for Exp 393.



LIMS Component Table


PLACEHOLDER until the new PXRF components and data structure is defined
ANALYSISTABLENAMEABOUT TEXT
PXRFSAMPLEExpExp: expedition number
PXRFSAMPLESiteSite: site number
PXRFSAMPLEHoleHole: hole number
PXRFSAMPLECoreCore: core number
PXRFSAMPLETypeType: type indicates the coring tool used to recover the core (typical types are F, H, R, X).
PXRFSAMPLESectSect: section number
PXRFSAMPLEA/WA/W: archive (A) or working (W) section half.
PXRFSAMPLEtext_idText_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
PXRFSAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
PXRFSAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
PXRFSAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
PXRFSAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
PXRFSAMPLEx_projectProject: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises
PXRFSAMPLEx_capt_locCaptured location: "captured location," this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2
PXRFSAMPLElocationLocation: location that sample was taken; this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2
PXRFSAMPLEx_sampling_toolSampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
PXRFSAMPLEchanged_byChanged by: username of account used to make a change to a sample record
PXRFSAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
PXRFSAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
PXRFSAMPLEx_offsetOffset (m): top offset of sample from top of parent sample, expressed in meters.
PXRFSAMPLEx_offset_cmOffset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
PXRFSAMPLEx_bottom_offset_cmBottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
PXRFSAMPLEx_diameterDiameter (cm): diameter of sample, usually applied only to CORE, SECT, SHLF, and WRND samples; however this field is null on both Exp. 390 and 393, so it is no longer populated by Sample Master
PXRFSAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
PXRFSAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
PXRFSAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
PXRFSAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
PXRFSAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
PXRFSAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
PXRFSAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
PXRFSAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
PXRFSAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
PXRFSAMPLElogin_dateLogin date: creation date of the sample
PXRFSAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
PXRFTESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
PXRFTESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
PXRFTESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
PXRFTESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
PXRFTESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
PXRFTESTtest instrumentTEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
PXRFTESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
PXRFTESTtest x_projectTEST project: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises
PXRFTESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
PXRFTESTTop depth CSF-A (m)Top depth CSF-A (m): position of observation expressed relative to the top of the hole.
PXRFTESTBottom depth CSF-A (m)Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole.
PXRFTESTTop depth CSF-B (m)Top depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
PXRFTESTBottom depth CSF-B (m)Bottom depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
PXRFRESULTdatetimeRESULT datetime: date/time stamp for each run
PXRFRESULTmodeRESULT mode: the calibration selected for the run (e.g., Geochem, Mudrock)
PXRFRESULTrun_numberRESULT run number: serial number of the run (incremented by the instrument for each sample)
PXRFSAMPLEsample_nameSAMPLE sample name: repeated display of the sample label ID from the SAMPLE table
PXRFRESULTreadingRESULT reading number: human-input run number for each sample
PXRFRESULTrun_spm_asman_idRESULT spectrum file ASMAN_ID: serial number of the ASMAN link for the spectral raw data (.SPM) file
PXRFRESULTrun_spm_filenameRESULT spectrum filename: file name for the spectral raw data (.SPM) file
PXRFRESULTrun_main_asman_idRESULT main report ASMAN_ID: serial number of the ASMAN link for the reduced data table (.CSV) file
PXRFRESULTrun_main_filenameRESULT main report filename: file name for the reduced data table (.CSV) file
PXRFRESULToffset (cm)RESULT offset (cm): position of the observation made, measured relative to the top of a section half.
PXRFRESULTresult commentsRESULT comment: contents of a result parameter with name = "comment," usually shown on reports as "Result comments"


ARCHIVE


LN-BrukerpXRFHandheld-270922-1259-68.pdf - September 27, 2022