Quick import

The Quick data import allows you to easily get your data into MOLGENIS, without the need of understanding the EMX format. There are some assumptions we make with regards file types and file contents.

1. The supported file types are CSV, XLS, XLSX, and a ZIP file containing CSV files
2. A file consists of a at least two lines, the first is the header, the rest is data

3. We always expect the first line to be the header

4. Empty files can not be imported

5. Files containing only a header can not be uploaded

Metadata guessing

The quick data import tries to guess what type your data is. MOLGENIS supports multiple data types like booleans, date fields, numbers etc.

1. To get INTEGERS, use values like 1, 30, 2012, etc...
2. To get LONG, use values like 128938972487837384
3. To get DECIMAL, use values like 2.3, 2901.3, or 123.8
4. To get DATE, submit strings in the format of dd/mm/yyyy
5. To get BOOLEAN, submit strings in the format TRUE or FALSE
6. Other values are inserted into the database as STRING. If a piece of text is longer then 255 characters, we use TEXT

Data placement

Data is imported into the MOLGENIS database as a single data table Data tables are grouped within packages

1. In the case of an excel, the file name is used as the package name and the workbook sheet is used as the data table name.
2. In the case of a CSV, the file is used as the package and the data table name.
3. In the case of a ZIP file, the name of the ZIP file is used as the package name, and the names of the files inside the ZIP are used as the names for the data tables

How to use

1. Click upload file
2. Select a file
3. Wait...
4. Done!

There are two types of links:

1. The file name will send you to the MOLGENIS navigator. Here you can view all packages, and the corresponding data tables.
2. The nested links (sheet names for Excel, file names for CSV) will take you to the data explorer. Here you can view, filter, query, download, and share your data