How about
1) Get list from external system (1,000,000)
import each of them - get the ID back for each.
Store SSN/ID for each in separate table (not in your system) -- will that
pass security?
2) Next week - compare old list to new list for
1) Mods
2) Delete
3) News
1) Find the old ID from new SS
If you do what you are talking about, you are going to have a different
problem - no way to search for requests put in for someone last week
based on who they are this week - the PPL ID will be different. And
don't tell me your users can search on name accurately - 12,000 of the
128,000 names in m
We did this at one client I was working in, whose name will be withheld
for various reasons. We had all the data in another database, but like
you've run into, we didn't have the time to get all the data in within a
timely manner.
So we used ARSPerl to create and run multiple perl scripts that wo
3 matches
Mail list logo
