Jeff,
Was your access DB "flat" (like a spreadsheet) and requiring mapping
mainly to the objects table... or did it include constituent and other
data which would require look ups to identify and link existing
records to the newly created object records?
Thanks,
Laurie Soures
Manager of Collections Information
George Eastman House
Rochester, NY
----- Original Message -----
From: "Smith, Jeffrey" <[log in to unmask]>
Date: Monday, November 5, 2007 4:07 pm
Subject: Re: Developing exhibitions outside of TMS
To: [log in to unmask]
> We hired a contractor to write the app - which is VB code inside an
> access database & uses an Access form as the interface to
> establish the
> ODBC connection and other set-up commands. Feel free to call me, I
can
> give you the programmer's information if you'd like.
>
>
> Jeffrey Smith
> Assistant Registrar for Collections Information
> Smithsonian Institution
> Freer Gallery of Art and Arthur M. Sackler Gallery
> 1050 Independence Avenue, SW
> MRC 707, P.O. Box 37012
> Washington, DC 20013-7012
> tel:202-633-0348
> fax:202-633-9770
> [log in to unmask]
>
>
>
> ________________________________
>
> From: The Museum System (TMS) Users [mailto:TMSUSERS@SI-
> LISTSERV.SI.EDU]On Behalf Of Rob Morgan
> Sent: Monday, November 05, 2007 2:50 PM
> To: [log in to unmask]
> Subject: Re: Developing exhibitions outside of TMS
>
>
>
>
> Hello Jeff,
>
> I have data in a flat-table, Access database that has information for
> 9000 catalog cards. I would love to get this data into TMS.
>
> You stated that "each project gets its own . . . database and when
the
> records are ready, they are imported into TMS via an application
> designed for the purpose." What is the application that you're
> using to
> import this data into TMS?
>
> Thanks,
>
> Rob Morgan, Baltimore Museum of Art
>
>
>
> From: The Museum System (TMS) Users [mailto:TMSUSERS@SI-
> LISTSERV.SI.EDU]On Behalf Of Smith, Jeffrey
> Sent: Thursday, November 01, 2007 5:10 PM
> To: [log in to unmask]
> Subject: Developing exhibitions outside of TMS
>
>
>
> The Freer-Sackler has been using FileMaker Pro 8 and a template
> databaseapproach to allow curators to collect all the information
> needed for
> loan objects in TMS. Each project gets its own FMP database and
> when the
> records are ready, they are imported into TMS via an application
> designed for the purpose. The data structure of each FMP database
> closely matches that of TMS.
>
>
>
> This helps solve the age-old problem of making sure all the data
> neededfor functional TMS records is complete, and puts the onus on
> the curator
> to gather everything needed, plus it's great to avoid a second
> round of
> data entry. But it doesn have its limitations.
>
>
>
> I would like to know how others are dealing with this problem,
> especially since TMS isn't designed for exhibition development. Also,
> are others cultivating the information in an outside database, and
> thenimporting into TMS? If so, how are you doing it?
>
>
>
> Are there good project-management tools that handle all the needs of
> curators, publications dept's and registrars for pulling needed
> data and
> related images together?
>
>
>
> I'm curious to hear how others are dealing with this issue - thanks!
>
>
>
>
>
>
>
> Jeffrey Smith
> Assistant Registrar for Collections Information
> Smithsonian Institution
> Freer Gallery of Art and Arthur M. Sackler Gallery
> 1050 Independence Avenue, SW
> MRC 707, P.O. Box 37012
> Washington, DC 20013-7012
> tel:202-633-0348
> fax:202-633-9770
> [log in to unmask]
>
>
>
>
|
