File upload as parameter on batch job parameter


File upload as parameter on batch job parameter:


Sometimes at run time, while running batch job we need to execute set of records through batch job.

I  my case, I want to update setup of customer details using batch job. So for that I have created batch job and on batch job parameter, I will upload set of customer using file and batch job will update only those uploaded customer details instead of entire customer.


Batch job parameter:

Objects:

1. Contract class: XXX_CustomerStatmentReportContract

[   DataContractAttribute,

    SysOperationContractProcessingAttribute(classStr(XXX_CustomerStatmentReportUIBuilder))

]

public class XXX_CustomerStatmentReportContract

{

    AccountNum  accountNum;

    boolean     includeAllCustomer;

    container   storageResult;



    [DataMemberAttribute,SysOperationLabelAttribute(literalStr("@XXX:CustomerEmailUpdateUpload")),SysOperationDisplayOrderAttribute('2')]

    public container parmStorageResult(container _storageResult =  storageResult)

    {

        storageResult = _storageResult;


        return storageResult;

    }


   

    [DataMemberAttribute,SysOperationLabelAttribute(literalStr("@XXX:IncludeAllCustomer")),SysOperationDisplayOrderAttribute('1')]

    public boolean parmIncludeAllCustomer(boolean _includeAllCustomer = includeAllCustomer)

    {

        includeAllCustomer = _includeAllCustomer;


        return includeAllCustomer;

    }


}


2. UI builder class: XXX_CustomerStatmentReportUIBuilder


public class XXX_CustomerStatmentReportUIBuilder extends SysOperationAutomaticUIBuilder

{

    private str                 availableTypes = ".csv, .xlsx";

    private const str           OkButtonName = 'CommandButton';

    private const str           FileUploadName = 'FileUpload';

    DialogField                 dialogStorageResult;

    XXX_CustomerStatmentReportContract   contract;

    


    public void postBuild()

    {

        DialogGroup      dialogGroup;

        FormBuildControl formBuildControl;

        FileUploadBuild  dialogFileUpload;


        super();


        contract = this.dataContractObject();

        

        dialogGroup = dialog.addGroup("@XXX:FilePath");

        formBuildControl = dialog.formBuildDesign().control(dialogGroup.name());

       

        dialogFileUpload = formBuildControl.addControlEx(classstr(FileUpload), FileUploadName);

        dialogFileUpload.style(FileUploadStyle::MinimalWithFilename);

        dialogFileUpload.baseFileUploadStrategyClassName(classstr(FileUploadTemporaryStorageStrategy));

        dialogFileUpload.fileTypesAccepted(availableTypes);

        dialogFileUpload.fileNameLabel("@SYS308842");

    }


    private void dialogEventsSubscribe(FormRun _formRun)

    {

        FileUpload fileUpload = _formRun.control(_formRun.controlId(FileUploadName));

        fileUpload.notifyUploadCompleted  += eventhandler(this.uploadCompleted);

        fileUpload.notifyUploadAttemptStarted += eventhandler(this.uploadStarted);

        _formRun.onClosing += eventhandler(this.dialogClosing);

    }


    protected void uploadCompleted()

    {

        var formRun = this.dialog().dialogForm().formRun();

        FileUpload fileUpload = formRun.control(formRun.controlId(FileUploadName));

        FileUploadTemporaryStorageResult uploadResult = fileUpload.getFileUploadResult();


        if (uploadResult != null && uploadResult.getUploadStatus())

        {

            contract.parmStorageResult(uploadResult.pack());

        }


        this.setDialogOkButtonEnabled(formRun, true);

    }


 

    private void uploadStarted()

    {

        var formRun = this.dialog().dialogForm().formRun();

        this.setDialogOkButtonEnabled(formRun, false);

    }


    public void postRun()

    {

        super();


        FormRun formRun = this.dialog().dialogForm().formRun();

        this.dialogEventsSubscribe(formRun);


        this.setDialogOkButtonEnabled(formRun, false);

    }


    private void dialogEventsUnsubscribe(FormRun _formRun)

    {

        FileUpload fileUpload = _formRun.control(_formRun.controlId(FileUploadName));

        fileUpload.notifyUploadCompleted -= eventhandler(this.uploadCompleted);

        fileUpload.notifyUploadAttemptStarted -= eventhandler(this.uploadStarted);

        _formRun.onClosing -= eventhandler(this.dialogClosing);

    }


}


3. Controller class: XXX_CustomerStatmentReportController


public class XXX_CustomerStatmentReportController extends SysOperationServiceController

{

    protected void new()

