Thanks. I will forward this to somebody whom I hope will understand
J
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]> 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 |
Davids Samling |
|
|
||
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.
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.
Denne mail er blevet scannet for virus af TDC Mailfilter.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.