Finance | Project Operations, Human Resources, ...

Importing data from Excel sheet

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Hi experts,

I am new to Dixf help me, I want to import the below feilds to update the customer master data urgently feilds are:

1Customer account 2 customer name3 customer status 4 sales group 5 region 6 country 7 City 8 credit limit 9 terms of payment10 email 11 contact person 12 phone number 13 Address 14 Tax Exempt

Best Regards

Shabir Ahmad

All responses (3)

Answers (0)

Martin Dráb 232,866 Most Valuable Professional on at

Like (0)

Report

RE: Importing data from Excel sheet

Lucas gave you links about D365FO, not AX 2012. Documentation for AX 2012 is here: Data Import/Export Framework (DIXF) user guide.

Do you have any particular problem that you want to discuss?
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Importing data from Excel sheet

Hi Shabir,

There are a few known issues with excel as source for DIXF. You can try using csv as a format instead.

You can follow this post in case you need any guidance for the same -

daxusers.wordpress.com/.../
Suggested answer

Lucas Boewood on at

Like (0)

Report

RE: Importing data from Excel sheet

Hi Shabir,

Please review the documentation on Data Management and Import/Export jobs here:

Data management overview
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities-data-packages

Data import and export jobs overview
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-import-export-job

Here is also a great blog on the topic with a more in depth example:

D365: How to Export/Import data through Data Management Framework (DIXF, DMF)
https://gfeaxblog.wordpress.com/2017/10/09/o365-how-to-exportimport-data-through-data-management-framework-dimf/

I believe you'll want to use the CustomersV3 data entity:

Or possibly the Customer details V2:

I hope that helps!