How do I import a list field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2018 04:43 PM
I have a table that contains a "list" field (of users). I attempted to import records into this table via the Excel template and ran into a problem. While most fields of the table imported without issue, the list field was left blank. To keep it simple, the Excel sheet only contain the name of 1 user for this list field.
Anyone tried doing an "easy import" of a list field with success? Any pointers?
- Labels:
-
Enterprise Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2018 08:19 PM
Hi,
I would check the Import Set log file, when you do the import its a number like Isetxxxx.
Click on the import set Rows tab and see if you are using a Transform Map.
If you have a map check that field is mapped correctly.
That is what I would recommend....Thanks...Gary
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2018 09:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-21-2018 11:26 AM
@Gary, my original question was pertaining specifically to "easy import", so there wouldn't be any Import Set log involved.
@Shweta, thanks for the link. If the "Easy Import" doesn't handle list fields, I'm going to go with doing it with an Import Set. I was hoping to just do it quickly with the Easy Import method.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-21-2018 01:14 PM
Does the column contain sys_id or display value of the users?
