Hello List,

 

We have a related issue. In order to export the TMS data to Yale Press for importing into InDesign for the Catalogue Raisonné, we developed a Crystal report that pulls from all the tables required to produce completely formatted catalogue entries. This includes all of the italics and quotation marks and bold formatting for the bibliography entries. We would like for this biblio data – fully formatted – to be available for eMuseum. In TMS, the data is there but not the formatting. The Crystal report does that on the fly, based on a very complex set of criteria triggered by many fields we have co-opted for that purpose. We can’t put all that code into the eMuseum export, so we were hoping to come up with a method of exporting the formatted Crystal report data to EXCEL and then importing it back into TMS, putting it in a field (e.g. text field) that could be easily exported to eMuseum without losing the formatting. The Crystal report and the export to EXCEL and the re-import back into TMS work just fine, but the formatting gets lost.

 

Apologies for the geekiness of what follows:

 

We have gotten the formatted data into EXCEL and then used the =CONCATENATE command to build SQL statements that load the data back into TMS. The export from Crystal into EXCEL keeps all the formatting intact. We have handled all the double and single quotes successfully (thanks to some wacky N’Unicode’ instructions from Brian), but the text data loses the formatting when copied from the EXCEL cell into which it was exported into the cell built by the =CONCATENATE statement. Interestingly, if you copy a whole cell by clicking on the cell and doing a CONTROL-C, the formatting comes along with the text. If you copy all or some portion of the contents of a cell, however, and paste it into another cell, the formatting goes away. The =CONCATENATE command does the latter, unfortunately.

 

If anyone has thoughts about getting to the next step with this I would be grateful.

 

Dick

 

Richard Grant

Executive Director

Richard Diebenkorn Foundation

3214 College Avenue

Berkeley, CA 94705

510-428-1400

510-459-4556 (mobile)

 

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Eckert, Ian
Sent: Wednesday, September 21, 2016 2:31 PM
To: [log in to unmask]
Subject: Re: TMSUSERS Digest - 17 Sep 2016 to 21 Sep 2016 (#2016-142)

 

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.

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.