How to get E-Mail from BatchJob-Report PrintDestinationSettings in AX 2012

(1) Share

Report

Posted on by CU28041408-0

Hello fellow AX Users and Developers!

In our AX 2012 environment, we have set up multiple batch jobs (for each customer) to run the CustTransOpen report. Each customer has their own email address to which the report should be sent. However, the email addresses are currently only available in the PrintDestinationSettings of the BatchJob. We would like to parameterise these in the CustTable to make it easier to adjust the email addresses. For the initial filling, however, I first have to export the e-mail addresses from the BatchJobs/PrintDestinationSettings, which I am struggeling with. Do you have any ideas or tips on how I should approach this?

Many thanks and kind regards

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

CU28041408-0 48 on at

Like (0)

Report

Okay, this seems to be relatively straightforward. I had a look at the 'Batch' and 'BatchJob' tables and on the 'Batch' table there is a "Parameters" field which contains all the parameters in a container structure. I opened it in the debugger and searched for all the required fields, so I'll just loop through them now. I couldn't actually find the customer number in the parameters, luckily it's in the BatchJob description and in the emailSubject. I'll share the job afterwards.

Was this reply helpful? Yes No
Verified answer

CU28041408-0 48 on at

Like (0)

Report
This is the job I wrote & used:

static void ExpBatchJobPrintDestinationSettingsMail(Args _args) { //Job data Batch batchTable; BatchParameters batchParameters; container innerCon, conEmailTo, conEmailCC, conEmailSubject, conEmailBcc, conEmailReplyTo; //For export file TextIo exportFile; FileName exportFileName; int counter = 0; #File #define.CRLF("\r\n") //Prepare export csv exportFileName = @"\\yourPath\"; //File path exportFile = new TextIo(exportFileName, #io_write); exportFile.outFieldDelimiter(';'); exportFile.outRecordDelimiter(#CRLF); //Write header exportFile.write("emailSubject;emailTo;emailCC;emailBcc;emailReplyTo"); //Job while select batchTable where batchTable.Caption LIKE "D*" //Query as you need { counter++; //Reset containers, just to make sure we dont export data from the last record batchParameters = conNull(); innerCon = conNull(); conEmailTo = conNull(); conEmailCC = conNull(); conEmailSubject = conNull(); conEmailBcc = conNull(); conEmailReplyTo = conNull(); //Iterate batchParameters containers. NOTE: the 2nd parameters (integers) 'where to peek' may differ, depending on custom fields batchParameters=batchTable.Parameters; innerCon = conPeek(batchParameters, 5); innerCon = conPeek(innerCon, 7); innerCon = conPeek(innerCon, 2); innerCon = conPeek(innerCon, 2); //DataContractMap innerCon = conPeek(innerCon, 6); //SRSPrintDestinationSettings conEmailTo = conPeek(innerCon, 7); conEmailCC = conPeek(innerCon, 5); conEmailSubject = conPeek(innerCon, 6); conEmailBcc = conPeek(innerCon, 12); //Custom field conEmailReplyTo = conPeek(innerCon, 13); //Custom field exportFile.write(strFmt("%1;%2;%3;%4;%5", conPeek(conEmailSubject, 2), conPeek(conEmailTo, 2), conPeek(conEmailCC, 2), conPeek(conEmailBcc, 2), conPeek(conEmailReplyTo, 2))); } info(strFmt("Exported %1 records", counter)); }

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to get E-Mail from BatchJob-Report PrintDestinationSettings in AX 2012

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to get E-Mail from BatchJob-Report PrintDestinationSettings in AX 2012

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates