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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Lucas Boewood on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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/.../

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No