Importing Email and phone contact data for Customer through DIXF

(0) Share

Report

Posted on by Community Member

2012 R3 CU8

I need to import a large collection of email addresses and phone/fax numbers to existing customers. Ideally I could also import multiple purpose/roles for each address. (I understand that part may be a customization)

Can someone tell me what entity and fields to focus on? I've tried using the Contact Person entity but my test import of 1 record seems to go nowhere. Thanks

This was my test data

'1' as ContactPersonId,

'90540' as CustAccount,

'Test@test.com' as AddressEmail,

'Test' as AddressEmailName,

'USA' as CountryRegionId

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

This is not working for me. Customer Address Entity only imports customer addresses with email addresses attached to the address. I need to add emails to the Contact information tab.

In regards to the customer entity, the customers already exist and I cannot reimport them. I just need to import the email addresses.

Was this reply helpful? Yes No
Syed Fasih 2,442 on at

Like (0)

Report

For importing E-mail address of existing customers,, I use the actual customerentity.

The fields are following:

1. "CustomerAccountNumber" = 90540

2. "PrimaryEmailAddress" = test@test.com

3. "PrimaryEmailAddressDescription" = Test

4. "PrimaryEmailAddressPurpose" = Invoice

Let me know if it works.

Was this reply helpful? Yes No
fatihgork 3,817 on at

Like (0)

Report

Hi,

I would consider giving all the current values of a customer, and adding additional phone numbers and e-mails on that master data.

In 2012 R2, there was an issue with HcmWorker entity. When DIXF updated a worker, it would delete phone numbers and e-mail addresses.

Let's say would like to update some info of your workers, for example identification number, when you give DIXF such a data -> WorkerNumber;Identification number

Then all the phone numbers and e-mails were gone.

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

just check dmfcustomerentity and dmfcustomeraddressentity.

also try to use office add ins to do that

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The problem with using the Customer Entity in my experience is that it wipes out any fields that you do not provide. This is too much of a risk for us.

Thanks for the replies. I was hoping for something out of the box but I've found it easier just to create a custom import job which also allows me to import the roles and isprimary status of the contact data.

Was this reply helpful? Yes No