Uploaded image for project: 'LIMS'
  1. LIMS
  2. LIMS-2042

Instrument. Improving Horiba ICP to avoid Element Symbols as keywords

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Edit, clarity.

      Use Case

      The lab has 2 inestruments, ICP and XRF, that deliver results per analyte using their Periodic Table abbreviotion, e.g. Au for Gold and Bika uses these to match the results to Analyses using their corresponding Analysis Service's keyword. Au by XRF or ICP are different ASs though, And the instruments difficult to reconfigure ans it is a recurring issue in geochemistry.

      To get pass it at this lab on the Horiba ICP we can use the full LineName from the file, e.g. Ca 315.887 but strip the space and . out of it, as keywords do not allow special character in the LIMS. 315.887 refers to the wavelength in nm of the Ca's spectral analysis.

      • e.g. read Ca 315.887 in the file and look up Ca315887 in the system, Mg 279.806 for Mg279806 etc. The element abbreviation and wavelength combination is pretty unique the lab ensures me and when they set up for different lines, they can edit the keywords in Bika

      We can reconsider the deluxe solution at LIMS-1988 later

        Issue Links

          Activity

          Hide
          rockfruit Campbell added a comment -

          https://jira.bikalabs.com/browse/LIMS-1805 says that the "Result" column is column F. This is the column with the RSD label, which is also called ResidualError in the system. Is this correct? This is what I have done.

          Show
          rockfruit Campbell added a comment - https://jira.bikalabs.com/browse/LIMS-1805 says that the "Result" column is column F. This is the column with the RSD label, which is also called ResidualError in the system. Is this correct? This is what I have done.
          Hide
          lemoene lemoene added a comment - - edited

          does not sound right, C looks like the best candidate. checking up

          edit column C! not J

          Show
          lemoene lemoene added a comment - - edited does not sound right, C looks like the best candidate. checking up edit column C! not J
          Hide
          lemoene lemoene added a comment -

          F... due to inserted coumns appears under RSD

          Show
          lemoene lemoene added a comment - F... due to inserted coumns appears under RSD
          Hide
          lemoene lemoene added a comment -

          still reads blanks. uploading CSV corresponding to https://metrontest.bikalabs.com/worksheets/WS15-028

          Show
          lemoene lemoene added a comment - still reads blanks. uploading CSV corresponding to https://metrontest.bikalabs.com/worksheets/WS15-028
          Hide
          lemoene lemoene added a comment -

          Works like a bought one!

          Show
          lemoene lemoene added a comment - Works like a bought one!

            People

            • Assignee:
              rockfruit Campbell
              Reporter:
              lemoene lemoene
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h

                  Agile