Skip to main content

Convert Field Values During The Importing Process Through DIXF

Convert Field Values During The Importing Process Through DIXF


In the last two articles we discussed how to:

Today we will discuss how we can convert the field values during the importing process.

Sometimes we may need to convert some of the master data values, especially when we planing to import data from a legacy to new system. For example, assume that one of your clients request to reclassify the vendors from a business line to a new one. in this case you can set up DIXF to convert the old business line value to the new value instead of change the business line for these vendors manually.

The following example we'll show how to convert the Vendor Line of Business during data import process.However we can use the same approach to change the values for any other fields.

 



Note: This example assume that you know how to set up the DIXF Parameters, Source file and Processing Group, So if you don't know how to configure any of these please read any of my previous articles about the DIXF.   To change field values do the following :


1- I will use the same CSV file that we created when we discussed how to import vendors master data. The CSV file contain the name field which represent the vendor name




2- Delete the AccountId, Vendor Group and Currency since we are going to assign the values of these this fileds automatically. as we discussed in the previous 2 posts.

3- This is how the CSV file looks after we delete the fields. Save and close the SCV.




4- Go to the DIXF > Processing Group > Select the  vendor processing group then click the entities button.



5- In the entities form make sure that the vendor entitiy is selected, and SCV file path is correct then click generate source mapping.



6-  Then click the modify source mapping button 


7- Click Mapping Details button.



8- Select the lineofbusinessId field. then click the Conversion Button.



9- In the Source value enter the Line of business that you want to change, Then enter the new value in Staging Vale. Then close the form 



10- Click preview source file button to see the data. note that line of business values was was converted to the new line of business. Close the form.


Note: don't click the validate button, if you did the default values will be cleared 


11- Go back to the DIXF > processing group > Select the vendor group then click Get staging data button.


12- Click Ok to create job


 13- Click Run in the staging data execution form.


14- Click Ok.


15- The records will be inserted in the staging. close the infolog.


16- Next, In the processing group select the group name then click Copy Data to target button.


17- Select the Job ID that we created in step 12 then click OK


18- Click run to import


19- Click Ok.


20- The data will be written to target


21- Go to the Vendor List form, note that vendors which had the old business line has was converted to the new one.


Comments

Post a Comment

Popular posts from this blog

Number sequence with existing module and new module

Number sequence customization in Dynamics 365 Create a number sequence in a standard module Step 1: Create new EDT Step 2: Add a new code block to the loadModule in the NumberSeqModuleXXX class Step 3: Add a new static method to the parameters table of the module to get the number sequence reference Using Extension [ExtensionOf(classStr(NumberSeqModuleCustomer))] final class NumberSeqModuleCustTest_Extension { protected void loadModule() { NumberSeqDatatype datatype = NumberSeqDatatype::construct(); next loadModule(); datatype.parmDatatypeId(extendedTypeNum(TestId)); datatype.parmReferenceHelp(literalStr(‘Test ID’)); datatype.parmWizardIsContinuous(false); datatype.parmWizardIsManual(NoYes::No); datatype.parmWizardIsChangeDownAllowed(NoYes::No); datatype.parmWizardIsChangeUpAllowed(NoYes::No); datatype.parmSortField(1); datatype.addParameterType(NumberSeqParameterType::DataArea, true, false); this.create(datatype); } } [ExtensionOf(tableStr(CustParameters...
Post a Comment
Read more

[D365/AX7] How to: Create and Use number sequence

[D365/AX7] How to: Create number sequence Posted on January 7, 2018 Updated on January 11, 2018 Number sequences are used to generate readable, unique identifiers for master data records and transaction records that require identifiers. A master data record or transaction record that requires an identifier is referred to as a reference. On this example, we are going to create a new number sequence for customer group. Create a new class that extends the NumberSeqModuleCustomer class and then create the method loadModule_Extension and add the following code: class NumberSeqModuleCustomer_CFS extends NumberSeqModuleCustomer {         public void loadModule_Extension()         {                 NumberSeqDatatype datatype = NumberSeqDatatype::construct();          ...
Post a Comment
Read more

Batch Multi threading D365FO AX7

Batch Multi threading D365FO AX7 Normally, when we schedule our RunBaseBatch class as a batch job, it will create single task. Which will responsible to execute complete process in single thread. But, As you know like AX-2009 and AX-2012. In D365FO We can add multiple AOS server in single batch group and they can process the multiple task simultaneously.  In this demo I will show, How to create multi threading Batch job. following are the steps Step-1 Create a table for demo purpose in our demo we keep table name is  SLD_DemoTable . Step-2 create a class with name  SLD_DemoBusinessLogic  and write your business logic in this class. In demo I write only insert records in table and show you guys how it works. Reference Code class   SLD_DemoBusinessLogic {      public   void  processInit( VendTable  _vend)     {          SLD_DemoTable  ...
Post a Comment
Read more