Hi,
I'm working on importing data into R3 and needed to figure out how to import multiple contact information records (e.g. multiple phone numbers) for customers and vendors. After spending a few hours "Googling" and trial and error, I discovered that it is actually a lot easier than I thought: all you need to do is put all the phone numbers into the "Phone" field, separated by a semicolon (or whatever your multiple value separator is).
For example:
Phone: 111-867-5309;111-555-1212
PhoneName: Home Phone; Work Phone
The first item in the field is automatically set as primary, and the value from the corresponding "PhoneName" is set as the description. After it is imported into AX it looks like this...
Description Contact number/address Primary
Home Phone 111-867-5309 Yes
Work Phone 111-555-1212
This works for the Email / EmailName and TeleFax/TeleFaxName (fax).
This also works for ODBC source data formats, even though AX doesn't give you an option for the "multiple value separator" for that type of source data. Using semicolon works in that scenario.
This also works for things like the External Item Ids when importing Products.
Hope this helps someone else who needs to use DIXF to import customers or vendors.
------------------------------
Daniel Zook
Director of IT
Lehman's
Dalton OH
------------------------------