Customize email archiving (DCO)

Hi All,

We are implementing DCO 6.6 into our system. And currently, we're going to create a custom web application (based on DFC) which supposed to be able to search and view emails (which is imported via DCO 6.6).

Here is some properties which I found useful:

I notice that email headers will be stored in dm_message_archive properties, such as:

message_subject received_datesent_dateattachment_count

Also I notice that there is 2 other object type which should be linked into this type:

dm_message_address -> link between email and email addresses 
dm_message_attachment -> link between email and attachment

I found that dm_message_attachment.message_object_id is linked to dm_message_archive.r_object_id

But I couldn't find any relation between dm_message_archive and dm_message_address

And also I didnt find any object type which contains emails content.

Does anybody know what is the used of message_id and tracking_id properties in dm_message_archive?

Can anybody help me out here?

Thank you.

Regards

Find more posts tagged with

Comments

DCTM_Guru

"But I couldn't find any relation between dm_message_archive and dm_message_address"

- dm_message_address is referenced in dm_message_route via addr_id and is linked to dm_message_archive via message_object_id

"And also I didnt find any object type which contains emails content."

- Email content is stored as content to dm_message_archive object.

"Does anybody know what is the used of message_id and tracking_id properties in dm_message_archive?"

- Message_id is unique ID of the email generated by the email system that sent the email

- Tracking_id is used internally by Documentum

Most of this info is described in the Object Reference Manual

FelikK

Hi Johnny,

Thanks for your help.

I've gotten all the information regarding the email message by using DFC.

IDfSysObject doc = (IDfSysObject) sess.getObject(new DfId("09020580800c8d8c"));        
IMessageArchive msgArchive = (IMessageArchive) doc;
IMessageArchiveData msgData = msgArchive.getMessageData();IRichText irt = msgData.getMessageBody();
String content = irt.getContentAsText(); // this is for getting the content of the mailif(msgData.getAttachmentCount() > 0)
{
     for(int i = 0; i < msgData.getAttachmentCount() ; i++)
     {                
          IAttachmentData attdata = msgArchive.getAttachmentData(i+1);
          if(attdata != null)
          {
               IDfId attchObjId = attdata.getObjectId();                                   
               IDfSysObject attchObject = (IDfSysObject)sess.getObject(attchObjId);      //this is the attachment object
               if(attchObject != null)
               {                 
                    System.out.println(attchObject.getObjectName());
               }          }     }}

Thanks