Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Andrea Smiley]

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
——————————

[Erin Neely]

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
——————————
——————————————-

[Kevin Fons]

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
——————————
——————————————-

[Andrea Smiley]

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
——————————
——————————————-

[Jason Wilder]

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
——————————
——————————————-

[Andrea Smiley]

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
——————————
——————————————-

[Jason Wilder]

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
——————————
——————————————-

[Andrea Smiley]

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
——————————
——————————————-

[Andrea Smiley]

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

——————————
——————————————-

[Kyle Hardin]

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
——————————
——————————————-