Michael, Gillian, and Kate, Thank you very much for each of your responses. All of this info will be very helpful. I may send you follow-up inquiries off-list. Best, Anita On Mon, Jan 24, 2011 at 10:03 AM, Kate Blanch <[log in to unmask]>wrote: > > > *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]* <[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 > > [image: Twitter logo] <http://twitter.com/walters_museum> [image: > Facebook logo]<http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/6634368191?ref=ts> > [image: Flickr logo]<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) > > > > *[image: LISTSERV mailing list manager]* <http://www.lsoft.com> > > *[image: 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)*<#12db88d244851a71_S1>(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> > > *[image: Powered by the LISTSERV Email List Manager]*<http://www.lsoft.com/products/listserv-powered.asp> > > >