Workshop Egbert

Installation

1. The compatibility problem of the FDT, FST, FMT and other database-definition files which use the dhtmlxgrid has been solved. The 'grids' did not display correctly in non-Firefox or non-IE browsers. A new dhtmlxgrid library is used which now works correctly in all actual browsers.
   Modified scripts : fdt.php, fdt_short_a.fdt, fst.php
   The folder dataentry/js/dhtml_grid now contains new scripts and style-sheets.
2. The similar compatibility problem of the FCKEditor is solved by changing it for the newer CKEditor. A folder ckeditor under central is created with the required components for using the new version. This affects the worksheets where a field type HTML AREA is used but also the helpfiles for fields and the online help.
3. The file config.php reads the general parameters of ABCD. Since this file also contains the paths or key access parameters, it cannot be changed each new installation. Therefore the additional script config_extended.php is created with extra parameters, also allowing individual database-related settings.

For this additional settings to be included the file config.php  needs to contain the following code :

  if (isset($arrHttp["base"])){
     if (isset($def[$arrHttp["base"]]))
         $cisis_ver=$def[$arrHttp["base"]]."/";
  }
  
  
  //***
  //Include config_extended.php that reads configuration parameters that applies to the selected database
  if (file_exists(realpath(dirname(__FILE__)).DIRECTORY_SEPARATOR."config_extended.php"))
      include (realpath(dirname(__FILE__)).DIRECTORY_SEPARATOR."config_extended.php");
  //***

So, copy in the script config.php de group of instructions in red, after the last instruction in blue. In the script script config.php of new ABCD-distributions this code is already included. </span></span></p>

The script config_extended.php read the file dr_path.def located in the folder of the active database and replaces the corresponding parameters in config.php for the specific database.  

Pop-up help for database fields (tooltips)

• An option ´Tooltips for help on database fields' is implemented in the menu Update database definitions which allows to deifne help-texts on database fields in the format of a pop-up text-box. (see Pop-up helptexts on database fields)

Ayudas emergentes

Example Ivic

• The file to import the tooltips can be found in C:\bases_abcd\IVIC

Revision of the permitology

Ver [Opciones de permisología]

New field types for data-entry

Combo Box

There can be 2 types : normal and 'read-only'. In addition the table can be filled in from a TXT file or from a database-index. In this last case it is recommended that the number of terms retrieved does not exceed 200 since all indexed terms with the same prefix need to be read before the list in the combo box can be constructed. Therefore only 200 terms starting with the given prefix will be read.

From an external text-file (txt)

Combo box

Combo Box solo lectura

From a database

Combo box

Combo box solo lectura

Select read only

In previous versions with a field using an authority list coming from a database, it was not allowed that the receiving field is read-only, so that operators could fill in any other values not taken from the authority list. Now a new field type named SELECT READ ONLY is added which is linked to a dictionary list but not allowing other values than taken from the list.

Select simple solo lectura

Select múltiple solo lectura

FDT con las diferentes opciones de campos de selección

Protection of records

Two new field types are introduced to protect a record :

Protect record

When this field is present, a password prompt will be requested in order to access the record for editing/deleting. This password is the same for all records en is to be added in the column for the "default value' in the FDT. It won't be stored in the records themselves. It is possible to create a separate protection password for each worksheet created in ABCD. This field is presented as a small tick-box which indicates whether the record is protected or not.

Record password

This alternative type of protection allows the operator who creates or edits a record to assign an individual password for protection of that specific record.

In this case the password will be stored inside the record. When the password field is not empty, the password will be requested.

When editing a protected record, ABCD will present a dialog-box asking for the password and will allow edition when this matches the protection key for both methods.

In order for this to work correctly it is necessary to update the message-tables 00 with the permitology options in the profiles.tab stored in the folder par/profiles. Note : If the user is system administrator or has database administration rights, or has rights to edit protected records, the password will not requested. Example dialog-box to request password : Archivo:Protect record.png

Ejemplo: Base de datos de registro de usuarios gascencio isis_

dbadmin adm

Protecting a database

With this option a database can be protected from being initialized, restored or deleted by accident. For this a file protect_status.def needs to be written into the root-folder of the database, containing the word PROTECTED. All scripts pertaining to deletion, initialisation and restoration a database will check the existence of this file and if present the requested action will be cancelled.

This file will be deleted when un-protecting a database.

Ejemplo

Performing searches in the operators database

An option to search in the system operators database is implemented.

See Búsquedas por nombre en la base de datos de operadores.

Ejemplo

New options for record validation

Up to version 1.5 record validatoin was performed in the server using a validation format definition. From version 1.5 on it is possible to define validation conditions in the FDT which will be executed directly in the client using a javascript before de data are sent to the server.

Validación de registros utilizando un javascript

ABCD will construct in a dynamic way the necessary JavaScript code which will execute the validation before sending data server-side.

Cataloging

