Difference between revisions of "Venice connector/Requirements"

Revision as of 14:31, 28 April 2020

You need to have an SQL Server running. If that is not the case, follow the SQL Server installation instructions.

1 System requirements

• Microsoft .Net framework version 4 or higher
• 100 MB RAM
• 10MB disk space for the installation of the service
• System logging can take up several GB per month. Cleanup of these files is not foreseen
• The service needs to run with a user that has sufficient privileges to access the venice folders and the connector folders.

2 Venice requirements

• The Venice monitor connects to the Venice SDK using a Venice user. So you will need to provide a user license for this.
• For further installation specifics you can check out the Venice connector installation

3 Firewall settings

The Venice monitor communicates to the onea archive (typically http://vis.onea.be/Onea) via https. You will need to allow this traffic in order for the Venice monitor to work.

4 Requirements in SQL Server

• We need an sql server instance running and a user with read and write rights to the database defined below. SQL express 2012 or higher is perfect.

• Database VENICE_MONITOR with 3 tables:
  • SVC_CABINET
  • SVC_DOSSIER
  • SVC_SYNCACTION

The scripts to create these tables are provided by Onea, please contact us if you haven't received them.

This table is used to:

• store the locations of the cabinets to synchronize.
• store the URL and login info needed to upload/download data from VIS.

Following columns are available:

• code: contains the path to the cabinet. For example: "C:/Venice/Cabinets/cabinet.
• isActive: indicates if the sync of the cabinet should be active or not. Possible values are:
  • 0: not active
  • 1: active
• instanceCode: the name of the instance to which the cabinets belong.
• serviceAddress: the address of the webservice. Default value: https://vis.onea.be/Onea/WS
• serviceName: the name of the webservice. Default value: ERPSync
• username: the username of the user that will be used for synchronization. This should be provided by Onea.
• password: the password of the user that will be used for synchronization. This should be provided by Onea.
• scanProImageLink: the prefix-URL of the direct link to a document. Default value: https://vis.onea.be/Onea/site/d/
• hasPriority: if set to 1, this cabinet is synchronized first.
• prioritySorting: influences the order in which the cabinets are synchronized.
• processing: indicates that a cabinet is being processed at the moment.
• scanProPublicImageLink: the prefix-URL of the public link to a document image. Default value: https://vis.onea.be/Onea/p/d/
• scanProPublicDocumentLink: the prefix-URL of the public link to a document. Default value: https://vis.onea.be/Onea/p/doc/

This table is used to define which dossier(s) of which cabinets need to be synchronized with VIS.

Following columns are available:

• dossier: indicates which dossier of the cabinet needs to be synchronized. This is the name of the dossier folder. It is also possible to use a wildcard (*) to indicate that all dossiers of the cabinet should be synchronized.
• isActive: indicates if the sync of the dossier should be active or not.
• cabinet_id: the id of the entry in the SVC_CABINET table.
• processing: indicates that a dossier is being processed at the moment.
• hasPriority: if set to 1, the dossier is synchronized first.
• prioritySorting: influences the order in which the dossiers are synchronized.

This table is used to store all different elements synchronized. There is no need to create rows here, these will be automatically added by 1Archive.