Originally Posted by
Steph3n
what kind of DB?
I can write ODBC export routine or something.
It's all sitting in an Excel spreadsheet at the moment. Database it's going into is Oracle; it came from a flat file on a mainframe system. Conversion scripts are bombing out in part because half of these records (job assignments for employees) are on people who no longer work there — in some cases, the people aren't even alive anymore. But they're mixed in with ones we do have to keep, because they are still active employees. There's also a mess with salaries not converting correctly. It's mostly due to the client's crappy records in the legacy system. I'm not going through all of it. I just have to skim over it and the error report from the converter program and tell them what to do to fix it so they at least get the good stuff, but none of the retired/fired/dead people.
After that, there's a bunch of benefit/deduction records that are screwed up too. But those are easy. The tech consultant and I have the scripts to fix 99% of those and force them into the database.
Oh, and then I have a task list of all the things they haven't done that they need to get done before December 1 I have to do. That's the part I most dread.