wiki:WikiStart

Database Machine Drawings

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=__&%'
Last modified 4 years ago Last modified on Jun 26, 2013 5:07:36 PM