How to use dataport to import data with Entry No.

vh8000

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.

garak

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

garak

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

vh8000

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

You're welcome