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:
- XLS Batch Update Objects
- TSV Batch Update Objects
XLS Batch Update Objects
- Navigate to the relevant collection (e.g. Raw Samples).
- 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
- 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.