Difference between revisions of "Venice connector/Requirements"

Revision as of 15:20, 12 January 2017

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

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.

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.

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.