290 likes | 456 Views
Using EMu for the new M-Shed museum. Bristol Museums, Galleries and Archives. Bristol Museums, Galleries and Archives. City Museum & Art Gallery. The Georgian House. The Red Lodge. Blaise Castle House Museum. M Shed. A Multi-disciplinary Collection. Applied Art Archaeology Biology
E N D
Using EMu for the new M-Shed museum Bristol Museums, Galleries and Archives
Bristol Museums, Galleries and Archives City Museum & Art Gallery The Georgian House The Red Lodge Blaise Castle House Museum M Shed
A Multi-disciplinary Collection • Applied Art • Archaeology • Biology • Community History • Eastern Art and Culture • Ethnography and Foreign Archaeology • Fine Art • Geology • Industrial and Maritime History • Social History + • Photographic Collections • Multi-disciplinary Handling Collection
EMu’s Role within the Organisation To be the central repository and management mechanism for all collections related information for the museum service. To provide collections related content for publication via the museum’s website and through gallery-based ICT and wireless technologies, as well as being used in capturing and re-publishing content generated by our users.
M Shed • Opened June 2011 • Cost - £27 million • Development of a 1950s dockside transit shed, retaining the building’s original industrial nature whilst providing facilities fit for a leading modern museum. • History of the city from prehistoric times to the present day • High community involvement in development of the museum • 2000 objects on display • Working dockside cranes, boats and railway • Free entry!
M Shed Website – Theme http://mshed.org/
Hierarchical record structure via Sub Narratives Theme 15 SubTheme 59 Display 84 Story 278 Object 573
EMu modules - attachments IMAGE OBJECT Rights Multimedia Locations Catalogue Accession lots Object Object-level interactive screen display Story Display Narratives
EMu modules - attachments IMAGE OBJECT Rights Multimedia Locations Catalogue Accession lots Object Object-level interactive screen display Story Display Narratives
Creating the records and structure • Time pressure • Staff prioritising writing content (not building it) Data Import • Created the upper levels of the hierarchy manually in EMu • Decided to import story and object data • Simple Excel template • Data re-formatted into a .csv file and imported • Two stage import process Constraints • XML would not work if attachment structure was wrong – kiosk crash
Story and Object Excel templates – used by curators Story Object
Import sheet format append Master Narrative: irn Main text: HieChildNarrativesRef_tab(+).NarTitle Catalogue irn: HieChildNarrativesRef_tab(+).ObjObjectsRef_tab.irn Multimedia irns
Field mapping by record level EMu Website Theme Sub- Theme Kiosk Display Story Object
Progress so Far • Over 1000 narratives records published to web / kiosks • Staff trained to create the records directly in EMu • User generated content popular Future • Import of user generated content • Updating navigational shards • Snagging sessions Challenges • Simple structure but scaled up makes a lot of data • Staff training • Constraints • Data cleaning / analysis…
Data analysis – Character checking / formatting • Each narrative field exported to a column in Excel • Formula columns check and reformat the data • Conditional formatting and autofilter to highlight errors Exported data Replace non AscII characters Same or Different? Import Excel Formula: “=SUBSTITUTE(‘OLD TEXT’, ‘TEXT TO FIND’, ‘NEW TEXT’)” Actual formula used… ”=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F4,"*","),"‘","'"),"","'"),"",""""),"",""""),"–","-"),"…",$S$1),"’","'")"),"‘","'"),"","'"),"",""""),"",""""),"–","-"),"…",$S$1),"’","'")”
Multimedia import file generator : Excel + Visual Basic Input Path to folder of images Title Rights Creator Keywords Output .csv file ready to be imported in EMu