Importing a List

Open or download the sample spreadsheet. Do not overwrite row 1.
Start entering list details on row 2 with a listcode. This can be a short version of the list name.
Enter a meaningful list name.
Leave listentrycode blank unless you are linking to a 3rd party system and need to match up list items.
Enter the list item itself. This is the text that the device user will select from a drop-down list, multiple-choice field, etc.
You may wish to copy and paste this from an existing spreadsheet or csv file created by a 3rd party system (eg product list).
Repeat step 5 (and step 4 if used) for all list items in the list entered in step 3.
Repeat steps 2 to 6 for each list. Save.
Log in to magic5.
Select Lists from Setup/Maintenance menu (or Setup/Maintenance->Settings menu).
Click on the Import from spreadsheet button at the bottom of the list of lists.
Click on Add attachment in the dialogue box that has opened.
Click the Select button to open the file selection dialogue box.
Select the required file from your computer in the usual way.
Click the Open button and the filename should appear in the box.
Click Save to save the file.
Click Save to import the lists into magic5. Your list(s) are now ready to use.