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

shubham
shubham Member Posts: 9
in NAV/Navision Classic Client
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

Best Answer

  • swpolo
    swpolo Member Posts: 80
    Answer ✓
    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.
    Nav Upgrades and DEV outsourcing
    Reports transformation to RDLC
    List -1h , Complex List -3h, Document -4h (dev hours)
    navisionupgrade.com

Answers

  • swpolo
    swpolo Member Posts: 80
    Answer ✓
    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.
    Nav Upgrades and DEV outsourcing
    Reports transformation to RDLC
    List -1h , Complex List -3h, Document -4h (dev hours)
    navisionupgrade.com
  • shubham
    shubham Member Posts: 9
    can you help me to corret that overwritten part
  • neilgf
    neilgf Member Posts: 148
    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
    shubham Member Posts: 9
    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 ??

Categories