1. Home
  2. Docs
  3. User Documentation
  4. Inventory of Materials and Methods
  5. Batch update entries in a Collection

Batch update entries in a Collection

 

It is possible to modify the values of one or more fields in several objects simultaneously via batch update. This can be done in two ways:

 

  1. XLS Batch Update Objects
  2. Batch Update Objects

 

 

XLS Batch Update Objects

 

  1. Navigate to the relevant collection (e.g. Raw Samples).
  2. Select XLS Batch Update Objects from the More.. dropdown
  3. Download the template file
  4. Fill in the identifiers of the objects you want to update (identifiers are unique in openBIS. This is how openBIS knows what to update).
  5. Fill in the values in the columns you want to update
  6. Save the file and upload it via the XLS Batch Update Objects from the More.. dropdown

 

Note

If a column is removed from the file or a cell in a column is left empty the corresponding values of updated samples will be preserved.

To delete a value/connection from openBIS one needs to put –DELETE– or __DELETE__ into the corresponding cell in the file.

 

 

Batch Update Objects

 

  1. Navigate to the relevant collection (e.g. Raw Samples).
  2. In the Collection table, from the Columns, select Identifier and the field(s) you want to update (e.g. Source), as shown below.

 

 

3. If you have several entries you can filter the table (see Tables)

4. Export the table choosing the options Visible Columns, all pages/current page, Rich Text.

DO NOT export the table in plain text for batch update, otherwise all text formatting will be lost on update!

 

 

5. Fill in or modify the fields to update in the exported file.

6. Select Batch Update Objects from the More… dropdown.

 

 

7. Select the relevant Object type, e.g. Sample 

 

8. Upload the file exported and modified before and click Accept.

 

Note:

If a column is removed from the file or a cell in a column is left empty the corresponding values of updated samples will be preserved.

To delete a value/connection from openBIS one needs to put –DELETE– or __DELETE__ into the corresponding cell in the file.