Skip to main content

Assign Default Values Automatically During the importing process through DIXF

Assign Default Values Automatically During the importing process through DIXF


During the preparation to import data, we often find ourselves having to fill a lot of values that are often the default values. For example, language, currency, customer group or group of suppliers etc....

In this article i will show you how we can assign default values during the importing process through DIXF.

The following example illustrate how to automatically assign default values for vendor currency and vendor group during the importing process. However we can use the same approach to assign default 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 automatically assign default 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 VendorGroup (Vendor Group), Currency (Vendor Currency).


2- Delete the VendorGroup and Currency since we are going to assign the values of these this filed automatically.



3- This is how the CSV file looks after we delete the currency and the vendor group . 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- Click New to create new record, then make sure to select theAuto default check box ( This is the trick), go to the staging field and select the Currency field.


9- Then click Default value button > select the click Currency.


10- Repeat 8 and 9 steps to select the default value for the vendor group. when you finish. close the form to go back to the entities form.



11- Click preview source file button to see the data. note that Currency and vendor group values was generated automatically. Close the form.

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


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



13- Click Ok to create job



 14- Click Run in the staging data execution form.



15- Click Ok.



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



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



18- Select the Job ID that we created in step 13 then click OK



19- Click run to import



20- Click Ok.



21- The data will be written to target



22- Go to the Vendor List form, note that currency, and vendor groups was assigned successfully.


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