How to import multiple lines in table using dataport in nav 2009 r2..?

shubham

and the problem is that when i am importing the the lines only the last line from the dataset is importing rest all are not getting imported ....please tell me how to do this in detail ...as i am a beginner

swpolo

Hi, It depends on dataport properties and code, primary key on table.
You have problem since all your records are overwritten each other except last record.

swpolo

Hi, It depends on dataport properties and code, primary key on table.
You have problem since all your records are overwritten each other except last record.

shubham

can you help me to corret that overwritten part

neilgf

Hi. If the primary key field for a table is, say, Code then you can only have 1 record for that code in the table. If the primary key field is Code, Text then you can have multiple entries for the code as long as the text is different. This is relevant to dataports as when you load in a csv file for a record and the primary key is Code, for example, then if the csv file contains mutiple entries for the same code only the last will be recorded in the table. It can only hold one record for the Code.
If this makes no sense, let me know which table you are trying to populate and I will explain further.
Hope this helps.
Neil

shubham

i am explaining you my senario,
i have made an bhav copy table of my own which include following field names; entry no. as code, ISIN as code , Date as date , rate as decimal
, exchange as option , symbol as code.

Now my concern is that i have to import a file to this table using dataport which includes only 3 source expression ISIN, DATE , RATE these and my file which i have to import contains three lines with these three fields
now my problem is that when i am importing this file only the last line from these three lines are imported to the bhav copy table....now can you help me ??