User Documentation

  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. TSV Batch Update Objects

 

 

XLS 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 Import Compatible= YES; Selected Columns; All pages/Current page/Selected rows (depending on what you want to export).

 

5. Modify the file you just exported and save it.

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

 

6. Upload the file you saved before and click Accept. Your entries will be updated.

 

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 or a parent/child connection from openBIS one needs to enter      into the corresponding cell in the XLS file.

 

TSV Batch Update Objects

 

  1. Navigate to the relevant collection (e.g. Raw Samples).

2. Select TSV Batch Update Objects from the More… dropdown.

 

 

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

 

4. Download the available template

5. Fill in the identifiers of the objects you want to update (identifiers are unique in openBIS. This is how openBIS knows what to update). You can copy the identifiers from the identifier column in the table and paste them in the file. Identifiers have this format: /MATERIALS/SAMPLES/SAMPLE1.

6. Fill in the values in the columns you want to update

7. 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 enter  or _ _DELETE_ _ into the corresponding cell in the file.