TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Date:
Tue, 20 Nov 2007 09:32:38 -0500
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
MIME-Version:
1.0
Content-Transfer-Encoding:
quoted-printable
In-Reply-To:
Content-Type:
text/plain; charset="iso-8859-1"
From:
Luc Bissonnette <[log in to unmask]>
Parts/Attachments:
text/plain (54 lines)
Bonjour,

Well, I do not have a store proc (but you can do it) but I have  a script that will put into a defined object package the list of the new objects created last week. I took this from somebody else on this list.

What you have to do is to create an object package with TMS (public access (if you want to share it). Find the ObjectPackageID of it and modify it on this script (mine is 949). You could change the conditions with yours. And change 'XXXXXX' with your loginid




if exists(select * from objpkglist where objectpackageID=949)
delete from objpkglist where objectpackageID=949
go
Insert into objpkglist
        (ObjectPackageID, ObjectID, ObjectNumber, LoginID, EnteredDate, Notes)
select 949, Objectid, Objectnumber,
        'XXXXXX', GetDate(), null from objects where objectid in
(select objectid from Objects
where objectnumber in ('PH1986:0901:001-045', 'MP002', 'PH1986:1189')) 
go


Good luck


Luc Bissonnette
Bibliothécaire des systèmes/Systems Librarians
Gestionnaire des systèmes des collections
Centre Canadien d'Architecture/Canadian Center for Architecture
Montréal, Québec
H3H 2S6
Téléphone: 514-939-7001 #2616
Télécopieur: 514-939-7020
[log in to unmask]




-----Message d'origine-----
De : The Museum System (TMS) Users [mailto:[log in to unmask]] De la part de Laurie Soures \\ Eoj
Envoyé : 19 novembre 2007 16:49
À : [log in to unmask]
Objet : Create Object Package from File?

Hello.

Has anyone created a stored procedure that would create an object
package given a list of object numbers from a file?

Thanks,
Laurie Soures
Manager of Collections Information
George Eastman House
Rochester, NY 14607

ATOM RSS1 RSS2