Thanks. I will forward this to somebody whom I hope will understand ☺
Kind regards,
Mette
Fra: The Museum System (TMS) Users [mailto:[log in to unmask]] På vegne af Chad Petrovay
Sendt: 20. oktober 2015 15:30
Til: [log in to unmask]
Emne: Re: Wrong photo being shown
Are you filtering on MediaXrefs where TableID = 108?
The MediaXrefs table uses the combination of the ID and the TableID to identify which images are associated with which records. The combination of the ID = ObjectID and TableID = 108 will connect to object images, and ID = ReferenceID and TableID = 143 will connect to Bibliography records. Since ReferenceID and ObjectID are both auto-incremented starting at 1, if the first object added to the system and the first bibliography added to the system both had media, there would be two MediaXrefs with ID = 1, therefore you have to filter on the TableID to differentiate.
I hope this helps. ~Chad
On Tue, Oct 20, 2015 at 8:30 AM, Mette Korsholm <[log in to unmask]<mailto:[log in to unmask]>> wrote:
The David Collection now use a “journalization” program that pulls some information from TMS. Most times it works very well, but we have a problem with one photo. In TMS the photo is correct, but in “Kosmos” (journalization program) it shows a book front that is used in TMS Bibliogtraphy. The lion has redition no. R.2005-10, while the book is R.2011-73.
According to our “Kosmos” people, the problem is that there are two photos in TMS for the lion and it takes the first one; however when looking at the lion in TMS, there is only one photo.
Anybody who can help?
Best,
Mette
Mette Korsholm
Registrator
[log in to unmask]<mailto:[log in to unmask]>
Davids Samling
Kronprinsessegade 30-32
1306 København K
+45 33 73 49 49<tel:%2B45%2033%2073%2049%2049>
www.davidmus.dk<http://www.davidmus.dk>
[Davids Samling]
[L]<http://www.davidmus.dk/signature/l/l>
[R]<http://www.davidmus.dk/signature/l/r>
TILMELD DIG DAVIDS SAMLINGS NYHEDSBREV<http://www.davidmus.dk/nyhedsbrev/tilmelding>
To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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.
________________________________
Denne mail er blevet scannet for virus af TDC Mailfilter.
________________________________
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.