= Database Machine Drawings =

 * Website URL: http://dmd.mpiwg-berlin.mpg.de/home
 * Server: xserve02a.mpiwg-berlin.mpg.de
 * Port: 38080

== Workflows ==

=== Updating the Online Databases ===
 * ded
    - Open the database which is to be uploaded, in Filemaker Pro
    - Go to "Datensätze / Alle Datensätze anzeigen"
    - In the menu, press Ablage/Datensätze exportieren...
    - In the new dialog choose XML as Typ and enter a filename and location you'll remember
    - As Grammar select FMPXMLRESULT and press ok
    - In the new dialog press Alle kopieren
    - Make sure that 'Ohne Formatierung' is selected and click Exportieren
    - Next, go to http://dmd.mpiwg-berlin.mpg.de/admin and click upload ded-Table
    - Click on Browse..., select the xml-file you previously created and press Open
    - Finally, click upload.
    - Also on http://dmd.mpiwg-berlin.mpg.de/admin , go to "File Server" and upload your Filemaker File of the current Database.

  * Literatur
    - Open the database which is to be replaced, in Filemaker Pro
    - Go to Datensätze / Alle Datensätze anzeigen
    - In Scripts, run the shortref script to generate the reference-column
    - In the menu, press Ablage/Datensätze exportieren...
    - In the new dialog choose XML as Typ and enter a filename and location you'll remember
    - As Grammar select FMPXMLRESULT and press ok
    - In the new dialog press Alle kopieren
    - Make sure that 'Ohne Formatierung' is selected and click Exportieren
    - Next, go to http://dmd.mpiwg-berlin.mpg.de/admin and click upload literatur-Table
    - Click on Browse..., select the xml-file you previously created and press Open
    - Finally, click upload.
    - Also on http://dmd.mpiwg-berlin.mpg.de/admin , go to "File Server" and upload your Filemaker File of the current Database.


  * current (26.6.2013) SQL fix for digilib-Links in Sevilla MS:
    - {{{update ded set translations = regexp_replace(translations||'\n', '(http:.*?)pn=(\\d{1})&(.*)\\n', '<a href="http://dmd.mpiwg-berlin.mpg.de/dmd/database/dmdlib?id='||picture_id||'&fn=/permanent/library/HNS20WZU/pageimg/000\\2&\\3" target="_blank">Scan No \\2.</a>\n','g') where translations like '%&pn=_&%'}}}
    - {{{update ded set translations = regexp_replace(translations||'\n', '(http:.*?)pn=(\\d{2})&(.*)\\n', '<a href="http://dmd.mpiwg-berlin.mpg.de/dmd/database/dmdlib?id='||picture_id||'&fn=/permanent/library/HNS20WZU/pageimg/00\\2&\\3" target="_blank">Scan No \\2.</a>\n','g') where translations like '%&pn=__&%'}}}