Plate maps and identifiersIndividual container optionsPartial delivery records
Home / Importing a peptide library inventory CSV

Importing a peptide library inventory CSV

Protect sample IDs and coordinates when transferring a supplier file into a spreadsheet or inventory system.

Agree what one exported row represents

Before a supplier creates the file, specify whether each row represents a physical container, a plate position or a project line. Name the fields for the buyer ID, supplier ID and container identity. RFC 4180 documents a common CSV format, including how quoted fields handle commas. Ask both parties to exchange a short mock file because different spreadsheet programs can still interpret dates, numbers and text identifiers differently.

RFC Editor · RFC 4180, comma-separated files

A gloved hand holds a transparent rectangular plate with a grid of wells.
Transparent multiwell plateThe plate edge and grid give the receiving team a reference for confirming the orientation of a plate map.
Image creditsJeffrey M. Vinocur · Image source · CC BY 2.5 · Converted to WebP.
A workbench holds sample racks, capped vials and preparation equipment.
Laboratory sample stationSeparate racks illustrate why the receiving list needs a unique identifier for each group of containers.
Image creditsGold Standard Analytics LLC · Image source · CC BY-SA 4.0 · Converted to WebP.

Open the mock file as an import

Ask receiving to import identifier columns as text and to state its preferred encoding. Compare the imported rows with the original file while checking leading zeros, punctuation and repeated location values on different plates. Where a human-readable PDF is supplied too, compare its total number of records with the electronic file. Keep the source version unchanged while investigating any differences introduced by the spreadsheet.

Try a supplier name that contains punctuation

Create a mock line with a site name such as “Receiving, West” and a buyer ID such as PL-0031. Ask the supplier to export the line using its normal system. Import it at the receiving end and confirm the site stays in one field. A shifted column can make the following location appear under the wrong heading even though the overall row count remains correct. Resolve this using dummy records before the first delivery.

Worked example

A regional spreadsheet setting may display a date such as 03/04 differently from the sender’s system. Ask both parties to agree an unambiguous date representation and test it on the sample export. Preserve the source file so the original record can be checked.

Prepare your inquiry

Verify both the number of rows and the content of individual identifiers after import.

Select the items you want to ask about.

Certificates of analysis

For a library supplied as dried members, use the supplier lot and member identifier to request the applicable certificate. Confirm coverage for each member or documented group.

Read a COA