Forum Index

No notifications
Notifications

Favorites

No favorites found
General Training Discussion General chat and comment on KnowledgeKube training
KnowledgeKube Training > General Training Discussion > Email template keyword not dynamic? View modes: 
User avatar
KnowledgeKube Staff
KnowledgeKube Staff
matt.pitman - 18/11/2016 13:58:01
   
RE:Email template keyword not dynamic?

You're very welcome!


User avatar
Advanced member
Advanced member
Arun Murthy - 18/11/2016 12:55:05
   
RE:Email template keyword not dynamic?

Hi Matt,

The problem has been solve.

Thank you very much. =)


User avatar
KnowledgeKube Staff
KnowledgeKube Staff
matt.pitman - 18/11/2016 12:52:17
   
RE:Email template keyword not dynamic?

Hi Arun,

A fix has been applied to your site. Would you mind checking and letting me know if the problem still occurs?

Thanks!


User avatar
KnowledgeKube Staff
KnowledgeKube Staff
Burns - 09/11/2016 09:29:17
   
RE:Email template keyword not dynamic?
Hi Arun! There are no updates as of yet. Kindest Regards Burns

User avatar
Advanced member
Advanced member
Arun Murthy - 09/11/2016 02:45:09
   
RE:Email template keyword not dynamic?
Hi Burns, Any update on this issue?

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
Burns - 24/10/2016 14:23:39
   
RE:Email template keyword not dynamic?
Hi Arun, After looking into this issue we have experienced similar problems when using other methods. We have pushed this to the Dev team and we will keep you updated as soon as we know more. Kind Regards Burns

User avatar
Advanced member
Advanced member
Arun Murthy - 24/10/2016 10:15:20
   
RE:Email template keyword not dynamic?
Hi Burns, I check from the preview form trace, and I can see the loop stored procedure is returning the the different token for each rows.

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
Burns - 24/10/2016 10:00:10
   
RE:Email template keyword not dynamic?
Hi Arun, Thank you, this has helped us in furthering our investigation! Currently we have the Dev team looking into this but we would really appreciate it if you could help us investigate just a little deeper. We would like to rule out the Stored Procedure as a problem area. Can you confirm that the Stored procedure is returning the dynamic values you expect? To double check this i would build a string list of the access tokens within the function you are running so i can check the values from the data have refreshed on each loop. Thanks again! Burns

User avatar
Advanced member
Advanced member
Arun Murthy - 24/10/2016 09:29:16
   
RE:Email template keyword not dynamic?
Hi, Below is the action to send the email ---------------------------------------------------------------------------------------------
// Get the list of employees who can recieve email token;
// Run Stored Procedure sp_GetRoleEmployees;
RolesId:= 6;
VarLocalEmployeesCSV:= RunStoredProcedure("sp_GetRoleEmployees","RolesId","2");	
	
VarLocalEmployeesCSVCount:= CSVGetListCount(VarLocalEmployeesCSV);
VarLocalEmployeesCSVCounter:= 0;
	
while:(VarLocalEmployeesCSVCounter< VarLocalEmployeesCSVCount) {
	PageId:= VarLocalInsertPageId; // id of the new row;
	EmployeeId:= CSVGetListItemByIndex(""&VarLocalEmployeesCSVCounter,VarLocalEmployeesCSV,",","|",0);
	EmailSendingTo:= CSVGetListItemByIndex(""&VarLocalEmployeesCSVCounter,VarLocalEmployeesCSV,",","|",4);
	
	// Run stored procedure to create and get token;
	VarToken:= RunStoredProcedure("sp_CreateNewToken","PageId,EmployeeId","2");
		
	// Send Email;
	SendHTMLEmail("Email Template",EmailSendingTo,"AttachmentDocument");
		
	//Increment counter;
	VarLocalEmployeesCSVCounter:= VarLocalEmployeesCSVCounter+ 1;
}

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
Burns - 24/10/2016 09:11:53
   
RE:Email template keyword not dynamic?
Hi Arun, Would you mind showing us the functions you are using in this process please. We have a few ideas in mind as to what may be happening for you but we need to know how you are processing the information. Many Thanks Burns

1 2
RSS Feed