Created: 2012-03-22 09:12
Updated: 2019-03-07 11:08


dump - this directory contains xml and sql data as retrieved from database via mysqldump


ACHTUNG: Folgende Skripte an die aktuell zu importierende BL-Nummer anpassen (z.B. 'XIII'):

  • bl_bibliography_export.sql
  • compilation_page_export.sql

After the print release the actual page numbers can be exported in order to import them into Aquila HGV (and then form there into FileMaker HGV and EpiDoc HGV)

(a) Go to

cd /Users/Admin/

(b) and call script


(c) Import into FileMaker manually

see point (4) below

The script comprises the following steps:

(1) Export page numbers from production database bl

mysql -u bl -p < compilation_page_export.sql > compilation_page_import.sql

(2.1) Import into Aquila HGV development

mysql hgv_dev -u hgv -p < compilation_page_import.sql

(2.2) respectively, import into Aquila HGV production

mysql hgv -u hgv -p < compilation_page_import.sql

(3) Export bl bibliography from mysql hgv (field bl)

mysql -u bl -p < bl_bibliography_export.sql > bl_bibliography_import.csv

(4) Manually import bl bibliography into HGV FileMaker


Menu > Ablage/File > Datensätze importieren/Import > Datei/From File



Dann verwende folgende Einstellungen:

  • Bestehende Datensätze Abgleichen
  • Erste Zeile ignorieren, enthält Feldnamen
  • TMNr_plus_texLett = Abgleichfeld
  • BL = einziges Importfeld


Danach nicht vergessen, die Datensätze als aktualisiert zu markieren (Feld last_modified)

Cookies help us deliver our services. By using our services, you agree to our use of cookies Learn more