Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Importing take too much time

Posted on by Microsoft Employee

Hello,

We are going to upload data to general journal about more than 5,000 record through excel even directly in server taking more than 2 - 4 hours could anyone help me to fix where the problem is?

looking for your kind support!

best wishes 

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Importing take too much time

    There are many options to upload the data:

    - use RapidStart (preferred option), it allows to process lots of data without problems

    - use Excel Importer

    - convert Excel data to text and import that through XML port

    - use SQL methods of transferring data

    Also, such exports are normally done within non-working hours, when database is not loaded with user interactions. The slow down might be the case of heavy database usage by users or some batch processes.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Importing take too much time

    Hi Nematullah,

    I have Universal Excel Import Export tool which can help you exchange data via Excel quickly.

    Please take a look at mibuso.com/.../universal-excel-import-export for detail!

    Please email me if you need Evaluated License!

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Importing take too much time

    Hi Nematullah,

    It is not the database that is slow, it's the application server layer that is slow and the NAV Service that you connect through. Try breaking up the import into separate batches making smaller amounts of rows to import.

    I've used RapidStart to import tens of thousands of records and it works... it's slow but it finishes... sometimes the screen hangs for a while until it finishes. If the XML method isn't working try using Rapidstart, or you can try pasting 1000 records at a time from an excel sheet right into the NAV form (this requires aligning the columns in the same order).

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Importing take too much time

    Most of the time data is push to database during offline period when nobody is logged in system and no transactions is happening in database

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing take too much time

    The companies which have thousands of record how they do it?

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Importing take too much time

    Hello Nematullah,

    Use SQL Server if you have heavy records.

    visit bellow link, you will get idea.

    EXPORT DATA FROM SQL SERVER 2014 WIZARD

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Importing take too much time

    Try to import the data by using server machine and check the speed

    as well as suggest to import file in parts.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing take too much time

    Which options is faster for importing to system the data?

    as this is global system should work for thousand of transaction is there any other way to fix this problem?

    regards,  

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Importing take too much time

    Would suggest check any specific validation is customized or try to reduce the rows and import

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing take too much time

    XMLPORT

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans