How to import data into Orca Scan
You can import your asset or inventory data into Orca Scan using a Microsoft Excel
.xlsx file. Your data must be in the first sheet and include a Barcode column that contains a unique barcode for each row.
When a barcode is scanned from the mobile app, it will search your barcode column for a match, if it finds one the row data will be returned to the device.
How to import data
1. Create an Excel file containing your data
At present you can only import .xlsx files - the default Microsoft Excel format.
2. Include a Barcode column
Ensure your sheet contains a barcode column so the system knows which columns to search through for a match.
3. Keep the file clean
Your Excel file should not contain any irrelevant information such as logos or merged cells. Ideally, it should resemble the example below:
When I import a file, it clears away all the formatting on the fields?
Yes. The system doesn't yet recognize the structure of an imported file to match them so it will overwrite the existing content in the sheet and clear the history log.
Import error: "Failed to fetch"
Try reloading the browser and import the file again.
Import error: "Your spreadsheet must include a barcode column"
You need to add a column to the filed with the name "Barcode". You can always change this once the file is imported.
Questions about importing files?
We're always happy to help, chat with us live or drop us an email.