hello all--

i have a table with several fields that are validated at all times
(including import).

if, during import, a field of the import file conflicts in some way
with the validation established for the field in the table it is being
imported into, the record errors out--that is fine.

has anyoone found an elegant way to capture or identify the records
which have errored out (currently i only recieve a message of how many
records imported and how many skpped, etc), and/or to pause the import
process with an error message asking the user how to proceed?

thanks for any insights--
sg

Perhaps not simple or elegant, but using a script, after performing the
initial import, you could import the same info into a second database without
validation (with a relation to the first), then perform a find for all that
have no related record and display them as a list of records not imported. Or
else have the find locate records that do match and delete them, leaving you
with an ongoing database containing all records with problems.

If it's an ongoing thing and you don't want the second list validated against
pre-existing records, then the relationship would have to use something like
import date combined with something else in order to only compare the current
records to current records.

Kent


MaximalVariance wrote: