Data Upload - Data Loaders
When you drop a file on the dropzone, Scifeon will search for a "Data Loader" to process the file.
Scifeon includes a number of standard data loaders that you can use immediately. You can also create custom data loaders using JavaScript.
Excel Files
We have created several standard data loaders that you can use with Excel files. These include a generic data loader that can write data to any table in the database, including your custom tables.
You can use the Demo URL if you have the Scifeon SDK installed and running
| Name | Status | Description | Demo URL |
|---|---|---|---|
| Generic | Ready | Write data to any primary or result entity table in the database | Demo |
| Compounds | Planned | Demo | |
| ProteinVariants | Planned | Upload protein variant definitions including sequence info and other properties | Demo |
| Batches | Planned | Demo | |
| BatchWithRecipe | In Progress | Register a batch with multiple components | Demo |
| ExperimentPlan | Planned | Register an experiment before the lab work | Demo |
| ExperimentTotal | Planned | Register an experiment along with results in one upload | Demo |
| ExperimentResults | Planned | Upload results for an already registeret experiment | Demo |
| ExpInVivoPlan | Planned | Register an in vivo experiment | Demo |
| ExpInVivoResults | Planned | Upload results for an in vivo experiment | Demo |
| ExpInVitroPlan | Planned | Register an in vitro / plate based assay | Demo |
| EnvisionDemo | Planned | Demo of uploading Envision plate reader results | Demo |
You can use various types of Excel files, and the Data Upload Templates has links to download templates for different types of content.
XLSX and XLS Files
Please be aware that Scifeon only reads files of the .xlsx format, not the .xls format. It looks list this in Windows Explorer and in the Excel Save As dialog:
The templates that you download from the Data Upload page are all in .xlsx format. You need Excel 2007 or newer create and edit files in the .xlsx format.
JSON Files
If using JSON, the files must be in the Scifeon JSON format.
CSV Files
We have not yet created any standard data loaders for CSV files - but we plan to do so as soon as customers need them. So please get in touch if you are a Scifeon customer and needs CSV support.