We need to override the base import to add a validation code that filters based on date field.
we have written a store procedure to be executed when import method is called.
Is there any other method to filter import based on date time.We have around ten thousand records imported regularly. Of these records only thirty or so records are new.Rest of the records are duplicates t.We added a duplicate delete query that remove these duplicates on database.We need a better solution as these records importing and deletion takes considerable amount of time to process.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/13/16, 3:19 AM|
|Seen: 222 times|
|Last updated: 6/13/16, 3:32 AM|