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. The value set there is valid for the bulk update file.


Upload options	CSV - field delimiter

The bulk update 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.


Bulk update sheet

The following bulk update actions are available:

Update compounds

Add value

You can use this function to add a value to additional data fields.

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.

{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


Bulk update process - 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.

Example file

Ln,Field1,Field2,Field3
CXN62-001,Value1,Value2,Value3


Before 'Add value'	After 'Add value'

It is also possible to add values to multi-line fields with line breaks. For this purpose please use quotation marks.

Example file

lnbref,comment
A1,"multi

line

comment"

If you need a quoted line in the multi-line field with line breaks please use double quotation marks.

Example file

lnbref,comment
A1,"multi

""quoted line""

comment"

Overwrite value

You can use this function to replace an existing additional data.

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.

{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


Bulk update process - 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.

Example file

Ln,Field1,Field2,Field3
CXN62-001,Test1,Test2,Test3


Before 'Overwrite value'	After 'Overwrite value'

It is also possible to overwrite values in multi-line fields with line breaks. For this purpose please use quotation marks.

Example file

lnbref,comment
A1,"multi

line

comment"

If you need a quoted line in the multi-line field with line breaks please use double quotation marks.

Example file

lnbref,comment
A1,"multi

""quoted line""

comment"

Delete value

You can use this function to delete an existing additional data.

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} 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


Bulk update process - 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.

Example file

Ln,Field1,Field2,Field3
CXN62-001,Test1,Test2,Test3


Before 'Delete value'	After 'Delete value'

It is also possible to delete values from multi-line fields with line breaks. For this purpose please use quotation marks.

Example file

lnbref,comment
A1,"multi

line

comment"

If you need a quoted line in the multi-line field with line breaks please use double quotation marks.

Example file

lnbref,comment
A1,"multi

""quoted line""

comment"