Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / Excel Requirements to ...
Microsoft Dynamics NAV forum
Answered

Excel Requirements to import into Configuration Package

(0) ShareShare
ReportReport
Posted on by thegnic 75

We have a client that is looking to export information from their HR system and import the data into NAV (It is basically user info to be imported into Continia Tables in NAV). I know that I can specify the tables that I want and then export to Excel, copy the data they have exported from their HR system and paste that info into the exported Excel sheet and this will import ok. When they export from their HR system it comes out in csv format, with all the correct column names, 1st two rows set accordingly too, however when I save it as an xlsx filetype it won't let me import the data. I'm having to copy and paste from one sheet to another to get the data into NAV.

Is there a way around this? i.e. is there a way to configure the excel sheet so that NAV can import it without exporting the data from NAV 1st? I'm hoping to automate most of this process and was looking to avoid having to copy and paste from one sheet to another.

Any help or suggestions appreciated.

Here is the error:

2020_2D00_12_2D00_04-15_5F00_12_5F00_22_2D00_127.0.0.1_5F00_53317-_2D00_-Remote-Desktop-Connection.png

Cheers

Gary

Categories:
Administration and Setup
Development / Customization / SDK
  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Excel Requirements to import into Configuration Package

    Good day,

    Excellent to hear, great to see you managed to work around it for now.

    Thanks.

  • Suggested answer
    thegnic Profile Picture
    thegnic 75 on at
    RE: Excel Requirements to import into Configuration Package

    Hi Marco, thanks for the reply. Just now getting a chance to look at this again. As this is a customers live environment I would need to arrange all of this with them.

    As it turns out, one of our developers is in the process of creating a codeunit that will carry out the import of the data we require.

    Thanks for your assistance.

    G

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Excel Requirements to import into Configuration Package

    Hello,

    I would start by ensuring you are on a more recent build of Dynamics NAV 2018. We just released CU36:

    support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2018

    If you update one component, it is best to update the other components as well.

  • thegnic Profile Picture
    thegnic 75 on at
    RE: Excel Requirements to import into Configuration Package

    Hi, NAV 2018 CU3 and Office 365.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Excel Requirements to import into Configuration Package

    Hello,

    I believe I have seen this before with some older releases of Office. What release of Office are you using and what CU of NAV 2018 is this?

    Thanks.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans