smoBackOffice
Last modified on 2023/06/29 15:28
Definition
smoBackOffice is the Service Manager scheduler used for running a list of predefined processing such as discovery integration, network integration, preimport processing, purge processing and statistics processing.
EndDefinition
- The processing is listed in a configuration file called smoBackOffice.cfg.
- Customers can enable or disable the processing based on their requirements.
- The scheduler will run the processing based on the order displayed in the file and the specified execution start date and time.
Notes
- The smoBackOffice service must be restarted to take into account any modification made to the configuration file.
- Integration models are run by the Service Manager smoScheduler scheduler.
Best Practice
- When you run a preimport processing using the smoBackOffice scheduler, it will be placed in the scheduler queue. Use the smoBackOfficeClient tool if you want to test it immediately or if you want to use an external scheduler or third-party application.
See How to automate an integration.
smoBackOffice.cfg configuration file
This file describes the properties for each type of processing that can be run by the smoBackOffice scheduler.
[HTTP]
PORT=8091
; ==> Network integrations
; Indicate the configuration parameters
[NETWORK]
; Listening port (default=1234)
PORT=31163
; ==> Discovery integrations
; Indicate if Discovery data can be collected: ACTIVE (Yes=1/No=0)
; Indicate how data is collected: locally or via an FTP/SMTP protocol (active=1/inactive=0)
; Specify the corresponding section [...Connect]
[GetData]
ACTIVE=0
FTP=0
SMTP=1
LOCAL=1
; Frequency in number of minutes
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; ==> Discovery integrations:
; Indicate the configuration parameters of the protocol if it is active in the [GetData] section
[FTP Connect]
rem Host=
rem Port=22 for sftp
rem Port=21
rem UserID=
rem Password=
rem Directory=
rem Ssl=SFTP
HOST=127.0.0.1
USERID=easyvista
DIRECTORY=data
PORT=21
; ==> Discovery integrations
; Indicate the configuration parameters of the protocol if it is active in the [GetData] section
[POP3 Connect]
rem Host=
rem Port=110
rem UserID=
rem Password=
Host=127.0.0.1
Port=110
UserID=easyvista@aef.com
Password=staff
; ==> Discovery integrations
; Indicate the EasyVista work folders
[Working folders]
DownloadDir=c:\easyvista\cust\done
UnZipDir=c:\easyvista\cust\
CSVDIR=\\127.0.0.1\report\
PDFDIR=\\127.0.0.1\report\
LocalResultDir=c:\Easyvista\Inventory
[GLOBAL]
MODE=SQL
; Frequency in number of minutes
DELAY=1
; Indicate if the encryption of passwords and connection strings is active in the .ini preimport files
CryptedPasswords=true
; ==> Imports:
; Indicate if imports can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[IMPORT]
ACTIVE=0
MAX_PACKET_SIZE=20
MAX_THREAD=10
; Frequency in number of minutes
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; For SQL Server
BULK_EXE=C:\Pro
; For oracle
;BULK_EXE=C:\Program Files\oracle\80\Tools\Binn\SQLLDR.exe
; ==> smoBackOffice:
; Indicate if the Discovery module is installed: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[DISCOVERY]
ACTIVE=1
;TEMPORARY_TABLE_NAME=
;ACCOUNT=23865
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
DO_NOT_DELETE_TEMPTABLE=0
PDF_ACTIVE=0
PDF_TEMPLATE=A-@_LANGUAGE_@-Inventory.rpt
PDF_EXPORT=inventory.pdf
CSV_ACTIVE=0
CSV_TEMPLATE=inventory.sql
; ==> Statistics processing
; Indicate if statistics processing can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[STAT]
ACTIVE=0
; Frequency in number of minutes
DELAY=30
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; ==> Network processing
; Indicate if Network processing can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[EZVNET]
ACTIVE=0
; Frequency in number of days for running the file
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; MODE = FTP, POP3 ou LOCAL
MODE=FTP
;POP3_Host=
;POP3_UserId=
;POP3_Password=
;POP3_Port=110
;EZVNetDir=CONFIGURE THIS VALUE WHEN MODE=LOCAL
; ==> Database access parameters
; They apply to smoBackOffice and smoBackOfficeClient
[SQL Connection]
Server=EZV_SQL1
UserId=EZV_ADMIN
Password=password
BO_OWNER=EZV_ADMIN
BO_DatabaseName=EVO_BACKOFFICE
ADMIN_OWNER=EZV_ADMIN
ADMIN_DatabaseName=EVO_ADMIN
REF_OWNER= EZV_ADMIN
DateFormat=MM/DD/YYYY
[Administrator]
;Email=ReturnAddr
;SMTPHost=ReturnAddr
;SMTPUserId=ReturnAddr
;ReturnAddr=ReturnAddr
;Port=25
; ==> Preimports
; Indicate if preimports can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active (They apply to smoBackOffice and smoBackOfficeClient)
[PREIMPORT]
ACTIVE=1
SAAS=1
; Frequency in number of seconds
DELAY=300
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
[LOG]
LEVEL=0
; ==> Purge processing
; Indicate if purge processing can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[PURGE]
ACTIVE=0
; Frequency in number of days for running the file
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; DELETE_... = n days
;DELETE_DISCOVERY_HISTORY=150
;DELETE_DISCOVERY_IN=100
[INSTALL]
VERSION=1.0
PORT=8091
; ==> Network integrations
; Indicate the configuration parameters
[NETWORK]
; Listening port (default=1234)
PORT=31163
; ==> Discovery integrations
; Indicate if Discovery data can be collected: ACTIVE (Yes=1/No=0)
; Indicate how data is collected: locally or via an FTP/SMTP protocol (active=1/inactive=0)
; Specify the corresponding section [...Connect]
[GetData]
ACTIVE=0
FTP=0
SMTP=1
LOCAL=1
; Frequency in number of minutes
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; ==> Discovery integrations:
; Indicate the configuration parameters of the protocol if it is active in the [GetData] section
[FTP Connect]
rem Host=
rem Port=22 for sftp
rem Port=21
rem UserID=
rem Password=
rem Directory=
rem Ssl=SFTP
HOST=127.0.0.1
USERID=easyvista
DIRECTORY=data
PORT=21
; ==> Discovery integrations
; Indicate the configuration parameters of the protocol if it is active in the [GetData] section
[POP3 Connect]
rem Host=
rem Port=110
rem UserID=
rem Password=
Host=127.0.0.1
Port=110
UserID=easyvista@aef.com
Password=staff
; ==> Discovery integrations
; Indicate the EasyVista work folders
[Working folders]
DownloadDir=c:\easyvista\cust\done
UnZipDir=c:\easyvista\cust\
CSVDIR=\\127.0.0.1\report\
PDFDIR=\\127.0.0.1\report\
LocalResultDir=c:\Easyvista\Inventory
[GLOBAL]
MODE=SQL
; Frequency in number of minutes
DELAY=1
; Indicate if the encryption of passwords and connection strings is active in the .ini preimport files
CryptedPasswords=true
; ==> Imports:
; Indicate if imports can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[IMPORT]
ACTIVE=0
MAX_PACKET_SIZE=20
MAX_THREAD=10
; Frequency in number of minutes
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; For SQL Server
BULK_EXE=C:\Pro
; For oracle
;BULK_EXE=C:\Program Files\oracle\80\Tools\Binn\SQLLDR.exe
; ==> smoBackOffice:
; Indicate if the Discovery module is installed: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[DISCOVERY]
ACTIVE=1
;TEMPORARY_TABLE_NAME=
;ACCOUNT=23865
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
DO_NOT_DELETE_TEMPTABLE=0
PDF_ACTIVE=0
PDF_TEMPLATE=A-@_LANGUAGE_@-Inventory.rpt
PDF_EXPORT=inventory.pdf
CSV_ACTIVE=0
CSV_TEMPLATE=inventory.sql
; ==> Statistics processing
; Indicate if statistics processing can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[STAT]
ACTIVE=0
; Frequency in number of minutes
DELAY=30
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; ==> Network processing
; Indicate if Network processing can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[EZVNET]
ACTIVE=0
; Frequency in number of days for running the file
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; MODE = FTP, POP3 ou LOCAL
MODE=FTP
;POP3_Host=
;POP3_UserId=
;POP3_Password=
;POP3_Port=110
;EZVNetDir=CONFIGURE THIS VALUE WHEN MODE=LOCAL
; ==> Database access parameters
; They apply to smoBackOffice and smoBackOfficeClient
[SQL Connection]
Server=EZV_SQL1
UserId=EZV_ADMIN
Password=password
BO_OWNER=EZV_ADMIN
BO_DatabaseName=EVO_BACKOFFICE
ADMIN_OWNER=EZV_ADMIN
ADMIN_DatabaseName=EVO_ADMIN
REF_OWNER= EZV_ADMIN
DateFormat=MM/DD/YYYY
[Administrator]
;Email=ReturnAddr
;SMTPHost=ReturnAddr
;SMTPUserId=ReturnAddr
;ReturnAddr=ReturnAddr
;Port=25
; ==> Preimports
; Indicate if preimports can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active (They apply to smoBackOffice and smoBackOfficeClient)
[PREIMPORT]
ACTIVE=1
SAAS=1
; Frequency in number of seconds
DELAY=300
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
[LOG]
LEVEL=0
; ==> Purge processing
; Indicate if purge processing can be run: ACTIVE (Yes=1/No=0)
; Indicate the configuration parameters if it is active
[PURGE]
ACTIVE=0
; Frequency in number of days for running the file
DELAY=1
; Start/end time for running the processes
Begin_Time=00:00:00:000
End_Time=23:59:59:999
; Indicate if a log file must be created: LOG_DEBUG (Yes=1/No=0)
LOG_DEBUG=0
; DELETE_... = n days
;DELETE_DISCOVERY_HISTORY=150
;DELETE_DISCOVERY_IN=100
[INSTALL]
VERSION=1.0