Data port import data

brijleobrijleo 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

  • idiotidiot 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
  • brijleobrijleo Member Posts: 70
    Thanks Idiot,

    This has solve my problem.

    =D>
Sign In or Register to comment.