Versions Compared

Old Version 8

changes.mady.by.user Serviva Service Desk

Saved on

compared with

New Version 9

changes.mady.by.user Serviva Service Desk

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


1. Prepare Patricia Database

  • In order to have Data available that is neccesary for the Pavis Interface, the Patricia Database needs to be enhanced.
  • Open up the Database Administration Tool of your choice (e.G. Microsoft SQL Server Management Studio) and execute the below scripts.

Run database Scripts

Code Block
languagesql
titleCreate Login Data
linenumberstrue
collapsetrue
-- Create Fields for Pavis Interface

-- 2019-11-28 Jr Serviva

INSERT [dbo].[NAME_ADD_FIELDS_DEF] ([NAME_FIELD_NUMBER], [FIELD_NAME], [FIELD_TYPE], [SORT_ORDER], [IS_ACTIVE], [MAINTAINED_BY_PATRIX], [IS_CHECKBOX]) VALUES (40000, N'pavis cust_id', 2, NULL, 1, 0, 0)
GO

INSERT [dbo].[NAME_ADD_FIELDS_DEF] ([NAME_FIELD_NUMBER], [FIELD_NAME], [FIELD_TYPE], [SORT_ORDER], [IS_ACTIVE], [MAINTAINED_BY_PATRIX], [IS_CHECKBOX]) VALUES (40001, N'Pavis password', 2, NULL, 1, 0, 0)
GO

INSERT [dbo].[NAME_ADD_FIELDS_DEF_LABEL] ([NAME_FIELD_NUMBER], [LANGUAGE_ID], [FIELD_LABEL]) VALUES (40000, 3, N'Pavis Connect Customer ID')
GO

INSERT [dbo].[NAME_ADD_FIELDS_DEF_LABEL] ([NAME_FIELD_NUMBER], [LANGUAGE_ID], [FIELD_LABEL]) VALUES (40000, 4, N'Pavis Connect Customer ID')
GO

INSERT [dbo].[NAME_ADD_FIELDS_DEF_LABEL] ([NAME_FIELD_NUMBER], [LANGUAGE_ID], [FIELD_LABEL]) VALUES (40001, 3, N'Pavis Connect password')
GO

INSERT [dbo].[NAME_ADD_FIELDS_DEF_LABEL] ([NAME_FIELD_NUMBER], [LANGUAGE_ID], [FIELD_LABEL]) VALUES (40001, 4, N'Pavis Connect Passwort')
GO
Code Block
languagesql
titleCreate Diary Field
collapsetrue
INSERT [dbo].[DIARY_FIELD] ([FIELD_NUMBER], [DIARY_ENTRY_POINT_ID], [DATE_FLAG], [DIARY_TYPE_LABEL], [CHECK_DUPLICATE], [DIARY_FIELD_TYPE], [CREATE_REGARDING_TEXT], [SORT_ORDER], [DIARY_GROUP], [IGNORE_DIARY_DATE_RULE], [SHOW_ON_CLIENTLIST], [UPDATE_FAMILY], [IS_NUMERIC], [USE_DDLB], [DDLB_SELECT], [MAINTAINED_BY_PATRIX], [STATUS_ID], [VISIBLE_AS_LETTER_CODE], [VISIBLE_IN_CASE_OVERVIEW], [USE_IN_FIND_RESULTS], [VALIDATION_TYPE_ID], [VALIDATION_DIARY_FIELD], [VALIDATION_DATE_FIELD], [UPDATE_DESIGNATION_STATUS], [AVAILABLE_IN_REPORT_CREATION], [GROUP_ON_CASE_FIND], [YMD_ADJUSTMENT], [PCP_RESULT]) VALUES (33000, NULL, CAST(1 AS Numeric(1, 0)), N'Pavis Next Annuity', NULL, NULL, NULL, 15, 4, 0, CAST(1 AS Numeric(1, 0)), CAST(0 AS Numeric(1, 0)), 0, 0, NULL, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL)
GO

INSERT [dbo].[DIARY_MATRIX_TEXT] ([FIELD_NUMBER], [DIARY_LINE_TEXT_SEQ], [MAINTAINED_BY_PATRIX]) VALUES (33000, 1, NULL)
GO

INSERT [dbo].[DIARY_LINE_TEXT] ([FIELD_NUMBER], [DIARY_LINE_TEXT], [DIARY_LINE_TEXT_SEQ], [DIARY_LINE_TEXT_LANGUAGE], [MAINTAINED_BY_PATRIX]) VALUES (33000, N'Pavis Next Annuity', 1, 3, NULL)
GO

