Error on specific record during dataport import

dallasdev50 · 2011-06-09

I have created a dataport to match the record to the customer no. and if it is a valid record to import. I want the dataport to fail if there is a record that contains an invalid customer no. Since the import will have a large quantity of records, I would like to return an error to the user that specifies which record in the tab delimited file is invalid.

Can somebody help me do this? It is most appreciated.

manisharma31 · 2011-06-09

Data in dataport is inserted line by line.
You can insert error message displaying the line no., customer no. or a unique record which you are importing.

dallasdev50 · 2011-06-09

How would I enter a variable in the Error(Txt) in order to be able to display an identifier of the line in error to the users? I want to make it easy for them to identify which record in their file requires correction.

Thank you

matttrax · 2011-06-09

You need another variable to keep track of your line number. And the error message is like ERROR('Error on Line %1', LineNumberVariable)

Savatage · 2011-06-09

create a seperate textfile of all the errors that occured during import.

But you'll have to import your data into variables.

then something like..
if customer.get(variablecustno) then begin //map all the fields you need back to nav fields
"no." := variablecustomerno;
"name" := variablecustname;
etc etc
end else begin
ExportFile.WRITE("variablecustno");
CurrDataport.SKIP;
end;

Explained here : viewtopic.php?f=23&t=42493
mine might be the 8th post down

Error on specific record during dataport import

Comments

Categories