    {

        super(classStr(XXX_UpdateCustomerService), XXXhodStr(XXX_CreateCustomerContactActivityReportService, processOperation), SysOperationExecutionMode::Synchronous);

        this.parmDialogCaption("@XXX:CustomerStatementReportParaXXXerPurpose");

    }


    public static XXX_CustomerStatmentReportController construct(SysOperationExecutionMode _executionMode = SysOperationExecutionMode::Synchronous)

    {

        XXX_CustomerStatmentReportController controller;

        controller = new XXX_CustomerStatmentReportController();

        controller.parmExecutionMode(_executionMode);


        return controller;

    }


    public static void main(Args _args)

    {

        XXX_CustomerStatmentReportController controller;

        controller = XXX_CustomerStatmentReportController::construct();

        controller.parmDialogCaption("@XXX:CustomerStatementReportParaXXXerPurpose");

        controller.parmArgs(_args);

        controller.startOperation();

    }


}


4. Service class: XXX_UpdateCustomerService

public class XXX_UpdateCustomerService extends SysOperationServiceBase

{

    public void processOperation(XXX_CustomerStatmentReportContract _contract)

    {

        #File

        container               currentLine;

        CommaTextStreamIo       localStream;

        AccountNum              accountNum;


        if (_contract.parmStorageResult() != conNull())

        {

            FileUploadTemporaryStorageResult fileUploadResult = new FileUploadTemporaryStorageResult();


            fileUploadResult.unpack(_contract.parmStorageResult());


            if (fileUploadResult != null)

            {

                try

                {

                    localStream = CommaTextStreamIo::constructForRead(File::UseFileFromURL(fileUploadResult.getDownloadUrl()));


                    if (localStream.status() != IO_Status::Ok)

                    {

                        throw error(strfmt('@XXX:UploadFileError',enum2str(localStream.status())));

                    }

   

                    localStream.inFieldDelimiter("\,");

                    localStream.inRecordDelimiter("\n");

   

                    currentLine = localStream.read();

   

                    while(currentLine)

                    {

                        accountNum = strRem(conPeek(currentLine, 1),'\r');


                        // Update customer based on extracted variable accountNum

            

                        currentLine = localStream.read();

                    }

                }

                catch (Exception::Error)

                {

                    error("Error");

                }

            }

        }

    }





Comments

Post a Comment

Popular posts from this blog

Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++

Image
 Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++ Steps: 1. Create controller class and execute SSRS report with parameter 2. Create Azure storage on Azure 3. Create Azure storage containers and folder to store report output 4. Get Azure connection key to establish connection between D365 F&O and Azure storage 5. Convert SSRS report output into byte stream 6. Upload byte stream to azure storage How to create Azure storage, containers and folder and get Azure connection key? Login to https://portal.azure.com Go to Storage account --> Storage browser --> Blob containers How to get  Connection string ? Go to Storage account --> Security + networking --> Access Key --> Connection string Code: using Microsoft.WindowsAzure.Storage; Using Microsoft.WindowsAzure.Storage.Blob; using System.IO; public class ExampleUploadReportToBlobStorage {     public static void main(Args _args)     {  ...
Read more

Microsoft D365 F&O: Remove custom models from deployable package

Image
Sometime we deploy custom model to PROD/Sandbox and due to some reason needs to revert back custom model code. If we revert back code, code reverted back but model still exist in the  environment. the next time when we suppose to deploy new package, deployment would failed with following reason: "The selected package is missing the following modules that are currently deployed on your environment. You must create an all-in-one deployable package that contains all your code customizations and ISV solutions. More information can be found at the following link:  https://go.microsoft.com/fwlink/?linkid=2118104 . Missing module(s): [ Package1 ] ,[ Package2 ] [ Package3 ]’ (Activity Id: ‘12345XXXX’)" I will explain how to remove the custom models from your environment(PROD/Sandbox). Steps 1.  Create a deployable package from your VM(Visual studio) or download the build package 2.  Unzip the deployable package and open the deployable package folder. 3. Go to   \AX...
Read more

Generate Text/CSV/DAT file using X++ and upload on Azure blob storage

 Generate Text/CSV/DAT file using X++ and upload on Azure blob storage There are many scenario's where we want to wrap data inside the file and upload on blob storage. Following code use to generate file and upload on azure blob storage. `   public void processOperation(Contract _contract)     {         #OccRetryCount         #File         InventTrans          inventTrans;         Query                query;         QueryRun             queryRun;         str                  stringToWrite;         int                  recordCount = 0;         stringToWrite = "Customer Account Number|Invoice Amou...
Read more