Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Trying to import 1 mil...
Microsoft Dynamics NAV (Archived)

Trying to import 1 million records through configuration packages - Rapid Start Services

(0) ShareShare
ReportReport
Posted on by Christos Christou 511

Hi there,

I just want to upload the UK postcodes in the Post Code table in Microsoft Dynamics NAV 2016. I underestimated the situation and I tried to do it via configuration packages - Rapid Start Services but is working for three days now. 

The server has the following specs:

1. Windows Server 2012 R2 Standard

2. 12 GB memory

3. 64-bit operating system, x64-based processor

The file has 1,048,576 records and this is the total number of the entire UK postcodes.

Should I wait or should I just kill it and create a data port?

Thanks

configuration packages - Rapid Start Services

*This post is locked for comments

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Thank Jonathan for introducing our Universal Data Import Export tool!

    Hi Christos,

    Configuration Package is nice standard utility. However, it is designed for small Excel file (less than 4000 rows). Beside Universal Data Import Export tool (handle delimited csv text, fixed width text, xml text) we also have Universal Excel Import Export tool which is designed to import large Excel file. If you need a trial, please contact us!

  • Christos Christou Profile Picture
    Christos Christou 511 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Hi Suresh, thanks for the answer. I have tried it just right now and i get an error "The file you are trying to use is too large".

  • Christos Christou Profile Picture
    Christos Christou 511 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Yes Raokman. It should be working. Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Chris,

    Try to download this tool

    blog.dynms.com/.../the-nav-2013-universal-xmlport.html

    This used to work me much better than rapid start and it is very fast.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    so everyone seems to be saying that the Rapidstart doesn't work.

    shouldn't Microsoft be working on making it work? Importing Postal Codes seems to me to be a pretty common need, around the world.

  • Suggested answer
    Christos Christou Profile Picture
    Christos Christou 511 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Thanks Alex

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Hello Christos,

    If you were using the function 'Import From Excel' from the "Config. Package Card" then you can safely kill the process because it is only loading the package records into the review screen. From there you still have to check for errors before you Apply the import into the database. Or were you already trying to Apply the imported records? If so, then if you kill the process some of the records may have already been imported.

    A simple import like this would be done in about 30 seconds if you were to script this using T-SQL. I've used Rapid start for several operations and it is the application layer that is slow, the database can handle this no problem. If you have an expert DBA in-house then you can script this into NAV very fast with SQL, or if you don't have the expertise then go the XML port route.

  • Suggested answer
    Christos Christou Profile Picture
    Christos Christou 511 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Thanks Jonathan

  • Suggested answer
    Christos Christou Profile Picture
    Christos Christou 511 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    Thanks Jens

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Trying to import 1 million records through configuration packages - Rapid Start Services

    three days running means the process crashed or ran into a deadlock. so kill it. you can use a xmlport to import the data or write a simple processingonly report for reading the textfile and creating the records in nav. the simple methods are mostly the best and do work and often very fast. the import should not last more than a couple of hours.

    there are quite often threads regarding rapid start. not easy to use and a bit buggy.

    there is additional a tool called "Universal Data Import Export - NAV 2013", which you could try:
    http://mibuso.com/downloads/universal-data-import-export-nav-2013

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans