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