Previous page Next page


Configuration of data import module is described in “Db_Import.ini” file. All facilities listed above are described in sections of the same name.

User’s task is to make SQL query to external DBMS in order to get essential information and set conformity between external data (numbers of fields in SQL query) and names of table fields of internal database.

Example. Getting information

[GET_DEPARTMENTS_MODIFIED_INFO]             ; Get information about modified departments

; This reaction has “last_sync_date” input parameter

event=UPDATE_DEPARTMENT_INFO   ; Event that is sent to core

AutoNotification=1                                        ; If > 0 then module makes this query itself once a day and it notify the core about modified departments 

SQL=SELECT STRUCT.STRUCT_ID, STRUCT.NAME FROM STRUCT WHERE  ((STRUCT.DATE_CREATED)>=%date1%) OR ((STRUCT.DATE_MODIFIED)>=%date2%));

NumberFields=2                                             ; Take only 2 fields from external Database

; Compulsory fields

NissFieldName.0=external_id                  ; Set STRUCT.STRUCT_ID = external_id compliance (field of internal table of ACFA Intellect)

NissFieldName.1=name

; The rest fields

NumberParameters=2

ParameterName.0=%date1%                   ; Parameter name in SQL query

ParameterValue.0=funDate(last_sync_date) ; Convert "last_sync_date" input parameter  into data  format (description of funDate function see in [FUNCTION]section of Db_Import.ini file)

ParameterName.1=%date2%

ParameterValue.1=funDate(last_sync_date)

  • No labels