Bulk import equipment or warranties from a spreadsheet

The easiest way to bulk import records is to use a spreadsheet saved as a CSV, TXT, or TSV file, which can be created and edited in Excel or Google Sheets.

Uploading from a spreadsheet includes the following processes:

1. Creating the spreadsheet
2. Uploading the spreadsheet
3. Confirming headers
4. Matching spreadsheet headers to Fiix fields
5. Reviewing and fixing any errors

Create a spreadsheet for import

To bulk import records from a spreadsheet, you need to create the file and populate it with data. Fiix allows for some differences between your spreadsheet and Fiix’s data, but your spreadsheet (saved as a CSV, TSV, or TXT file) should include the following fields for equipment and warranties:

Equipment fields

Warranty fields

Upload an import spreadsheet

To upload an import spreadsheet:

1. Navigate to Assets > Equipment.
2. Click the Action (…) button.
3. Click Import equipment or Import warranties depending on what you are importing:
   
4. Click Upload data from file:
   
5. Select your spreadsheet from your device and click Open.

Confirm header rows

To upload your data accurately, the uploader tool needs to know which row of your spreadsheet contains your headers:

• If the arrow is pointing to your header row, click Yes:
  
• If the arrow is not pointing at your header row, click Select another row.
• If there is no header row, click No header row.

Match spreadsheet headers to Fiix fields

Your spreadsheet’s data may differ from the fields in Fiix. Fiix automatically maps (i.e. matches) your spreadsheet headers to the closest data fields, but you need to confirm these mappings before moving on.
To match your headers to the fields in Fiix:

• If the header matches the data field in Fiix, click Confirm mapping:
  
• For headers that do not match, choose the most similar option from the drop-down list, and then click Confirm mapping.
• For headers that you don’t want uploaded to Fiix, click Ignore this column.

Review and fix data

Fiix flags data that might not upload properly before you finish bulk importing. This includes missing fields or duplicated entries for items that have to be unique.

1. Issues are highlighted in red. For more details about each issue, hover your cursor over the red field:
   
2. To fix an issue, edit the data directly in the table.
3. When you’re finished, click Continue.
4. If there are unresolved format issues, a pop-up will confirm that you want to discard these items and submit the rest.
   To discard, click Continue. To fix the data, click Go back.
5. Upon successful import, a pop-up window will show successful completion. Click Ok.
6. Confirm the successful import.