Smartstaff
2,460
edits
Changes
m
no edit summary
# Navigate to '''Global Settings''' > '''Custom Lookup Options''' and click on the '''Import Custom Lookup Options''' button represented by an import icon.<br />[[File:2021-07-ticket-124709-1.png|thumb|none|300px]]
# You will now access step 1 one of the '''Custom Lookup Options Import''' wizard. Upload a CSV containing your custom data. The first row of the CSV must include column headers. A sample CSV is provided under the '''Settings Explained''' section below.
# Give your custom lookup a descriptive name under '''Lookup Name''' that will help you remember what it is for. For our example, we will call our lookup "UniversityCourseLookup".
# Select one of the columns for the '''Lookup Key'''. The lookup key is a non-unique identifier that is associated with ''one or more'' records in the table. In our example, our lookup key is the "University ID" because this number corresponds to the different universities in our dataset.
# The '''Primary Key''' is optional. A primary key is a unique identifier that corresponds to a ''single'' record in our table. For our example, the primary key is "Course ID" because each row in the table has a uniquely different Course ID that distinguishes it from every other row. Click '''Next''' to continue.
# You will see a warning that notifies you that an existing lookup with the same name already exists. All existing records for that lookup will be deleted and re-imported with the new updated data. Click '''Next''' to continue and click '''Yes''' on the alert pop-up.
# Click '''Next''' to finish the import.
===Viewing Custom Lookup Data===
To view the data of any custom lookup, navigate to '''Global Settings''' > '''Custom Lookup Options''' to see a list of imported lookups. Click the name of the lookup you want to see in more detail. This will allow you to see the uploaded data in a list view format.
[[File:2021-07-ticket-124709-5.png|thumb|none|800px]]
=Configuration - Advanced=