dataport - Importing identical records problem

TomasStulpinas

hi,

i've got a file for import which contains identical lines. when i import, i want all records (including identical) appear in my table. i've added an extra column in table, named it 'No.' and made it primary key. Still, navision removes duplicated lines.

what can be done about this?

DenSter

In addition to adding a column and making it the primary key, you also need to generate unique values for this field.

TomasStulpinas

I've set 'No.' property 'AutoIncrement' to 'yes', too. this did not help.

DenSter

I haven't gotten autoincrement to work, so I wouldn't even try that again. Since it is REALLY easy to program it yourself, I didn't really give it much effort either.

TomasStulpinas

DenSter wrote:

I haven't gotten autoincrement to work, so I wouldn't even try that again. Since it is REALLY easy to program it yourself, I didn't really give it much effort either.

well, i simply wrote a trigger in my dataport. next time i simply won't bother with autoincrement (by the way, if i try to enter data in my table manually, autoincrement works fine)

bbrown

When the dataport runs it uses Rec.INIT to initialize each new record. INIT does not reset the primary key fields.

Result:

First Record (before insert):

Key Field = NULL

First Record (after insert):

Key Field = 1

Second Record (before insert):

Key Field = 1

Second Record (on insert):

Error - Primary key exist

You must clear the primary key values (CLEAR(Rec)) for each new record.

andy76

Hello,

In which trigger should I write CLEAR(Rec) for reset Autoincrement?

I have a text file tab delimited with 3 records, NAV 5.0 and SQL 2005.
When I import it I don't have any error message but only the last record is in the table.
Is this the problem?

Thank you

Savatage

why not onimport record

UniqueKey := UniqueKey +1;

is it a one time import or something you are going to use alot?

andy76

I solved the problem with this code in onBeforeImportRecord

XXX_Rec - OnBeforeImportRecord()
CLEAR(XXX_Rec);

Thank you