...
| Code Block | ||
|---|---|---|
| ||
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 = 313) INSERT INTO PAT_CONFIGURATION (configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) VALUES (313,'Installation ID','Installation ID',2,'<enter id here>',1,7); if not exists (select * from PAT_CONFIGURATION where configuration_id=314) INSERT INTO PAT_CONFIGURATION(configuration_id,label,description,type,string_value,maintained_by_patrix,group_flag) VALUES(314,'Open documents using PINXDesktop','Open documents using PINXDesktop',3,'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); |
If the related EDMS tables do not yet exist in your Patricia database, please execute the following SQL:
| Code Block | ||
|---|---|---|
| ||
if object_id('PAT_DMS_OCR_SCAN') is Null
CREATE TABLE PAT_DMS_OCR_SCAN(
OCR_EMAIL_ADDRESS nvarchar(200) NOT NULL,
SAVE_CATEGORY_ID int NULL,
PRIMARY KEY CLUSTERED (OCR_EMAIL_ADDRESS ASC))
GO
if object_id('PAT_DMS_SETTINGS') is Null
CREATE TABLE PAT_DMS_SETTINGS(
DMS_SETTING_KEY nvarchar(200) NOT NULL,
DMS_SETTING_VALUE nvarchar(500) NULL,
PRIMARY KEY CLUSTERED (DMS_SETTING_KEY ASC))
GO
if object_id('PAT_DMS_TOKEN') is Null
CREATE TABLE PAT_DMS_TOKEN(
USERNAME nvarchar(255) NOT NULL,
TOKEN nvarchar(255) NOT NULL,
CREATION_TIME datetime NULL,
PRIMARY KEY CLUSTERED (TOKEN ASC))
GO |
The following steps are required to configure the Patricia application for extended DMS:
...