Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Configuring source dat...
Microsoft Dynamics AX (Archived)

Configuring source data formats for file import on Data Management AX365

(0) ShareShare
ReportReport
Posted on by greengrimms 1,400

Hi guys, I ran into the following problem;

I have a file with this format:

R;21122016;01012017;31012017;20000000028;D;N;N;4,00;16;
R;21122016;01012017;31012017;20000125327;C;N;N;4,00;16;

that I have to import into a table using the data management framework. Obviously the column delimiter is the semicolon and the row delimiter is CR;LF. Now, the thing is that when I try to generate the source to staging mapping, I get this error: 

cap1.jpg

which I'm guessing is due to two columns having the same field. I changed the name on the field just to see where would that get me, and I got this other error at the time of mapping the fields:

cap2.jpg

I'm getting an empty column from the source, and I can't complete the mapping... I tried adding a column to the staging table so I can map the empty field on the source to that one, but I got an error when I tried to regenerate the mapping. Does anyone have any idea how to get around this issue without changing anything in the source file?

*This post is locked for comments

  • greengrimms Profile Picture
    greengrimms 1,400 on at
    RE: Configuring source data formats for file import on Data Management AX365

    Hi André, thank you for your answer. I actually found a work around, which is probably not the recomended way but it worked for me:

    When I uploaded the file with its corresponding header, I was getting an empty column from the source that I couldn't map to the staging table, so what I did was create a column on the staging table to map it to the empty source column. Then I uploaded the file with the headers but without the semicolon delimiting the last column of the header and I was able to generate the mapping. Then I ran the project and I uploaded the file without the headers and the upload was successful.

    Please let me know if there is a better way because my approach is a mess.

    Thank you for your help!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    RE: Configuring source data formats for file import on Data Management AX365

    Hi Greengrimms,

    The source file is missing headers. Now the first row is taken as header where the value 'N' is found twice. So it cannot add the colunm name 'N' twice.

    Do you have a file with headers?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans