@jmiskey, here's a simple approach.
Follow the steps below.
1) First, have only one field in your list view that you wish to update with the suffix or minimum fields as possible. Like example below.
2) Then click on column context menu and select "Import". Select the options as shown in the example below and click on "Create Excel template". It will process your request and show you download button. Download the template. (Don't include all fields.)
3) This downloaded excel template will have "SysIDs" of all the filtered records along with your selected column that you chose in the list view of you custom table. See example snip below.
4) Now, all that you need to do is concatenate the 2 strings as example below and upload it back with the same interface.
5) Copy and paste the concatenated text to your desired column that you want to update. For example I used "Short Description" field. Do not change any field header. Otherwise it will fail.
6) Save your excel and upload it back from the same interface you downloaded the template.
See example below. If all goes well no error will throw. If error shows up you can fix and upload the excel again.
7) Click on "Preview imported data". Check your updates and scroll to the bottom to complete your import.
Final result...
Hope this helps.
P.S - By the way, did you try fix script? Is it throwing the same error? Not spending too much time there. Try this little trick!
Also, did you check the scope in which you're running your script?
Let me know if it worked!
Regards,
Vikas K
you are running the background script from global scope and hence the error is coming.
Ensure you select your custom scope here when you Run the script and then it will work for sure
also update script as this
var gr = new GlideRecord('x_table_name');
gr.addQuery('active','true');
gr.query();
while(gr.next()){
gr.security_group = gr.security_group.toString() + '- Role';
gr.update();
}If my response helped please mark it correct and close the thread so that it benefits future readers.
