Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current  |   View Page History

comes from AdLib collection management software and is better structured

There are currently no attachments on this page.


  • 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

AdLib Correspondence

20110917 Vladimir to Bert Degenhart Drenth cc BM, SSL, Mariana
We're starting work on the 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>.

So I have some questions:

  • are you involved in the Rembrandt project, or they only use your system?
  • could you send us the schema of the Rembrandt XML export?
  • 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.
  • 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.

Thanks in advance for your cooperation and best regards!

Sample Record Analysis

Full Sample Record

I've simplified the XML sample record to a table for easier comprehension, by using (all hail!) Emacs and these commands:

key command from to explanation
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


Reduced Sample Record

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

viewxls: The viewfile macro is unable to locate the attachment "rdb-sample-reduced.xls" on this page
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.