Prevent 'Send to Excel' from Workspaces

Question

We have a customer who would like to prevent users mass exporting data to Excel. 
 We would need to prevent access to List Views because I understand it's currently not possible to prevent the Send to Excel option on those. 
 Instead we're looking at using Workspaces, but again the same challenge - can we remove the 'Send to Excel...' options? It's not an option in Workspace Designer. 
 I know some things that you can't do in Workspace designer but are achievable by editing the XML files directly, so I'm wondering if this is actually possible. 
 Thanks in advance.

Chris Burke · Accepted Answer

Oh. But this only does half a job, thanks to the function in sage.widgets.listcontentpart.js that's responsible for drawing the context menu. Yes, the 'export' option will be removed from the action bar at the top of the content part, but it'll still get put on the right-click menu. Great stuff. 
 If you edit the sage.widgets.listcontentpart.js file (it's in inetpub/Sage 200 Self Service/Sage200SelfSeervice/Scripts) and find the $.contextMenu function it should be apparent what's going on. This particular bit of code (edited for brevity) ... 
 menuItems.exp = {
 name: 'Export',
 accesskey: 'X',
 items: {
 excelall: {
 name: 'All to Excel',
 
 . . .
 
 }; 
 ...*should* really look like this: 
 if(o.export.isVisible) {
 menuItems.exp = {
 name: 'Export',
 accesskey: 'X',
 items: {
 excelall: {
 name: 'All to Excel',

 . . .
 
 };
} 
 Is it advisable to edit this file? Probably not. Would I do it? Yes.

Sage 200 UKI

Prevent 'Send to Excel' from Workspaces

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING