Hi All,
We built a Crystal Report that our users export from TMS and save as a
CSV. Our Graphics department then imports the CSV into an InCopy label
template, which adjusts the formatting based on Department/Classification
and is used to print our wall labels.
I'm also interested to hear how other institutions manage this process.
Best,
Ian
On Wed, Sep 21, 2016 at 5:16 PM, Frances Lloyd-Baynes <
[log in to unmask]> wrote:
> 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.
>
--
*Ian Eckert*
Manager, Collection & Exhibition Technologies (CE-Tech)
*The Museum of Modern Art*
11 West 53rd Street New York, NY 10019
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.