Mia has for some time been using an elaborate, Access-based process to draw data from TMS, transform it via a variety of algorithms (based on curatorial department, purpose, etc.) and then export it into Quark for the person who generates our physical labels. Of course, not everyone works directly from TMS. Some prefer to work in Word and then our challenge is getting the final content back into TMS. We have found since going to TMS2012 that Access can handle our Unicode content (lots of Japanese characters, etc.), but cannot successfully export it. This is a big problem for us, but inherent in Access, so we cannot fix it to our knowledge.

Our DBA and our label producer have been looking at software (mentioned some years ago at a Collective Imagination conference) that promises to enable us to pull content from the TMS SQL back end directly, and use something like a mail merge to load it into InDesign templates. This would both solve our Unicode problem and get our designer out of Quark and into InDesign. If you would like more details I can put you in touch with our dba (though I have also forwarded your email to him and he may reply separately.)

Cheers,
Frances

On Wed, Sep 21, 2016 at 4:00 PM, TMSUSERS automatic digest system <[log in to unmask]> wrote:

There is 1 message totaling 120 lines in this issue.

Topics of the day:

  1. Gallery Wall Labels from TMS

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

----------------------------------------------------------------------

Date:    Wed, 21 Sep 2016 10:53:43 -0400
From:    Karen Hines <[log in to unmask]>
Subject: Gallery Wall Labels from TMS

Hi All,

We would like to be able to generate our gallery wall labels directly from
TMS. Currently they are being set in InDesign manually by our
administrative assistant, based on content from TMS or sometimes from a
word checklist provided by a curator. Labels are then proof read by our
curators. After they are proofed the content is then cross-referenced in
TMS and any appropriate data changes are input into TMS.

I am very interested in hearing what types of processes other folks are
using to generate gallery wall labels directly from TMS. Also, if there is
a way to export/import data from TMS to InDesign. We are currently on TMS
2010, but will be upgrading soon up through to 2016, so input from anyone
using any of these version would be great. We are just looking to
streamline our process and as well as make sure that appropriate data
changes to content get made in our database.

Any suggestions would be great and much appreciated!

Many thanks,
Karen

*Karen Casey Hines* Associate Registrar* Frances Lehman Loeb Art Center *

*Vassar College *Box 703, 124 Raymond Avenue, Poughkeepsie, NY 12604* | T*
845.437.5249* | **F*845.437.5955* |* *http://fllac.vassar.edu/
<http://fllac.vassar.edu/>*

September 2 - December 18, 2016* Celebrating Heroes: American Mural Studies
of the 1930s and 1940s from the Steven and Susan Hirsch Collection*

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

------------------------------

End of TMSUSERS Digest - 17 Sep 2016 to 21 Sep 2016 (#2016-142)
***************************************************************

--

Frances Lloyd-Baynes  |  Content Database Specialist
Minneapolis Institute of Art
2400 Third Avenue South
Minneapolis, MN 55404

612-870-3189  |  [log in to unmask]  |  www.artsmia.org

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.