FlyerTalk Forums - View Single Post - The Penalty Box
Thread: The Penalty Box
View Single Post
Old Oct 9, 2009 | 11:26 am
  #96766  
ssullivan
FlyerTalk Evangelist
20 Years on Site
 
Join Date: May 2001
Location: Washington, DC
Programs: DL Diamond, B6 Mosaic, AS MPV Gold, UA Gold MM, Marriott Plat, SPG Plat, Nat'l Exec Elite
Posts: 16,679
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.
ssullivan is offline