Microsoft Dynamics AX (Archived)

DIXF: import address with "new line"

(1) Share

Report

Posted on by Martina Bergamo

1,470

Hi to all!

I have to import (from .txt file) addresses.

The street have more lines, for example:

StreetA 10,

StreetB 15

How can I say to DIXF to start a new line in the same string during the import?

Thanks

Martina

*This post is locked for comments

All responses (9)

Answers (2)

Suggested answer

Mr Brent 45 on at

Like (0)

Report

RE: DIXF: import address with "new line"

In the excel sheet for the address import, in the "street" field after your desired text for line 1, press ALT + Enter to insert a carriage return, then enter the data for line 2, press ALT + Enter again, etc. so that the street text appears as having 2nd, 3rd lines in the cell in excel, just as you would like it to appear in AX.

I used tab delimited

Column delimiter Tab {t}

Row delimiter {CR}{LF}

" for text qualifier,
Martina Bergamo 1,470 on at

Like (0)

Report

RE: DIXF: import address with "new line"

Hi! I have another problem. I've imported the street with two lines

"Kreischaer Stra. 1A
Kreischaer Stra. 1B"

but AX formats the address as following:

There is an empty line instead of a simple "new line".

Any ideas?

Thanks

Martina
Martina Bergamo 1,470 on at

Like (1)

Report

RE: DIXF: import address with "new line"

Hi! This is the file:

AccountNum|Currency|CustGroup|CountryRegionId|Street
000005|EUR|Group01|ITA|"Street 1A
Street 1B"

And I've set the following settings under

Data import export framework > Setup > Source data format:

Hope this help!

Martina
Community Member Microsoft Employee on at

Like (0)

Report

RE: DIXF: import address with "new line"

Hi Martina,

What do mean exactly by 'I've created I file with 5 fields and I found my error!'

How did you solve your issue? We are facing a similar issue while importing addresses using DIXF.

Can you share the solution you found?

Thanks,
Martina Bergamo 1,470 on at

Like (0)

Report

RE: DIXF: import address with "new line"

Ok, I've created I file with 5 fields and I found my error!

It's work!!!

Thank you very much!
Verified answer

Martina Bergamo 1,470 on at

Like (0)

Report

RE: DIXF: import address with "new line"

With Text qualifier = " and Row delimiter = ; I receive the following error:

Duplicate tag exists in file ''
Verified answer

Mea_ 60,278 on at

Like (0)

Report
RE: DIXF: import address with "new line"

So your have in your file

"StreetA 10, StreetB 15";

You Text qualifier = " and Row delimiter = ; and it does not work ?

Or you did something else ? it's hard to guess what you did and what is wrong...
Martina Bergamo 1,470 on at

Like (0)

Report

RE: DIXF: import address with "new line"

I've already tried these possibilities...but without success...
Suggested answer

Mea_ 60,278 on at

Like (0)

Report

RE: DIXF: import address with "new line"

Hi Martina Bergamo,

Did you try to change Row delimiter from {CR}-{LF} to something else ?

Also you can play with Text qualifier, set it to " and wrap your street with "".

Community site session details

DIXF: import address with "new line"

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

Vahid Ghafarpour – Community Spotlight

Tip: Become a User Group leader!

Leaderboard

Featured topics

Product updates

Community site session details

DIXF: import address with "new line"

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

Vahid Ghafarpour – Community Spotlight

Tip: Become a User Group leader!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates