Import Analyses From File

It is possible to import analyses from a Excel, csv, or yaml file into the pychron database.

Excel

To import analyses from an Excel file follow the following file format.

Note

Column order is not important, however, column names must match the following table. In addition the column names should be on the second row.

Example Excel template

analysis_import.xls

Necessary Columns

name	type	example	optional	note
identifier	str	12345
project	str	Foo
sample	str	Bar
material	str	Feldspar
aliquot	int	1
step	int or str	2 or B
analysis_type	str	unknown
mass_spectrometer	str	jan
analysis_time	date	6/7/12
irradiation	str	NM-256	Yes
comment	str	This is a comment	Yes
Ar40	str or float	10.123 or Sheet2		Use sheet name to link to sheet with raw data
Ar40err	str or float
Ar39	str or float
Ar39err	str or float
Ar38	str or float
Ar38err	str or float
Ar37	str or float
Ar37err	str or float
Ar36	str or float
Ar36err	str or float
Ar40bs	str or float
Ar40bserr	str or float
Ar39bs	str or float
Ar39bserr	str or float
Ar38bs	str or float
Ar38bserr	str or float
Ar37bs	str or float
Ar37bserr	str or float
Ar36bs	str or float
Ar36bserr	str or float
Ar40bk	float
Ar40bkerr	float
Ar39bk	float
Ar39bkerr	float
Ar38bk	float
Ar38bkerr	float
Ar37bk	float
Ar37bkerr	float
Ar36bk	float
Ar36bkerr	float
Ar40det	str
Ar39det	str
Ar38det	str
Ar37det	str
Ar36det	str