Importing a Cascading List

Open or download the child spreadsheet. Do not overwrite row 1.
Identify the lowest level in your cascading list and enter the first listcode in row 2. 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 lowest level 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.
Open or download the parent spreadsheet. Do not overwrite row 1.
Identify the next level in your cascading list and enter the first listcode in row 2. 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. You may wish to copy and paste this from an existing spreadsheet or csv file created by a 3rd party system (eg product list).
Enter the listcode of the child list created in steps 1-16 that you wish to be shown to the device user when they select this item from the drop-down 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 on this level. Save.
Do steps 8-16 to upload this spreadsheet to magic5.
Repeat steps 17-25 for higher levels in the cascading list.