Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Could be better
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      As first customisation, to make it work as is with the rest of Bika, is to simply add a Batch ID cell in the spreadsheet, where the user must enter the ID of a manually created Batch/WO in which the ARs must be created. That way we do not have to build auto batch create machinery and expect many more attributes in the spreadsheet.

      Addressing big numbers of Analyses per AR remains probably bets addressed by using Profiles

      1. BikaARImportTemplate.csv
        2 kB
        Campbell
      2. BikaARImportTemplate.ods
        83 kB
        Campbell
      3. BikaARImportTemplateB15008.csv
        2 kB
        lemoene
      4. BikaARImportTemplateB15008.ods
        87 kB
        lemoene
      5. BikaARImportToBatchTemplate_02.ods
        84 kB
        lemoene
      6. BikaARImportToBatchTemplate_02.xlsx
        30 kB
        lemoene
      7. BikaProfileImportToBatchTemplate_02.ods
        77 kB
        lemoene
      8. BikaProfileImportToBatchTemplate_02.xlsx
        19 kB
        lemoene
      9. FileLoadExcelError.tiff
        19 kB
        Russell Dills
      10. metrontest-1004.csv
        2 kB
        lemoene
      11. metrontest-1004.ods
        58 kB
        lemoene
      12. metrontest-valid-1.csv
        2 kB
        lemoene
      13. SamplingDateValidationError.tiff
        54 kB
        Russell Dills
      1. capture-for-jira-screenshot-20151004-192844-341.png
        87 kB
      2. capture-for-jira-screenshot-20151014-214819-795.png
        125 kB
      3. capture-for-jira-screenshot-20151014-214937-563.png
        113 kB
      4. capture-for-jira-screenshot-20151014-215002-105.png
        113 kB
      5. capture-for-jira-screenshot-20151014-215052-955.png
        135 kB
      6. jira-capture-screenshot-20150615-085828-553.png
        129 kB

        Activity

        Hide
        rockfruit Campbell added a comment -

        The format has changed in slight, but significant ways:

        1) there is no import/export specifier cell
        2) Profiles and Services can be freely mixed and added.
        3) Batch-headers are matched directly against the fieldnames of batch schema
        4) some header-field names have changed, which caused this latest key-error

        Sorry for not uploading these when resolving this issue earlier.

        Show
        rockfruit Campbell added a comment - The format has changed in slight, but significant ways: 1) there is no import/export specifier cell 2) Profiles and Services can be freely mixed and added. 3) Batch-headers are matched directly against the fieldnames of batch schema 4) some header-field names have changed, which caused this latest key-error Sorry for not uploading these when resolving this issue earlier.
        Hide
        rockfruit Campbell added a comment -

        "BikaARImportTemplate.csv" and "BikaARImportTemplate.ods" are also included in the tests folder of the bika.lims source repository.

        Show
        rockfruit Campbell added a comment - "BikaARImportTemplate.csv" and "BikaARImportTemplate.ods" are also included in the tests folder of the bika.lims source repository.
        Hide
        lemoene lemoene added a comment - - edited

        then again just not

        http://pastie.org/10479360, importing attached BikaARImportTemplateB15008.csv to upload to Batch https://metrontest.bikalabs.com/batches/B15-008/base_edit.

        ....
        Module Products.ZCatalog.Catalog, line 410, in recordify
        Module bika.lims.content.batch, line 240, in getClientTitle
        Module bika.lims.content.batch, line 235, in getClient
        AttributeError: context

        very nice spreadsheets. above populated with Metron data. I miss the lab's Batch ID. Cient Geostratum looks OK though?

        edit: Or does Metron Clients need re-indexing quick quick? Upgrade issue?

        Show
        lemoene lemoene added a comment - - edited then again just not http://pastie.org/10479360 , importing attached BikaARImportTemplateB15008.csv to upload to Batch https://metrontest.bikalabs.com/batches/B15-008/base_edit . .... Module Products.ZCatalog.Catalog, line 410, in recordify Module bika.lims.content.batch, line 240, in getClientTitle Module bika.lims.content.batch, line 235, in getClient AttributeError: context very nice spreadsheets. above populated with Metron data. I miss the lab's Batch ID. Cient Geostratum looks OK though? edit: Or does Metron Clients need re-indexing quick quick? Upgrade issue?
        Hide
        rockfruit Campbell added a comment -

        You can add a 'ClientBatchID' column in the batch-header and batch-values rows.

        Show
        rockfruit Campbell added a comment - You can add a 'ClientBatchID' column in the batch-header and batch-values rows.
        Hide
        lemoene lemoene added a comment -

        Exciting. I am in. I get a site error when I delete the 2 empty rows and save

        https://metrontest.bikalabs.com/clients/client-1/AI15-001/base_edit

        WorkflowException: No workflow provides the '$

        {action_id}

        ' action.

        http://pastie.org/10481871

        will also test with another working file

        Show
        lemoene lemoene added a comment - Exciting. I am in. I get a site error when I delete the 2 empty rows and save https://metrontest.bikalabs.com/clients/client-1/AI15-001/base_edit WorkflowException: No workflow provides the '$ {action_id} ' action. http://pastie.org/10481871 will also test with another working file

          People

          • Assignee:
            rockfruit Campbell
            Reporter:
            lemoene lemoene
          • Votes:
            0 Vote for this issue
            Watchers:
            4 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 - 3 hours
              3h

                Agile