How can I identify mandatory columns in my Excel file?

While Labregister allows you to define ‘mandatory fields’ for very important reagent information that should always be filled, this can on occasion lead to error messages when importing Excel lists. 

Note: In your Excel file it is crucial to have the mandatory fields filled with appriopiate data as set in Labregister.   

Please follow the steps below, to identify mandatory columns in your Excel file:

1. In Labregister, identify via Options > Category attributes, the mandatory Attributes (marked with an asterisk) of your Category. 
2. Within the original Excel file, highlight the top row/header of your inventory.
3. Navigate to Data > Filter to enable a filter for each of the selected columns.
4. For the respective mandatory Attribute enable the filter for (Blanks).
5. Fill the mandatory field with appropriate information or remove the mandatory rows.