To get the Data entity Fileds details in excel from Runnable class

-

 using System.IO;

using OfficeOpenXml;

using OfficeOpenXml.Style;

using OfficeOpenXml.Table;

internal final class TECGetDataEntityDetails extends RunBase

{

     DialogField dataEntityName;

     DMFEntityName entityName;


     public Object Dialog()

     {

          Dialog dialog = super();


          dialog.caption('Extract Data entity field properties.');

          dataEntityName = dialog.addField(extendedTypeStr(DMFEntityName), '@SYS122449');

          return dialog;

     }


     public boolean getFromDialog()

     {

          entityName = dataEntityName.value();

          return super();

     }


     public void run()

     {

          DictTable       dictTable;

          DictField       dictField;

          int             i, cnt;

          DMFEntity dmfEntity;


          select firstonly1 dmfEntity where dmfEntity.EntityName == entityName;

   

          dictTable = new DictTable(Global::tableName2Id(dmfEntity.EntityTable));

          cnt = dictTable.fieldCnt();


          MemoryStream memoryStream = new MemoryStream();


          using (var package = new ExcelPackage(memoryStream))

          {

               var currentRow = 1;

               var worksheets = package.get_Workbook().get_Worksheets();

               var dataEntityWorksheet = worksheets.Add("Export");

               var cells = dataEntityWorksheet.get_Cells();

               OfficeOpenXml.ExcelRange cell = cells.get_Item(currentRow, 1);

               System.String value = "Field Name";

               cell.set_Value(value);

               cell = null;

               value = "Label ID";

               cell = cells.get_Item(currentRow, 2);

               cell.set_Value(value);

               cell = null;

               value = "Help Text";

               cell = cells.get_Item(currentRow, 3);

               cell.set_Value(value);

               cell = null;

               value = "Base Type";

               cell = cells.get_Item(currentRow, 4);

               cell.set_Value(value);

               cell = null;

               value = "Type";

               cell = cells.get_Item(currentRow, 5);

               cell.set_Value(value);

               cell = null;

               value = "String Length";

               cell = cells.get_Item(currentRow, 6);

               cell.set_Value(value);

              

               for (i= 1; i <= cnt; i++)

               {

                    dictField = new DictField(Global::tableName2Id(dmfEntity.EntityTable),dictTable.fieldCnt2Id(i));

                    currentRow ++;


                    cell = null;

                    cell = cells.get_Item(currentRow, 1);

                    cell.set_Value(dictField.name());


                    cell = null;

                    cell = cells.get_Item(currentRow, 2);

                    cell.set_Value(dictField.label());


                    cell = null;

                    cell = cells.get_Item(currentRow, 3);

                    cell.set_Value(dictField.help());


                    cell = null;

                    cell = cells.get_Item(currentRow, 4);

                    cell.set_Value(dictField.baseType());


                    cell = null;

                    cell = cells.get_Item(currentRow, 5);

                    cell.set_Value(dictField.type());

    

                    cell = null;

                    cell = cells.get_Item(currentRow, 6);

                    cell.set_Value(dictField.stringLen()); 

                    

               }

               package.Save();


               Dynamics.AX.Application.File::SendFileToUser(memoryStream, 'Field Prop.xlsx');

          }

     }


     public static void main(Args _args)

     {

          TECGetDataEntityDetails getFieldProp = new TECGetDataEntityDetails();

 

          // Prompt the dialog, if user clicks OK it returns true

          if (getFieldProp.prompt())

          {

               getFieldProp.run();

          }

     }


}

Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more