- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2019 02:38 AM
Hi
We need to sent out a publication via targeted communications that wil involve a subset our our active contacts.
It's not possible to select contactg using the condition builder as there is some manual decions to made so we need to upload a template of contacts.
The template asks for sys_id and email and my question is, how do I get a list of our active contacts and their sys_ids so tit can be edited and uploaded?
Thanks
Solved! Go to Solution.
- Labels:
-
Customer Service Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2019 03:15 AM
Hi
There is also an easy option to read a list of contacts, if you have access to scripts.
You can run the following script e.g. in "Scripts - Background":
var gr = new GlideRecord('customer_contact');
gr.query();
gs.info('List of contacts');
while(gr.next()) {
gs.info(gr.first_name + ', '
+ gr.last_name + ', ' + gr.sys_id);
}
This is just an example, on how to create a comma separated List of all Contacts.
If your contacts are not from the "customer_contact" table, just read e.g. the "sys_user" table.
You can see that the sys_id is the last field in the output per row.
SysIDs are not shown OOB in the Lists or Forms. So, if you want to export from the UI (maybe because you do not have access as admin to scrpts), you should ask an Admin to add a calculated field as SysID, so that you can add it to your lists.
You need to add a new field of Type "Function" (see screenshot below). Maybe you first need to modify the "Dictionary Entry" Form view to show the field "Function"!
That way, you can also export list from the classic UI (as a "normal" User) INCL. the SysID.
I hope that helps to solve your requirement.
Let me know, and mark my answer as correct and helpful, please.
BR
Dirk

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2019 02:54 AM
Hi
If you are talking about the Contact table, you can open a list of all contacts, an export the list manually to excel.
The columns shown, are the ones, that are in the export file...
Why do you want to have the sysid in the export?
Can't you coalesce with the email or login name for update?
Let me know, if that answered your question and mark my answer as correct and helpful, please.
BR
Dirk
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2019 08:03 AM
Hi Dirk
The sys_id is required for the XLS template you upload to the recipient list if you are not selecting contacts using the condition builder.
All sorted now but thanks for your responses, it's appreciated.
Regards
Richard

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-24-2019 03:15 AM
Hi
There is also an easy option to read a list of contacts, if you have access to scripts.
You can run the following script e.g. in "Scripts - Background":
var gr = new GlideRecord('customer_contact');
gr.query();
gs.info('List of contacts');
while(gr.next()) {
gs.info(gr.first_name + ', '
+ gr.last_name + ', ' + gr.sys_id);
}
This is just an example, on how to create a comma separated List of all Contacts.
If your contacts are not from the "customer_contact" table, just read e.g. the "sys_user" table.
You can see that the sys_id is the last field in the output per row.
SysIDs are not shown OOB in the Lists or Forms. So, if you want to export from the UI (maybe because you do not have access as admin to scrpts), you should ask an Admin to add a calculated field as SysID, so that you can add it to your lists.
You need to add a new field of Type "Function" (see screenshot below). Maybe you first need to modify the "Dictionary Entry" Form view to show the field "Function"!
That way, you can also export list from the classic UI (as a "normal" User) INCL. the SysID.
I hope that helps to solve your requirement.
Let me know, and mark my answer as correct and helpful, please.
BR
Dirk