14.3.2 Calling a program during scanning

You normally always use Field name=Value followed by a colon before the next entry. In addition to fixed fields, you also have the script option. Here, the relevant program is called after each page that is scanned.

This program is transferred via the command line to the file number, host (computer), database, user and password of the active file. The program can then register in the system and carry out specific post processing activities. For example:

#!/usr/bin/perl

my ($host,$db,$user,$pwd,$lnr) = @_;
use DBI;
my $dns = "DBI:mysql:host=$host;database=$db;";
my $dbh = DBI->connect($dns,$user,$pwd);
if ($dbh) {
  my $sql = "select client from archive where file number=$lno";
  my @row = $dbh->selectrow_array($sql);
  my $sql1 = "";
  if ($row[0] == 300) {
    $sql1 .= "Owner='HHWRW'";
  } elsif ($row[0] == 100) {
    $sql1 .= "Owner='KISRW'";
  }
  if ($sql1 ne "") {
    $sql1 = "update $db.archive set $sql1 where file number=$lno"
    $dbh->do($sql1);
  }
}

The above script adjusts automatically to the 'Owner' field if the 'Client' field adopts a value of 100 or 300.

The corresponding script was entered here, for example, with auto.pl in the input fields. It must be stored under the following path in the ArchivistaBox:

/home/data/archivista/cust/autofields/auto.pl

Image tip : Logically, the scripts are linked with the barcode recognition in the input fields. You even can administrate the jobs in WebAdmin, see 21.