Ma’am;
I am not sure if you have access to the SQL backend, but if you do then you can run this query and export the results to excel. Or you can make it a view and create a list view and use it that way.
regards,
Ron Auxier
THE MUSEUM OF FINE ARTS, HOUSTON
5100 Montrose Boulevard
Houston, Texas 77006
Phone: 713-353-1509
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Diane Lee
Sent: Thursday, August 01, 2013 10:04 AM
To: [log in to unmask]
Subject: Report/Listview help?
Hello all –
Forgive me if I’ve asked this question before, but I checked the archive and didn’t see anything.
We’ve recently gotten an image server of sorts, and I’ve been updating our Media records with the current archival image information so staff can retrieve archival images as needed. The one thing that seems to be clunky is getting TMS to
spit out a list of where the archival images live. We currently have to go into each record and go through all the clicks to get to the Archival Storage tab on the filename for each one. We note the folder location of the image in the Archival Volume Name
field, and I can’t see to find a listview or report that includes this field anywhere.
So, my question is, does anyone have a report or listview (so they export to an Excel sheet) that includes this field? I am on 2010, and do not have Crystal Reports to create my own at this point. (Or am I missing an obvious shortcut??)
Any help or suggestions would be great! Thanks!
Diane.
==================================================================
Diane Lee |
Collections Manager
[log in to unmask] |
(860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105
| www.chs.org
Upcoming Events |
Membership |
Donate | Volunteer
Visit us on
Facebook and
Twitter @ConnHistSoc
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.