Skip empty field value during import through dataport.

ManiNav
ManiNav Member Posts: 120
in NAV/Navision Classic Client
Hi Everyone,

I want to import 'FirstEmail' and 'SecondEmail' through dataport in customer table in NAV 2009 R2. But in the list of customer email fields, some customer doesn't have email. So, i want to skip that customer and to import for the remaining customers.
But getting below warning:
The field cannot be empty. Please enter a value.
Sample file that i am trying to import:

a3og9n1jjl1x.png

please guide me for the above query.

Thanks,
Mani.

Comments

  • ManiNav
    ManiNav Member Posts: 120
    Hi Everyone/Expert;

    I tried to put below code in Customer- OnAfterImportRecord() trigger in dataport. But its not working/importing.


    IF (Customer."Second Email Address" = '') OR (Customer."Self Service E-Mail Address" = '') THEN
    CurrDataport.BREAK;

    Please guide me for the above query.

    Thanks,
    Mani.
  • foo_bar
    foo_bar Member Posts: 91
    can you try with CurrDataport.SKIP; ?
  • ManiNav
    ManiNav Member Posts: 120
    Hi foo_bar,

    Thanks alot for your reply.
    I have completed this requirement with the help of below link:
    https://forum.mibuso.com/discussion/8280/dataport-import-problem

    Thanks,
    Mani.

Categories