Export List of Records into CSV with SysID
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 08:32 AM
Hello All,
I really need help on the scenario that one of Managers is asking me. They wanted to export CSV files from a List of Records including the SysID (32 long string ID). I can find it individually but not as part of a list.
Please advise how to do this.
Thank you in advance.
Dor Marchan
one month-old newbie admin
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 10:27 AM
Thank you for the reply; let me explore that and find out more...Thanks again...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-15-2018 07:50 AM
You can do it through the UI if you add the sys_id to the System UI List.
1. Go to System UI -> Lists
2. Select the record for the Table and view you want to modify
3. In the List Elements related list, add sys_id in the position you want
4. Execute cache.do
*credit goes to mamann (Community Post)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 11:21 AM
A nice workaround is exporting to json format. Exporting to json will include sys_id values. (this does require json plugin enabled I believe)
As long as you are willing to work with json over xml/csv than this should suffice your needs.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 11:24 AM
I'm always curious to know what the manager wants the sys_id for. Don't be afraid to ask "why" when people ask you for something. Find out what the business requirement is before accepting their technical "suggestion". There may be better/simpler ways to get what they need. It's likely you know more about the tool than they do. Any time someone says "Hey, I need x to do y." My standard response is usually "What is the problem we're trying to solve here?" Always gather requirements before proposing a solution - something I have to keep reminding myself.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 11:28 AM
I agree Chuck, however I have done 2 projects over last year where sys_id was required. There are cases but usually its worth exploring other directions where you do not need sys_id.
In a nutshell 90% of the time sys_id is not needed for whatever project though.