Skip to content

Fill shipment from CSV

ispyb edited this page Feb 26, 2018 · 25 revisions

Import shipment from CSV data file

EXI allows to fill in a shipment uploading a CSV file. Such file should contain information about the sample, container, parcel and diffraction plan. Some parameters are mandatory and others will be optional.

What is a CSV file?

A CSV file is a plain text format mainly used to store tabular data. CSV means Comma-Separated Values then each value is separated with a comma. Example:

myParcelName,myContainer,Unipuck,1,5HT3,sample1,barcode,Default,P1,90,90,90,0,0,0,beam,1,111,11,1,P121,smiles,comments

This line describes a sample located in a parcel called 'myParcelName' that contains one container called 'myContainer' which type is Unipuck.

If a column has no value then it is left empty. Example:

myParcelName,myContainer,Unipuck,1,5HT3,sample1,,,,,,,,,,,,,,,,,

Why a CSV file and not a Excel file?

CSV is a stardard format capable to be read for all different operating systems and it does not depend on any program.

Supported format

Value Description Example
pacelName mandatory identifier of the parcel
containerName mandatory identifier of the container
type mandatory Controlled list: Unipuck, Spinepuck
position mandatory sample position within the container
protein acronym mandatory Acronym of the protein. It should exist in ISPyB. It is case sensitive.
sample acronym mandatory Name of the sample that should be unique within the shipment
Pin Barcode optional

Clone this wiki locally