Skip to main content

Import Vendors using Data Import framework

Import Vendors using Data Import framework | AX 2012 R3


This post illustrate how to import Vendors Accounts using the data import framework in Dynamics AX 2012 R3


1- Go to Data import export framework --> Setup --> Data import / export framework Parameters.

2- Click browse to select shared working directory then click Validate button then close the form.

3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delemiter if needed.

4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

5- in the entities form select the vendor Entity, CSV in the Sourcse data format, then Click the generate source file button.

6- in the wizard make sure to select the following fields:
Accountnum (Vendor Code)
Name (Vendor Name)
VendGroup (Vendor Group)
Currency (Vendor Currency) 
LineOfBusinessId (Line Of Business)
then click Generate sample file.

7-Save the file in the shared folder you specified in step 2.

8-Open the file using MS Excel, fill the data then save the file.

9-Go back to the processing group --> entities---> Select the Sameple file path then click the generate source mapping button.


10- if the mapping done successfully Click the Preview source file button to preview the data then close the form.

11- in the processing group select the group name then click the Get staging data button to copy the file data to staging table.

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.

16-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 the vendors records was imported 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