1. An option to searc directly form the toolbar is addded. (See Búsquedas)
2. Perform cross-searching by author, topics etc. within the ABCD Central module.
3. Perform cross-searching by author, topics ect. opening a new window showing results in iAH
4. Present in a windows records related to the active database
   Example: Link a database of institutions with its courses
   Example: A simple cardex for periodicals
5. A possibility to define higher levels of security for operator passwords is included. See: Definición de parámetros para seguridad de claves
6. A link to show/hide passwords during editing it is included.
7. A new attribute in the ABCD operator profiles is added to restrict actualisation of the picklists and authority files during record edition. Adding the attribute in the table par/profiles/profiles.tab with contents ACTPICKLIST=Y just before the line [ADMINISTRATION] is required.. Subsequently edit the existing profiles to enable/disable this attribute./li>
8. The file in which previous search statements are kept can now be edited (pfts/{lang}/search_expr.tab). In addition a new attribute in the user profiles is created which defines access or not to the edition of stored searches. This can be done using a link which is shown in the advanced search form. The attribute EDITSTOREDEXPR in the profiles table par/profiles/profiles.tab is created to enable/disable this option in the user profiles. Again this new attribute should be put before the section [ADMINISTRATION]
   See Permisología de los operadores de ABCD
9. When showing a search result, a link is now given to see the FDT, FST and the prefixes of the advanced search form.
10. When editing the picklists, it is possible to :
    • Select a group of rows and move them into another position
    • Sort the table by the first column
    • Sort the table by the second column
11. A possibility to select records when browsing a database or search results is now available. In the menu 'browse by' a new option to select or unselect the selected-records option is added.
12. Selected records can be printed or exported when using the toolbar for these options. In the section of records to print or export now a text-box with all MFN's selected is shown, separated by comma. This option is also available in the free search section.
13. In the free search function now a PFT, defining conditions, can be used to select records. See Búsqueda libre

Thesaurus

See: Tesauros

Ejemplo

Printing labels and barcodes

(See Etiquetas)

Utilities

• In the utilities menu the following options have been added :
1. Duplicate a database using the commands for copying of the operating system
2. Duplicate a database with compacting of the database, eliminating the deleted records physically. This options uses the Mxcp utility of CISIS
3. Read a database with the MX utility of CISIS without needing all database definition files of ABCD
4. Replace a database by its corresponding copy created by the duplication option

Using these options a database can be 'reorganized' (=physically shrinked and optimized) For more information check : Copiar la base de datos, Leer base de datos con MX, Restaurar base de datos y Reorganizar la base de datos

• The option Full Inverted File generations with MX is improved by adding the possibility to read a file with re-directions of paths for the resources used in the process (cipar). See Generación de la lista invertida con el MX
• An option to read a database with MX is added. Now also ISO-files can be read directly.
• An option to export a database using MX is added.
• The option to link a catalog database to the copies-database is again restored in the utilities menu.

Circulation and loans

1. An option to send out reminders by e-mail is added.
   See: Envío de recordatorios por correo electrónico
   
2. A clearing receipt ('no pending issues in the library system') can be printed from the 'user status' page.
   See: Impresión de solvencia
   
3. New loans option for items without 'object type' info.
   See: Días de préstamo/renovación]
   
4. New option for loans with on-the-spot definition of number of days or renewal duration.
   See: Días de préstamo/renovación
   
5. In the configuration file Abcd.def the following new parameters have been added :
   RESERVATION=Y/N to show/hide reservation options
   AC_SUSP=Y/N to modify the way how the initial suspension date is defined.
6. When a copy is returned which holds a reservation and the object type has the reservation option active, the copy will be directly assigned to the first user in the waiting list and this assignment will be shown in a sub-window.
7. The calculation of the renewal time-window is adjusted taking into account the waiting list.

IAH

1. End-users now can check their user-status from the iAH OPAC. (see Estado de cuenta en línea). Also online reservations are now available. (see Renovación en línea).
2. Online reserbation option now active (see Reserva en línea)
3. A mechanism to highlight search terms is now active, see : IAH Incluir un javascript para resaltar los términos de búsqueda
4. The editor for the DBN.def file to configure iAH for the current database is improved. Now a file isisuc.tab for correct upper-case conversion is added. (e.g. problems were noted with Ñ since iAH by default converted to N). The DBN.def configuration file checks if there is a file isisuc.tab inthe folder data of the database. If found it will be activated as uppercase conversion. If not found, it will be searched in the database foot-folder (ABCD/www/bases) and used from there.
5. New parameters have been added in the file abcd.def to customize the windows for user account status, neweal and online reservation.
6. The presentation of the reservations of a title has been changed : no longer the details of the waiting list but only the total number of reservations is shown.
7. A possibility to have the IP-number from which the search-request is launched determined from a PFT is available and documented Detectar el IP desde el cual se accede a la consulta de la base de datos

Customization of ABCD Central

An extra optional button can be added to the main Central menu and local or extra functions can be added there. Agregar un botón propio para acceder un menú con scripts desarrollados localmente

Modificar la página de inicio