Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: supplied full SQL to enable DMS

...

  • (313) Installation ID: Make sure your unique installation id is set. If it isn't, please contact Patrix Support to get it.
  • (314) Open documents using PINXDesktop: ALWAYS set to FALSE.
  • (315) Nuxeo hostname and port: Enter the hostname and port of your nuxeo service, e.g. nuxeo.company.com:8080
  • (318) Enable checksums for case numbers: Will make Patricia use checksums when generating case refs. in letter codes. Depending on your setup you may wish to enable/disable this setting.
  • (325) If you are using Patricia 5.6.2+ you can activate the native nuxeo dll access so that Patricia will no longer need a WebDAV drive mounted for the documents path. This increases stability and is strongly suggested. Support of the old technology using a WebDAV mounted drive will cease in time. Simply set this setting to TRUE and make sure you have received and deployed the nuxeo.dll correctly.

In case you are missing any one of the settings (313, 315, 318, 325), DMS has not been enabled in your Patricia database, please run the corresponding following SQL as follows:

Code Block
languagesql
if not exists (select * from pat_display_layout_functions where description = 'DMS')
INSERT INTO pat_display_layout_functions
            (layout_type,
             pat_or_maint,
             id,
             parent_id,
             description,
             action,
             sort_sw,
             parent_sort_sw)
VALUES     (1,
            'B',
            16,
            0,
            'DMS',
            'dms',
            1,
            14);
UPDATE pat_display_layout_functions
SET    sort_sw = 15
WHERE  layout_type = 1
       AND id = 12;
UPDATE pat_display_layout_functions
SET    sort_sw = 16
WHERE  layout_type = 1
       AND id = 14;
UPDATE pat_display_layout_functions
SET    sort_sw = 17
WHERE  layout_type = 1
       AND id = 15;
if not exists (select * from mandata_projectlog where project_id = 3501)
INSERT INTO mandata_projectlog
            (project_id,
             execution_date,
             customer_id,
             status)
VALUES     (3501,
            CURRENT_TIMESTAMP,
            13,
            1); 
 
if not exists (select * from PAT_CONFIGURATION where configuration_id = 325313)  
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag)  
VALUES (325313,'UseInstallation NuxeoLib.dllID','UseInstallation NuxeoLib.dllID',32,'FALSE<enter id here>',1,7);

if not exists (select * from PAT_CONFIGURATION where configuration_id = 313314) 
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) 
VALUES (313314,'Installation IDOpen documents using PINXDesktop','Installation IDOpen documents using PINXDesktop',23,'<enter id here>FALSE',1,7);

if not exists (select * from PAT_CONFIGURATION where configuration_id = 315)  
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag)  
VALUES (315,'Nuxeo hostname and port','Nuxeo hostname and port',2,'hostname:port',1,7);

if not exists (select * from PAT_CONFIGURATION where configuration_id = 318)  
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag)  
VALUES (318,'Enable checksums for case numbers','Enable checksums for case numbers',3,'TRUE',1,7);
 
if not exists (select * from PAT_CONFIGURATION where configuration_id = 325) 
INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) 
VALUES (325,'Use NuxeoLib.dll','Use NuxeoLib.dll',3,'FALSE',1,7);

Configure write access for Patricia Users in Nuxeo GUI

...