Wonderful - thanks for both of these.
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of French, Ariana
Sent: Tuesday, July 28, 2009 11:16 AM
To: [log in to unmask]
Subject: Re: TMS Bibliography module and web publishing
Depending on the context, I'll use either a UDF (e.g. in listview
queries) to concatenate strings, or in the case of our bibliography
report, a combo of Crystal Reports formulas.
Example UDF (concatenates alternate numbers):
CREATE function [dbo].[concat_altnums](@objectID varchar(50))
RETURNS varchar(200) AS
BEGIN
DECLARE @str varchar(200)
SELECT @str = COALESCE(@str + ', ', '') + altnum
FROM altnums WHERE id = @objectID and tableid=108 GROUP BY altnum
RETURN @str
END
Example CR XI formulas (concatenates bibliography-related constituents):
//@reset (place in group header)
whileprintingrecords;
stringvar x:= "";
//@accum (in details; suppress details section)
whileprintingrecords;
stringvar x;
x := x + {Constituents.DisplayName} & ", ";
//@displ (in group footer)
whileprintingrecords;
stringvar x;
if len(x) > 2
then left(x,len(x)-2) & ', '
I think I originally got the CR formulas from something I read on
Tek-Tips (tek-tips.com) - a great resource.
Ariana
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Smith, Jeffrey
Sent: Monday, July 27, 2009 3:30 PM
To: [log in to unmask]
Subject: Re: TMS Bibliography module and web publishing
Jeri,
So would I! I need a little technical help on this one - in the form of
variable arrays. When I get it figured out, I'll be happy to share.
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Moxley, Jeri
Sent: Friday, July 24, 2009 4:44 PM
To: [log in to unmask]
Subject: Re: TMS Bibliography module and web publishing
Jeff Steward -
I'd love to see an example of your use of global variables for
concatenating one-to-many. I've been reading up on this and have made
some initial attempts, but have not yet met with success.
Thanks!
Jeri
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Smith, Jeffrey
Sent: Friday, July 24, 2009 4:07 PM
To: [log in to unmask]
Subject: Re: TMS Bibliography module and web publishing
Thanks, Jeff. It's good to get this advice - we've had a 'hold' put on
our migration, and it's not such a bad thing, as I'm playing catch-up
with the more technical part of my homework!
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Jeff Steward
Sent: Friday, July 24, 2009 3:56 PM
To: [log in to unmask]
Subject: Re: TMS Bibliography module and web publishing
Hi Jeff,
We publish our bibliography cross-references to the web. Here is an
example:
http://harvardartmuseum.org/collection/detail.dot?id=1953.41%20&collecti
onID=21009&collectionItemID=21013
It is possible to concatenate items in a one-to-many relationship in
Crystal Reports using global variables. I had just worked on a report or
two that does this with constituent phone numbers. I'll pass one along
once I locate it. You might have an easier time if you shape some of the
data in SQL Views and UDFs or even in a query in a Crystal Command.
Jeff
--
Jeff Steward
Digital Information and Technology Department
617-495-0785
[log in to unmask]
Harvard Art Museum
32 Quincy Street, Cambridge, MA 02138
www.harvardartmuseum.org <http://www.harvardartmuseum.org/>
-----Original Message-----
From: The Museum System (TMS) Users
[mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey
Sent: Thursday, July 23, 2009 3:53 PM
To: [log in to unmask]
Subject: TMS Bibliography module and web publishing
Dear fellow TMS users,
I am curious to know who among you is fully using the
Bibliography module to record published references for objects, and at
the same time currently publishing (or planning to) publish these
citations to the web. The Bib. module & the way it is viewed/accessed
from the Objects module is lacking in some features, and yet seem the
best way to standardize the recording of this information.
I've been playing with Crystal reports formulas to take all this
data and concatenate it into a line which adheres to the Chicago Manual
of Style. Pretty darned difficult when you have 2 or more authors. I'm
hitting the limit on what I can do with it.
Also, how do you mark whether the link between an object and
bibliography module record is a "published reference", or a
"bibliography" one?
Thanks for any advice you can provide!
- Jeff
Jeffrey Smith
Assistant Registrar for Collections Information
Freer Gallery of Art and Arthur M. Sackler Gallery
1050 Independence Avenue SW
MRC 707, P.O. Box 37012
Washington, DC 20013-7012
www.asia.si.edu
[log in to unmask]
tel: 202-633-0348 / fax: 202-633-9770
|
