Data port import data

brijleo
brijleo Member Posts: 70
Hi,

I have a file format .CSV file. I have to import data from this file to Navision. There are 10 fields in the .CSV file and i need to import only 5 fields in navision.

I hv created a navision table with 5 fields & created a dataport to import thse 5 fields only into navision table. The problem is every time i try to import, it gives me an error, since the data in the 6th field & thereafter also gets imported into the next record in the same navision field.

I want to skip 6th to 10th field in reading CSV file.

How can i achieve this?

Thanks,

Comments

  • idiot
    idiot Member Posts: 651
    One way is to use dummy variables in the dataport fields
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • brijleo
    brijleo Member Posts: 70
    Thanks Idiot,

    This has solve my problem.

    =D>