import fields to tables have data via dataport

Business Central/NAV Developers Forum
1

Hi,

I create a basic table which has 7 fields. “Document No.” , “Code”, “Description”, “Date”, “Quantity”, “Income Quantity” and “Remaining Quantity”. I designed a dataport and imported five fields (“Document No.” , “Code”, “Description”, “Date”, “Quantity”). I didn’t import “Income Quantity” and “Remaining Quantity”.

Now i want to import these two fields seperately. I have tried to import but they have been imported as different records and other five fields are empty. For example:

Document No Code Description Date Quantity Inbound Quantity Remaining Quantity

70 30

67 43

3 A1 AA 05.12.2008 100

4 A2 AB 06.12.2008 110

5 A3 AC 06.12.2008 150

firstly I imported A1,A2,A3 and then I created another dataport and imported 70-30 and 67-43.

It must be imported this way :

3,A1,AA,05.12.2008,100,70,30

4,A2,AB,06.12.2008,110,67,43

How can I import that way?

Thanks in advance…

2

When you import then it’s important that all rows in your import file has a unique identifier, in NAV the primary key and in your case the Document No.

Without this then NAV doesn’t know what records to associate the additional fields with.

3

Yes, now i import. I forgot identifier. It’s a simple mistake. Thanks very much.