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

All responses (2)

Answers (1)

Sort by

Suggested answer

CU28041408-0 48 on at

Like (0)

Report
Copy link

Link copied!

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.
Verified answer

CU28041408-0 48 on at

Like (0)

Report
Copy link

Link copied!
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)); }