Bonjour Glenn,
 
This is my first posting to this list. 
 
The following will erase the credit line existing in those records and replace it with you new Credit line.
 
When I have to do things like this, I do the work at the SQL level. 
ATTENTION : BEWARE : You can damage and loose data if you are not familiar with SQL. Proceed with EXTREME
care...
 
 
A) Create an object package with a name and put your 800 objects in it.
 
B) at an sql prompt, find the ObjectPackageID of your object package with the following:
select * from dbo.ObjectPackages where Name like 'name that you gave before'
 
The first column is the ObjectPackageID. Note that number.
 
Then, do the following:

update objects
set CreditLine = 'YOUR CREDIT LINE TEXT'
where objectid in
 (select objectid from dbo.ObjPkgList where ObjectPackageID = "The objectpackageid that you find in the preceding request")
 
/* Replace "The objectpackageid that you find in the preceding request" with the number without " "   */
 
Hope this help
 
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 Glenn Fye \\ eoj
Envoyé : 4 décembre 2006 13:52
À : [log in to unmask]
Objet : Re: Adding or Editing Multiple Entries



Hi Everyone, 

Has anyone had success with doing gang entries to data fields. I would;like to enter a credit line to a group of 800 plus objects in a group. 

Thanks, Glenn 

Glenn Fye 
Photoarchivist 
Albuquerque Museum