Create Customers in AX using XML

(0) Share

Report

Posted on by Vikas Gupta

2,626

Hello ALL,

I have just started to study AX. I need to create Customer record in AX using XML. My all record are in XML.i need to integrate all records from XML to AX. What should be the solution for this?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,014 Super User 2025 Season 2 on at

Like (0)

Report

Hi Vikas,

You can use the Application Integration Framework (AIF) or Data Import/Export Framework.(DIXF).

If you are not using AX2012 CU7 then DIXF is not able to read xml files.

You can also write a custom xml handler to read the file.

For more information first have a look at several technet pages:

AIF: technet.microsoft.com/.../gg731810.aspx

DIXF: technet.microsoft.com/.../jj225591.aspx

Was this reply helpful? Yes No
Vikas Gupta 2,626 on at

Like (0)

Report

Hello ANDRE,

Thanks for your reply,

if my data is in tables instead of XML then what will be the solution.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,014 Super User 2025 Season 2 on at

Like (0)

Report

Hi Vikas,

If it is not XML, then it depends on the file type. You mentioned 'tables'. Where can we find these tables? Is it an SQL Server database?

Was this reply helpful? Yes No
Vikas Gupta 2,626 on at

Like (0)

Report

Hi ANDRE,

Yes, our tables are in SQL SERVER 2008 R2.

Was this reply helpful? Yes No
Suggested answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

official MS tell you to use AIF

look at my online demo

www.youtube.com/watch

Was this reply helpful? Yes No
Vikas Gupta 2,626 on at

Like (0)

Report

Thanks to All for your valuable and helpful Comments,

I need one more help. I have done some code for integrate the customer using C#. But the problem is that it is creating the record in ONE(Thats is USMF test company) company only if i need to integrate that record in any other company what to do with code.

Here is my C# Code.

AxdCustomer Cust = new AxdCustomer();

CustomerServiceClient CstService = new CustomerServiceClient();

AxdEntity_CustTable tabCust = new AxdEntity_CustTable();

CustomerServiceClient proxy = new CustomerServiceClient();

AxdCustomer AxCustTableObject = new AxdCustomer();

AxdEntity_CustTable[] AxCustTableData = new AxdEntity_CustTable[1];

CallContext AxDocumentContext = new CallContext();

EntityKey[] AxEntityKey;

AxDocumentContext.MessageId = Guid.NewGuid().ToString();

AxCustTableData[0] = new AxdEntity_CustTable();

AxCustTableData[0].AccountNum = "256714"; //mandatory for AXClass

AxCustTableData[0].CustGroup = "10"; //mandatory for AXClass

AxCustTableData[0].Currency = "eur"; //mandatory for AXClass

AxCustTableObject.CustTable = AxCustTableData;

try

{

AxEntityKey = proxy.create(AxDocumentContext, AxCustTableObject);

}

catch (Exception c)

{

richTextBox1.Text = c.ToString();

}

Was this reply helpful? Yes No
Verified answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

yes but this code will always point to the user default company

CustomerServiceClient client = new CustomerServiceClient ();

CustomerServiceClient .CallContext context = new CallContext();

context.Company = "trd";

Was this reply helpful? Yes No

Community site session details

Create Customers in AX using XML

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Create Customers in AX using XML

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates