Previous page Next page


Photo export to external DBMS is performed with the help of Db_Export.exe module.

In external DBMS one should create ISS_PHOTOS table that must contain the following fields:

  1. ID ( INTEGER, Initial key) identifier of employee in ACFA Intellect
  2. EXTERNAL_ID ( INTEGER) identifier of employee in external DBMS
  3. PHOTO (BLOB)
  4. DATE_CREATED (DATE) date of photo creation
  5. DATE_MODIFIED (DATE) date of photo modification

«Personnel department» application:

  1. Export photo of employee after its selection from the file
  2. Delete photo of employee from external DBMS after removing employee
  • No labels