Import external data into the Choice Table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2018 12:49 PM
I am attempting to load data to the CHOICE table so I can populate one of my drop down fields on my Incident Form. Everything works except the 'Create Excel Template' does not have the Table column(See SS1). When I import, the Table is blank and I have to set it manually(See SS2). I tried adding Table to the template but it seems to ignore it.
What am I missing?
SS1
SS2
SS3
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-12-2018 03:13 AM
Hi Weargle,
it seems that you did not add the col into your excel sheet(refer bellow image)
and because of this you are not able to map table field to sys_choice table.
now do the same process using import set,
Navigate import set->load data
and submit it.
you will get above page,
now see Loaded data in that it is showing you u_test_import_choice table means you have loaded source data into this table(you can check using .list)
the next step is to create transform map
click on it
now refer above image
give the name to field,target table in case of you choose sys_choice
save the record and click on Auto Map Matching ,your all fields will be match automatically and then
click transform
your record will be insert into expected table ...check it.
if helpful mark it correct or helpful..
Regards,
Varsha.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 03:13 PM
This is best, I have bookmarked it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2018 04:07 AM