comes from AdLib collection management software and is better structured
- see [^Rembrandt Database 2-23-09.pdf] for a description of this project
- We got 2 sample XMLs (a record list and an individual record about a painting. Still don't have the schema
- tags are in Dutch but often there are English comments following; and a dictionary will help understanding
- many values are bilingual
We're starting work on the www.ResearchSpace.org project for the British Museum. One of the tasks is to convert the Rembrandt project database to CIDOC CRM and import it to ResearchSpace. Dominic Oldman (IS Development Manager of BM) sent us some sample records from Rembrandt (attached), and I noticed they are exported from your system: the root is <adlibXML>.
- are you involved in the Rembrandt project, or they only use your system?
- We are involved in the Rembrandt project. We made the UI for the web application and RKD have used our software to create the RKD technical database. The RKD technical database is a database that has been created by the RKD themselves and has been used as the basis for the Rembrandt database. It is currently hosted at the RKD. From our side a programmer has worked on this who has left in the meantime. His colleague Ilya Gorbylev i.Gorbylev@adlibsoft.com has taken over his responsibilities in this project.
- could you send us the schema of the Rembrandt XML export?
- The RKD can send you the data dictionary of the database. Then you can also see if all the tags have translations. Furthermore you can probably access the data through the Adlib API online. The RKD must open their system to allow you access. Using the API you can query the live system and get data out of it (rather than exporting). Technical information on the API can be found on api.adlibsoft.com
- would it be possible to export using English tags? (We don't speak Dutch). There are English XML comments in the file (very useful) but the conversion will be more robust if the tags are in English.
- Sure, but that’s up to the RKD to decide.
- does AdLib have conversion/export to some standard format (e.g. LIDO) that can be used by Rembrandt? It would be higher value to BM if we develop an import from a standard format.
- We do support LIDO for object information and have a standard output format for our Adlib Museum System. But as I already have explained the Rembrandt database has been created by the RKD itself. As such it does not map to LIDO using our Standard XSLT transformation. Again, this is up to the RKD to change this.
Thanks in advance for your cooperation and best regards!
- No problem, please let me know if you need more help or information
I've simplified the XML sample record to a table for easier comprehension, by using (all hail!) Emacs and these commands:
|M-%||query-replace||</.*?>||remove closing tags|
|C-u C-x C-o||my-delete-blank-lines||remove empty lines|
|M-%||query-replace||><||> <||add a space here: <empty-tag/><!-- English comment>|
|M-=||query-replace-regexp||^(TAB*)||\,(format "%dTAB%s" (length \1) (make-string (length \1) ?-))||replace leading tabs with N (tag level) and leading dashes (to conserve space while still showing the hierarchy)|
|M-=||query-replace-regexp||>(.*)(<!-- (.*) -->)||> \3TAB\1||move English comment right after the tag, put element content in new column|
|M-=||query-replace-regexp||>([^ ])||>TAB\1||put remaining element contents in new column|
I've reduced the sample by leaving only 1 instance of each element. In many cases I merged elements so the remaining one has all possible sub-elements (which may lead to non-sensical data, eg begindatum_in_collectie>einddatum_in_collectie).
This can be used as the frame on which to discuss and later describe the CRM mapping