UCS contact history

[cavagnaro]

Hi guys,
I have a customer that doesn't control the way emails goes into their mailbox, they use a webpage that is handled by a third party and changing its code seems to be complicated by some reason....
So, this webpage uses a form to send emails but all emails are sent as only 1 person, and that person is even the mailbox account user, so for example if a customer fills this form it will go to the mailbox sales@company.com but the sender is also sales@company.com when it should be user@hotmail.com for example.
So, now I have an issue because when an email arrives to GAD it retrieves a whooooooooooooooooole history for this contact sales@company.com which is HUGE!
My questions is, what query can I use to clean all this interactions in the meanwhile until the 3rd party agrees to change the webpage code....
Thanks!

[YevgeniyP]

Do not have the direct answer, but UCS schema description (at least about contacts and interactions)  is included into standard Multimedia (MCR, BPR, etc) documentation.
YP

[René]

Hi Cav,

The easier way would be deleting the contact using GAD.

It's possible to do it directly in the database but the schema is not documented expect few tables. Let me know if you need the query to delete the interactions only.

R.

[cavagnaro]

Tried to delete the contact but got an error... In UCS couldn't find the delete action.
Couldn't check the GAD logs...
Now for what I understand...
Contact table stores the contacts
emailin and emailout tables stores the pending emails for in and out, right? These are associated with the table interactions...
Am I right?

[René]

Hi Cav,

Yeah, UCS fails on timeout as it takes long time to delete all the interactions.

There are more tables than emailin/emaiout where content of interactions is stored. I will try to find the script I used in the past. What version of UCS do you have?

R.

[cavagnaro]

7.6 will get exact versioning  Thanks as usual

[René]

Hi Cav,

I didn't find the script I've used in the past. Below is the list of tables you should check as these main contain parts of the messages:

- interaction - list of all interactions stored in UCS
- emailin - incoming emails
- emailout - outgoing emails
- ixcontent - hold content of both in&out messages
- attachment - holds list of attachment belonging to the interactions (interactionID = entityID)
- document - holds the attachments (referenced via documentId attribute of attachment table)

R.

[nishantank]

[quote author=cavagnaro link=topic=5711.msg24909#msg24909 date=1278602886]
Tried to delete the contact but got an error... In UCS couldn't find the delete action.
[/quote]

I guess you mean you could not find the delete action on the GAD rather than UCS?
If you are not able to find the delete option on GAD, check the "delete-contact-enabled" option in your GAD application is set to true. You can find this option under 'contact' section.

Hope this helps.

Cheers

[cavagnaro]

Thanks will give it a try!