Module 7.1 Flashcards
Understand what data is coming in and where is should be place before what?
Before importing any data
Plan time before an import to verify the data to correct inaccurate data and delete undesired or inaccurate data (t/f)
True
Why is it best to spend time planning and examining data before importing it?
To save time and potential problems later
What are the three ways that the guided application creator provides for creating tables?
Upload spreadsheet
Extend
Scratch
What option do you choose to easily transform an excel spreadsheet into a table?
Upload spreadsheet option
What are the two ways to upload a spreadsheet?
Manually or drag and drop
What requirements does the spreadsheet have to be successfully used?
Must be xlsx with horizontal columns and header labels
After you upload a spreadsheet what must you indicate?
Which rows contain header columns
What is the default row for the header column?
1
When a spreadsheet is uploaded what information is detected and extracted?
The field labels, the field names, and the field types
After uploading the spreadsheet, to include the data make sure you select what?
import the spreadsheet data
The system cannot identify choice or reference fields but what can be done?
It can be defined manually
The system will parse the first worksheet in the spreadsheet to do what?
To identify the fields for the custom table
Can new fields be added to a table after fields have already been imported?
Yes
How many field types are listed as options for new fields for tables?
18
If a field type for a table is not listed, what system property can be added for you to set value to the field type?
sn_g_app_creator.field_types
After table columns are defined, what is next to do?
Define the table properties and permissions
To finish designating tables when creating an app, what do you select?
Done with tables
If you do not use the import option during Guided Application creator, what provides a mechanism to pull data into servicenow?
Import sets
Where do import sets store data?
In import set tables
When does the import set process skip records?
when the data in the instance is the same as the data being imported