<%@ page import = "com.crystaldecisions.sdk.occa.infostore.*, com.crystaldecisions.sdk.plugin.desktop.common.*, com.crystaldecisions.sdk.framework.*, com.crystaldecisions.sdk.occa.security.*, com.crystaldecisions.sdk.exception.SDKException, com.crystaldecisions.sdk.occa.infostore.IInfoObject, com.crystaldecisions.sdk.properties.IProperties.*, com.crystaldecisions.sdk.plugin.desktop.user.*, com.crystaldecisions.sdk.properties.*, com.crystaldecisions.ePortfolio.framework.common.CrystalIdentity, com.crystaldecisions.ePortfolio.framework.common.CEClientConstants, com.crystaldecisions.webapp.CEConstants, java.util.Locale" %> <%@ taglib uri='/WEB-INF/fmt.tld' prefix='fmt' %> <%@ taglib uri='/WEB-INF/struts-html.tld' prefix='html' %> <%@ taglib uri='/WEB-INF/generic_tagcontrols_taglibrary_1.0' prefix='tc' %> <% // ****************************************************************** // CopyPrefs.jsp // // This script copies the preferences from the currently logged in // user to all the other users in the system. // // RKing, Business Objects, Feb 2006 // ****************************************************************** %> <% schema.setPrefsFromCookie (request); %> <% userSettings.init(request, CE_Session); %> <% IInfoStore iStore = (IInfoStore)((CrystalIdentity)request.getSession().getAttribute(CEConstants.SESSION_EN_SESSION)).getSession().getService("InfoStore"); String userName = "Administrator"; //((CrystalIdentity)request.getSession().getAttribute(CEConstants.SESSION_EN_SESSION)).getSession().getUserInfo().getUserName(); IEnterpriseSession es = null; IInfoObjects sourceUser = null; IInfoObjects targetUsers = null; IInfoObjects targetCnt = null; IInfoObject oSourceUserObject = null; IInfoObject oTargetUserObject = null; try { ISessionMgr mySessionMgr = CrystalEnterprise.getSessionMgr(); if (iStore != null ) { session.setAttribute("InfoStore", iStore); sourceUser = (IInfoObjects) iStore.query("SELECT SI_DATA FROM CI_SYSTEMOBJECTS WHERE SI_PROGID = 'CrystalEnterprise.User' And SI_Name = '" + userName + "'"); targetCnt = (IInfoObjects) iStore.query("SELECT TOP 50000 SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_PROGID = 'CrystalEnterprise.User' And SI_Name != '" + userName + "'"); int Cnt = targetCnt.getResultSize(); targetUsers = (IInfoObjects) iStore.query("SELECT TOP " + Cnt + " SI_DATA FROM CI_SYSTEMOBJECTS WHERE SI_PROGID = 'CrystalEnterprise.User' And SI_Name != '" + userName + "'"); oSourceUserObject = (IInfoObject)sourceUser.get(0); IUser sUser = (IUser)sourceUser.get(0); String Source = oSourceUserObject.properties().toString(); String sCDZ_VIEW_leftPane=sUser.getProfileString("CDZ_VIEW_leftPane"); out.println("Source Left Panel Settings of : "+userName+" : "+sCDZ_VIEW_leftPane); out.println("
This will Sync the preferences from the current account to all other users.

"); out.println("Coping Preferences from " + oSourceUserObject.getTitle() + ""); out.println("
"); for ( int i = 0; i < targetUsers.getResultSize(); i++ ) { oTargetUserObject = (IInfoObject)targetUsers.get(i); IUser iUser = (IUser)targetUsers.get(i); out.println(i+ "
"); iUser.setProfileString ("CDZ_VIEW_leftPane", sCDZ_VIEW_leftPane); } iStore.commit( targetUsers ); out.println("Updated " + targetUsers.getResultSize() + " user preferences."); out.println("

"); out.println("Setting String used: " + Source); out.println("
"); } else { out.println("null session"); } } catch (SDKException e) { out.println(e.getMessage()); } %> '/>'>