To export sample information from eLabJournal, you can export it as a PDF. Open the sample information sheet of the sample you want to export and click on the PDF button.




To export multiple samples, you create an export file to Excel. Navigate to Advanced Search in the Inventory and specify your search criteria. If you do not specify any search criteria, you can export a list of your entire sample database to keep that as a local back-up.





The searched samples are displayed in the search results of the advanced search. Click on Export to create a tab-delimited CSV file that can be opened with or imported in Excel.





You can open the CSV file directly in Excel, but depending on the settings in your Excel installation the data may not automatically separate into columns. If that is the case, save the file first to your computer and import the file into Excel. Open Excel and choose in the Data tab the import from text option






Browse to the saved sample export file and select it. A 3-step wizard in Excel will help you to import the samples in Excel. Choose in the first step the following settings:


  • Delimited – data in the export file are separated by tabs and placed between quotes (“)
  • UTF-8 encoding – if your sample contains special characters, make sure set the character set to UTF-8 to keep them in the export file.





In the next step, you can define how to separate the data and which text indicator to choose. Choose the option Tab and (double quote). In the preview window, the data should be separated correctly in different columns.



In the last step, you can define the data type should for each column. The default setting is standard. You can scroll through all columns to see if the preview of the data is accordingly. For most columns, the standard-setting is works alright. Only when there are punctuations (such as: ' or, or ") used that could be interpreted by a spreadsheet program as a separator these columns should be changed from General to Text. For columns that contain a date or date and time, make sure to change these columns to a date and select the date desired formatting.




Click Finish to complete export to Excel.


The first columns are the default columns in eLabJournal after the default columns are the user created columns


Excel column name

Description 

SampleID

Unique number to identify samples

Barcode

Sample Barcode

Sample Type

Sample Type

Sample Name

Sample Name

Description

Sample Description

Notes 

Sample Notes

Quantity

Quantity 

Expiration date

Expiration Date

Storage Date

Date the sample is stored in eLabJournal

Storage Location

Storage location in text

Compartment Name

Compartment name

Position

Position as defined for compartment (A1 or 1)

StorageLayerID

Unique storage compartment ID

eLABPosition

Shows information as is stored in eLabJournal database (e.g A1 = 1)

Group

Shows the eLab group where the sample is in

User

Current sample owner

User (email)

Shows the current users email address

Created By

User that originally stored the sample

Parent

Parent sample 

Parent SampleID

Sample ID from the parent sample

SeriesID

In case a sample is part of a series it shows the seriesID

Series Name

In case a sample is part of a series it shows the Sample Series Name