Changing Smart Office settings files without Smart Office client

From Smart Office 10.0.3 all settings files are located in the GDBC database instead of the file system. Sometimes an administrator needs to change a setting without opening the Smart Office client. In Smart Office 10.0.5 there is an external tool called SettingsTool.exe that can be used to access the settings files on the server.

The SettingsTool.exe is a command line tool that can export and import server files. Files currently included are settings files, a pre-defined widget file and link files. Normally these files are edited through the Settings Editor, Predefined Widgets editor and Link Manager inside of Smart Office.

SettingsTool.exe produces the same files that can be exported/imported with the Import/Export Manager administration tool in Smart Office. See http://lawsonsmartoffice.com/2012/06/14/import-export-manager/ for more information.

An administrator can however configure settings so it is not possible to start Smart Office. For example:

–          Setting the SelectedProfile in Mango.Core to a profile that does not exists and do not letting the user change the value.

–          Modifying the AllowedApplications Mango.Core to be to restrict that Smart Office cannot start.

If something like this happens, the SettingsTool tool can be used to export the settings files, change the files manually and then import them back.

Usage

The SettingsTool .exe is found in the AdditionalFiles folder in the zip file downloaded from the download center.

To use the SettingsTool open a command window (cmd.exe) and go to AdditionalFiles folder. Usage syntax:


SettingsTool <–export/-import> [-exportRoles/-importRoles] <-file=<filename>> <-server=<serverurl>> <-user=<connectuser>> <-password=<password>>

Either –import or –export must be specified.

-exportRoles or –importRoles are optional and is including the role values when doing an export or an import. –exportRoles is a valid parameter only if –export is specified and -importRoles is a valid parameter  only if –import is specified. When importing role values, all role values the existing role values are completely replaced (no merge is made). Be a bit careful with the –importRoles because if the exported file does not include any role values (like if it has been exported without role values) all existing role values will be removed. It is however possible to open up the exported file and remove those settings files that should not be updated. If there is a problem with only one settings file this can be a good idea.

Here is an example on an export where the role values are not include.


SettingsTool -export -server=https://myserver.company.com:19006 -file=myfile.zip -user=mysuser -password=mypassword

The user specified must be a Smart Office administrator. And the server URL must be the HTTPS URL to the Grid where Smart Office server is installed.

If Smart Office cannot be started due to bad settings configuration

Use this procedure if a setting is causing such a problem that no user can start Smart Office.

Start with exporting the settings files with the SettingsTool.exe. If you have not that many role values configured in the settings file that causes the problem the easiest may be to remove all role values and redo that configuration later. In this example all role values will be removed, if you do not want to remove all role values make sure to specify the –exportRoles parameter during export.

Export the settings with the following command:


SettingsTool –export –server=https://myserver.company.com:19006 –file=export.zip –user=<myadminuser> –password=<password>

Open up the exported file with your favorite zip tool, locate the settings file to change and edit it in a text editor.

Locate the file where the setting that is to be changed is in, make the change and make sure to update the zip file with the edited file.


<?xml version="1.0" encoding="utf-8"?>
<mp:Properties xmlns:mp="<a href="http://schemas.intentia.net/Mango/Settings/Properties">http://schemas.intentia.net/Mango/Settings/Properties</a>">
  <mp:Settings>
    <mp:UserSettings>
      <mp:Property Name="SelectedProfile">
        <mp:DefaultValue><strong>Production</strong></mp:DefaultValue>
        <mp:Value />
      </mp:Property>
      <mp:Property Name="EnableSystemProfileSelector">
        <mp:DefaultValue>False</mp:DefaultValue>
        <mp:Value />
      </mp:Property>

Files that are not changed can be removed from the zip file. This is important if other settings files have role values configured on the server and you do not want to delete those role values for all settings files.

To import the settings use the SettingsTool again but specify –import instead, also specify the –importRoles parameter to completely remove all existing role values (all role values will be removed because when the export was done role values where not included).


SettingsTool –import –importRoles -server=https://myserver.company.com:19006 -file=export.zip - user=<myadminuser> –password=<password>

Done.

How to locate the URL to Grid where Smart Office is installed

To get the URL to the Grid where Smart Office is installed, open the Smart Office install page, right click on the “Install Infor Smart Office” and select Copy shortcut.

Open up a text editor and paste the content from the clipboard, it should look similar to this:

http://sestw325.infor.com/LSO/LawsonClient.application?server=https://sestw325.infor.com

It is the last part, after server= that is the URL to the Smart Office server.

How to administrate Smart Office administrators

Smart Office administrators are maintained in the Grid Configuration Manager.
The easiest way to find the Grid Configuration Manager is by opening it from the
LCM client.