You can add each item to the inventory individually or you can import an existing database of inventory items (samples, reagents, lab equipment, etc.) as a .csv, .txt, .tsv or .xlsx file.
This can be done by all team members except those that have the Guest role.
To manually add an individual item, simply click New item above the sample inventory (see the screenshot below), name it, and click Save.
If you wish to import a file of existing items, please, follow the next steps:
- Create the same number of columns in SciNote that you wish to import from your file (please click here to see how to do this)
- Click on Edit inventory
- Select Import items as shown on the screenshot below.
- A pop-up will ask you to upload a file (see the screenshot below). You can upload a .csv, .txt, .tsv or .xlsx file. Select a file and then click Upload.
Match the columns of your uploaded file to the columns in SciNote (see the picture below) and select Import.
Please note: if you wish to import a date into SciNote, the date format needs to be the same in both SciNote and in Excel. In the latter, the cell type should be 'Text'.
There are 5 pre-set inventory columns in SciNote: Assigned, ID, Name, Added on, and Added by. The names of these columns cannot be changed. When you are linking columns from your file to columns in SciNote, you are only going to be able to link the Name column out of these five.
It possible to upload 2000 items at once from a file, so if you have a very large database of items you would like to upload, please split it into parts accordingly.
There is also a limitation to drop-down options you can have within a column. The limit is 500. If you have more than 500 options within a drop-down list (please see the screenshot below), some of them will not show.