Importing sample information list as a CSV file
EXI allows to provide information about the samples in a shipment uploading one or more CSV files. This document contains information about the format and contents of the 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:
Dewar1,MX001,Unipuck,1,HEWL,xtal101,,P43212,77.4,77.4,37.2,90,90,90,,,,,,,,,Lysozyme test crystal
This line describes a Hen Egg White Lysozyme crystal, located in the position 1 of a Unipuck labeled ‘MX001’ included in a parcel called ‘Dewar1’. Optional or unused columns can be left empty, although the separating commas must be present.
Using a file like this makes it easier to edit, update or correct the sample information; the CSV file also acts as a backup. The advantage of using a CSV file and not a Excel file is that CSV is a standard format that can be handled in all different operating systems and it does not depend on any program.
Note: All the fields in the CSV file are case-sensitive
|Parcel (compulsory)||Identifier of the parcel. If it does not exist, it will be created automatically||Dewar1|
|Container name (compulsory)||It must match the value engraved in the puck||MX001|
|Container type (compulsory)||Only Unipucks are accepted at MAX IV||Unipuck|
|Container position (compulsory)||Sample position in the container||1|
|Protein acronym (compulsory)||Case sensitive. Must have been saved previously to the sample database||HEWL|
|Crystal name (compulsory)||Name of the sample. Must be unique for the protein||xtal101|
|Pin barcode (not used)||For the user's records|
|Space Group (optional)||If present, used for strategy calculation. If given, the unit cell parameters must be provided too autoprocessing.||P43212|
|a, b, c, alpha, beta, gamma (optional)||Enter each unit cell parameter in a separate column||77.4,77.4,37.2,90,90,90|
|Experimental parameters in columns 15-27 (not used)|
|Comment (not used)||For the user's records||Lysozyme test crystal|
See also an example file.