Parker Software Forum : Message UID

Message UID : HiNo- the MessageStore table...

Tue, 19 Jun 2012 09:37:22 +0000

Author: Daniel
Subject: 8561
Posted: 19 Jun 2012 at 9:37am

Hi

No - the MessageStore table is populated after the message is processed. Before this it is inside the EdgeQueue table, but the MessageIDs here aren't related.

You could modify the messageid on the fly if you want to replace it with a GUID for instance. You can do this in the script at any stage in the trigger process:

Email2DBMessage.MessageID = "Your New ID" '  this is a string field.

The only downside to this would be if you needed the Message ID to remain intact to prevent duplicate processing. The original Message ID would still be available inside the email header.

Message UID : Hi again,I have decided to use...

Mon, 18 Jun 2012 10:27:22 +0000

Author: l33m4n
Subject: 8561
Posted: 18 Jun 2012 at 10:27am

Hi again,

I have decided to use RecordNo as my unique message id in the autoresponse. I can't see it exposed as a built-in field so I am trying to populate it into a variable called using the Set Variable action.

Variable Name = RecordNo
Select RecordNo
from [Email2DBV3].[dbo].[MessageStore]
where UID = '%msg_messageid%'

ReturnField=RecordNo

I have tested the SQL command and it returns RecordNo if I use an existing UID value but it returns blank when the trigger fires. At what point does the MessageStore record get commited to the database? Is it before the trigger executes and if so should this value be available to populate into the RecordNo variable?

Thanks!

Message UID : Hi James,Can I add a new column...

Fri, 15 Jun 2012 09:30:50 +0000

Author: l33m4n
Subject: 8561
Posted: 15 Jun 2012 at 9:30am

Hi James,

Can I add a new column to the MessageStore table in the database that is a new Guid (uniqueidentifier) and use this as a variable in my trigger? As an example, if I wanted to use the RecordNo identity which isn't available as a built in variable, how do I do that?

Thanks!

Message UID : Hi l33m4n,You should be able to...

Thu, 14 Jun 2012 20:23:59 +0000

Author: James Horton
Subject: 8561
Posted: 14 Jun 2012 at 8:23pm

Hi l33m4n,

You should be able to create an Extracted Field within the Trigger that is set via an Extract Script. This can be any value you would like if this is any value you wish to assign to the message within a Trigger Actions.

This can be assigned to a Trigger Action by script using FIELDS_Value(" {field name} ") or within an Action's UI controls by using %field name% or dragging it across from the available fields.

Here is a link through to a UID creation script that we have within our samples - http://www.parker-software.com/forum/forum_posts.asp?TID=6115&title=custom-unique-id-field

Message UID : Hi,I want to store a unique message...

Thu, 14 Jun 2012 18:13:24 +0000

Author: l33m4n
Subject: 8561
Posted: 14 Jun 2012 at 6:13pm

Hi,

I want to store a unique message ID against every message processed. I am collecting emails from multiple mailboxes so I can't use the Server Generated MessageID option (it would give duplicates). The problem is that the default UID is something like:-

BCA79D1E51B2BD44AFE3EAE99E2791FF952FD82720 ORD1MBX06 mex04 mlsrvr com 20120614180218

which isn't very user friendly when included in auto-response emails and any further human interfacing workflow.

Is there any way I can control the format of the UID so that it's a more user-friendly value? The other option is that I use the RecordNo field but that's not a preferable option if I ever need to use replication..

Any ideas?