Venice connector/Requirements
From 1Archive help
Revision as of 13:45, 28 April 2020 by Bjorn.misseghers (talk | contribs)
You need to have an SQL Server running. If that is not the case, follow the SQL Server installation instructions. |
Contents
1 System requirements
- Microsoft .Net framework version 4
- 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
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 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
- 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. |
SVC_CABINET
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/
SVC_DOSSIER
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.
SVC_SYNCACTION
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.