Before attempting to import an inventory, you will need to make sure your Excel is appropriately formatted.
Each worksheet of the Excel file will correspond to a category in the Labfolder MDB. Therefore, you should set up a ‘destination category’ where all items will be inserted.
Navigate to Manage > Material Database.
Add a new category via the button in the left-hand panel.
Name the category.
Insert attributes according to the column header of the Excel file you’d like to import.
Press save and continue by uploading your inventory.
When assigning the MDB category attributes, text allows for all types of characters, whereas numbers only accept numeric values (no hyphens or units allowed) and date field will be described as DD.MM.YYYY.