Skip empty field value during import through dataport.

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

  • ManiNavManiNav 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_barfoo_bar Member Posts: 91
    can you try with CurrDataport.SKIP; ?
  • ManiNavManiNav 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.
Sign In or Register to comment.