Hi Anita, the data that populates our Online Collections website is
pulled from a SQL Server database that is refreshed nightly with TMS
data. The refresh is automated and requires no human intervention. We
are in the process of a major website overhaul - the current site was
written in .NET but it is being re-designed in PHP. Data will be pulled
from our "middle-man" SQL Server database into the web server's MySQL
database (housed on a Unix server) on a nightly basis. We built the SQL
Server database in-house that contains the relevant TMS data and
necessary data transformations. The web designers we contracted with are
programming the part of the process whereby data is pulled into the web
server's MySQL database nightly. Related media is transported to the web
server via a PHP utility which was crafted by the same web design firm. 

 

I'd be happy to share more details offline if any of this is of interest
- budget, data flow, techinical details. We don't have a blockbuster
budget, and have done a lot with limited means. Our on-staff web manager
can read and program in PHP so will be able to support the new site to a
much greater capacity than the old .NET site. That was a key component
in spearheading this project. 

 

All the best!

 

 

Kate Blanch

Administrator, Museum Databases

[log in to unmask] <mailto:[log in to unmask]>  / 410.547.9000
ext. 266  

 

The Walters Art Museum

600 N. Charles Street, Baltimore MD 21201

www.thewalters.org <http://www.thewalters.org/> 

Beasts on Parchment: Picturing Animals in Medieval Manuscripts
<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1770>
November 6-February 13

German Drawings from the Walters' Collection
<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1769>
November 20-February 13

Treasures of Heaven: Saints, Relics and Devotion in Medieval Europe
<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1568>
February 13-May 15, 2011

  <http://twitter.com/walters_museum>     
<http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/66343
68191?ref=ts>     
<http://www.flickr.com/photos/walters-art-museum/sets/> 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of TMSUSERS automatic digest system
Sent: Friday, January 21, 2011 5:00 PM
To: [log in to unmask]
Subject: TMSUSERS Digest - 20 Jan 2011 to 21 Jan 2011 (#2011-8)

 

LISTSERV mailing list manager <http://www.lsoft.com> 

LISTSERV 16.0 <http://si-listserv.si.edu/cgi-bin/wa?LIST=TMSUSERS> 

 

 


TMSUSERS Digest - 20 Jan 2011 to 21 Jan 2011 (#2011-8)


Table of contents:


*	Website Collections Searches (but NOT eMuseum) (3) 

1.     Website Collections Searches (but NOT eMuseum)

o    Website Collections Searches (but NOT eMuseum) (01/21)
From: Anita Heggli <[log in to unmask]> 

o    Re: Website Collections Searches (but NOT eMuseum) (01/21)
From: "Michael T. Black" <[log in to unmask]> 

o    Re: Website Collections Searches (but NOT eMuseum) (01/21)
From: "Michael T. Black" <[log in to unmask]>

 

Browse the TMSUSERS online archives.
<http://si-listserv.si.edu/cgi-bin/wa?LIST=TMSUSERS> 

Powered by the LISTSERV Email List Manager
<http://www.lsoft.com/products/listserv-powered.asp>