Import Export Templates - jean/Bika-LIMS GitHub Wiki

File formats and lay-outs used by Bika LIMS

Bulk AR Import from spreadsheet

There are 2 types of AR Import templates, Classic and Profile. In the Classic template, you must indicate which analyses are required for each sample. In the Profile template, you must indicate which profiles are required for each sample

Be sure that the Analysis Service and Profile keywords you use in the CSV to be imported, corresponds to those in the system.

Examples

Using demonstration data:

Annotated ODS Must be saved as CSV before import

Classic Using Analysis Services

Profiles Using Analysis Profiles

Results Import from spreadsheet

Lab's often calculate results in spreadsheets and upload them into Bika via the import facility designed for importing instrument results. If proper version control is applied on the spreadsheet before uploading as attachments to the LIMS, the procedure seems to satisfy ISO 17025 auditors