Dataport: Importing new contacts

Noeline · 2006-08-01

Is is possible for the the "No." field to automatically be populated/updated from the number series within Navision during an import of new records? Or does it have to exist in the import file?

Regards - Noeline

kriki · 2006-08-01

You can do it automatically.
In the OnBeforeImport-trigger you must do a CLEAR of the record.
In the OnAfterImport-trigger, do a INSERT(TRUE) of the record.

Noeline · 2006-08-03

Must be doing something wrong but it just would not work. :oops: I eventually inserted some code that is not very robust, doesn't check date ranges etc, but at least created the contact no's as required for this particular purpose.

RMsetup.GET;
NoSeriesLine.GET(RMsetup."Contact Nos.",10000);
NewNo:=NoSeriesLine."Last No. Used";
Contact."No.":=NoSeriesLine."Last No. Used";
NoSeriesLine."Last No. Used" := INCSTR(NewNo);
NoSeriesLine.MODIFY;

Savatage · 2006-08-03

http://www.mibuso.com/forum/viewtopic.php?t=4521

Noeline · 2006-08-03

THANKS!!!

According to the link this is what must be done ...

"No." := ''; 
INSERT(TRUE);

It works!

Savatage · 2006-08-03

In the OnAfterImport-trigger, do a INSERT(TRUE) of the record.

but that's what Kriki said earlier

kriki · 2006-08-04

Savatage wrote:

In the OnAfterImport-trigger, do a INSERT(TRUE) of the record.

but that's what Kriki said earlier

Probably it was late, and he was already sleeping (or early and still sleeping).

Noeline · 2006-08-04

I suspect my input file was the problem the first time round. But I learn't one heck of a lot from it all.

Thanks for the help.

Howdy, Stranger!

Quick Links

Categories

Dataport: Importing new contacts

Comments