Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Maximum lines of DIXF ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Maximum lines of DIXF upload file

(0) ShareShare
ReportReport
Posted on by Hideaki_Horii 95

Dear WW colleagues,

 

I hope all of you are fine.

 

Please kindly advice the maximum lines of DIXF upload file at 1 shot.

I assume no limit on this.

I’d like to upload 20,000.

 

Thanks !

 

Best regards,

  • Suggested answer
    Tad Okada Profile Picture
    Tad Okada on at
    RE: Maximum lines of DIXF upload file

    Hi Hideaki san,

    I think it's no limit. But, please be careful lines of 20000 import via DIXF.

    My recommended import job method is to set the threshold to 1000 rows and batch run with multiple tasks.

    Thanks, Tad

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Maximum lines of DIXF upload file

    Good Morning Hideaki Horii,

    Uploads of 20000 lines or more should work fine with DIXF; that what DIXF is made for.

    Yet, as Christoph mentioned, it might take a while until the update is completed.

    Best regards,

    Ludwig

  • Suggested answer
    Hideaki_Horii Profile Picture
    Hideaki_Horii 95 on at
    RE: Maximum lines of DIXF upload file

    Hi Christoph,

    Thanks ! Understood.

    Best regards,

  • Suggested answer
    Christoph Thaler Profile Picture
    Christoph Thaler 5,442 on at
    RE: Maximum lines of DIXF upload file

    Hi Hideaki_Horii,

    technically you should be able to upload 20.000 rows in one run but based on my experience the performance is not the best. In my projects I split the import in files with maximum 1000 lines. Importing 20 files with 1000 lines is usually faster than one file with 20.000 records.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans