web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Enable Skip row parame...
Microsoft Dynamics AX (Archived)

Enable Skip row parameter in Data Import Export Framework (DIXF)

(0) ShareShare
ReportReport
Posted on by Rouissi Slim 250

Hi everyone,

I'm importing lots of vendor data from a csv source file to staging, and I'm tired of getting errors each time, so I thought about importing everything that's right and after that correct the rows sent in log and make a second import ( instead of correcting each time I get a new error )

I wanted to enable "Skip row" in the Data import export framework > Setup > Source data format form but the "Skip row" field is put to 0 and greyed.

Even if I create a new source data format it's still the same, the skip row is greyed! What's the problem here ?

Anyone had this problem before ?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Rouissi,

    This field becomes active when you disable the field First row header (En-tête sur la première ligne).

  • Rouissi Slim Profile Picture
    Rouissi Slim 250 on at

    Hi André,

    Thank you, that works! But it still doesn't skip errors...  I checked that in Data Import/Export Framework parameters the Ignore error param is selected. Do you know if there's something else I should change ?

  • Rouissi Slim Profile Picture
    Rouissi Slim 250 on at

    Alright I understand now. That grey parameter has nothing to do with errors!

    It's an error in the technet page technet.microsoft.com/.../jj225596.aspx

    They say "Select this option to leave rows that contain errors unprocessed and continue with the processing. If this option is selected, errors are written to the log." Well there's nothing to select, there's a value to enter for the row you want to skip. So it's for a header located in a row other than the first one, or it's for errors and then you have to put each row where an error might happen, which isn't useful at all!

    Anyway, still looking for a solution...

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Rouissi,

    There is a parameter for DIXF to skip errors. Probably the documentation indeed has an error and this is the description of this parameter field.

  • Rouissi Slim Profile Picture
    Rouissi Slim 250 on at

    Thank you André :)

    The actual problem was many of my vendors had the same account number, and I wanted to import those that are unique and send the duplicates back (using log) for correction.

    So I checked the auto-generated parameter in the mapping.

    In the end, I finally sent my data to staging, but I'll have to take every duplicate manually if users will want to keep the same account numbers they're using...

    Warm Regards

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans