How to use dataport to import data with Entry No.

vh8000
vh8000 Member Posts: 23
edited 2008-08-12 in NAV/Navision Classic Client
Hi

I would like to use Dataport to import data from a csv file into a custom Navision table made by outside consultant.

The problem is this custom table has a field called "Entry No.", which contains sequence of the transaction.

I try to put some codes in section:-
OnBeforeImportRecord()
OnPostDataItem()

But nothing has been imported.

Can someone enlighten me?

Thanks in advance.

Answers

  • garak
    garak Member Posts: 3,263
    the "Entry No." is the PK and not included in the csv file :?:
    Why do you not select the last "Entry No." from the table (in trigger OnPreDataItem(), store this in a variable and in Trigger OnAfterImportRecord() you set
    "Entry No." := YourVariableWithLastEntryNo;
YourVariableWithLastEntryNo += 1;

    regards
    Do you make it right, it works too!
  • garak
    garak Member Posts: 3,263
    Note:
    If a dataport is running from design mode, he only imports the data if there is a COMMIT; for example in OnPostDataItem() or OnPostDataport()

    Regards
    Do you make it right, it works too!
  • vh8000
    vh8000 Member Posts: 23
    Thanks so much for your prmopt reply and it solved my problem.

    I always tried the import from Design mode without using the COMMIT.

    Now, when I run it in [Run] mode, everything works fine.

    I list my codes here in case someone need it:-

    Sales Forecast Entry - OnPreDataItem()
    IF FIND('+') THEN
    NextEntryNo := "Entry No." +1;

    Sales Forecast Entry - OnAfterImportRecord()
    "Entry No." := NextEntryNo;
    NextEntryNo := NextEntryNo +1;
  • garak
    garak Member Posts: 3,263
    You're welcome
    Do you make it right, it works too!

Categories