This guide shows you how to import items into Scorpion using Microsoft Excel.
1- Navigate to the Import page by using the drop down menu in the top left corner then click on Import.
2-Click on the drop down menu and select XLSX
3- Click on the Browse button then navigate to your file, select it and click on the Open button.
Note: Your items in excel should have the following cells from the examples below. Make sure your cells are formatted as Text before importing it into Scorpion. To add custom fields, you can add them after the J column, the heading is case sensitive and needs to match exactly what the custom field says.
You can copy and paste this example into excel:
| Question # | Question Text | A | B | C | D | Objective | Answer | Reference | Reference Location (i.e., Page #) |
| AD.01.02.03 | What is the color of red? | Red | Blue | Green | Purple | OB 01.01 | A | Ref 01 | x |
4- Click on the Upload button.
5- Here you can review what has been imported. If you click on the items you can see what what uploaded and edit the item. Once you are done Click on the Save All button.
Note: If you are uploading custom fields you need to match the custom field with the drop down that appears.
Comments
0 comments
Article is closed for comments.