INSERT [dbo].[DIARY_LINE_TEXT] ([FIELD_NUMBER], [DIARY_LINE_TEXT], [DIARY_LINE_TEXT_SEQ], [DIARY_LINE_TEXT_LANGUAGE], [MAINTAINED_BY_PATRIX]) VALUES (33000, N'Pavis Nächste Gebührenzahlung', 1, 4, NULL)
GO
Code Block
languagesql
titleCreate Web View
collapsetrue
INSERT [dbo].[PAT_WEB_LINKS] ([LINK_ID], [LINK_TYPE], [LINK_VALUE], [LINK_DESCRIPTION], [LINK_GLOBAL], [LINK_AUTH_REQ], [PCP_LINK], [DC_LINK]) VALUES (30000, 1, N'http://'+(select STRING_VALUE from PAT_CONFIGURATION where CONFIGURATION_ID = 131)+':8081/?caseref=@@', N'PAVIS', 1, NULL, 1, 0)
GO

INSERT [dbo].[PAT_WEB_LINKS_ARGS] ([LINK_ID], [LINK_ARG_ID], [LINK_ARG_SEQ], [LINK_ARG_TYPE], [LINK_DIARY_FIELD]) VALUES (30000, 30000, 1, 1, NULL)

2. Change Diary Matrix in Maintenance

  • Open Patricia Maintenance
  • Navigate to Country/Law | Diary Matrix | Diary Matrix
  • Open up the Diary Matrix for "Patent - Top Matrix"

  • Add the new Field (which has been created in the script you ran above)

  • Do the same for all Casetypes you want to use with Pavis.


3. Install the Interface Software on your Patricia Application Server

  • Check if Java is already installed

  • open up a command line and enter

    Code Block
    languagepowershell
    themeEmacs
    Java -version

    if that Returns a value you already have Java installed.

  • In the  unlikely event that you do not already have Java installed, please install a Java Version of your choice.
    For reference please check here https://stackoverflow.com/questions/52511778/how-to-install-openjdk-11-on-windows or here https://www.java.com
  • open up the Server´s Firewall to grant Access from other Computers to port 8081
  • open up your Network´s Firewall for the Interface Software from your Patricia Application Server to connect to Pavis under the hostname https://www.pavis-online.com
  • copy the file
    View file
    namepavis-rest-0.0.1.jar
    height150
     to a new Folder called "C:\Serviva"

    open up a command line and enter

4. Edit the Database Connection inside the .jar File

  • a .jar File is a "renamed" .zip File

  • You can open it with any .zip unpacker/packer that you like, we recommend 7zip

  • Inside the .jar Archive, Navigate to the file BOOT-INF\classes\application.properties

  • edit the database connection to your needs:

    Code Block
    languagejs
    titleapplication.properties
    spring.datasource.url=jdbc:sqlserver://localhost;databaseName=Patricia_Database
spring.datasource.username=sa
spring.datasource.password=Mysupersecretpassword.
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
spring.jpa.hibernate.ddl-auto=none
spring.main.allow-bean-definition-overriding=true
server.port=8081

    and save the document back into the .jar file

  • open up a command line and enter

  • Code Block
    languagepowershell
    themeEmacs
    java -jar C:\Serviva\pavis-rest-0.0.1.jar
  • please note: when you close the command line window, the application will stop. see further below for installing a permanent instance.


Panel

Auf dieser Seite:

Table of Contents

5. Validate the Installation

  • Open Up Patricia
  • On the "Web" Tab you should see an entry named "PAVIS"
  • Click this and you should see something like this:
  • If this fails, it is very likely that your Internet Explorer does not allow Javascript .


6. Make the application start after a reboot

  • Create a .bat File "pavis-service.bat"

  • Provided you were following the above enter this into the file

    Code Block
    languagepowershell
    themeEmacs
    java -jar C:\Serviva\pavis-rest-0.0.1.jar
  • Run this .bat file in your Windows Task Scheduler. Add "run hidden" as you see fit.


Zugehörige Seiten

Content by Label
showLabelsfalse
spacesST
showSpacefalse
sorttitle
typepage
cqllabel = "documentation-space-sample" and type = "page" and space = "ST"
labelsdocumentation-space-sample