eMail Notification in Workflow

[Former Member]

Hi Folks,

I need to send out an email which says ..

" The material number - 1234 has been successfully created"

The value of the material number needs tobe picked up from the material number field in the main table.

Is this possible. ?

Regards,

Vinay

[Former Member · Accepted solution]

Hi Vinay,

This is possible through notify step. You can format your email body as: The material number - %Material Number% has been successfully created.Material number should be a display field in your main table.

However this will not work in subject of email as %Material Number% gives you all the material numbers in that job and corresponding display fields separated by |.

Hope this is clear to you.

Regards,

Dheeraj.

[Former Member · Accepted solution]

Hi Dheeraj,

I have created a WF to send material number created with following statement in email body.

Material %Material Number% created.

This statement is getting printed as it is in email. It is not picking material no from repository.

Material Number is display field in my repository.

With %records% it is printing material no properly but I dont all display field to get printed in email.

[Former Member · Accepted solution]

Hi Abhijeet

this is correct. You can use %record% as variable in the email body or subject as variable which will show all display fields for the record. We dont have any variables for selecting Fields alone in MDM notify step.

hope this helps.

Regards

Ravi

[Former Member]

Hi Vinay,

It is possible to display the above message in the email notification. For this your Material Number field should be the Display Field and use the following senetence in the body:

" The material number %Records% has been successfully created"

But along with Material Number it also displays the Record ID. Also there should be any other Display Field other than Material Number otherwise that field will also be displayed.

Below are the variables which provide dynamic information:

%RepositoryName% - The repository name

%TableName% - The table name

%JobId% - The job id

%JobName% - The job name

%StepId% - The step id

%StepName% - The step name

%Records% - The record id and display fields of the job records

Regards,

Jitesh Talreja

[Former Member]

Hi,

In MDM workflows we can do this by using

Variable Description

%RepositoryName% The repository name.

%TableName% The table name.

%JobId% The job id.

%JobName% The job name.

%StepId% The step id.

%StepName% The step name.

%Records% The record id and display fields of the job records.

For using mail notifications u must do add a Mail Server entry in the mds.ini for every repository that

uses workflow (e.g. u201CMail Server=mail.domain.comu201D) purpose

Also ,

MDM separates a recordu2019s display fields with a u201C|u201D delimiter

when populating the %Records% variable.

When populating the %Records% variable, MDM only

looks up one level when a job recordu2019s display field is a lookup field. If the display field of the lookup table is itself a lookup field, MDM

substitutes the job recordu2019s display field value with the RecID of the

u201Cfirstu201D lookup table record.

U can aslo refer the MDM data manager reference guide page no. 269 for the same

Hope this may help u .

Sorry for prevous ans.

Rgds

Ankit

Edited by: ankit jain on Jul 30, 2008 6:38 AM