Export List of Records into CSV with SysID

salvadormarchan
Kilo Guru

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

30 REPLIES 30

Thank you for the reply; let me explore that and find out more...Thanks again...


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)

sherman_1206
Tera Contributor

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.


Chuck Tomasi
Tera Patron

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.


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.