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

Community site session details

Session Id :
Business Central forum

Data Import

(1) ShareShare
ReportReport
Posted on by 187

I downloaded the data import templates for customers, vendors, accounts, and items. These templates only contain a handful of fields that can be imported. Are these the only fields that I can import directly? For example, how can I import the Item Attributes for every item (e.g. the color for each item)? Can I also import directly using the template? Or do I need a 3rd party application like SmartConnect to do it? Or do I have to do it manually? Thanks so much for the help.

Categories:
I have the same question (0)
  • Chris Bulson Profile Picture
    on at
    RE: Data Import

    Hello,

    The Excel template is pretty basic and meant for quickly getting in a list of Master Records.  We also have the Configuration Package, which has more import ability... but I don't think you can do Item Attributes there either.  You would need to manually add these or it may be possible through SmartConnect.

    Thanks,

    Chris

  • Suggested answer
    dano1968 Profile Picture
    on at
    RE: Data Import

    Check out this post: https://community.dynamics.com/nav/b/dynamicsnavessentials/archive/2016/12/11/dynamics-nav-2017-item-attributes

    you might be better off assigning it to the item category then once item is added to the system and assigned to the item category, it will automatically inherit all these attributes.  So you would not have to go in manually and assign to each item.

  • Community Member Profile Picture
    on at
    RE: Data Import

    You can try this:

    1. Open Item list with Excel.

    2. Connect Excel Add-in for MS Dyncamics

    3. Edit Item_Card to include additional system fields

    Not sure if you would be able to add custom attributes using this approach though

     .

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans