Import new items to Quartzy as well as edit existing items via Excel using the Quartzy Import Template. Just make sure to follow all the instructions.
If you received an error message and not all of your items were imported, download the error report and complete the following steps:
1. Make changes directly on the report
2. Save your changes
3. Import the newly saved error report back to Quartzy
Important: Download the error spreadsheet in Step 1 right away and do not navigate away from the page.
Here are some common errors and how to fix them! Make your corrections directly on the Error Spreadsheet and import that to Quartzy.
1. * Invalid item name
You must enter a title/description for each item in the Item Name column.
2.* [Field Name] is not a valid date (mm/dd/yyyy)
The recommended format for all dates is MM/DD/YYYY.
3. * You cannot assign an item to a sub-location without first assigning it to a location
This also applies to having information in the Location Details field without having the Sub-Location or Location information filled in. These 3 fields must be filled in order.
Location (-80 freezer) > Sub-Location (John's Antibody box) > Location Details (A1, A2, A3)
4. * [Field name] is required.
An admin in your lab has marked an inventory field as required, but the importer didn't find any data in that field for that item. The field name (column header) will display an asterisk (*) to indicate this is a required field. If the required field doesn't apply to that particular item, you can use a placeholder such as N/A.
5. * [Field Name] is not a number.
Similar to date fields which must have information in date format, fields that are set to the number format must have only numbers in them.
6. * [Name] is not a member of [Lab Name]. Please check that the name is spelled correctly.
You can change the owner of an inventory item when uploading an edited inventory spreadsheet, however, the name you enter must be the exact name of a person in your lab. We recommend copying and pasting the name from the Lab Members page to ensure it is the same.
7. * Couldn't locate [Serial Number].
You changed the Serial Number field when editing your inventory in Excel and since that is the field we use to upload your changes to Quartzy, we cannot find the item to save those changes. Do not edit the Serial Number field. If you use your own serial numbers in your lab, create a custom field.
8. * You don’t have permission to edit this item.
Items you are not allowed to edit will appear in the exported inventory spreadsheet in grey. You do not have permission to edit those items so changes you have made to that item will not be saved.
Tip: If you receive a generic 'Import Failed' message at the bottom of your screen instead of an error report, please send the file you attempted to import to email@example.com and our team will help you troubleshoot!