Update compounds

    Since version 24.3.0 it is possible to bulk update (add, overwrite, delete) additional data of registered compounds by uploading a CSV file or you can paste as text. You can define the CSV delimiter in the Upload options.

    This operation can be performed only if the user has the appropriate role for it. For more info please check the Groups and roles - Bulk update.

    images/download/attachments/9241676/bulk_update_sheet.png
    Bulk update sheet
    • Column headers must correspond to the configured fields in the registration system.
    • Only IDs and additional data values should be included in the uploaded file.
    • Parent, version, and lot identifiers can be present in the uploaded file.
    • Deleting additional data values requires a file that specifies the values to be deleted.

    {info} In the case of “Overwrite value” please add a valid not empty value. For delete please use the “Delete value" option.

    {info} Bulk updates of multi-value fields are not yet supported.

    {info} Bulk updates of collections are not yet supported.

    Example file

    pcn,cn,ln,lnbref,comment
    CXN1,,,,parent comment
    ,CXN1A,,,version comment
    ,,CXN1-001,,lot comment identified by LN
    ,,,A1234,lot comment identified by LnbRef
    images/download/attachments/9241676/update_items.png
    Bulk update records

    After the file has been selected, the user is allowed to navigate with the aid of arrows between the first records, while the accompanying data fields are displayed.

    The update process can be started with the help of the Upload and Update button.

    At the end of the process the Update summary page is visible.