Open Forum

Expand all | Collapse all

Configuration Packages

  • 1.  Configuration Packages

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Good Morning Looking for guidance on cofniguration packages.

    I imported a rapid start file with about 25 tables.
    When i import data from excel  it seems only the first table is getting updated with data.
    I am not getting any errors
    Thanks!

    ------------------------------
    Andrea Smiley
    Product Manager
    Providence RI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Configuration Packages

    Posted 12 days ago
    Good morning Andrea,

    Where on the configuration package card are you selecting import? There are two options:

    1. At the very top above the General FastTab under Package/Import from Excel - this should import all tables in your Excel file
    2. On the Tables FastTab under Excel/Import from Excel - this will import the selected table

    Thanks,
    Erin

    ------------------------------
    Erin Neely
    Silverware
    erin@silverw.com | 480-423-8324
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Configuration Packages

    TOP CONTRIBUTOR
    Posted 9 days ago
    You need to make sure you select all tables you are importing in the lines area or you use the import at the top of the page and then select the tabels to impor tin the import screen.  This changes about a year ago and confused a lot of people.

    ------------------------------
    Kevin Fons
    Senior Application Consultant
    Innovia Consulting
    Windsor WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Configuration Packages

    GOLD CONTRIBUTOR
    Posted 5 days ago
    So I was able to get some of this work - not all tables imported, but most did. I am hoping it is just my data or me.

    On one table, we are getting a message that one of the fields must have a value.

    The record did create, but not with all the data, and there is actually data in the field it says is missing data.
    Any thoughts?

    ------------------------------
    Andrea Smiley
    Product Manager
    TrueCommerce
    Providence RI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Configuration Packages

    TOP CONTRIBUTOR
    Posted 2 days ago
    Can you give us a little more info?  What table and what is the exact error message? Sounds like this is happening when you apply the package not import it, right?

    ------------------------------
    Jason Wilder
    Senior Application Developer
    Stonewall Kitchen
    York ME
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Configuration Packages

    GOLD CONTRIBUTOR
    Posted 2 days ago
    Thanks for replying
    The error is after we import from excel and apply the package data

    These were my steps specific to one of our tables
    1. In NAV, I opened configuration packages and entered 6080125 and exported to excel.
    2. In BC,  I opened configuration packages and entered 6080125 and exported to excel
    3. Copied the data from NAV excel sheet to BC sheet
    4. Imported Data
    5. Apply Package – I  get error message  ID Type must have a value in TC-EDI Purch. Agreement: No.=RED1. It cannot be zero or empty

    Thanks!


      ------------------------------
      Andrea Smiley
      Product Manager
      Providence RI
      ------------------------------

      Academy - Online Interactive Learning from Experts


    1. 7.  RE: Configuration Packages

      TOP CONTRIBUTOR
      Posted 2 days ago
      Did you import the "ID Type" field?  Seems this is missing.  Possible this field didn't exist in NAV but does in BC.

      If you are populating this field maybe it is happening too late and you need to move it up in regard to the Processing Order.  Imagine you were a user hand entering this in and choose the same order for when you apply the package.  This is done by drilling into the No. of Fields Active and using the Move Up/Move Down buttons to get things in the order that you want.




      ------------------------------
      Jason Wilder
      Senior Application Developer
      Stonewall Kitchen
      York ME
      ------------------------------

      Academy - Online Interactive Learning from Experts


    2. 8.  RE: Configuration Packages

      GOLD CONTRIBUTOR
      Posted 2 days ago
      Thanks, the field did exist and when i compare the excel sheets - the fields are in the same order, etc.
      We will look at the suggestion you have around the filed order.

      ------------------------------
      Andrea Smiley
      Product Manager
      Providence RI
      ------------------------------

      Academy - Online Interactive Learning from Experts


    3. 9.  RE: Configuration Packages

      GOLD CONTRIBUTOR
      Posted yesterday
      Thanks, tried that suggestion of the fields - moving it to 3 as i tab through it is the third field - still same error.
      I will keep at it.


      ------------------------------
      Andrea Smiley
      Product Manager

      ------------------------------

      Academy - Online Interactive Learning from Experts


    4. 10.  RE: Configuration Packages

      TOP CONTRIBUTOR
      Posted 12 hours ago
      I can think of a few things to try.

      If IDType comes from another table, then you can specify the import order for those tables. An example might be trying to set Customer Posting Group while importing Customers. It will give an error if that posting group doesn't already exist. And there are two ways to try to fix that. First, is to check the box Create Missing Codes for the posting group field on the Customer record. Another way is to specify (when looking at the table list) that the Parent Table ID for table 18 is 92, and that will force the posting groups to import before the customers.

      You can also try turning off field validation for the IDType field, although that won't work if the field is part of the primary key of that table. We are just getting started on a TC implementation, so I don't know your table schema (yet) :)

      One other possibility - if IDType is an Option or Enum field, then the values in Excel have to match the valid possible values for that Option or Enum in BC.

      And one last thing to try - just try importing the fields that make up the primary key, plus IDType and see if you can get that to work before adding all of the other fields.

      ------------------------------
      Kyle Hardin
      Business Central Developer
      ArcherPoint Inc.
      Atlanta GA
      ------------------------------

      Academy - Online Interactive Learning from Experts


    If you've found this thread useful, dive deeper into User Group community content by role