Publié Mon, 04 Mar 2019 14:40:10 GMT par Kevin Fultz Software Incident Engineer

Has this changed or where can we find out now where the user specific settings are stored?

We no longer see this file or the location.

https://docuwarekb.microsoftcrmportals.com/en-us/knowledgebase/article/K...

Publié Mon, 04 Mar 2019 15:11:43 GMT par Craig Williams President/ CEO

If you read the article carefully it states that the system can store them in the database or the local macine.

The installaion default to the database when I installed it so I imagine that all installations 6.7 and greater would do the same. 

I should look something like the follwing:

 [system].[dbo].[DWUserSettings]

There are 7 fields

The settings are stored in the settings column and look like this 

<UserApplicationPreferences guid="30qq3c9a-a660-4c52-8ebf-6e88f3ff2b90" Name="Default" uid="5"><Preferences>&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;ApplicationPreferencesHolder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://dev.docuware.com/schema/public/services/platform"&gt;
  &lt;AppPrefs xsi:type="WebClientPreferences"&gt;
    &lt;WorkAreas&gt;
      &lt;ContentAreas xsi:type="BasketAreaPreferences" AreaType="Basket" SelectedInstanceIndex="-1" /&gt;
      &lt;ContentAreas AreaType="Search" SelectedInstanceIndex="-1"&gt;
        &lt;Instances ID="dfc29c1b-4b1d-4da4-bd54-3dd49f22ac32" /&gt;
      &lt;/ContentAreas&gt;
      &lt;ContentAreas AreaType="Workflow" SelectedInstanceIndex="-1" /&gt;
    &lt;/WorkAreas&gt;
    &lt;GeneralSettings /&gt;
    &lt;RegionalSettings /&gt;
    &lt;WebClientLayout Mode="AllInOne" /&gt;
    &lt;Favorites&gt;
      &lt;Baskets /&gt;
      &lt;StoreDialogs /&gt;
      &lt;SearchDialogs /&gt;
      &lt;TaskLists /&gt;
      &lt;MultiFCSearches /&gt;
    &lt;/Favorites&gt;
    &lt;Viewer LeftToolbarState="Collapsed" RightToolbarState="Expanded" ExpandStatusbar="false"&gt;
      &lt;Annotations /&gt;
      &lt;Toolbars&gt;
        &lt;Toolbar Type="Navigation" Position="Left" Visibility="NotVisible"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Nav_DocumentNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FirstDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PreviousDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_NextDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_LastDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FileNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FirstFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PreviousFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_NextFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_LastFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PageNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FirstPage" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PreviousPage" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_NextPage" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_LastPage" Checked="true" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Tools" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Tools_Save" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_Edit" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_PrintDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_SendDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_ShowDocumentInformation" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_ShowDocumentOverview" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_FulltextSearch" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_FulltextSearchContinue" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_TextAnnotation" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_Checksum" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_Download" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_PointAndShoot" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_ShootToClipboard" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_WorkflowHistory" Checked="true" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Display" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Display_FitToWidth" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_FitToWidthNoMargins" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_FullDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ZoomIn" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ZoomOut" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ZoomNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_MagnifyingGlass" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_DisplayEnhancement" Checked="true" State="Toggled" /&gt;
            &lt;ToolbarControl Type="Display_Invert" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_RotateLeft" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_RotateRight" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_SaveRotation" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ImageEnhancement" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_MergeLayers" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay1" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay2" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay3" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay4" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay5" Checked="false" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Stamps" Position="Left" Visibility="NotVisible"&gt;
          &lt;Controls /&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Annotations" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Annotations_Select" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Delete" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Text" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Marker" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Line" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_FreehandLine" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Arrow" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Rectangle" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Ellipse" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_FilledEllipse" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_FilledRectangle" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_TransparentEllipse" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_TransparentRectangle" Checked="false" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="DocOverview" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls /&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="DocLinks" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls /&gt;
        &lt;/Toolbar&gt;
      &lt;/Toolbars&gt;
    &lt;/Viewer&gt;
    &lt;MultiFCSearches /&gt;
  &lt;/AppPrefs&gt;
&lt;/ApplicationPreferencesHolder&gt;</Preferences></UserApplicationPreferences>

 

querey the data as follows:

SELECT [USetID]
      ,[uid]
      ,[admin]
      ,[type]
      ,[settings]
      ,[guid]
      ,[checksum]
  FROM [system].[dbo].[DWUserSettings]

The user data needs to be linked  with [dbo].[DWUser] and [dbo].[DWUserIdentity] to get all the data in one place.

 

Publié Mon, 04 Mar 2019 15:31:54 GMT par Kevin Fultz Software Incident Engineer

Maybe I should have referenced the original article but the corresponding links are bad and not working. 
https://docuwarekb.microsoftcrmportals.com/en-us/knowledgebase/article/K...

I am just trying to understand the easiest way to determine if the settings are stored in the local storage of the browser or in the database as the kb indicates and it states that you should be abe to determine this by reviewing the "C:\Program Files (x86)\DocuWare\Web\Platform\Web.config"

But that file location does not exist. So does that mean it is being stored in the database?

Publié Mon, 04 Mar 2019 16:52:07 GMT par Craig Williams President/ CEO

If the user settings are stored in the database:

  1. Create a backup of your DWSystem database
  2. Go to table DWSystem.DWUser and find the UID of the affected user. 
  3. Go to table DWSystem.DWUsersettings and delete all Rows with the UID of the affected user. 

I have a feeling that you will find them there...you will want to compare the 3 databases to see which GUID you need to remove.

You must be signed in to post in this forum.